Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.

eventure

eventure
XLA said:
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.
Click to expand...

Try the following:

Make a screenshot with F10.
Copy the screenshot into the EliteOCR\bin folder
Start your command prompt, navigate to EliteOCRcmd.exe (EliteOCR\bin)
Type: EliteOCRcmd.exe -i "Name of screenshot" -o result.csv and press enter
You got the error again? Check the error report.
 
Last edited:

XLA

XLA
no error. result.csv gave me about 124 lines of data like this.

So EilteOCR is working ?

<?xml version="1.0" encoding="UTF-8"?>
<ocrresult>
<setup>
<language>eng</language>
<inputfile>test.bmp</inputfile>
<resolution>1920x1080</resolution>
<marketWidth>1225</marketWidth>
<filetimestamp>2015-02-14T17:30:26+00:00</filetimestamp>
<ocrtime>2015-02-14T17:35:24+00:00</ocrtime>
</setup>
<location>
<system fromlog="true"></system>
<station conf="1.0">Tsibliyev Station</station>
</location>
<market>
<entry>
<commodity conf="1.0">Explosives</commodity>
<sell conf="1.0">196</sell>
<buy conf="1.0">212</buy>
<demand></demand>
<demandlevel></demandlevel>
<supply conf="1.0">226042</supply>
<supplylevel conf="1.0">Med</supplylevel>
</entry>
 

Pequi

P
Eventure said:
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.
Click to expand...

Can we use our "old" database? Did you change anything in the databasestructure? I would like to use the update only to avoid overwriting my database with the hard earned data.
 

eventure

eventure
Pequi said:
Can we use our "old" database? Did you change anything in the databasestructure? I would like to use the update only to avoid overwriting my database with the hard earned data.
Click to expand...

You can. TCE adds/changes the following to the database:
- A new column for the station table (Star_ID) and adds the correct IDs for the stations present.
- Change of misspelled commodity names (for correct OCR detection)
- New economies

All changes are made at the first start to pre V1.33 databases. But why not make a backup. Better safe than sorry.

XLA said:
no error. result.csv gave me about 124 lines of data like this.

So EilteOCR is working ?
Click to expand...

Looks good. Then please check the OCR_BMP folder of TCE and look, if you get the same results with the Screenshot.bmp file in it. TCE making a screenshot itself.

New Update (V1.33a) released:
- Main panel positioning fix
- Destination panel didnt calculate new profits fix
- Start panel position fix
 
Last edited:
  • Like (+1)
Reactions: XLA

XLA

XLA
Ok, in OCR_BMP there is a screenshot.bmp file. If I press START OCR SCAN. This file is replaced with a new screenshot. So that bit works.
I am guessing that your results.csv ends up in the OCR_Exports. I tried the following and it crashed in a similar way :

D:\TCE>d:\tce\EliteOCR\bin\EliteOCRcmd.exe -i d:\tce\OCR_BMP\Screenshot.bmp -o d
:\tce\OCR_Export\result.csv
[=== ]Error opening data file ./tessdata/big.traineddata
Please make sure the TESSDATA_PREFIX environment variable is set to the parent d
irectory of your "tessdata" directory.
Failed loading language 'big'
Tesseract couldn't load any languages!
Error in pixCreateHeader: width must be > 0
Error in pixCreateNoInit: pixd not made
Error in pixCreate: pixd not made
Error in pixGetData: pix not defined
Error in pixGetWpl: pix not defined
Error in boxClipToRectangle: box outside rectangle
Warning in pixClipRectangle: box doesn't overlap pix
Error in pixGetDepth: pix not defined
Error in pixConvertTo8: pixs not defined
Error in pixGetWidth: pix not defined
Error in pixGetHeight: pix not defined
Error in pixGetDepth: pix not defined
Error in pixCreateHeader: width must be > 0
Error in pixCreateNoInit: pixd not made
Error in pixCreate: pixd not made
Error in pixSetAllArbitrary: pix not defined
Error in boxClipToRectangle: box outside rectangle
Warning in pixClipRectangle: box doesn't overlap pix
Error in pixGetDepth: pix not defined
Error in pixConvertTo8: pixs not defined
Error in pixGetWidth: pix not defined
Error in pixGetHeight: pix not defined
Error in pixClone: pixs not defined
Error in pixClone: pixs not defined
pix_binary_ != NULL:Error:Assert failed:in file pagesegmain.cpp, line 111

