Abandoned [RELEASE] Trade Computer Extension

john211murphy · Jun 4, 2015

I have been experiencing a problem with the "Ship Logbook".
The time zone in the U.K. is one hour ahead of system time.
This means that when the local time is between 0000 and 0100, date is stored with the incorrect date and time,
as the date has changed but the time store is universe time and is therefore one hour behind.

I have entries in the Ship Logbook showing time stamps of 06/04/330 23:04. It shows that the Date has advanced but has stored the Universe time, not my local time.
I can edit the entry and correct this but not any Activity entries associated with this entry.

Regards

eventure · Jun 4, 2015

Jack London said:
getting this error (Line 591) at startup, stock db, excel/access2013

http://i.imgur.com/wL1IqIr.jpg

Ui is loading and seems to be working fine until i jump to the next star.

http://i.imgur.com/jCc7hN4.jpg

This repeats every jump.

Love the new logbook feature! Just made my day.

Did you using the V1.40?

eventure · Jun 4, 2015

Abil Midena said:
No. I don't think the system has any weird names, etc.

I just booted up ED and then TCE. I went to the Cartography panel, chose the system I was in (was at top already) and entered some text. Clicked save. Everything ok.

Clicked on another system. Typed in some text and clicked save. Same Type mismatch error.

I noticed that the system I was trying to enter text for earlier was not listed in the cartography pane.

But then I noticed in the "travel logbook" that is did indeed log me being in the system.

I then hid the panel so that only the main TCE 'Control, ship logbook, etc' was at the top, and traveled back to the system I was at earlier today. TCE tracked where I was in the "current position" box exactly like it should.

I docked, clicked on cartography, and selected the current system and entered some text, then save. Same mismatch error. The system name is Scirth.

Alt-tab, click TCE, select no, close options excel book. Start TCE. Same error when clicking save after entering text.

Please press debug and show me the codeline, where the error happens.

LBITB said:
Only using the main database. Tried fresh copying several times. Was using 1.39 v7 before

Please try to use only the new installer version without any changes. Please setup a new TCE.ini file and start. Did you experience the same?

john211murphy said:
I have been experiencing a problem with the "Ship Logbook".
The time zone in the U.K. is one hour ahead of system time.
This means that when the local time is between 0000 and 0100, date is stored with the incorrect date and time,
as the date has changed but the time store is universe time and is therefore one hour behind.

I have entries in the Ship Logbook showing time stamps of 06/04/330 23:04. It shows that the Date has advanced but has stored the Universe time, not my local time.
I can edit the entry and correct this but not any Activity entries associated with this entry.

Regards

Thanks for reporting, didnt recognized. Will look, what i can do.

@Okay, i changed also the date calculation. I have to test it, so i must wait till midnight.

Abil Midena · Jun 4, 2015

Eventure said:
Please press debug and show me the codeline, where the error happens..

Hoo, boy. Ok, the screen shot is ok, but the line highlighted in yellow was:

StarData (8) = CLng(Ar_DBStars(StarData(1), 8))

And since that screen shot is terrible...

Private Sub BTN_Save_Click()

Dim a As Long, b As Long

Me.BTN_Save.Caption = "PLEASE WAIT"
DoEvents
If FTP_Enabled = True Then
Call Download_DB
Call FTP_Data_Update
End If
Ar_DBStars(Ar_Carto(CA_SelectID, 1), 7) = Me.CA_Note.Text
Ar_Carto(CA_SelectID, 8) = Me.CA_Note.Text
StarData(1) = Val(Ar_Carto(CA_SelectID, 1))
StarData(2) = Ar_DBStars(StarData(1), 2)
StarData(3) = Ar_DBStars(StarData(1), 3)
StarData(4) = Ar_DBStars(StarData(1), 4)
StarData(5) = Ar_DBStars(StarData(1), 5)
StarData(6) = CLng(Ar_DBStars(StarData(1), 6))
StarData(7) = CStr(Me.CA_Note.Text)
StarData(8) = CLng(Ar_DBStars(StarData(1), 8))
Call SQL_Export_Mod(AppPath & "\DB\TCE.mdb", "Stars")
If FTP_Enabled = True Then
Call Upload_DB
End If
Saving = True
Worksheets("DB_Stars").Range("A2:H" & AzStars + 1) = Ar_DBStars
Saving = False
Call CA_ScrollBar_Change
Me.BTN_Save.Caption = "SAVE CHANGES"
Me.BTN_Save.Visible = False

