Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.
Hmm, as i see, it has to do with your position. Did you was at a recorded station before? What you did before?

Created a station and then landed at it. It didn't detect that is where I was, so I pointed it to it and that's when the crash occurred.
 
Windows 7 Home Premium 64bit
Office 2016 32/64 bit (both tried)
Access Runtime 32/64 bit (both tried as appropriate)
TCE Version: 1.38c

When I first start TCE at first I get this error:

2015-04-02_1808.png

Clicking OK allows TCE to Continue and appears to work as expected, although I@ve not gone to another system or scanned/changed any data, yet.

Quitting TCE also produces this error and Debug Information.

2015-04-02_1809_001.png2015-04-02_1809.png

HOW DO I IMPORT A DB, IN the latest version?

Secondly, it appears the db import feature has been removed from the options window, I remember reading something the other day, but I can't find it at the moment.

I want to import my db as I have a few errors in my previous one that I don't want to import.

Found it:

It is the same, so there should be no problems. One thing has to be done, when using a pre V1.38 version:

Note: I found a bug in the database (Stars table). There are a double entry for STAR ID 18285. Please change the ZOSMA star system (ID 18285) to ID 18284. I suggest to change this. V1.38 databases (non-beta) are not affected, only pre V1.38 versions.
 
Last edited:
Didn't play very long but no errors at all tonight ! :)

It might be as intended but just in case, when hiding TCE,
if the STAR SYSTEM SUMMARY is up,
it does not hide with the rest of the interface.

This does not bug me since I open it up on my second screen,
I just put it up here as feeback.

Thanks again for fixing the Hide Hotkey, It is very useful !!!
I hope it is now working for everybody !
 
My TCE.mdb is screwed, broken.

Basically one entry that I've found (thus far) has double trade price entries. I could set them all to zero and go back and scan, but I don't know why two entries for all commodities happened.

I haven't edited my database in any way since you last looked at it, except changing Economy Type 15: from Military to Tourism, but that was a few weeks ago.

2015-04-02_2050.png

System 284 and 286 are fine, they have single entries.

I have also sorted the Columns for Station Prices and entry 285 is the only one with double entries.

I don't know which one to delete, I don't want to delete entry 285 as then they'll be a gap, which could (probably will cause problems), I'd like to delete the entry but only if the ID's remained sequential without missing ID's in the sequence.

db's here if you want to look, but I'd rather know how to fix these issues myself.
 
Last edited:
Disappearing data

Hi Eventure

Still using v1.38b as I have not been playing for a few days. Coming back to the game however I have noticed a number of strange things happening with TCE.

  • In the Access tables would I be right in saying that the 'System' row in the StationPrices table is linked to the 'ID' row in Stations?
  • If so then I am at a loss to explain what is happening. I have been collecting commodities data at all stations I have visited but noticed that when using the Trade tool very few stations seemed to have data. Going into the StationPrices table in Access I noticed that all the recent stations I had visited had no prices recorded (i.e. they were showing zero alongside the Good ID). Is it possible the reset prices routine has wiped the data in some way?
  • Also from time to time I seem to get a corrupted station, these tend to show up with an 'Updated Date' of 30/12/1899. Is this by accident or design? This sometimes seems to occur when a station is added with an incorrect 'body number'. A few times I have added a station only to see it not showing up in the main panel after it is saved. After restarting TCE I notice that the body number has changed and entering the station again saves OK as it should.

    Table.jpg
  • Prior to the above investigations I noticed in the Trade tool that one of the 'corrupted' stations was showing commodity prices that were obviously wrong and simply assumed that I had not spotted the incorrect prices when using OCR but now I am not so sure. This station is now showing zero prices for all goods. I have not visited this system again in the meantime so somehow the prices have been set to zero along with other stations without any input from me.

Still a great tool though and getting better all the time. If you can solve my current problem I'll be tempted to make a further donation ;)

Thanks
 
Last edited:
Hi Eventure

Still using v1.38b as I have not been playing for a few days. Coming back to the game however I have noticed a number of strange things happening with TCE.

  • In the Access tables would I be right in saying that the 'System' row in the StationPrices table is linked to the 'ID' row in Stations?
  • If so then I am at a loss to explain what is happening. I have been collecting commodities data at all stations I have visited but noticed that when using the Trade tool very few stations seemed to have data. Going into the StationPrices table in Access I noticed that all the recent stations I had visited had no prices recorded (i.e. they were showing zero alongside the Good ID). Is it possible the reset prices routine has wiped the data in some way?
  • Also from time to time I seem to get a corrupted station, these tend to show up with an 'Updated Date' of 30/12/1899. Is this by accident or design? This sometimes seems to occur when a station is added with an incorrect 'body number'. A few times I have added a station only to see it not showing up in the main panel after it is saved. After restarting TCE I notice that the body number has changed and entering the station again saves OK as it should.
  • Prior to the above investigations I noticed in the Trade tool that one of the 'corrupted' stations was showing commodity prices that were obviously wrong and simply assumed that I had not spotted the incorrect prices when using OCR but now I am not so sure. This station is now showing zero prices for all goods. I have not visited this system again in the meantime so somehow the prices have been set to zero along with other stations without any input from me.