D:\TCE>

Did i simulate this properly ?
big.traineddata exists in d:\tce\EliteOCR\tessdata\
 

FX2K

FX2K
Hi Eventure ,

Not sure if the latest update was relating to the panel position I posted about, if it was it didn't work, each load would still position the panel somewhere near the top of the screen (as in prev screenshot) :(

However... instead of exiting TCE I forced Excel to the front and quit Excel directly, when prompted I saved the xlsm file.
Now it loads with the last position / the correct one... I'm happy with that ;)
 

atomic7431

A
when i change the panel position in 1.33a the position isnt remembered and the trade screen is partially off my monitor even though i set it in the middle using 600 as X position, it keep defaulting to 1075.

my screen res is 3440 x 1440 and it was working fine with version 1.32c.
 
Last edited:

eventure

eventure
XLA said:
Ok, in OCR_BMP there is a screenshot.bmp file. If I press START OCR SCAN. This file is replaced with a new screenshot. So that bit works.
I am guessing that your results.csv ends up in the OCR_Exports. I tried the following and it crashed in a similar way :

D:\TCE>d:\tce\EliteOCR\bin\EliteOCRcmd.exe -i d:\tce\OCR_BMP\Screenshot.bmp -o d:\tce\OCR_Export\result.csv
Did i simulate this properly ?
big.traineddata exists in d:\tce\EliteOCR\tessdata\
Click to expand...

You have to call it from D:\TCE\EliteOCR, not from D:\TCE.

D:\TCE\EliteOCR>d:\tce\EliteOCR\bin\EliteOCRcmd.exe -i d:\tce\OCR_BMP\Screenshot.bmp -o d:\tce\OCR_Export\result.csv
 

lefty1117

L
It looks awesome. We really need something like this in-game. Maybe FD could pay for your work to shorten the implementation time!
 

eventure

eventure
FX2K said:
Hi Eventure ,

Not sure if the latest update was relating to the panel position I posted about, if it was it didn't work, each load would still position the panel somewhere near the top of the screen (as in prev screenshot) :(

However... instead of exiting TCE I forced Excel to the front and quit Excel directly, when prompted I saved the xlsm file.
Now it loads with the last position / the correct one... I'm happy with that ;)
Click to expand...
atomic7431 said:
when i change the panel position in 1.33a the position isnt remembered and the trade screen is partially off my monitor even though i set it in the middle using 600 as X position, it keep defaulting to 1075.

my screen res is 3440 x 1440 and it was working fine with version 1.32c.
Click to expand...

