If you have a SQL browser you can adjust it manually (as I did) by changing the 'Y' value of the 'Main' row in the Panel table to -12 and then restarting TCE.
This has probably been answered before, but.. 100 pages.
What SQL is the DB? MySQL or SQLite?
I tried to do a SQLite comparison thingy to pull over the starter database things into the one I was building, but it didn't seem to work since the it still has zero registered markets, and then my personal log was reset to the starter one. I read about trying to use the attach feature of SQLite, but am too stupid to figure out how to run it, even with a GUI tool like
DB Browser.
Any tools you could recommend?
Edit: Well, I said screw it and restarted over with a fresh install of the program with the 1.0.2 update.
Seems that despite the database that comes with the full installer being byte identical to the one that contains the starter database, it's actually lacking the information in the starter database. I don't understand how this is possible. Surely 150 rows of data would've increased the filesize?
The database I had was totally out of whack to the one that comes with the program & the starter DB. Listings for markets started at 10,000 instead of 1. Combining them basically doubled the data erroneously.
I gave up trying to do a full merge and used
sqlite compare to copy over a few star systems that weren't in the DB (probably what I discovered), my personal data and my flight log. Seems to be working just fine now.
Understanding SQL databases is a nightmare. I could read coding languages better.
Right, just skimmed through the manual to find out what this is.
I use EDMC out of convenience for updating prices with one click. I never used EliteOCR (knew about it a year ago) until I ran into a station I couldn't update with EMDC. I only learned to use it because it was Hutton.. and barely anybody goes there (for good reason). Data on EDDN was 36 days out of date and I didn't want to waste my trip.
Manually entering data to 'register' a station is not something I really want spend my time doing. This program seems to rely a lot on registered stations, as I couldn't seem to do much with any of the data I had.
I haven't really looked into things, so I have a question: Can't you just pull data from the EDDN to populate everything instead of having us fill all the information in? As of right now, I've switched from using Slopey's BPC tool to
http://eddn.io due to SQLite freezing horribly when it gets to a large size (full db for BPC is around 350MB; freezes program for 10+ seconds when parsing). I thought TCE would be a better solution as it has a great UI and offered a lot of automated features.. but then seeing this registered market thing and not having a full EDDN database has kinda put me off from using it.
As of right now, I'm pretty clueless on what tool(s) everyone's using for trade routes and rares data and stuff. It seems like we need to use websites like eddn.io now for searching for trade routes.. but even then I don't see where rares are.
Overall, I'm still pretty confused with things.