Abandoned [RELEASE] Trade Computer Extension

[GrumpyOldMan]

Hey Eventure

This looks freeking awsome !

Can you please add some logging to your subs so we can start debugging Excel 2013 VBA / Macros with you ?

------

Private Sub Workbook_Open()
'clear my "event" log text file
Dim logFileName As String
Dim logBuffer As Integer
logFileName = ThisWorkbook.Path & Application.PathSeparator & "MyLogFile.txt"
logBuffer = FreeFile()
Open logFileName For Output As #logBuffer
Print #logBuffer, "File Opened for Use at " & Format(Now(), "dd-mmm-yyyy hh:mm:ss")
Close #logBuffer
End Sub

----------

I can open it fine in 32bit Excel 2013 and it runs for a few mouse clicks before event failures start. A log will hopefully give us a starting point to investigate.

 

[cpy]

That should be in game also no libre/open office support?

 

[eventure]

With the help of Hexersup i found the error (13) at the Commodity panel. It comes, when the selected Trade Range is too low (no stations in range) and the AUTO-DESTINATION selection is activated at the Options panel. It will be fixed next update. If no station in Range, the AUTO-DESTINATION option will be automatically deactivated. Till release, please deactivate the option, when you are not in range of another trade station or raise the trade range to set LHS 3447 in range.

So please what is your opinion about maximum Trade Range. Is 100 light years too low? More range means more processing time.

- - - - - Additional Content Posted / Auto Merge - - - - -

Hey Eventure

This looks freeking awsome !

Can you please add some logging to your subs so we can start debugging Excel 2013 VBA / Macros with you ?

------

Private Sub Workbook_Open()
'clear my "event" log text file
Dim logFileName As String
Dim logBuffer As Integer
logFileName = ThisWorkbook.Path & Application.PathSeparator & "MyLogFile.txt"
logBuffer = FreeFile()
Open logFileName For Output As #logBuffer
Print #logBuffer, "File Opened for Use at " & Format(Now(), "dd-mmm-yyyy hh:mm:ss")
Close #logBuffer
End Sub

----------

I can open it fine in 32bit Excel 2013 and it runs for a few mouse clicks before event failures start. A log will hopefully give us a starting point to investigate.

Please wait for the developer version of TCE. After release, there will be no need for a log, because you will see directly the code where it hangs.

 

[Ervig]

Will check this out! Thanks for the work... (and something like this should be in the game imho)

 

[Xntryk]

a version for open office would be AWESOME SAUCE!

- - - - - Additional Content Posted / Auto Merge - - - - -

make the trade range at least 140 LY for rare selling

 

[LeetNoob]

Looks brilliant, can't wait to abuse it when I get home.

 

[Jup]

With the help of Hexersup i found the error (13) at the Commodity panel. It comes, when the selected Trade Range is too low (no stations in range) and the AUTO-DESTINATION selection is activated at the Options panel. It will be fixed next update. If no station in Range, the AUTO-DESTINATION option will be automatically deactivated. Till release, please deactivate the option, when you are not in range of another trade station or raise the trade range to set LHS 3447 in range.

So please what is your opinion about maximum Trade Range. Is 100 light years too low? More range means more processing time.

- - - - - Additional Content Posted / Auto Merge - - - - -



Please wait for the developer version of TCE. After release, there will be no need for a log, because you will see directly the code where it hangs.

That makes sense, thx for figuring it out.

