Release Trade Computer Extension Mk.II

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.
 
I found another star system with double quotation marks instead of a single quotation mark.

BEVAN''S HOPE should be BEVAN'S HOPE.

Plus I wasn't notified automatically that the system wasn't registered. I was just jumping through, then I noticed, whilst updating the details I got interdicted by 3 sidewinders, 15K bounty total, so now I had to dock at the only station in the system to claim bounties. :rolleyes:

Also the NAVIGATION/STAR SYSTEMS PANEL doesn't automatically update after updating the system details. It's fine after restarting TCE.

NAVIGATION_STAR_SYSTEM_PANEL_DOESN'T_UPDATE.png
 
Last edited:
Hello mates,

the mentioned update today is delayed, because I want to include some more star system and unregistered market data to TCE. I adepted most of the star system data and market data from EDDN to the TCE database.
The number of entries for star systems is raised from 22400 to 88400 and the number of unregistered market data is raised from 11600 to 47600 entries.
Additionally, all unregistered markets containing the data to auto-populate the required fields and dropdowns to register the market without entering something.
Select the unregistered market from the dropdown and SAVE it thereafter. That's all.

I have to work on the import routines to make old databases compatible, but it will need some testing before release. So please be patient.
 
Hi Eventur

Just want to say I don't know how you do all of this or where you find the time to reply and get game play in but top marks and rep....:D

dee..
 
Choice of delimiter for Planet ID

Hi Eventure

Just an idea for a development request.

As you know when adding a Planet ID the text is added to the Star Name field in the Markets table. At present a '-' is automatically used to separate the two. However as a lot of star names also include a '-' it can sometimes be confusing where the star name ends and the planet id begins.

Would it be possible as a future enhancement to allow the user the choice of what this delimiter is? For example '=', '»' or '|' might be easier to separate the star name and planet id.

Just a thought ;)
 
Hello mates,

the mentioned update today is delayed, because I want to include some more star system and unregistered market data to TCE. I adepted most of the star system data and market data from EDDN to the TCE database.
The number of entries for star systems is raised from 22400 to 88400 and the number of unregistered market data is raised from 11600 to 47600 entries.
Additionally, all unregistered markets containing the data to auto-populate the required fields and dropdowns to register the market without entering something.
Select the unregistered market from the dropdown and SAVE it thereafter. That's all.

I have to work on the import routines to make old databases compatible, but it will need some testing before release. So please be patient.
Ok, but if we don't want anything to do with crowd sourced data (EDDN), this doesn't affect us, right? This change only impacts those who choose to download and add the db you have separate from TCE, right?

Or, if you mean that TCE will import data from EDDN, that is going to be an option we can deselect, right?

Just trying to understand the change.

Thanks,
Abil
 
Hi Eventure

Just an idea for a development request.

As you know when adding a Planet ID the text is added to the Star Name field in the Markets table. At present a '-' is automatically used to separate the two. However as a lot of star names also include a '-' it can sometimes be confusing where the star name ends and the planet id begins.

Would it be possible as a future enhancement to allow the user the choice of what this delimiter is? For example '=', '»' or '|' might be easier to separate the star name and planet id.

Just a thought ;)

Hmm...., yes, that could be a problem, so my offer is to return to the established sign ':'.
So it will display as Star System : PlanetID : Trade Market

Ok, but if we don't want anything to do with crowd sourced data (EDDN), this doesn't affect us, right? This change only impacts those who choose to download and add the db you have separate from TCE, right?

Or, if you mean that TCE will import data from EDDN, that is going to be an option we can deselect, right?

Just trying to understand the change.

Thanks,
Abil

TCE won't go online to access EDDN. The default database will only be expanded by the EDDN star systems and unregistered maket data.
The additional star systems entries will reduce the need of adding unknown star systems. As before, TCE will not hold any commodity data for unregistered trade markets.
The default database will hold all new data. You will be able, when importing your old database, to delete all unregistered markets, if you like as before. It is up to you, if you want the data or not. But the new star system data can't be avoided.
 
Hi Eventure.

Still running 1.0.0 right now (only just realised I was a couple of releases behind) but I just hit an unhandled exception.

