Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.
Got v1.32b, and the update to v1.32c. Trusted. Got the Type Mismatch error. Got rid of TCE.ini . Started with the config window. Configured my log/Appconfig/EliteOCR directories, then...

Run-time error '1004'

Initialization of the data source failed.

Looks like it didn't like the line ".Refresh BackgroundQuery:=False" in Sub DB_Importer()

Pls help.

OK, installed AccessDatabaseEngine. Loaded OK. But getting type mismatch errors when doing some things. Editing stars - hit save - type mismatch error.

This looks great if it works.
 
OK, installed AccessDatabaseEngine. Loaded OK. But getting type mismatch errors when doing some things. Editing stars - hit save - type mismatch error.

This looks great if it works.

yeah I keep hitting mismatch errors aswell doing all kind of stuff

Please be more specific:
- Where did you have this error?
- Press debug and show me the codeline.
- What did you before the error happens?
- Screenshot from TCE with the error.

Thanks.
 
Last edited:
I got a PM from Seeebek:

icon1.png
EliteOCR update
0.5.2.2
-Fix for a minor bug when exporting to EDDN (won't crash anymore when part of the data won't be sent)
-Added supplyLevel and demandLevel to EDDN export
-Added command line argument to translate the output

He added translation support from command line...

Edith:
I tried your actual version and found the utf-8-import from EliteOCR bugged: commodities with umlauts aren't still read correctly. I understood your comment, that you already implemented utf-8 support into version 1.32c. I modified my TCE.mdb, that I replaced the english commodity names of the goods with the germans, which runs in TCE pretty well despite the names with umlauts aren't read properly from the EliteOCR output file.

Edith 2: BTW, I edited correctly the flag in the TCE.xlsm to "-l deu"

Edith 3: Tested the translate feature: I works like a charm: I can use ED in german and TCE in english and I get the german commodities translate into english into TCE.
 
Last edited:
tried this with excel 2010 just before 1.1 release went live worked fine was using 1.32b, upgraded to 1.1 & 1.32c and I now get at starttup to three green cubes and it hangs with a runtime 9, script out of range
this was the debug in goods code :

ArData_Buy(b + 2, a + 2) = ArData_Import((a - 1) * Worksheets("Werte").Cells(52, 2).Value + b, 4)

Any help would be appreciated.

Love your work
 
May I have a dumb question: I have no clue, what the "margin" means. Is that the difference to the "galactic average"?

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

I found an issue with the commodities in "Stock". The trade advisor and trade scout wants me to buy Palladium at a station which doesn't have any in stock.

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

I got another bug after OCRed the commodities and hit the save button:
2015-02-13 23_41_27-Panel_Prices.png2015-02-13 23_59_02-Panel_Prices.png
 
Last edited:
Edith:
I tried your actual version and found the utf-8-import from EliteOCR bugged: commodities with umlauts aren't still read correctly. I understood your comment, that you already implemented utf-8 support into version 1.32c. I modified my TCE.mdb, that I replaced the english commodity names of the goods with the germans, which runs in TCE pretty well despite the names with umlauts aren't read properly from the EliteOCR output file.

Edith 2: BTW, I edited correctly the flag in the TCE.xlsm to "-l deu"

Edith 3: Tested the translate feature: I works like a charm: I can use ED in german and TCE in english and I get the german commodities translate into english into TCE.

Preparing a bigger update tomorrow. The new import routine for EliteOCR exports supports utf-8 now. In addition TCE supports the new translation feature also. You can select your OCR language in the Options panel. Perhaps you can share your translation of commodities with me to move a step further of translating TCE into german, if you like.

May I have a dumb question: I have no clue, what the "margin" means. Is that the difference to the "galactic average"?

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

I found an issue with the commodities in "Stock". The trade advisor and trade scout wants me to buy Palladium at a station which doesn't have any in stock.

Yes, it is the difference to the "galactic average". Will check the issue.

Edit: Found both issues.

tried this with excel 2010 just before 1.1 release went live worked fine was using 1.32b, upgraded to 1.1 & 1.32c and I now get at starttup to three green cubes and it hangs with a runtime 9, script out of range
this was the debug in goods code :

ArData_Buy(b + 2, a + 2) = ArData_Import((a - 1) * Worksheets("Werte").Cells(52, 2).Value + b, 4)

Any help would be appreciated.

Love your work

Looks like a database problem. Are you using a clean install or did you entered data (especially commodities or stations)? Try the last working backup of TCE.mdb.
 
Last edited:
Ok Eventure, now we are getting somewhere, i was right in my theory that it was a language issue, in that the TCE.ini file had Wahr and Falsch in the values, so i did a Replace using notepad to change them to True and False and then launched TCE.

I am now seeing Elite dangerous running with the TCE overlay as it should be.

Thank you for your efforts on this project, my frustration was only in not getting it to work despite doing all the pre-checks in your instructions, but now i've found the bit about Wahr and Falsch causing the issues, it works first time without the runtime error 13 error occuring.