Still a great tool though and getting better all the time. If you can solve my current problem I'll be tempted to make a further donation ;)

Thanks

Yes, the System row is the Station ID. The 30/12/1899 is not a corruption. Its a Date value of zero (no updated commoditites yet). So all prices are zero, because nothing was scanned. Will look into the Body Id issue, you have.
 
Last edited:
Yes, the System row is the Station ID. The 30/12/1899 is not a corruption. Its a Date value of zero (no updated commodities yet). So all prices are zero, because nothing was scanned. Will look into the Body Id issue, you have.

Hmmm.. yes this explains the strange dates but as regards the wrong body number that is sometimes applied to the station I have had instances where I have had difficulty adding a station and when looking at the station table afterwards it shows two entries each with a different body number. I have been able to determine the incorrect one as it has had the 1899 date (I had obviously not scanned the prices for this) and I have then deleted it.

Also the above explanation would not account for the loss of station prices that I have been experiencing. For those stations that are affected I notice that all 81 goods are listed (regardless of whether all 81 were traded at the station) with a zero price - this is what lead me to think that somehow the reset prices routine had caused this. What do you think?
 
Last edited:
Hmmm.. yes this explains the strange dates but as regards the wrong body number that is sometimes applied to the station I have had instances where I have had difficulty adding a station and when looking at the station table afterwards it shows two entries each with a different body number. I have been able to determine the incorrect one as it has had the 1899 date (I had obviously not scanned the prices for this) and I have then deleted it.

Also the above explanation would not account for the loss of station prices that I have been experiencing. For those stations that are affected I notice that all 81 goods are listed (regardless of whether all 81 were traded at the station) with a zero price - this is what lead me to think that somehow the reset prices routine had caused this. What do you think?

When adding a station, please check, if the Body ID, which is display at the Position panel (like NETO : near Body 45) is the same as noted at the Station Database panel in the Stellar Body ID textbox. If it is the same, after you click on SAVE, it should be displayed at the Position panel (like NETO : Reisman Orbital). Did the station name showed up or stayed it at NETO : Body 45 in my example? Also deleting stations directly at the database can damaging it, if the right procedure to do that is not correctly executed. Perhaps you can upload your database, so i can check, if it was damaged.

The reset price data routine is called only, if you click on the "RESET ALL PRICES" button. But i added some code to be sure, that it is only executed, if the button was clicked.
 
Last edited:
Game is getting better all the time

Even though I currently do not have much time to play the game, I am finding it getting better with each update :)
 
Windows 7 Home Premium 64bit
Office 2016 32
Access Runtime 32
TCE Version: 1.38c

When I first start TCE at first I get this error:

View attachment 26463

Clicking OK allows TCE to Continue and appears to work as expected, although when it's loaded up I can't enter any data.

Quitting TCE also produces this error and Debug Information.

View attachment 26464View attachment 26465

The above is still happening, it doesn't happen all the time but once it does happen only rebooting and starting again does it work. Even killing the Excel process doesn't resolve the problem only a reset of the machine.

I'll try and figure out when the problem occurs the last time it happened I was leaving the station. I got an error and then trying to start TCE produces the above issue.
 
Full-Version and Update (V1.39 beta 1) released:
- New compact UI (changable at the Options panel). At the Panel Position window you can also select, to which side the database buttons are displayed.
- New Hotkey selection procedure. It can only be selected through the TCE_setup.
- TCE_Setup V1.01 included
- Options panel revised.
- Bugfix/code overhaul at the Station Database panel.
- Search Route at the Trade panel depends now on your actual star system, not on the last station visited.
- Bugfixes in different routines, to prevent runtime errors.
- Bugfix at Star System Summary panel popup

Note: This version needs a new TCE.ini file. The update contains the new TCE_Setup to make one. TCE.mdb and Panel.mdb databases of the V1.38 can be transfered to the new version.

@Found the runtime error on exit. Not a big problem for now, but will be fixed in next update.
 
Last edited:
Eventure I really don't know what to say now. Thanks just isn't enough. You have absolutely outdone yourself now making the interface fit in neatly with the ship.

Thank you very much. And i can say, there is more to come.

But at first, we contiune hunting bugs for stable version.
 
Another nice evening, seaching for a new trade route.
So extensive use of TCE for the last few hours, without error so far ! :)