End Sub

eventure · Jun 4, 2015

Abil Midena said:
Hoo, boy. Ok, the screen shot is ok, but the line highlighted in yellow was:

StarData (8) = CLng(Ar_DBStars(StarData(1), 8))

View attachment 41062

And since that screen shot is terrible...

Private Sub BTN_Save_Click()

Dim a As Long, b As Long

Me.BTN_Save.Caption = "PLEASE WAIT"
DoEvents
If FTP_Enabled = True Then
Call Download_DB
Call FTP_Data_Update
End If
Ar_DBStars(Ar_Carto(CA_SelectID, 1), 7) = Me.CA_Note.Text
Ar_Carto(CA_SelectID, 8) = Me.CA_Note.Text
StarData(1) = Val(Ar_Carto(CA_SelectID, 1))
StarData(2) = Ar_DBStars(StarData(1), 2)
StarData(3) = Ar_DBStars(StarData(1), 3)
StarData(4) = Ar_DBStars(StarData(1), 4)
StarData(5) = Ar_DBStars(StarData(1), 5)
StarData(6) = CLng(Ar_DBStars(StarData(1), 6))
StarData(7) = CStr(Me.CA_Note.Text)
StarData(8) = CLng(Ar_DBStars(StarData(1), 8))
Call SQL_Export_Mod(AppPath & "\DB\TCE.mdb", "Stars")
If FTP_Enabled = True Then
Call Upload_DB
End If
Saving = True
Worksheets("DB_Stars").Range("A2:H" & AzStars + 1) = Ar_DBStars
Saving = False
Call CA_ScrollBar_Change
Me.BTN_Save.Caption = "SAVE CHANGES"
Me.BTN_Save.Visible = False

End Sub

The Problem is the star class value. It should be a number or it is empty.

To be sure, please look into your TCE.mdb, Stars table, find "Scirth" star system and look at the "Class" column. What do you find there?

Jack London · Jun 4, 2015

Eventure said:
Did you using the V1.40?

Yes 1.40 FINAL clean install, i also tried 1.40 BETA 13 which is working fine.

Abil Midena · Jun 4, 2015

Eventure said:
The Problem is the star class value. It should be a number or it is empty.

To be sure, please look into your TCE.mdb, Stars table, find "Scirth" star system and look at the "Class" column. What do you find there?

The Class is blank. It shows a 1 in the SOK column for Scirth.

I also noticed in the cartography section that the stars listed have question marks for class and scoopable.

FYI, the one star it let me make an entry for, Ye'kuana, does have a 0 in the Class cell. All others, including those I've visited, are blank.

Please remember I deleted the stations in 'Stations_UR in case that has anything to do with it.

eventure · Jun 4, 2015

Abil Midena said:
The Class is blank. It shows a 1 in the SOK column for Scirth.

I also noticed in the cartography section that the stars listed have question marks for class and scoopable.

FYI, the one star it let me make an entry for, Ye'kuana, does have a 0 in the Class cell. All others, including those I've visited, are blank.

Please remember I deleted the stations in 'Stations_UR in case that has anything to do with it.

Thanks, if you put in a zero in "Scirth" class column, it will then work for you.
The blank cell is the problem at you, not here of course. So i will change the save routine in TCE, that it will handle blank entries better.

Bragolatch · Jun 4, 2015

Error 13 reproduced

Abil Midena said:
LOL. After I posted, I was like, why am I scared...just try it (after saving a copy of the mdb).

BTW, I'm getting "Run time error '13' Type mismatch" after I enter text and hit "save" in the notes section of cartography for a star system.

