Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.

LBITB

L
LBITB said:
V1.42 Beta 1

Trying to save commodity prices in a newly entered station

Getting error:

Error in Commodity Panel
Error Line: 30

Error: (13) Type Mismatch

Will try Beta 2 now


Also, discovered a new outpost type - Mining Outpost. Ignore that, it comes up as Industrial Outpost once docked.
Click to expand...

Commodity saving fixed in Beta 2, but now noticed that despite following instrucitons on how to upgrade, my database doesn't have Osmium or SAP Core 8 - how do I safely add them in please?

- - - Updated - - -

Now getting Error in Startsequence, Error Line: 220, Error: (9) Subscript out of range when opening TCE
 

Warox

Warox
LBITB said:
Commodity saving fixed in Beta 2, but now noticed that despite following instrucitons on how to upgrade, my database doesn't have Osmium or SAP Core 8 - how do I safely add them in please?
Click to expand...

You had them in previous versions ? Strange indeed. It didn't disapear in my case. Verify you added both in EliteOCR. And then, if yes, launch TCE => Database Tab => Wares => Add commodity record.

To add them in EliteOCR : launch EliteOCR.exe => Settings => Commodities Editor => Add Commodity button. Type in your commodity and add "False" in rare row (except if it's a rare commodity of course^^)
 
Last edited:

LBITB

L
LBITB said:
Commodity saving fixed in Beta 2, but now noticed that despite following instrucitons on how to upgrade, my database doesn't have Osmium or SAP Core 8 - how do I safely add them in please?

- - - Updated - - -

Now getting Error in Startsequence, Error Line: 220, Error: (9) Subscript out of range when opening TCE
Click to expand...

And now getting Error in Commodity Panel, Error Line 10, Error (13) Type mismatch when I click on the commodity panel
 

eventure

eventure
LBITB said:
Commodity saving fixed in Beta 2, but now noticed that despite following instrucitons on how to upgrade, my database doesn't have Osmium or SAP Core 8 - how do I safely add them in please?

- - - Updated - - -

Now getting Error in Startsequence, Error Line: 220, Error: (9) Subscript out of range when opening TCE
Click to expand...

Please read here for adding the new commodities. Cmdr Bupu made a good walkthrough.

Your error comes from your database. Please check the last entries, you made, use a backup or send it to me.

- - - Updated - - -

Warox said:
You had them in previous versions ? Strange indeed. It didn't disapear in my case. Verify you added both in EliteOCR. And then, if yes, launch TCE => Database Tab => Wares => Add commodity record.

To add them in EliteOCR : launch EliteOCR.exe => Settings => Commodities Editor => Add Commodity button. Type in your commodity and add "False" in rare row (except if it's a rare commodity of course^^)
Click to expand...

Did you update your Office, as you said? How about changing your display settings for dates in excel to france, germany or any other, beside your actual selected, as a test.

@Found this: http://answers.microsoft.com/en-us/...t-issues/915a9037-6095-4c74-bb38-54a3b41da9d8
 
Last edited:

LBITB

L
Eventure said:
Please read here for adding the new commodities. Cmdr Bupu made a good walkthrough.

Your error comes from your database. Please check the last entries, you made, use a backup or send it to me.

- - - Updated - - -
Click to expand...

Thanks Warox and Eventure. I had a mad 10 minutes not thinking, not helped by the internet connection going down here, meaning when looking at a clean copy of TCE database, I stupidly manually added the missing commodities in myself. Deleted rows from the Goods table, then used TCE properly and error messages went. Still couldn't get SAP 8 Core Container to scan, turns out OCR is case sensitive when you add commodity names in!

All working fine now with Beta 2!
 

eventure

eventure
LBITB said:
Thanks Warox and Eventure. I had a mad 10 minutes not thinking, not helped by the internet connection going down here, meaning when looking at a clean copy of TCE database, I stupidly manually added the missing commodities in myself. Deleted rows from the Goods table, then used TCE properly and error messages went. Still couldn't get SAP 8 Core Container to scan, turns out OCR is case sensitive when you add commodity names in!

All working fine now with Beta 2!
Click to expand...

Please check your language.mdb > LOC_Goods table of double entries.
 

LBITB

L
Now trying to edit my dates and times for those entries the in the Commanders Log when I was using Beta 1. Get a Run time error 13 (I think, box partially obscured) Type mismatch, when I click save, then TCE crashes out.

When click debug, in Panel_LOG_Logbook (Code) it stops at highlighted row below:

If Me.BTN_Com2_Label.Caption = "SAVE" And Me.TL_TB_Date.Visible = True Then
iTxt = "TL_Date"
iName = iTxt & TL_SelectID - Me.TL_ScrollBar.Value
Me.Controls(iName).Caption = Me.TL_TB_Date.Value
If Ar_DBLogbook(TL_SelectID, 2) <> CDate(Me.TL_TB_Date.Value) Then [THIS ROW IS HIGHLIGHTED YELLOW]
Ar_DBLogbook(TL_SelectID, 2) = CDate(Me.TL_TB_Date.Value)
Worksheets("DB_Log").Cells(TL_SelectID + 1, 2).Value = CDate(Me.TL_TB_Date.Value)
End If
Me.TL_TB_Date.Visible = False
Me.Controls(iName).Visible = True
Log_edit = True
Call SQL_Export_Mod(AppPath & "\DB\Logbook.mdb", "Log")
Log_edit = False
Call Command_Buttons_Reset
Me.BTN_Com1.Visible = True
Me.BTN_Com1_Back.Visible = True
Me.BTN_Com1_Label.Caption = "MODIFY"
Me.BTN_Com1_Label.Visible = True
Me.BTN_Com2.Visible = True
Me.BTN_Com2_Back.Visible = True
Me.BTN_Com2_Label.Caption = "DELETE"
Me.BTN_Com2_Label.Visible = True
Me.BTN_Com3.Visible = True
Me.BTN_Com3_Back.Visible = True
Me.BTN_Com3_Label.Caption = "STORE"
Me.BTN_Com3_Label.Visible = True
Me.BTN_Com4.Visible = True
Me.BTN_Com4_Back.Visible = True
Me.BTN_Com4_Label.Caption = "ACTIVITY"
Me.BTN_Com4_Label.Visible = True
Exit Sub
End If
 
Last edited:

eventure

eventure
LBITB said:
Now trying to edit my dates and times for those entries the in the Commanders Log when I was using Beta 1. Get a Run time error 13 (I think, box partially obscured) Type mismatch, when I click save, then TCE crashes out.

When click debug, in Panel_LOG_Logbook (Code) it stops at highlighted row below:

If Me.BTN_Com2_Label.Caption = "SAVE" And Me.TL_TB_Date.Visible = True Then
iTxt = "TL_Date"
iName = iTxt & TL_SelectID - Me.TL_ScrollBar.Value
Me.Controls(iName).Caption = Me.TL_TB_Date.Value
If Ar_DBLogbook(TL_SelectID, 2) <> CDate(Me.TL_TB_Date.Value) Then [THIS ROW IS HIGHLIGHTED YELLOW]
Ar_DBLogbook(TL_SelectID, 2) = CDate(Me.TL_TB_Date.Value)
Worksheets("DB_Log").Cells(TL_SelectID + 1, 2).Value = CDate(Me.TL_TB_Date.Value)
End If
Me.TL_TB_Date.Visible = False
Me.Controls(iName).Visible = True
Log_edit = True
Call SQL_Export_Mod(AppPath & "\DB\Logbook.mdb", "Log")
Log_edit = False
Call Command_Buttons_Reset
Me.BTN_Com1.Visible = True
Me.BTN_Com1_Back.Visible = True
Me.BTN_Com1_Label.Caption = "MODIFY"
Me.BTN_Com1_Label.Visible = True
Me.BTN_Com2.Visible = True
Me.BTN_Com2_Back.Visible = True
Me.BTN_Com2_Label.Caption = "DELETE"
Me.BTN_Com2_Label.Visible = True
Me.BTN_Com3.Visible = True
Me.BTN_Com3_Back.Visible = True
Me.BTN_Com3_Label.Caption = "STORE"
Me.BTN_Com3_Label.Visible = True
Me.BTN_Com4.Visible = True
Me.BTN_Com4_Back.Visible = True
Me.BTN_Com4_Label.Caption = "ACTIVITY"
Me.BTN_Com4_Label.Visible = True
Exit Sub
End If
Click to expand...

Will check it. You can also add the dates and time directly into the logbook.mdb > log.

LBITB said:
I have double entries - safe to delete first entry of each manually?
Click to expand...

Their ID have to be continuous and the same as in the Goods table of the TCE.mdb.
 
Last edited:

Warox

Warox
Eventure said:
Did you update your Office, as you said? How about changing your display settings for dates in excel to france, germany or any other, beside your actual selected, as a test.

@Found this: http://answers.microsoft.com/en-us/...t-issues/915a9037-6095-4c74-bb38-54a3b41da9d8
Click to expand...

Yes everything was updated. I disabled the secondary clock which was UTC, didn't resolve the problem. I verified every Windows parameters, but they didn't move, and were still french as usual.
It works if I use German format in Windows !!! Hahaha !!! It's alive !

- - - Updated - - -

Jack London said:
Bugreport V1.42 Beta 2 FreshDB (Win8.1/O13/64bit)

Stored Locations – Shipyard


  • Editing the availability of a ship (remove/add) causes an error (Pictures)
  • Editing or Adding a Note causes an error

Pitures: http://imgur.com/a/HVHlW
Click to expand...

Ha Jack has the same error than me. It's really related to format so ! It's strange as french and german formats are the same. (Now my computer say we are Donnerstag^^).
 

LBITB

L
I think it's linked to same problem as Warox and Jack London. Also, I can't edit directly as it comes up with an error on the format - it's like there is some hidden extra numbers and format needed....?
 

Warox

Warox
I think I found the issue. German format is "dd.mm.yyyy" and french format is "dd/mm/yyyy". I changed short date in Windows settings to "dd.mm.yyyy" and it now works !

- - - Updated - - -

Damn Slash !!! /
I always knew it was Gun's and Roses guitarist's fault !
 

eventure

eventure
LBITB said:
I think it's linked to same problem as Warox and Jack London. Also, I can't edit directly as it comes up with an error on the format - it's like there is some hidden extra numbers and format needed....?
Click to expand...

Please clear the format from the Date column. Here is a picture:
Db_properties.jpg

Please try again. Perhaps that could be an issue.
 

eventure

eventure
Jack London said:
Minor Bugreport 1.42 Beta 2


  • Inconsistent Date Stamps (I do not want to wake the currently sleeping data-format-monster)
OS formate is TT.MM.JJJJ which translates to dd.mm.yyyy
​

Picture: http://imgur.com/TuNwhF5
Click to expand...

No, no, it is well sleeping :)

Found the problem. Your date shows MM.DD.YYYY, beside of the log entry, it was forced to german, my fault, forgot to delete the format.
I let Excel select the right language setting with a xlcountrycode call. Case 1 (USA) for MM.DD.YYYY, as displayed for you, all other getting DD.MM.YYYY. So Excel is thinking, you are in the USA.

- - - Updated - - -

LBITB said:
Changing it has done the trick - thank you!
Click to expand...

Wow, cool, i saw it some days ago, that the column had a defined format. But i cant remove it through SQL commands, or i didnt know, how to do it. Was a guess.

To all with DATE FORMAT PROBLEMS, please delete the following format definions (not the column) at the Logbook.mdb:

Table: Log
Column: Date

Table: Activity
Column: EntryDate

Table: Store
Column: VDate

Here again the picture:
Db_properties.jpg

If anyone knows, how to do it with SQL commands, tell me. I will add it as a start up fix. But until then, it has to be done manually.
 
Last edited:

yyy

Y
Edited

I installed version 1.41. Moved the database files from 1.40beta1. Whenever I try to add station the windows taskbar appears at the bottom and the "Add New Station dialogue" does not have a save button, therefore I cannot save the station. I am running ED in borderless mode.

How do I resolve this?
 
Last edited:

Warox

Warox
Eventure said:
No, no, it is well sleeping :)

To all with DATE FORMAT PROBLEMS, please delete the following format definions (not the column) at the Logbook.mdb:

Table: Log
Column: Date

Table: Activity
Column: EntryDate

Table: Store
Column: VDate

Here again the picture:
View attachment 43183

If anyone knows, how to do it with SQL commands, tell me. I will add it as a start up fix. But until then, it has to be done manually.
Click to expand...

I did it as you said, but unfortunately the only solution for me is changing my OS date format in Windows Regional and languages parameters. When I use the date format with the points, I have no problem.
 
Status
Thread Closed: Not open for further replies.
Back
Top Bottom