Abandoned [RELEASE] Trade Computer Extension

[eventure]

Hi Eventure,

I asked Seeebek abt EliteOCR, if he is capable to implement the translation feature of EliteOCR into his EliteOCRcmd.exe as a command line option. He replied, that maybe in a few days, he would implement this. I thought, it would be nice to run ED with german interface and use your TCE in english, while OCRing the german commodities and get them translated directly from EliteOCR into TCE, unless it is totally localized.

Despite that, I try to have a look into your code and see, if it is maybe possible for me to tryout some localisation of TCE. But with VBA I am not familiar. So I have to get some clue before... Coding in Modula, C, Basic, TCL/TK and a few other languages is not the problem, but abt VBA I dont know anything...

BTW: How can I prevent running TCE in Excel to see the code. Everytime I open it from Excel, it run as a program. Can't go into the VBA-Editor. Only when I go into the trustcenter ad choose "all macros w/o digital signed macros disable". This prevents Excel from running TCE.

Hello again,

there is an option for the german language allready with the command line exe, but EliteOCR scan shows problems with ä,ö and ü. For example Bio-Müll = Biomüll or Haushaltsgeräte = Haushaltsgeräte. That could be difficult to add these commodities into the TCE data correctly. The first move in translating TCE into german is to translate the whole database. Add a column to each table (Goods, Category, Economy, Jurisdiction and Type) for the translation text. Thereafter modding TCE to operate with these data.

To enter the editor directly from TCE, you have to do the following:
At first you have to activate the developer tools via Excel Options > Ribbon Menu (Menüband in german).
Click the "Trade Computer Extension" label at the main panel to make Excel visible, when TCE is running.
Alt-Tab to Excel application and use the mouse wheel at the ribbon menu to show the Developer Tools.
There you can click at Visual Basic to open the VBA-Editor. Press the filled square to stop the code.
If you have further questions for editing the code please via PM in german, if you like.

Update (V1.32c) released:
- Fixes restart message behind start panel hidden
- Fixes prestart config not saving folders correctly
- Fixes Trade Advisor scrollbar issue

 

[Pizz001]

No Prob , thanks for answering the question re importing via other 3rd party prog's

 

[Pequi]

Hello again,

there is an option for the german language allready with the command line exe, but EliteOCR scan shows problems with ä,ö and ü. For example Bio-Müll = Biomüll or Haushaltsgeräte = Haushaltsgeräte. That could be difficult to add these commodities into the TCE data correctly. The first move in translating TCE into german is to translate the whole database. Add a column to each table (Goods, Category, Economy, Jurisdiction and Type) for the translation text. Thereafter modding TCE to operate with these data.

Hi,
EliteOCR has no problems with reading german umlauts when it is launched by itself. I replaced the english commodities with the german ones and noticed, that TCE can handle it pretty good, except the extra long names, which runs out of the window. As I could see, that you managed the data handling really professional: i.e. using references instead of text. So it maybe quite easy to make localized version of TCE. I prepared a goods database with all three languages, btw. I can send it to you if you want.