Thanks Eventure all the Stored Locations hickups appear to be fixed and the sorting/search of the Modify Station, is great !

I know this was fixed in a previous beta because I clearly remember testing it but now I can reproduce this error.

Adding a note to a visited system with a selected star class works perfectly but a non visited without a STAR CLASS entry also gives me :

Run time error '13' Type mismatch

Private Sub BTN_Save_Click()

Dim a As Long, b As Long

Me.BTN_Save.Caption = "PLEASE WAIT"
DoEvents
If FTP_Enabled = True Then
Call Download_DB
Call FTP_Data_Update
End If
Ar_DBStars(Ar_Carto(CA_SelectID, 1), 7) = Me.CA_Note.Text
Ar_Carto(CA_SelectID, 8) = Me.CA_Note.Text
StarData(1) = Val(Ar_Carto(CA_SelectID, 1))
StarData(2) = Ar_DBStars(StarData(1), 2)
StarData(3) = Ar_DBStars(StarData(1), 3)
StarData(4) = Ar_DBStars(StarData(1), 4)
StarData(5) = Ar_DBStars(StarData(1), 5)
StarData(6) = CLng(Ar_DBStars(StarData(1), 6))
StarData(7) = CStr(Me.CA_Note.Text)
StarData(8) = CLng(Ar_DBStars(StarData(1), 8))
Call SQL_Export_Mod(AppPath & "\DB\TCE.mdb", "Stars")
If FTP_Enabled = True Then
Call Upload_DB
End If
Saving = True
Worksheets("DB_Stars").Range("A2:H" & AzStars + 1) = Ar_DBStars
Saving = False
Call CA_ScrollBar_Change
Me.BTN_Save.Caption = "SAVE CHANGES"
Me.BTN_Save.Visible = False

End Sub

Oups, a bit late, my browser updated and I just saw that there was a new page.

eventure · Jun 4, 2015

Bragolatch said:
Thanks Eventure all the Stored Locations hickups appear to be fixed and the sorting/search of the Modify Station, is great !

I know this was fixed in a previous beta because I clearly remember testing it but now I can reproduce this error.

Adding a note to a visited system with a selected star class works perfectly but a non visited without a STAR CLASS entry also gives me :

Run time error '13' Type mismatch

Private Sub BTN_Save_Click()

Dim a As Long, b As Long

Me.BTN_Save.Caption = "PLEASE WAIT"
DoEvents
If FTP_Enabled = True Then
Call Download_DB
Call FTP_Data_Update
End If
Ar_DBStars(Ar_Carto(CA_SelectID, 1), 7) = Me.CA_Note.Text
Ar_Carto(CA_SelectID, 8) = Me.CA_Note.Text
StarData(1) = Val(Ar_Carto(CA_SelectID, 1))
StarData(2) = Ar_DBStars(StarData(1), 2)
StarData(3) = Ar_DBStars(StarData(1), 3)
StarData(4) = Ar_DBStars(StarData(1), 4)
StarData(5) = Ar_DBStars(StarData(1), 5)
StarData(6) = CLng(Ar_DBStars(StarData(1), 6))
StarData(7) = CStr(Me.CA_Note.Text)
StarData(8) = CLng(Ar_DBStars(StarData(1), 8))
Call SQL_Export_Mod(AppPath & "\DB\TCE.mdb", "Stars")
If FTP_Enabled = True Then
Call Upload_DB
End If
Saving = True
Worksheets("DB_Stars").Range("A2:H" & AzStars + 1) = Ar_DBStars
Saving = False
Call CA_ScrollBar_Change
Me.BTN_Save.Caption = "SAVE CHANGES"
Me.BTN_Save.Visible = False

End Sub

Oups, a bit late, my browser updated and I just saw that there was a new page.

Thanks for validation. I will release an update tomorrow, till then please select the class of the star, before entering a text.

Jack London said:
Yes 1.40 FINAL clean install, i also tried 1.40 BETA 13 which is working fine.

Thanks for the reply. It has also to do with the star class. Next update will fix this.

johnUK · Jun 4, 2015

