Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.
@Infomage Check that the shortcut to EliteOCR in correct in the TCE.ini file

eg:
NetLogPath=C:\Elite Dangerous\Products\FORC-FDEV-D-1002\Logs
AppConfigPath=C:\Elite Dangerous\Products\FORC-FDEV-D-1002
EliteOCRPath=C:\Elite Dangerous\TCE\EliteOCR

When I set mine up its always blank have to manually add the location to file, even though I select the correct location on setup. (Possible Bug)
 
Last edited:
@Infomage Check that the shortcut to EliteOCR in correct in the TCE.ini file

eg:
NetLogPath=C:\Elite Dangerous\Products\FORC-FDEV-D-1002\Logs
AppConfigPath=C:\Elite Dangerous\Products\FORC-FDEV-D-1002
EliteOCRPath=C:\Elite Dangerous\TCE\EliteOCR

When I set mine up its always blank have to manually add the location to file, even though I select the correct location on setup. (Possible Bug)

Thanks for the suggestion. Checked - the path is there correctly.

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

Please activate the debug window for OCR in the Options panel.

Debug output provides a clue

[== ]Image too small! Minimum market width required: 1065px, given: 992px

Addition:

Screenshot from EliteOCR itself using the .jpg I embedded above:

OCR.jpg
 
Last edited:
Thanks for the suggestion. Checked - the path is there correctly.

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



Debug output provides a clue

[== ]Image too small! Minimum market width required: 1065px, given: 992px

Addition:

Screenshot from EliteOCR itself using the .jpg I embedded above:


Please reduce your FOV in the ED game options, you missed 73px's to hit the minimum resolution for EliteOCR.
 
I like that if you hover your mouse over the 'Commodity' button when you don't have the current station added, it tells you so. However after the message disappears you can no longer click 'Commodity' after you add the station, the field is blank. You have to then go through 'Control -> Panels -> Commodity' to open the window.

Just wondering if you could also check to see if the FTP upload/download feature is working correctly, I don't seem to be seeing any new data coming in from other users.

Loving the extention though!
 
I like that if you hover your mouse over the 'Commodity' button when you don't have the current station added, it tells you so. However after the message disappears you can no longer click 'Commodity' after you add the station, the field is blank. You have to then go through 'Control -> Panels -> Commodity' to open the window.

Just wondering if you could also check to see if the FTP upload/download feature is working correctly, I don't seem to be seeing any new data coming in from other users.

Loving the extention though!

Thanks for the report. Rare issue found with the Commodity button and will be fixed in next update.
TCE creates two log files (one for upload and one for download) in the LOGS folder for FTP transfer. Please check these files in case of problems. In addition the SCRIPTS folder contains the FTP command file for transfering the data.
 
Last edited:
Hi Eventure,

today I saw a thread, in which realdragnet showed, what his new voicemacro-tool is capable of doing:


In the post no. #9 he explains, that he set up a macro to make screenshots of the commodity market in one shot, i.e., the macro uses a function called "WaitForPixel". It is used to detect the window scrollbar.

What I suggest (or wish to become a part of TCE) is: screenshotting the whole market in a series and processing all screenshots one after another while only pressing the OCR-button once. Do you think, that is possible? I know, it's possible with Autohotkey, but I reject to involve another tool just for that reason. Despite the use of TCE and RegulatedNoise, personally, I won't migrate from VoiceAttack to this new Voicemacro tool, just to use this feature (which is cool imo). I will ask the dev of VA, if he would implement this into VA too... but that's beside your TCE...
 
Last edited:
Thanks for the report. Rare issue found with the Commodity button and will be fixed in next update.
TCE creates two log files (one for upload and one for download) in the LOGS folder for FTP transfer. Please check these files in case of problems. In addition the SCRIPTS folder contains the FTP command file for transfering the data.

Double checked the logs and the script, everything seems to be working as it should, thanks for the pointer :)
 
Hi Eventure,

today I saw a thread, in which realdragnet showed, what his new voicemacro-tool is capable of doing:



