Abandoned [RELEASE] Trade Computer Extension

stevie · Feb 6, 2015

Allthough the looks are great, i'm having a hard time using it.

I keep getting "Runtime error "13" Type Mismatch" quite alot when adding new systems / stations

Wavey · Feb 6, 2015

Looks nice hoping for a non excel version please

eventure · Feb 6, 2015

stevie said:
Allthough the looks are great, i'm having a hard time using it.

I keep getting "Runtime error "13" Type Mismatch" quite alot when adding new systems / stations

Please give me a shot of your whole screen before you got the error and the code line, where TCE halts, so i can help you.

Wavey1 said:
Looks nice hoping for a non excel version please

Please check FAQ, but i cant see, this will be possible.

Daffan · Feb 6, 2015

Eventure said:
Okay, so enter your station into the database via Database > Station. Thereafter you can add the commodities also.

I did this myself, and i got a runtime error. No code or anything. The overlay crashed but the excel stayed open.

eventure · Feb 6, 2015

Daffan said:
I did this myself, and i got a runtime error. No code or anything. The overlay crashed but the excel stayed open.

Please give me a shot of your whole screen before you got the error.

Daffan · Feb 6, 2015

Eventure said:
Please give me a shot of your whole screen before you got the error.

I managed to get it again

When changing the name of "star system" in database > station from LHS 3447

It said

"Run-time error '13';

Type mismatch

eventure · Feb 6, 2015

Daffan said:
I managed to get it again

When changing the name of "star system" in database > station from LHS 3447

It said

"Run-time error '13';

Type mismatch

Cant reproduce it, so tell me, the station panel shows what (Add or Modify)? You click at star system or did you type something? Please give me a screenshot, as requested.

marktay · Feb 6, 2015

I deleted the line and it then asked me for the netlog location which I gave it.
I then got a 3706 error
It fails on line:
cn.Open strConnection
From this sub:
Sub ADO_Export_Mod(DBFullName As String, TableName As String)
thanks

eventure · Feb 6, 2015

marktay said:
I deleted the line and it then asked me for the netlog location which I gave it.
I then got a 3706 error
It fails on line:
cn.Open strConnection
From this sub:
Sub ADO_Export_Mod(DBFullName As String, TableName As String)
thanks

You delete the whole line (.Refresh BackgroundQuery:=False)? If so, that is too much. Please only "BackgroundQuery:=False", the ".Refresh" must stay.

marktay · Feb 6, 2015

yes - the whole line

Daffan · Feb 6, 2015

Eventure said:
Cant reproduce it, so tell me, the station panel shows what (Add or Modify)? You click at star system or did you type something? Please give me a screenshot, as requested.

I type the name in for the station and then when i clicked save or something.

eventure · Feb 6, 2015

Daffan said:
I type the name in for the station and then when i clicked save or something.

Thx for the screenshot, that is, what i needed. I can see, that your ShipLog is empty. That is not correct. TCE didnt detect your position. Open the AppConfig.xml file and check, if there is an entry under NETWORK (VerboseLogging="1"). It is in your Elite installation folder.

Mnemoch · Feb 6, 2015

Hi all, any idea what "runtime error 9: out of range" might be please? Hangs on startup as you see...was working before and then this happens each time now and I am not sure how to fix...I have tried a reboot but still not loading past that error.

reaper7 · Feb 6, 2015

@Eventure Any chance to add a station type for unsanctioned outpost

eventure · Feb 6, 2015

reaper7 said:
@Eventure Any chance to add a station type for unsanctioned outpost

View attachment 13400

Unsanctioned outposts are mostly civilian outpost, like mining Outposts are mostly Industial Outposts. You see the type, when locking it for landing.

reaper7 · Feb 6, 2015

Eventure said:
Unsanctioned outposts are mostly civilian outpost, like mining Outposts are mostly Industial Outposts. You see the type, when locking it for landing.

No problem, figured out how to add it to the database.

Anyone wishing to do the same here is how:

Open TCE.mdb located at ...\TCE\DB
Add a new entry under TYPE Section
Item ID = 12 : Type: UNSACTIONED OUTPOST

Finally add a jpg pic for the station type named 12.jpg into ...\TCE\JPG

Hexersup · Feb 6, 2015

@Eventure
Just a small change:
I have seen now 3 times a station with Economy type of Agricultural/Hightech, could you add this type to Economy in your next update?

iAmLegion · Feb 6, 2015

One thing that would be kinda cool i think is to have graphs of how the commodities change in price over time at each station.

I guess either output it as a new excell file, or as a new window under trading or such.

eventure · Feb 6, 2015

Hexersup said:
@Eventure
Just a small change:
I have seen now 3 times a station with Economy type of Agricultural/Hightech, could you add this type to Economy in your next update?

No Problem, i will add this and fill up all combinations to the DB. Tommorow i release the next update (V1.31).

bdybldkris · Feb 7, 2015

I've tried to look through the thread but haven't found any solutions. When I open TCE the main menu boxes that stretch across the top of the screen trail off the screen. I can't actually see the Cartography box at all and the Trade Scout is partly off screen. My resolution is 1920x1080 which is as good as it gets. What do I need to do to correct this?

Thanks for all your work. It looks great. I'm using Excel 2013 and Windows 7 64 bit if it matters.