Hi
Looks great, but I can't get it to work.
I'm using a steam account, perhaps that's it.
I've got EliteOCR working (using AMD rapture screen save, I can't get ED's screen capture to work)
I presume someone else has asked but I can't find the answer, I've tried googling etc.
Could somebody point me in the right direction, please.
Thanks
John

PS, it says "current status.. Waiting for elite dangerous.. please enter the game"

eventure · Jun 4, 2015

johnUK said:
Hi
Looks great, but I can't get it to work.
I'm using a steam account, perhaps that's it.
I've got EliteOCR working (using AMD rapture screen save, I can't get ED's screen capture to work)
I presume someone else has asked but I can't find the answer, I've tried googling etc.
Could somebody point me in the right direction, please.
Thanks
John

PS, it says "current status.. Waiting for elite dangerous.. please enter the game"

Hello,

TCE cant find your position at the netlog file of Elite Dangerous, so please check, if the appconfig.xml path is set correctly and if the file holds the VerboseLogging="1" entry under network.
You dont need any screencapture app, because TCE makes the screenshot and reads it via EliteOCR automatically. Extract EliteOCR into the predefined folder of TCE.

If you using the Powerplay Beta of ED, TCE wont work, because they removed the required infos needed from the netlog file.

johnUK · Jun 4, 2015

Eventure said:
Hello,

TCE cant find your position at the netlog file of Elite Dangerous, so please check, if the appconfig.xml path is set correctly and if the file holds the VerboseLogging="1" entry under network.
You dont need any screencapture app, because TCE makes the screenshot and reads it via EliteOCR automatically. Extract EliteOCR into the predefined folder of TCE.

If you using the Powerplay Beta of ED, TCE wont work, because they removed the required infos needed from the netlog file.

Hi
Thanks for the prompt reply.
I think I've done the above, including moving EliteOCR into the folder created by TCE. (Though I'd forgotten that TCE can do the OCR using EliteOCR etc)
J:\Program Files (x86)\steam\SteamApps\common\Elite Dangerous\Products\FORC-FDEV-D-1010\Logs
in the top box
box below same but no logs on the end

I can't fathom it, but EDDiscovery has stopped working today, it has my flights from yesterday.
(I have an alpha account which I've used beta 1.3 with, but that's not what I'm using today or yesterday. I failed to get EDDiscovery to work with it last weekend)

<Network
Port="0"
upnpenabled="1"
LogFile="netLog"
DatestampLog="1"
VerboseLogging="1"
>
</Network>

For some reason it had two VerboseLogging="1", which I'd already corrected

I can't think of the obvious simple thing I'm missing.
John

johnUK · Jun 4, 2015

johnUK said:
Hi
Thanks for the prompt reply.
I think I've done the above, including moving EliteOCR into the folder created by TCE. (Though I'd forgotten that TCE can do the OCR using EliteOCR etc)
J:\Program Files (x86)\steam\SteamApps\common\Elite Dangerous\Products\FORC-FDEV-D-1010\Logs
in the top box
box below same but no logs on the end

I can't fathom it, but EDDiscovery has stopped working today, it has my flights from yesterday.
(I have an alpha account which I've used beta 1.3 with, but that's not what I'm using today or yesterday. I failed to get EDDiscovery to work with it last weekend)

<Network
Port="0"
upnpenabled="1"
LogFile="netLog"
DatestampLog="1"
VerboseLogging="1"
>
</Network>

For some reason it had two VerboseLogging="1", which I'd already corrected

I can't think of the obvious simple thing I'm missing.
John

Hi
It now works as does EDDiscovery, still can't fathom it, but I've noticed that the date stamp wasn't up to date at the end of the log file name, probably from about first starting up elite this evening before doing any changes. I don't think I actually changed anything just now, but, works it does. There's a new logfile with the current time.
Thanks
I'll TCE a thorough going over

eventure · Jun 4, 2015

johnUK said:
Hi
Thanks for the prompt reply.
I think I've done the above, including moving EliteOCR into the folder created by TCE. (Though I'd forgotten that TCE can do the OCR using EliteOCR etc)
J:\Program Files (x86)\steam\SteamApps\common\Elite Dangerous\Products\FORC-FDEV-D-1010\Logs
in the top box
box below same but no logs on the end