In the post no. #9 he explains, that he set up a macro to make screenshots of the commodity market in one shot, i.e., the macro uses a function called "WaitForPixel". It is used to detect the window scrollbar.

What I suggest (or wish to become a part of TCE) is: screenshotting the whole market in a serious and processing all screenshots one after another while only pressing the OCR-button only once. Do you think, that is possible? I know, it's possible with Autohotkey, but I reject to involve another tool just for that reason. Despite the use of TCE and RegulatedNoise, personally, I won't migrate from VoiceAttack to this new Voicemacro tool, just to use this feature (which is cool imo). I will ask the dev of VA, if he would implement this into VA too... but that's beside your TCE...

Checked it and i think, it would really nice, if i get it to work. I am not familiar with this tool. As i can see it runs in the background and waits of a hotkey, to activate the macro. I tried this in a similar way with VBA, but it failed, when it comes to the SendKey command and mousepointer/-wheel movement of VBA. TCE makes his own screenshots (didnt use F10) , so we only need a macro, that scrolls down the commodity list of ED. Starting the macro, TCE can make screenshots in a timed sequence and after scrolling to the bottom, TCE reads the hole export in.
 
Last edited:
Checked it and i think, it would really nice, if i get it to work. I am not familiar with this tool. As i can see it runs in the background and waits of a hotkey, to activate the macro. I tried this in a similar way with VBA, but it failed, when it comes to the SendKey command and mousepointer/-wheel movement of VBA. TCE makes his own screenshots (didnt use F10) , so we only need a macro, that scrolls down the commodity list of ED. Starting the macro, TCE can make screenshots in a timed sequence and after scrolling to the bottom, TCE reads the hole export in.

Yep, that was my intention. But when you think, with VBA this isn't possible, then we should have a look at AutohotKey to do the task with scrolling (GetPixelColor seems the keyfunction). I know, that is possible with it. A couple of weeks ago, I did a few recherche on INet about that, but forgot. If you demand it, I'll have a look and find it again for you...
 
Yep, that was my intention. But when you think, with VBA this isn't possible, then we should have a look at AutohotKey to do the task with scrolling (GetPixelColor seems the keyfunction). I know, that is possible with it. A couple of weeks ago, I did a few recherche on INet about that, but forgot. If you demand it, I'll have a look and find it again for you...

Playing with the tool, i think, i've made it to scroll the mousewheel. It has to be tested with ED, but i cant now, because i add new star systems (22k+ total) , recalculating there positions for better accuracy level of distances and route calculation, and new stations (11k+ total), as unregistered, to the initial database.
 
Playing with the tool, i think, i've made it to scroll the mousewheel. It has to be tested with ED, but i cant now, because i add new star systems (22k+ total) , recalculating there positions for better accuracy level of distances and route calculation, and new stations (11k+ total), as unregistered, to the initial database.

...and I guess, you calculate all star and station data with an oldfashioned TI-30 by hand using pen and paper and abuse your 3-year old boy chained at your computerdesk as an edit-slave for your database. :D
 
Update (V1.35b) released:


Clicking 'control -> panels -> commodity' makes the commodity panel appear however clicking anywhere in the panel gives a Microsoft Visual Basic "run-time error 13: type mismatch" notification then the TCE closes. (worked in v1.33 not in v1.35a)


If the Shiplog is empty, check the AppConfig.xml, if there is the entry VerboseLogging="1" under NETWORK. Otherwise please give me a screenshot and the debug code block, so i can help. Thanks.

I have Verbose in AppConfig and EliteOcr works perfectly and get the systems names.
but ship log is empty and when I try to access the Database I get "run-time error 13: type mismatch"

Selecting Debug gives me:

Microsoft Visual Basic for applications

Can't execute code in break mode

with highlighted :

Me.ComboBox1.ListIndex = Worksheets("Werte").Cells(35, 8).Value - 1



Opening with 2007 Sp3 is no better for me, I get
Microsoft Office Excel
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, clic Yes.

If I select No, it closes.

If I select yes

Open and Repair TCE.xlsm does 3 Attempts
Then:

