Hi Eventure,
I have a question about the 'Trade Overview' panel. When I'm at a station, it shows that station (A) and the destination station (B) prices vs the galactic avg on the bottom right and left, respectively. At the top middle, it shows commodities I should take from A to B and what the profit would be.
But how do I know what I could bring back to A for the most profit? Do I have to go there, or is there another way?
May I suggest a 'swap' button that, within the 'Trade Overview' panel, swaps the current station with the destination station so i can see the updated info in the top middle? Or would it be easier to split the top middle into A to B and B to A? I would use this info to set up a route in the route planner.
I think I'm missing the easy way to do this without travelling to the other station, so I thought I'd ask.
Thanks,
Abil
P.S. FYI, I tried to figure this out with the route planner.I saw that after I added the first station A, the list of stations at the bottom is cut down to those stations buying/selling the commodities I had input for station A. This is smart for an A>B>A route, and I figured this was because "loop route" was ticked, but clicking on the 'loop route' doesn't do anything. Shouldn't deselecting 'loop route' allow you to pick any station in your db, say, if you want to go from A to B to C, then back to A without buying anything at C? Maybe the 'loop route' button isn't working (or I don't understand what it's for)?
edit* Dang it, the 'loop route' button is working fine. As the manual says, you have to select/deselect BEFORE you start adding stations. Sorry!
edit2* I am exploring the 'Route Planner' for the first time. WHHHHYYYYYYY is this the first time I'm exploring/using it.It is super useful.
A swap button for the Trade Advisor will be included into the next update.
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.
TCE Mk.II using SQLite and I am using SQLite Studio. The starter database containing 150 registered trade stations around LHS 3447 to start with. The default database, comming with the install, didn't have any registered stations.
Station IDs starting with 10000+ are unregistered stations. They have to be registered by you.
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.
To be clear, TCE is not a crowdsource tool. It's database is local and filled up by you and only you. A connecting to EDDN to search after trade routes containing crowdsource data is not supported.
Adding an auto-populate function for the required fields to add a market could be possible, but to a later point.