JIT Debugger output:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at Trade_Computer_Extension.Panel_Commodity.Check_Sell() in C:\Users\Hellfire\Documents\Visual Studio 2010\Projects\Trade Computer Extension\Trade Computer Extension\Panel_Commodity.vb:line 1658
at Trade_Computer_Extension.Panel_Commodity.Sell4_Click(Object sender, EventArgs e) in C:\Users\Hellfire\Documents\Visual Studio 2010\Projects\Trade Computer Extension\Trade Computer Extension\Panel_Commodity.vb:line 1740
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Label.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1063.1 built by: NETFXREL3STAGE
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Trade Computer Extension MK.II
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/TCE2/Trade%20Computer%20Extension%20MK.II.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 10.0.0.0
Win32 Version: 14.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data.SQLite
Assembly Version: 1.0.99.0
Win32 Version: 1.0.99.0
CodeBase: file:///C:/TCE2/System.Data.SQLite.DLL
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Screenshot:
TCE2 Exception.jpg

When I clicked Continue, the application seemed to continue running.

Prior to this, I had noticed that the Current Location tile was taking a long time to update with the system I had jumped into. At one point the displayed system was 2 jumps behind me. (Looks as if the log files were being cached in memory then spooled out every so-often, but I really hope that isn't it!)

<removed mention of an issue which has been resolved in 1.0.2>

Do you still need a hangar picture of a T-7?

Screenshot_0439.jpgScreenshot_0440.jpgScreenshot_0442.jpg
 
Last edited:
@eventure.
Maybe I have missed it, but I wonder if it's possible to make it easier to select a marked manually?
when I am doing missions I try to trade with the destination as well as it is the target of the mission.
All saved markeds are alphabethically available under the "commodity" panel. May be if you had a"destination" choice there as well?
 
Hello mates,

the mentioned update today is delayed, because I want to include some more star system and unregistered market data to TCE. I adepted most of the star system data and market data from EDDN to the TCE database.
The number of entries for star systems is raised from 22400 to 88400 and the number of unregistered market data is raised from 11600 to 47600 entries.
Additionally, all unregistered markets containing the data to auto-populate the required fields and dropdowns to register the market without entering something.
Select the unregistered market from the dropdown and SAVE it thereafter. That's all.

I have to work on the import routines to make old databases compatible, but it will need some testing before release. So please be patient.

Lovely Jubbly :D
 
Last edited:
@eventure.
Maybe I have missed it, but I wonder if it's possible to make it easier to select a marked manually?
when I am doing missions I try to trade with the destination as well as it is the target of the mission.
All saved markeds are alphabethically available under the "commodity" panel. May be if you had a"destination" choice there as well?

Please use the Navigation panel to select a destination.
 
Hi
Thanks for all your hard work. But I wondered if you could give me some help. I think i have managed to install TCE Mk2. But I cant seem to see anything. I can launch it and I see the overlay, but nothing else really. I realise that I have to input some stuff by hand, but I was hoping the commodities woulld work. I dont get a panel where I can ask it to update.

Any ideas?

Thanks
 
Hi
Thanks for all your hard work. But I wondered if you could give me some help. I think i have managed to install TCE Mk2. But I cant seem to see anything. I can launch it and I see the overlay, but nothing else really. I realise that I have to input some stuff by hand, but I was hoping the commodities woulld work. I dont get a panel where I can ask it to update.

Any ideas?

Thanks

Can you post a screenshot of what you see please? Are you docked at a station? You should register with ED Market Connector to be able to automatically input commodity data from the station. Remember this tool is not crowd sourced so you need to input your own data when you visit stations.
 
Hi
Thanks for all your hard work. But I wondered if you could give me some help. I think i have managed to install TCE Mk2. But I cant seem to see anything. I can launch it and I see the overlay, but nothing else really. I realise that I have to input some stuff by hand, but I was hoping the commodities woulld work. I dont get a panel where I can ask it to update.

Any ideas?

Thanks

Please read the manual, it should help you to find the way, how TCE works. Remember, ED has to be set into borderless window mode to see the overlay in game.
 
Hi

Thanks for your help. I have been reading the manual but could really do with a simple step by step instruction. I think you describe the tools very well and what each panel does, but not in detail as to how to use it. Maybe I'm totally missing something though. I did think there was some automation in the application and it wasn't all manual input.

Please understand that I'm not being critical :) i think its amazing what you have created :)

Thanks
 
Hi Scotty,

No, it's not all manual, you do have to put in the basic details regarding the stations but then such as Eliteocr will scan in the commodity prices page by page.

Then once they are loaded you can just scan and update the prices the next time you visit that station.
 
Back
Top Bottom