Excel was able to open the file by repairing or removing the unreadable content

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error460760_01.xml</logFileName><summary>Errors were detected in file 'D:\Games\Elite Dangerous\TCE\TCE.xlsm'</summary><removedParts summary="Following is a list of removed parts:"><removedPart>Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))</removedPart></removedParts></recoveryLog>


Of course TCE doesn't work after that !
Tried re-installing many times and even donwloading a fresh copy.
I always get the same results !
 
Last edited:
but ship log is empty and when I try to access the Database I get "run-time error 13: type mismatch"

If your shiplog is empty, TCE cant read/find the NetLog file it requires. So please check if the NetLog folder was set correctly in the TCE.ini. Did you selected it manual or with Auto-Detect?
 
Last edited:
If your shiplog is empty, TCE cant read/find the NetLog file it requires. So please check if the NetLog folder was set correctly in the TCE.ini. Did you selected it manual or with Auto-Detect?

Back with Excel 2013 for the next 3 days at lest lol not only 2007 didn't work but it screwed up my 2013 license.
Now it's telling me my key will expire in 3 days !
I've uninstalled all version of office and re-installed 2013 with the same result.
Don't feel too bad about having some bugs lol even multi-million dollar software corporations have plenty of them !
Anyway I'll fix that soon enough.

As for TCE,
Getting closer, I managed to enter all the info about the station I'm in and save it.
-with an update date of 1899-12-30 and time 00:00:00
-the note didn't stick
-and Explored stays no in cartography even if I had selected in star system database
but it did save the distance to the star, the services available and the number of bodies in the system
Then I got another error 13 when I clicked to open the commodity panel lol

Is TCE.xmls supposed to modify itself on normal use ?
Everytime I close Excel it asks me if I want to save.
I would have thought, that only the mdb's would have been modified !

So I said no after the error 13

now it crashes with error 1004 before it is done opening

Sub DB_Importer(DBFullName As String, TableName As String, TargetTable As String, TargetRange As Range)

Worksheets(TargetTable).Activate
With ActiveWorkbook.Worksheets(TargetTable).ListObjects.Add(SourceType:=0, Source:=Array( _
"OLEDB;Provider=Microsoft.ACE.OLEDB.12.0;Password="""";User ID=Admin;Data Source=" & DBFullName & ";Mode=Share Deny Write;Extended Pro" _
, _
"perties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OL" _
, _
"EDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Pass" _
, _
"word="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet" _
, _
" OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False" _
), Destination:=Range("$A$1")).QueryTable
.CommandType = xlCmdTable
.CommandText = Array(TableName)
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.SourceDataFile = DBFullName
.ListObject.DisplayName = TableName
.Refresh BackgroundQuery:=False
End With
ActiveSheet.ListObjects(TableName).Unlink

End Sub


I think that was cause by some of Excel's process still running in the background.

I've managed to reopen TCE and I can open and use all the windows but Database Commodities and Commodity.

in Control - Panels I can place them where I want, but they will not open for use !
no errors, just nothing happens ! any clue ?
 
Last edited:
As for TCE,
Getting closer, I managed to enter all the info about the station I'm in and save it.
-with an update date of 1899-12-30 and time 00:00:00
-the note didn't stick
-and Explored stays no in cartography even if I had selected in star system database
but it did save the distance to the star, the services available and the number of bodies in the system
Then I got another error 13 when I clicked to open the commodity panel lol

Is TCE.xmls supposed to modify itself on normal use ?
Everytime I close Excel it asks me if I want to save.
I would have thought, that only the mdb's would have been modified !

So I said no after the error 13

now it crashes with error 1004 before it is done opening

Please install this http://www.microsoft.com/en-us/download/details.aspx?id=23734, if you have the 1004 error. For the 13 error please give me a screenshot of TCE with the error and the code block when pressing debug. The Save message comes, when you encounter an error. TCE loads the TCE.mdb into it, so the workbook content changes every time, but you dont need to save the changes to TCE.

The Panel Control is only for positioning and zoom, all panels are locked.
 
Last edited:
Status
Thread Closed: Not open for further replies.
Back
Top Bottom