Follow this guide to correctly setup TD. Make sure you understand the difference between a pip installation and a portable installation.Sorry guys, next problem with me. I wanted to import the market data from stations I had flown to into the database
( e.g. c:\trade\trade.py import "c:\trade\Minmar.Bayliss Landing.2019-11-19T17.29.09.prices" ).
The command is executed but the following error message is displayed
What am I doing wrong?Code:
C:\trade>trade.py import "c:\trade\Fomalhaut.Wargnerport.2019-11-19T16.46.54.prices" NOTE: Rebuilding cache file: this may take a few moments. *** INTERNAL ERROR: NOT NULL constraint failed: RareItem.station_id CSV File: C:\trade\data\RareItem.csv:2 SQL Query: INSERT OR REPLACE INTO RareItem (station_id,category_id,name,cost,max_allocation,illegal,suppressed) VALUES((SELECT Station.station_id FROM Station INNER JOIN System USING(system_id) WHERE System.name = ? AND Station.name = ?),(SELECT Category.category_id FROM Category WHERE Category.name = ?),?,?,?,?,?) Params: ['16 LYRAE', 'Budrys Ring', 'Legal Drugs', 'Lyrae Weed', '148', '10', 'N', 'N']
The following section is especially relevant to what you're trying to do:
You may also want to look at the documentation on the EDMC_batch import plugin, as it is designed to import multiple .prices files at once.