After opening Koishi, go to the plugin market to install two plugins
One is used to write typeid.yaml from the CCP official SDE file or the xlxs file from the Chinese server market into the database, and the other is for price checking.
After installation, enable the plugins by clicking modify and configure in the market interface
According to the prompt, this plugin requires enabling Puppeteer. After clicking to enable Puppeteer, return to evemarket2 to enable the query plugin
After enabling all three plugins, start trying to import item data into the database
You need to give your account admin permissions first. If it's too troublesome, you can execute it in the sandbox; importing into the database requires at least level 4 permissions
Choose either private chat or group mode, and enter the command eveupdate. If you are importing the Chinese server's evedata.xlsx, you need to execute eveupdate -c
According to the prompt, place the file in the specified folder
EU server Full SDE (sde.zip) download: developers.eveonline.com/resource/resources
Chinese server market evedata.xlsx download: EVE Data - EVE Chinese Server Market Center (ceve-market.org)
Note that the EU server's file is currently named types.yaml, manually change it to typeIDs.yaml
If you placed the Chinese server's file, run eveupdate -c; if it's the EU server, run eveupdate
After executing the command, there will be no response. You can check the logs for import completion prompts or try sending any command like help to check if the program is responsive. When it can respond to commands, the import is complete.
After the import is complete, you can check the database for the required item information
Next, you can execute the query command. Job well done!