Thanks for the feedback, damn it work here, but i frequently save the workbook myself, so this can be my problem of simulating the issue. Will look tommorow into it again :(
 

XLA

XLA
Ok, so I run it from D:\TCE\EliteOCR, stops working again, with a different output :

D:\TCE\EliteOCR>d:\tce\EliteOCR\bin\EliteOCRcmd.exe -i d:\tce\OCR_BMP\Screenshot
.bmp -o d:\tce\OCR_Export\result.csv
[=== ]Error in pixCreateHeader: width must be > 0
Error in pixCreateNoInit: pixd not made
Error in pixCreate: pixd not made
Error in pixGetData: pix not defined
Error in pixGetWpl: pix not defined
Error in boxClipToRectangle: box outside rectangle
Warning in pixClipRectangle: box doesn't overlap pix
Error in pixGetDepth: pix not defined
Error in pixConvertTo8: pixs not defined
Error in pixGetWidth: pix not defined
Error in pixGetHeight: pix not defined
Error in pixGetDepth: pix not defined
Error in pixCreateHeader: width must be > 0
Error in pixCreateNoInit: pixd not made
Error in pixCreate: pixd not made
Error in pixSetAllArbitrary: pix not defined
Error in boxClipToRectangle: box outside rectangle
Warning in pixClipRectangle: box doesn't overlap pix
Error in pixGetDepth: pix not defined
Error in pixConvertTo8: pixs not defined
Error in pixGetWidth: pix not defined
Error in pixGetHeight: pix not defined
Error in pixClone: pixs not defined
Error in pixClone: pixs not defined
pix_binary_ != NULL:Error:Assert failed:in file pagesegmain.cpp, line 111

D:\TCE\EliteOCR>
 

dave562

D
No "START OCR SCAN" option

Please see the attached screen shot. I created a record for the STATION in the DATABASE (visible on the top menu bar)

In the Commodities menu, I do not have a START OCR SCAN option.

What do I need to do to make that option available? (I have already input the path to EliteOCR into TCE)

View attachment 15252
 

Jadel

J
This looks amazing, really great idea thanks.

For me though its not really working.

Windows 8.1 Excel 2010.

1. The ini needs to be edited to work at all, the german? to true/false, perhaps include this in the instructions.
2. The auto detect file location doesnt work. That whole process was quite awkward. The instruction to point to the elite install location is misleading because thats not where it needs to be. Everything is in the user section
3. The size and position of the UI is off for a 1920 monitor, is there a way to edit the size? The position I can see included.
4. Maybe just user error, but it seems to want my destination to be LH447 (150ly away)without anyway to change it.


Hoping I can get it running smoothly, thanks for any help.
 

Pequi

P
I got another bug after OCRed the commodities and hit the save button:
Click to expand...

In version 1.33c this bug persists. It occurs reliable after I entered a new station to the database, scanning then the warehouse and after I clicked then onto the save button.
 

eventure

eventure
XLA said:
Ok, so I run it from D:\TCE\EliteOCR, stops working again, with a different output :

D:\TCE\EliteOCR>d:\tce\EliteOCR\bin\EliteOCRcmd.exe -i d:\tce\OCR_BMP\Screenshot
.bmp -o d:\tce\OCR_Export\result.csv
[=== ]Error in pixCreateHeader: width must be > 0
Click to expand...

Please retry it with your previous screenshot (F10) and use the same way. Will that work?

dave562 said:
Please see the attached screen shot. I created a record for the STATION in the DATABASE (visible on the top menu bar)

In the Commodities menu, I do not have a START OCR SCAN option.

What do I need to do to make that option available? (I have already input the path to EliteOCR into TCE)
Click to expand...

Click on Commodity at the top menu bar of TCE, to open the panel.

Jadel said:
1. The ini needs to be edited to work at all, the german? to true/false, perhaps include this in the instructions.
2. The auto detect file location doesnt work. That whole process was quite awkward. The instruction to point to the elite install location is misleading because thats not where it needs to be. Everything is in the user section
3. The size and position of the UI is off for a 1920 monitor, is there a way to edit the size? The position I can see included.
4. Maybe just user error, but it seems to want my destination to be LH447 (150ly away)without anyway to change it.
Click to expand...

1. Please use the newest version/update and delete TCE.ini.
2. At my installation, all is in the install folder of elite dangerous. Some said, that differs from point of installation (beta, gamma, release). If auto-detect didnt find anything for you, select it the manual way.
3. Not for me, TCE is optimized for 1920x1200/1080. But with the next update the panel positioning will be overhauled.
4. Deselect Auto-Destination at Options panel. Enter stations from your surrounding to fill the database. Only LHS3447 is recorded in the initial database, so its the only destination you have atm.

Pequi said:
In version 1.33c this bug persists. It occurs reliable after I entered a new station to the database, scanning then the warehouse and after I clicked then onto the save button.
Click to expand...

Please exchange this
Code: 
        Worksheets("DB_StPrices").Activate
        With ActiveWorkbook.Worksheets("DB_StPrices")
        lLZeile = .Cells(Rows.Count, 1).End(xlUp).row
        iLSpalte = .Cells(1, Columns.Count).End(xlToLeft).Column
        .Range(Cells(1, 1), Cells(lLZeile, iLSpalte)).Sort Key1:=.Range("B1"), Order1:=xlAscending, Key2:=.Range("C1"), Order2:=xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
        End With
with that
Code: 
    Worksheets("DB_StPrices").Activate
    ActiveWorkbook.Worksheets("DB_StPrices").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("DB_StPrices").Sort.SortFields.Add Key:=Range( _
        "B2:B100001"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
        xlSortNormal
    ActiveWorkbook.Worksheets("DB_StPrices").Sort.SortFields.Add Key:=Range( _
        "C2:C100001"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
        xlSortNormal
    With ActiveWorkbook.Worksheets("DB_StPrices").Sort
        .SetRange Range("A1:F100001")
        .Header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With

Tell me, if that works. Thanks.
 
Last edited:

XLA

XLA
After doing this several times. When I use the F10 version the command works.
When I use exactly the same screenshot but generated with the START OCR SCAN button it fails with the following error :

D:\TCE\EliteOCR>d:\tce\EliteOCR\bin\EliteOCRcmd.exe -i d:\tce\OCR_BMP\Screenshot
.bmp -o d:\tce\OCR_Export\result.csv
[=== ]Error in pixCreateHeader: width must be > 0
Error in pixCreateNoInit: pixd not made
Error in pixCreate: pixd not made
Error in pixGetData: pix not defined
Error in pixGetWpl: pix not defined
Error in boxClipToRectangle: box outside rectangle
Warning in pixClipRectangle: box doesn't overlap pix
Error in pixGetDepth: pix not defined
Error in pixConvertTo8: pixs not defined
Error in pixGetWidth: pix not defined
Error in pixGetHeight: pix not defined
Error in pixGetDepth: pix not defined
Error in pixCreateHeader: width must be > 0
Error in pixCreateNoInit: pixd not made
Error in pixCreate: pixd not made
Error in pixSetAllArbitrary: pix not defined
Error in boxClipToRectangle: box outside rectangle
Warning in pixClipRectangle: box doesn't overlap pix
Error in pixGetDepth: pix not defined
Error in pixConvertTo8: pixs not defined
Error in pixGetWidth: pix not defined
Error in pixGetHeight: pix not defined
Error in pixClone: pixs not defined
Error in pixClone: pixs not defined
pix_binary_ != NULL:Error:Assert failed:in file pagesegmain.cpp, line 111

D:\TCE\EliteOCR>
 
Last edited:

eventure

eventure
XLA said:
After doing this several times. When I use the F10 version the command works.
When I use exactly the same screenshot but generated with the START OCR SCAN button it fails with the following error :
Click to expand...

Did you changed your FOV setting and what is you display resolution in ED? Perhaps post the screenshot, you made with TCE.

Update (V1.33b TEST1) released:
- New panel positioning fix (to users, who have problems with panel positions, please give feedback).
 
Last edited:

XLA

XLA
I have not changed it consciously. This is my settings file :

<?xml version="1.0" encoding="UTF-8" ?>
<GraphicsOptions>
<Version>1</Version>
<PresetName>Custom</PresetName>
<StereoscopicMode>0</StereoscopicMode>
<IPDAmount>0.003000</IPDAmount>
<AMDCrashFix>false</AMDCrashFix>
<FOV>56.249001</FOV>
<HighResScreenCapAntiAlias>3</HighResScreenCapAntiAlias>
<HighResScreenCapScale>4</HighResScreenCapScale>
<GammaOffset>0.000000</GammaOffset>
<DisableGuiEffects>false</DisableGuiEffects>
<StereoFocalDistance>25.000000</StereoFocalDistance>
</GraphicsOptions>
 

atomic7431

A
Eventure said:
Did you changed your FOV setting and what is you display resolution in ED? Perhaps post the screenshot, you made with TCE.

Update (V1.33b TEST1) released:
- New panel positioning fix (to users, who have problems with panel positions, please give feedback).
Click to expand...

when i start it up i get a screen behind your splash screen asking from what i can see for database initialization information and i cant select it as it isnt moveable, the program wont load from this point


update : going back to 1.33a the above doesnt happen.
 
Last edited:

eventure

eventure
atomic7431 said:
when i start it up i get a screen behind your splash screen asking from what i can see for database initialization information and i cant select it as it isnt moveable, the program wont load from this point


update : going back to 1.33a the above doesnt happen.
Click to expand...

Damn, forgot the language database (i am working that atm). Will correct it and updating soon.
 
Status
Thread Closed: Not open for further replies.
Back
Top Bottom