HOPE THIS HELPS.

(I also used your latest xlsm posted by you just now but still got the runtime error 13 until i did this ini file change.

it DOES - THANK YOU!
 
Hm, I dunno, but I think, the Trade Scout is bugged: It can't be convinced to calculate my latest visited stations against each other. It suggests routes that I did days ago. Even, when I alter the values in total, profit and distance. I can't specify, where the prob is, but it seems highly bugged...
The "Laufzeitfehler 1004" appears every time I save after entering a new station and OCRing then. After a new start of TCE OCRing is directly possible included saving. Very annoying... But you said already, you adressed the problem...
 
I was able to get TCE working. This is great.

The help mentions this...

"At the bottom of the panel, when EliteOCR was detected, you found a button "START OCR SCAN". "

I have EliteOCR installed and I added the EliteOCR directory to the configuration. It detected it successfully.

I do not see a START OCR SCAN option. What do I need to do to enable that option?
 
I was able to get TCE working. This is great.

The help mentions this...

"At the bottom of the panel, when EliteOCR was detected, you found a button "START OCR SCAN". "

I have EliteOCR installed and I added the EliteOCR directory to the configuration. It detected it successfully.

I do not see a START OCR SCAN option. What do I need to do to enable that option?

Maybe, you have before to insert the Station, where you are currrently in, in the Database->Station-Menu in the upper left corner of TCE
 
Last edited:
Hi Eventure,

in the Trade Scout, it would be nice, if we can choose a range within ...ly of the current station the routes are shown, like in RegulatedNoise.
 
Having issues trying to get to run.

Getting a Run-time error 13 after clicking on the icon to start.

Debug is showing "Show_ShipLog = CBool(Mid(ArINI(10), 14, x - 13))" as being the issue.

Verbose logging set correctly, manually modded the TCE.ini file to point to the correct locations.

Excell 2010 (64bit) fully patched. Win 7 also fully patched.

Anyone with any ideas?

Please delete the TCE.ini and restart.
 
Full-Version (V1.33) and Update released:
- Many optimizations and code improvements
- Introducing OCR language selection (you need the newest EliteOCR version). You can select your OCR language at the Options panel
- Small Trade Scout panel fixes
- Main panel (bottom) fixes and visual improvement
- Database corrections and extension in preparation of further developments. All fixes are applied at the first start of TCE. Be patient, it needs a little time.
 
Installed 1.33

Getting some errors.

With updated commodities between two common route stations.

import station has palladium to sell at 14293
export station has palladium to buy at 12495

Both stored correctly in the commodity table.

Click on the new destination and the profit is shown as 81 Cr.
Click on the Trade button and the trade advisor gives a profit of 1801 Cr
 
Hi Eventure,

Thanks for another update ;)

Still a few niggling issues with panel positioning, just thought I would let you know.
When I startup, the panel is in the wrong place, but the options show it as the desired Y coordinate:

p4J0yPNh.jpg

If I edit the value and press enter, it resets the position as expected, however.. I also lost the 'Ship log' panel.

YEI1cDQh.jpg

The hide / show appears to be working well now though ;)

Screen res is 2560x1600, images are resized a little for the forum.
 
Last edited:
Installed 1.33

Getting some errors.

With updated commodities between two common route stations.

import station has palladium to sell at 14293
export station has palladium to buy at 12495

Both stored correctly in the commodity table.

Click on the new destination and the profit is shown as 81 Cr.
Click on the Trade button and the trade advisor gives a profit of 1801 Cr

Thanks for the feedback, issue found and fixed in next update.

Hi Eventure,

Thanks for another update
wink.png


Still a few niggling issues with panel positioning, just thought I would let you know.
When I startup, the panel is in the wrong place, but the options show it as the desired Y coordinate:

p4J0yPNh.jpg

If I edit the value and press enter, it resets the position as expected, however.. I also lost the 'Ship log' panel.

YEI1cDQh.jpg

The hide / show appears to be working well now though
wink.png


Screen res is 2560x1600, images are resized a little for the forum.

Thanks for the feedback too, issue found at last and fixed in next update. The zoom function kills the positioning. Every day is a new day to learn. ;)
 
Last edited:
Hi Eventure,

I followed your advice and replaced my database and that solved my last problem.
The only issue i have not be able to fix is the EliteOCR.
When I press your button i get Please wait and then "EliteOCRcmd.exe has stopped working". The data in the commodity screen does not match the market.
I thought the problem was with EliteOCR, so I have done a F10 screenshot of my market and EliteOCR seems to OCR read this OK, line by line.
Is there something on the TES side I need to check to get this to call EliteOCRcmd.exe without crashing ?
Now using 1.33, issue since i started with 1.31, have used last few versions of EliteOCR, but not found the answer. Using Excel 2010
EltiteOCR path is d:\TES\EliteOCR
Any advice appreciated.
 
Last edited:
Status
Thread Closed: Not open for further replies.
Back
Top Bottom