Abandoned [RELEASE] Trade Computer Extension

[LBITB]

Getting an error when trying to run for first time, having set the file locations. Get the following error message:

Run-time error '380':

Could not set the Zoom property. Invalid property value. Enter a value between 10 and 400.

On pressing debug, it highlights the following line of code in the Panel_Position (Code) area:

If Main_Panel = "TOP" Then
Panel_Menu_top.Zoom = Worksheets("DB_Positions").Cells(2, 5).Value
Else
Panel_Menu_bottom.Zoom = Worksheets("DB_Positions").Cells(2, 5).Value
End If

I'm on a 4k screen, is that the trouble?

 

[eventure]

Getting an error when trying to run for first time, having set the file locations. Get the following error message:

Run-time error '380':

Could not set the Zoom property. Invalid property value. Enter a value between 10 and 400.

On pressing debug, it highlights the following line of code in the Panel_Position (Code) area:

If Main_Panel = "TOP" Then
Panel_Menu_top.Zoom = Worksheets("DB_Positions").Cells(2, 5).Value
Else
Panel_Menu_bottom.Zoom = Worksheets("DB_Positions").Cells(2, 5).Value
End If

I'm on a 4k screen, is that the trouble?

No, did you copied the panel.mdb from the Update V1.35d into the DB folder of TCE?

Adding a new Star System

Microsoft Visual Basic

Run-time error '-2147417848 (80010108)':
Method 'Value' of object 'Range' failed


Could not copy the Debug Code because Excel Crashed.

Restarted and tried the same again. Full Excel Crash again with the same error,
but I manage to take a screen shot before it shut down on me :

Have wrote a partial new routine for all database access for the new version, so further problems should be minimal or gone.

I plan to release a beta of the new V1.36 this evening. The beta has no import function for your old databases, but the non-beta will have one. Its a full-version only, because of too many changes. So all, who wants to test it, please make a clean install.

 

[LBITB]

No, did you copied the panel.mdb from the Update V1.35d into the DB folder of TCE?


Whoops! I hadn't, just the main Excel file. Thanks very much - first time of use

 

[punkerich]

I plan to release a beta of the new V1.36 this evening. The beta has no import function for your old databases, but the non-beta will have one. Its a full-version only, because of too many changes. So all, who wants to test it, please make a clean install.

So, we could start fresh with the beta, and when full comes out import the data into it?
Sounds very good.

 

[LBITB]

Getting another Runtime error now:

Run-time error '-2147417848 (80010108)':

Method 'Value' of object 'Range' failed

This happens when I try to Add Star System Record, on the press of the save button.

 

[RadBlaster]

Getting another Runtime error now:

Run-time error '-2147417848 (80010108)':

Method 'Value' of object 'Range' failed

This happens when I try to Add Star System Record, on the press of the save button.

Hey LBITB. Glad you enjoying the tool. Both myself and Bragolatch have the same issues. Look at post #847 from Eventure.
I think we just have to wait

...Have wrote a partial new routine for all database access for the new version, so further problems should be minimal or gone.

I plan to release a beta of the new V1.36 this evening. The beta has no import function for your old databases, but the non-beta will have one. Its a full-version only, because of too many changes. So all, who wants to test it, please make a clean install.

 

[BennyBoyW]

Hi. I only just started using this but it looks brilliant.
One problem I am having is that the Commodity button doesn't do anything when I click it. Do I need to do something else first?

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

Ignore last post. Just found what I think is the answer.

 

[eventure]

New Full-Version (V1.36 beta 1) released:
- Added 145 registered (150 total) and ca. 11.700 unregistered trade stations
- Added ca. 2.500 star systems (22,3k total)
- Thanks to Maddavo's data support
- Many code optimizations for better performance on larger databases and starting process
- Bugfixes and optimiations in many panels
- Added Star System Note panel to Panel Control
- Added Landing Pad Size to stations information
- Small UI fixes

Notes: This is a new full version, which is not compatible with older databases (TCE.mdb) from previous versions. I will add an import function in the final V1.36 version. But you can use the panel.mdb from older verions, the Star System Info panel value are automatically (x=0,y=0,zoom=100) added, when the values are missing. Also, you can use the TCE.ini, if you copy this version to the same place. But dont overwrite your old database. Make a backup before!

Registered trade stations are stations, that have a full set of data, which are entered via Database panel. Unregistered trade stations are stations, that have only a star system position. You can view and select them via the Destination panel. When landed on an unregistered station, you have to register it through the Database > Stations panel. You can select it via a dropdown box. Fill all the rest of the data and save it. Now its a registered station.

I found some duplicates or mistyped stations in the unregistered station data. I think, i didnt found all. I will add a delete option at the Station Panel in a comming update. But please feel free to give a comment, if you found more.

 

[punkerich]