When I try to add the option "-l deu" to the commandstring in "XML_Access", I am getting confused abt the """. My trial was not successful:

s = "cmd /c """"" & EliteOCR & """ -i """ & BMP_Target & """ -o """ & OCR_Export & "-l deu"""""

Cuz I don't nothing abt VBA, I maybe complete wrong doing so, but I think adding this option to the command line, could EliteOCR convince to OCR the Screenshots in german as properly as it does running as itself.

Edith: I fiddled a bit with EliteOCRcmd.exe in CLI-mode and got the same results as you: Biomüll -> Biomüll. Strange!
Because with the standalone version of EliteOCR it gets the correct values and strings!!

I'll get to reply that to Seeebek...

 

[Pequi]

Hi Seeebek,
I found that the CLI-version of EOCR istn't as reliable as the standalone version. Can you tell me, what I can do to get the same really good results with EliteOCRcmd.exe as with EliteOCR.exe?
I want to help Eventure to localize TCE step by step.


Tnx in advance,
Pequi

Seeebek answered:
The XML output is coded in UTF-8, that's why you get those funny characters! The accuracy is exactly the same. You just need to decode UTF-8 to whatever encoding you use.

Edith: Excel should be convinced to read the csv as UTF-8.

 

[planetrobbo]

Hi there

I am getting stuck at the splash screen. No apparent errors and all the orange boxes are empty. Been like that for about 10 minutes now. Any ideas please?

 

[Pequi]

Edith: Excel should be convinced to read the csv as UTF-8.

I did some research how to read utf-8-files and came up with this snipsel:

option explicit
Dim objSTREAM, strDATA, strFILENAME
strFILENAME = "uni.txt"
Set objSTREAM = CreateObject("ADODB.Stream")
objSTREAM.CharSet = "utf-16"
objSTREAM.Open
objSTREAM.LoadFromFile(strFILENAME)
strDATA = objStream.ReadText()
msgbox(strDATA)

I tried to convert it to some sort of you wrote in XML_Access:

Option Explicit
Dim strDATA
Set fso = CreateObject("ADODB.Stream")
fso.Charset = "utf-8"
fspen
fso.LoadFromFile (OCR_Export)
strDATA = fso.ReadText()
MsgBox (strDATA)

Maybe this can be used to make it work...

 

[eventure]

Hi there

I am getting stuck at the splash screen. No apparent errors and all the orange boxes are empty. Been like that for about 10 minutes now. Any ideas please?

Please use the newest update (V1.32c). It fixes your problem.

@Pequi

Changed the import to support UTF-8 coding. Had to go another way, but it works.

 

[atomic7431]

i see this now has office 2013 support, many thanks will give this a whirl another night

 

[atomic7431]

When i enter commodities data for the stock levels i have an issue where by the value is being changed automatically with an extra ,000.
So 1 becomes 1000 as screen shots shows-

Spoiler

and then if i needed a figure of over the hundreds of thousands - 100000 becomes ########### as pic shows.

Spoiler

thoughts please?

this is using the latest version off front page 1.32c and office 2013

 

[eventure]

When i enter commodities data for the stock levels i have an issue where by the value is being changed automatically with an extra ,000.
So 1 becomes 1000 as screen shots shows and then if i needed a figure of over the hundreds of thousands - 100000 becomes ########### as pic shows.
thoughts please?

this is using the latest version off front page 1.32c and office 2013

This is intended, because if you enter all data manually, you only need to enter thousands for stocks, like 1,3 for 1300 units or 625 for 625000 units. By using EliteOCR, and you wont need to enter the data manually anymore. Please see also HOW TO OPERATE: at the first page.

 

[atomic7431]

Thanks for the info i did look at the front page and tried eliteocr which is working very well, however i do notice a couple of commodities that do not get scanned as they are named incorrectly.
For instance Liquor is Liquors and so the data doesn't get auto scanned and has to be applied manually which is fine as that's really a very small amount compared with what this tool saves us.

Been using the Trade computer all of tonight and have to say it is amazing and extremely useful and cant imagine elite without it now

many thanks to all involved.

 

[arxerisdam]

Hi how are you?
First of all i want to thank you this tool is great i like it a lot.

Secondly i have a doubt is there any plan in the future to add the faction owning the station the goverment and the state of such station?

Sorry for the trouble and thanks again for the tool.

 

[eventure]

Thanks for the info i did look at the front page and tried eliteocr which is working very well, however i do notice a couple of commodities that do not get scanned as they are named incorrectly.
For instance Liquor is Liquors and so the data doesn't get auto scanned and has to be applied manually which is fine as that's really a very small amount compared with what this tool saves us.

Been using the Trade computer all of tonight and have to say it is amazing and extremely useful and cant imagine elite without it now

many thanks to all involved.

Please correct the misspelled commodity names, so that got scaned, via the Commodity database panel.

Hi how are you?
First of all i want to thank you this tool is great i like it a lot.

Secondly i have a doubt is there any plan in the future to add the faction owning the station the goverment and the state of such station?

Sorry for the trouble and thanks again for the tool.

Is this relevant for trading or why you need that info? Its possible but i working on other things at the moment, so it has a low priority unless highly requested.

 

[th03bgt]

Please correct the misspelled commodity names, so that got scaned, via the Commodity database panel.



Is this relevant for trading or why you need that info? Its possible but i working on other things at the moment, so it has a low priority unless highly requested.

I can see a need if you were looking to increase your rep with a specific faction through repeated trading.

 

[Veskandar]

excel repair

When I try to start it up excel comes with an error:
"Excel found unreadable content in 'TCE.xlsm'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

When I click yes it tries to repair the workbook and it:
"Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))"

any ideas on fixing this?

Microsoft office home and student 2007

 

[Veskandar]

Did a full reinstall of office and that seemed to fix it, now however i get an:
"run-time error '13': Type mismatch"

in debug the following line is highlighted:
" Show_ShipLog = CBool(Mid(ArINI(10), 14, x - 13))"

 

[eventure]

Did a full reinstall of office and that seemed to fix it, now however i get an:
"run-time error '13': Type mismatch"

in debug the following line is highlighted:
" Show_ShipLog = CBool(Mid(ArINI(10), 14, x - 13))"

Please use the newest update and delete the TCE.ini. Restart and TCE creates a new one.

I can see a need if you were looking to increase your rep with a specific faction through repeated trading.

Okay, i understand. Then it will be moved on the to-do list.

 

[Veskandar]

that worked, thanks, it looks great

 

[maddavo]

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.

 

[eventure]

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.

Hello,

please check the PREREQUISITES: at the main page of this thread or post #569.