I can't fathom it, but EDDiscovery has stopped working today, it has my flights from yesterday.
(I have an alpha account which I've used beta 1.3 with, but that's not what I'm using today or yesterday. I failed to get EDDiscovery to work with it last weekend)

<Network
Port="0"
upnpenabled="1"
LogFile="netLog"
DatestampLog="1"
VerboseLogging="1"
>
</Network>

For some reason it had two VerboseLogging="1", which I'd already corrected

I can't think of the obvious simple thing I'm missing.
John

Okay, make a test:

Start ED and enter the game. When in, exit ED.
Search in the Logs folder after the newest netLog file and open it.
Look after the following rows, which looks like:

Code:

{17:56:14} System:19(Halai) Body:23 Pos:(788,409.748,459.524) 
{17:56:14} vvv------------ ISLAND 0x00000001 CLAIMED ------------vvv
{17:56:14} ^^^------------ island 0x00000001 claimed ------------^^^

The system row holds all informations, TCE needs. Is there any?
If not persent, appconfig.xml have a problem with the VerboseLogging entry. Delete the entry and start TCE. It will add the entry. Restart test again, till you found the system row.
If present, then TCE cant read the file, please post the filename of the netLog file, perhaps upload it, so i will try to look, where the problem is.

@Fine, it works again.

LBITB · Jun 4, 2015

Eventure said:
Please try to use only the new installer version without any changes. Please setup a new TCE.ini file and start. Did you experience the same?

Eventure,

Just tried an hour testing different things. If I do a complete clean install, I can get it to work but it then freezes. If I do a complete clean install, then copy in my database before running the setup file and then running TCE for the first time, I get the following error:

Error in Startsequence
Error Line:110
Error: (-214721900) Could not find field 'OutFitNote'

And after clicking ok, the problem of black screen on Logbook appears again.

So appears to be a problem with the new TCE upgrading the database from the previous version.

eventure · Jun 4, 2015

LBITB said:
Eventure,

Just tried an hour testing different things. If I do a complete clean install, I can get it to work but it then freezes. If I do a complete clean install, then copy in my database before running the setup file and then running TCE for the first time, I get the following error:

Error in Startsequence
Error Line:110
Error: (-214721900) Could not find field 'OutFitNote'

And after clicking ok, the problem of black screen on Logbook appears again.

So appears to be a problem with the new TCE upgrading the database from the previous version.

Please upload your database, i will check it.

What you mean with "freezes"? Please more details. Thanks

LBITB · Jun 4, 2015

Eventure said:
Please upload your database, i will check it.

What you mean with "freezes"? Please more details. Thanks

PM sent.

By freezes, either all TCE freezes, or most often it was just the Commanders Log Panel, where there was no responsiveness. As trouble in a much previous version, switching to Task Manager and back again, briefly got TCE flowing again.

eventure · Jun 4, 2015

LBITB said:
PM sent.

By freezes, either all TCE freezes, or most often it was just the Commanders Log Panel, where there was no responsiveness. As trouble in a much previous version, switching to Task Manager and back again, briefly got TCE flowing again.

Thats not normal, i suggest you reinstall your office and update it to the newest level. I tested your upgraded version and it looks all good here. No problems with it. So i cant reproduce your reported behavior.
Perhaps, you can send me your whole TCE folder.

Grumpy181155 · Jun 5, 2015

Hi Evenure. I have decided to make a clean start which I will probably do when 1.3 comes out and with that in mind I have just done a clean install of the TCE and was looking in the Databases. I have found in Stations_UR at least one duplicate station ID # 6019 and 6020 and I have a couple of questions that I hope you answer for me;
1. Assuming this is a clean install and no data has been entered - is it okay to just delete an entry in the Stations_UR database and then re-number the ID list;
2. Is it possible to delete all stations in the database and enter them as I find them using the Overlay?