I just found a station with Tourism economy.
there is all the double tourism/*** in TCE's list
but not Tourism only.

That was with V1.38c

Now downloading V1.39 beta 1

and another big Thank You to Eventure ! wishing I could send more rep !!!
 
Last edited:
I run this on 2 pc's and have been moving TCE.mdb back and forth when I switch pcs. Does this mean to keep my info I need to move both TCE.mdb and Panel.mdb databases or is TCE.mdb the one that contains my station, star and price data?
 
Nice one Eventure, any chance of a screen shot of the new UI?

I'll kill 5 bird with one post here.

1. Screenshots for reaper7
Main.jpgextended.jpg

2. reporting a minor panel placement inconvenience when first selecting compact UI
the CURRENT POSITION panel is on top of the TRADE COMPUTER EXTENSION button
On Top.jpg

3. confirm that the Hide selection and function works perfectly in this version !

4. Congratulate you again Eventure and thank you for the STAR SYSTEM SUMMARY button !

5. report error 9 on trying to select a destination

Private Sub BTN_Hide_Click()

Dim DataObj As New MSForms.DataObject
Dim s As String

If DES_Unregistered = False Then
s = DES_SysData(DES_StationID, 3)
Else
s = DES_SysData_UR(DES_StationID, 3)
End If
DataObj.SetText s
DataObj.PutInClipboard
ScanHalt = False
PanelOpen = False
If Menu_Mode = "CLASSIC" Then
If Main_Panel = "TOP" Then
Panel_Menu_top.Calc.Caption = "PROCESSING"
Panel_Menu_top.Calc.Visible = False
Panel_Menu_top.BTN_Trade_Layer.BackColor = TCE_Color
Panel_Menu_top.BTN_Trade_Label.ForeColor = 0
Else
Panel_Menu_bottom.Calc.Caption = "PROCESSING"
Panel_Menu_bottom.Calc.Visible = False
Panel_Menu_bottom.BTN_Trade_Layer.BackColor = TCE_Color
Panel_Menu_bottom.BTN_Trade_Label.ForeColor = 0
End If
End If
Me.Hide
Panel_Trade.DES_Display
Panel_Trade.Show
DoEvents


End Sub
Now I'm out for further trade search and TCE testing :)
 
Last edited:
Another nice evening, seaching for a new trade route.
So extensive use of TCE for the last few hours, without error so far ! :)

I just found a station with Tourism economy.
there is all the double tourism/*** in TCE's list
but not Tourism only.

That was with V1.38c

Now downloading V1.39 beta 1

and another big Thank You to Eventure ! wishing I could send more rep !!!

Please change the Economy ID 15 to Tourism at the database, there is double entry for Military. Only pre V1.38 version databases are affected.
 
I run this on 2 pc's and have been moving TCE.mdb back and forth when I switch pcs. Does this mean to keep my info I need to move both TCE.mdb and Panel.mdb databases or is TCE.mdb the one that contains my station, star and price data?

Panel.mdb is only the position of all of your Panels

TCE.mdb contains your station, star and price data...

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

Please change the Economy ID 15 to Tourism at the database, there is double entry for Military. Only pre V1.38 version databases are affected.

Done and successful, Thanks !
 
2. reporting a minor panel placement inconvenience when first selecting compact UI
the CURRENT POSITION panel is on top of the TRADE COMPUTER EXTENSION button
View attachment 26724

Found it. Will be fixed next update.

5. report error 9 on trying to select a destination

Private Sub BTN_Hide_Click()

Dim DataObj As New MSForms.DataObject
Dim s As String

If DES_Unregistered = False Then
s = DES_SysData(DES_StationID, 3)
Else
s = DES_SysData_UR(DES_StationID, 3)
End If
DataObj.SetText s
DataObj.PutInClipboard
ScanHalt = False
PanelOpen = False
If Menu_Mode = "CLASSIC" Then
If Main_Panel = "TOP" Then
Panel_Menu_top.Calc.Caption = "PROCESSING"
Panel_Menu_top.Calc.Visible = False
Panel_Menu_top.BTN_Trade_Layer.BackColor = TCE_Color
Panel_Menu_top.BTN_Trade_Label.ForeColor = 0
Else
Panel_Menu_bottom.Calc.Caption = "PROCESSING"
Panel_Menu_bottom.Calc.Visible = False
Panel_Menu_bottom.BTN_Trade_Layer.BackColor = TCE_Color
Panel_Menu_bottom.BTN_Trade_Label.ForeColor = 0
End If
End If
Me.Hide
Panel_Trade.DES_Display
Panel_Trade.Show
DoEvents


End Sub

Found the problem. It comes, if you did not have a destination and exiting Destination panel without selecting a target. Will be fixed in next update.
 
Last edited:
Status
Thread Closed: Not open for further replies.
Back
Top Bottom