About the Trade Range, how about if you add it to the option panel with standard "100 LY" and max. "1000 LY"? (i wouldn't go higher than Frontier planed for the galaxy routes).

 

[eventure]

make the trade range at least 140 LY for rare selling

Rares are not recorded at the moment. They need special attention and will be included to a later date.

 

[eventure]

how about if you add it to the option panel with standard "100 LY" and max. "1000 LY"?

My personel database contains 132 trade stations atm in a 60 LY bubble. Loading and processing times are raising faster than i love to see. I think i could double the range and we will see, when time/usage efficiency suffers.

 

[Chris_t0f]

This looks sick... Before I try it, how does it work with Oculus Rift? I only play with it...

thanks

 

[rbridd]

With the help of Hexersup i found the error (13) at the Commodity panel. It comes, when the selected Trade Range is too low (no stations in range) and the AUTO-DESTINATION selection is activated at the Options panel. It will be fixed next update. If no station in Range, the AUTO-DESTINATION option will be automatically deactivated. Till release, please deactivate the option, when you are not in range of another trade station or raise the trade range to set LHS 3447 in range.

So please what is your opinion about maximum Trade Range. Is 100 light years too low? More range means more processing time.

I was/am also getting the error code 13, type mismatch.
So I have unticked the AUTO-DESTINATION option, which does now allow commodity data entry for the current system.
(Even though my decimal separator is set to . and thousands separator is set to , UK standard.)

However, a more interesting question to ask is why there are no detected stations in range.
With My install, it seems that there is a problem with reading the database.

I can add my current destination station, (Austen Town Station, in Arque), which I needed to do, although on reflection, this station in Alliance space should probably be in the pre-existing database.
The destination is set to Yapping Enterprise in LHS 3447.
On clicking this, I get no other options at all in the panel.

I then tried setting my trade range to 200ly, to see if it could find anything, even the other stations in LHS3447, which is 118ly away, but that just brought back a type mismatch (13) error, this time hidden behind the destination panel, so it took a while to realise that it wasn't just taking a long time searching

Reloading the TCE now results in an instant type mismatch (13) error.

I thought to look inside the Access database, to check the data, but you have password protected it.

The station and commodity data I am entering is persistant, which indicates that the database is being updated, but it seems that the pre-existing data in the database is not being accessed for some reason.

Windows 8.1 home
Excel 2007 SP3
Access 2007

 

[eventure]

Releasing update (V1.20) and the Developer Version now.

Developer remarks:
Support of unagreed changes are not possible. If you have questions or worked out solutions, please notify me via PM. Preferred german language, if possible. Thanks to all helpers in advance.

- - - - - Additional Content Posted / Auto Merge - - - - -

This looks sick... Before I try it, how does it work with Oculus Rift? I only play with it...

thanks

Can't say it, i didnt own OR, try it out and post your experience here.

 

[eventure]

I then tried setting my trade range to 200ly, to see if it could find anything, even the other stations in LHS3447, which is 118ly away

Please use the newest version and try it again. Now you can set your Trade Range freely, so if you far away from the initial recorded station (which are only 5), set it so they are in range. After you have entered a couple of stations, you can reduce the range to save processing time.

 

[Jup]

For some reason i can't add new stations now (it worked yesterday). I am using the latest version 1.20.

When i am landing on a new station, i can't get to the "Add new station panel", and it shows me the type mismatch 13 error again.
Says "SYSTEM UNKNOWN" in the screeny below, but SOL is known!

Like i said, everything worked fine yesterday.

 

[eventure]

For some reason i can't add new stations now (it worked yesterday). I am using the latest version 1.20.

When i am landing on a new station, i can't get to the "Add new station panel", and it shows me the type mismatch 13 error again.
Says "SYSTEM UNKNOWN" in the screeny below, but SOL is known!

Like i said, everything worked fine yesterday.

ED got an update today, did you entered VerboseLogging into Appconfig.xml again, because Shiplog is empty?

 

[Jup]

ED got an update today, did you entered VerboseLogging into Appconfig.xml again, because Shiplog is empty?

Doh, thanks... That was it ofc.

 

[eventure]

Releasing update (V1.21):
- Error fixing to all input areas. Special thanks to Hexersup for the hints.

Perhaps someone gives me a hint, how to check the Appconfig.xml, if VerboseLogging is set, or not, and to add the entry automatically, if not set. Thanks in advance.

 

[FreeeLancer]

I just realized while adding a new station: AFAIK every station has a bulliten board, but not every station has a repair station. Might want to switch those two.

Keep up the great work, this is by far my favorite trading tool.

 

[eventure]

I just realized while adding a new station: AFAIK every station has a bulliten board, but not every station has a repair station. Might want to switch those two.

Keep up the great work, this is by far my favorite trading tool.

Thanks for the info, i didnt knowing this for sure. Can anyone confirm this? Has anyone found a station with Commodities and without a BB? When not, lets kick BB and replace it the repair station, as you suggested.

 

[Tigerclaw]

when starting the developer version 1. 21 excel wants a database password. Is that intended?

I encountered two strange bugs where TCE dupped a station and in another case i cannot change the commodities any more. ( error about not enough memory) But without being able to start the dev version i cannot track it down or have a look at the entries in the database...
I had the feeling that sometimes when entering the same station type in different systems TCE mixed up the files. I had entries completly in the wrong collums. No clue what happend but i cannot overwrite it anymore.