well done, eventure. working like a charm.

i have a few suggestions for future updates:

- for the trade scout, add an optional field for the max search range, depending on actual position. should speed up the search aswell.
- add a note field for stations, so one can e.g. document the available outfitting.

and perhaps, if possible, something like a search field for the destination panel would be cool (station and/or system)

wishing you a good night, and a relaxing weekend.

 

[Bragolatch]

Hi, just starting with 1.36beta.

1. Got an error and a crash when I tried keeping TCE.ini,
so I erased everything and started again with everything new, without problems.

2. Mouse switch between the game an TCE seem much improved !

3. Can't change the value for #of bodies in DATABASE - START SYSTEM

4. Added my first station, scanned the commodities and got an error when I clicked on save
(did it twice, with the same result)

Run-time error '9':
Subscript out of range

Can't execute code in break mode


Sub DES_Commodities()


Dim Station_ID_S As Long, Station_ID_Z As Long, ArExport As Variant, ArImport As Variant, b As Long, c As Long, lLZeile As Long

Station_ID_Z = Worksheets("Werte").Cells(13, 2).Value
ReDim ArExport(1 To AzGoods, 1 To 3) As Variant
ReDim ArImport(1 To AzGoods, 1 To 3) As Variant
For c = 3 To AzGoods + 2
DoEvents
If ArData_Buy(c, Station_ID_Z + 2) <> 0 And ArData_Buy(c, Station_ID_Z + 2) <> "" Then
ArExport(c - 2, 1) = ArData_Buy(c, 2)
ArExport(c - 2, 2) = ArData_Buy(c, Station_ID_Z + 2)
ArExport(c - 2, 3) = ArData_Buy(c, Station_ID_Z + 2) - ArData_Goods(c - 2, 3)
End If
If ArData_Sell(c, Station_ID_Z + 2) <> 0 And ArData_Sell(c, Station_ID_Z + 2) <> "" And ArData_Sell(c, Station_ID_Z + 2) - ArData_Goods(c - 2, 3) > 0 Then
ArImport(c - 2, 1) = ArData_Sell(c, 2)
ArImport(c - 2, 2) = ArData_Sell(c, Station_ID_Z + 2)
ArImport(c - 2, 3) = ArData_Sell(c, Station_ID_Z + 2) - ArData_Goods(c - 2, 3)
End If
Next c
Worksheets("DES_Export").Range("A2:C" & AzGoods + 1).ClearContents
Worksheets("DES_Export").Range("A2:C" & AzGoods + 1) = ArExport
Worksheets("DES_Export").Activate
ActiveWorkbook.Worksheets("DES_Export").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("DES_Export").Sort.SortFields.Add Key:=Range( _
"C2:C1001"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("DES_Export").Sort
.SetRange Range("A1:C1001")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Worksheets("DES_Import").Range("A2:C" & AzGoods + 1).ClearContents
Worksheets("DES_Import").Range("A2:C" & AzGoods + 1) = ArImport
Worksheets("DES_Import").Activate
ActiveWorkbook.Worksheets("DES_Import").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("DES_Import").Sort.SortFields.Add Key:=Range( _
"C2:C1001"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("DES_Import").Sort
.SetRange Range("A1:C1001")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With

End Sub

 

[punkerich]

Something changed with the implementation of eliteocr?
Yesterday evening, working well. now, when i click start ocr scan, it directly comes back without scanning. restart tce, it asks me for the directory. i point towards it, tce starts, does not scan.
tried different folders, different eliteocr versions. sometimes it even says 'file not found'. definately the right dir. and well working on its own...
?

edit: is there a version check of some kind?
if i point to tce135\eliteocr dir, it works.
if i select the eliteocr-path of the newest version, it does not, 'file not found'
updated eliteocr, too, last evening...

edit:
ignore this. somehow unnoticed, 360 total security quarantined the eliteocrcmd.exe...

 

[BennyBoyW]

I started using this tool last night and can I just say that it is absolutely brilliant !
@Eventure - great work !!!!

I have seen an issue which has been mentioned on this board.
Adding any star systems to the database seems to break the tool - is there any news on when this might be fixed ?

 

[Yokai]

Hi, just starting with 1.36beta.

1. Got an error and a crash when I tried keeping TCE.ini,
so I erased everything and started again with everything new, without problems.

2. Mouse switch between the game an TCE seem much improved !

3. Can't change the value for #of bodies in DATABASE - START SYSTEM

4. Added my first station, scanned the commodities and got an error when I clicked on save
(did it twice, with the same result)

Run-time error '9':
Subscript out of range

Can't execute code in break mode


Sub DES_Commodities()


Dim Station_ID_S As Long, Station_ID_Z As Long, ArExport As Variant, ArImport As Variant, b As Long, c As Long, lLZeile As Long

Station_ID_Z = Worksheets("Werte").Cells(13, 2).Value
ReDim ArExport(1 To AzGoods, 1 To 3) As Variant
ReDim ArImport(1 To AzGoods, 1 To 3) As Variant
For c = 3 To AzGoods + 2
DoEvents
If ArData_Buy(c, Station_ID_Z + 2) <> 0 And ArData_Buy(c, Station_ID_Z + 2) <> "" Then
ArExport(c - 2, 1) = ArData_Buy(c, 2)
ArExport(c - 2, 2) = ArData_Buy(c, Station_ID_Z + 2)
ArExport(c - 2, 3) = ArData_Buy(c, Station_ID_Z + 2) - ArData_Goods(c - 2, 3)
End If
If ArData_Sell(c, Station_ID_Z + 2) <> 0 And ArData_Sell(c, Station_ID_Z + 2) <> "" And ArData_Sell(c, Station_ID_Z + 2) - ArData_Goods(c - 2, 3) > 0 Then
ArImport(c - 2, 1) = ArData_Sell(c, 2)
ArImport(c - 2, 2) = ArData_Sell(c, Station_ID_Z + 2)
ArImport(c - 2, 3) = ArData_Sell(c, Station_ID_Z + 2) - ArData_Goods(c - 2, 3)
End If
Next c
Worksheets("DES_Export").Range("A2:C" & AzGoods + 1).ClearContents
Worksheets("DES_Export").Range("A2:C" & AzGoods + 1) = ArExport
Worksheets("DES_Export").Activate
ActiveWorkbook.Worksheets("DES_Export").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("DES_Export").Sort.SortFields.Add Key:=Range( _
"C2:C1001"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("DES_Export").Sort
.SetRange Range("A1:C1001")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Worksheets("DES_Import").Range("A2:C" & AzGoods + 1).ClearContents
Worksheets("DES_Import").Range("A2:C" & AzGoods + 1) = ArImport
Worksheets("DES_Import").Activate
ActiveWorkbook.Worksheets("DES_Import").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("DES_Import").Sort.SortFields.Add Key:=Range( _
"C2:C1001"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("DES_Import").Sort
.SetRange Range("A1:C1001")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With

End Sub

Same issue with the 1.63 beta.

I'm getting exactly the same symptoms quoted above when trying to save a commodity update for a (formerly) unregistered station. Same exact line in Sub DES_Commodities ios triggering the "Can't execute code in break mode". TCE becomes irrevocably broken after this occurs.

To reproduce:

1. Find a station that is listed in the "unregistered stations" list (can select the name of station from the dropdown, but station data is otherwise empty.
2. Fill out station data and save. So far successful.
3. Open commodity panel and "Start OCR Scan" (several times as needed) to fully populate the commodity data for the station.
4. Click Save. Crash as quoted above, and your commodity UI is stuck on the "wait" button. ETC is now totally locked up and non-responsive, need to use Task Manager to kill Excel entirely.
5. Restart ETC entirely and after the UI loads you see the SAME "Run-time error '9': Subscript out of range" message suddenly appear.
6. Click End, and TCE shuts down by itself.
7. Try to open TCE again and you get a message that TCE is already open and do you want to reopen it, which will undo any changes, yada yada.
8. Click OK, TCE opens again, overlay appears fine, but then the SAME error message appears.

Bascially, once you run into this error, TCE is utterly and completely hosered for good and will no longer work at all

Note that I'm using the Office 365 version of Excel, on a Win 8.1 64-bit OS.


Other issues with 1.63 beta:

Your instructions on "how to install and run" on the OP imply there is a shortcut already waiting to be run, but I had to manually create a shortcut from the XSLM file and manually add the TCE icon to the shortcut.

Next up: Office 365 does not like the certificates made by your prestart.bat. File. You get the typical "Macros were blocked" message, and the ONLY thing that enables your XSLM to fully start successfully (in Excel 365), is to go into the trust center and fully enable ALL macros. Which is pretty risky. I could find no way to enable only your XSLM that would not require a blanket drop in security.

The first config dialog that gathers the relevant paths asks for the ED install directory, which will confuse more people than it helps because multiple ED folders are spread all over one's computer. I imagine that especially for the ED /logs folder it would be helpful to specify typical places to go looking for it, with advice to enable visibility of hidden folders. On my Win 8.1 64-bit computer the path is C:\Users\(computer name)\AppData\Local\Frontier_Developments\Products\FORC-FDEV-D-1010\Logs. Note that AppData is a hidden folder by default, and that in the Local folder there are both a "Frontier Developments" and "Frontier_Developments" folder. Confusing. As. Heck.

On the bright side, cheers for the amazing integration with EliteOCR. How you've pulled that off is beyond me. Although it's not clear from your OP instructions that you must still manually scroll the commodities screen in-game to display the full "section" you're trying to capture next, and that you must "Start OCR Scan" several times as needed in any "section" that does not have accurate data yet. Veterans at EliteOCR will figure this out quickly, but I doubt new users will. Essentially, right now, your tool's usability and instructions are effectively usable only by the more technically minded. That's not a bad thing, but a "tread carefully if this stuff is all new to you" caution in your OP instructions might be helpful?

 

[BennyBoyW]

Adding a star system with no stations in it for me results in "Method 'value' of Object 'Range' failed" followed by full crash of Excel

Using new Beta version

 

[eventure]

3. Can't change the value for #of bodies in DATABASE - START SYSTEM

Its locked in adding a new or unregistered station, you can modify it when editing a station.

4. Added my first station, scanned the commodities and got an error when I clicked on save
(did it twice, with the same result)

Problem comes, when you have an unregistered station as your destination. Releasing an update shortly, that should fix the issue.

Other issues with 1.63 beta:

Your instructions on "how to install and run" on the OP imply there is a shortcut already waiting to be run, but I had to manually create a shortcut from the XSLM file and manually add the TCE icon to the shortcut.

Its the non-installer version, so no creation of a shortcut. The installer comes back with the non-beta version.

Next up: Office 365 does not like the certificates made by your prestart.bat. File. You get the typical "Macros were blocked" message, and the ONLY thing that enables your XSLM to fully start successfully (in Excel 365), is to go into the trust center and fully enable ALL macros. Which is pretty risky. I could find no way to enable only your XSLM that would not require a blanket drop in security.

Please try to add the TCE folder as a trusted location, when possible.

The first config dialog that gathers the relevant paths asks for the ED install directory, which will confuse more people than it helps because multiple ED folders are spread all over one's computer. I imagine that especially for the ED /logs folder it would be helpful to specify typical places to go looking for it, with advice to enable visibility of hidden folders. On my Win 8.1 64-bit computer the path is C:\Users\(computer name)\AppData\Local\Frontier_Developments\Products\FORC-FDEV-D-1010\Logs. Note that AppData is a hidden folder by default, and that in the Local folder there are both a "Frontier Developments" and "Frontier_Developments" folder. Confusing. As. Heck.

On the bright side, cheers for the amazing integration with EliteOCR. How you've pulled that off is beyond me. Although it's not clear from your OP instructions that you must still manually scroll the commodities screen in-game to display the full "section" you're trying to capture next, and that you must "Start OCR Scan" several times as needed in any "section" that does not have accurate data yet. Veterans at EliteOCR will figure this out quickly, but I doubt new users will. Essentially, right now, your tool's usability and instructions are effectively usable only by the more technically minded. That's not a bad thing, but a "tread carefully if this stuff is all new to you" caution in your OP instructions might be helpful?

To find the right folders is really a problem, because of FD inconssistant install structure. I can scan the hole computer after the right files, but thats real time consuming and not practical. Perhaps accessing the registry could be the right way, but i dont no how to make it via vba atm. But i will check this.

Adding a star system with no stations in it for me results in "Method 'value' of Object 'Range' failed" followed by full crash of Excel

Using new Beta version

That problem is not solved? I added some new systems without a problem. I will big deeper into it.

Update (V1.36 beta 2) released:
- Fixed saving prices with an unregistered station as a destiniation issue.

 

[Yokai]

To find the right folders is really a problem, because of FD inconssistant install structure. I can scan the hole computer after the right files, but thats real time consuming and not practical. Perhaps accessing the registry could be the right way, but i dont no how to make it via vba atm. But i will check this.

Ya, I understand. Slopey's does some type of brute force search, perhaps starting at root of C:? It can take close to 5 minutes to finally find the logs folder on my system the way Slopey does it.

Testing Beta 2 now.

 

[eventure]

To all, who have crashes on star system adding, what system language you are using?

 

[Bragolatch]

Problem comes, when you have an unregistered station as your destination. Releasing an update shortly, that should fix the issue.

Do you mean that if I Register the System by inputting the distance to the 3 reference starts it will not crash ?

I'll have to try that before in install the beta 2.

I'm a sucker for punishment lol

 

[eventure]

Do you mean that if I Register the System by inputting the distance to the 3 reference starts it will not crash ?

I'll have to try that before in install the beta 2.

I'm a sucker for punishment lol

No, i mean, that when saving prices, the problem is your destination, when its an unreg. station. Beta 2 should fix it. But when saving a star system, there could be a problem with point values (like 3.4). In germany we use a comma (3,4).

 

[Yokai]

In Beta2 I'm now successfully adding commodities to unregistered stations.

BTW, after I play extensively with ETC this weekend, would you like me to write a user-friendly guide to installing and using it? I can post it in the guides forum and you can link to it in the OP. It might be Wednesday before I can finish it and post the first version.