Abandoned [RELEASE] Trade Computer Extension

[Bragolatch]

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.

That link is for Office 2007, since I have 2013 wouldn't this be better ?
https://www.microsoft.com/en-us/download/confirmation.aspx?id=39358
if so, here is the one for people running 2010:
http://www.microsoft.com/en-us/download/details.aspx?id=10910


I know Panel Control is only for positioning.
That is what I have said !
I can pop Commodities and Commodity for positioning
But they did not open for normal use !

Now, by manually copying all the commodities of one of the included station to my newly added station,
I was able to get the Database Commodities to open and even scan and update it's commodities.

but the Commodity window still doesn't want to open.

It seems to me all those errors have a lot to do with missing/empty data fields !
Everything works pretty good when accessing stations that have all the data already filled in.
If we could import .csv from EliteOcr it might solve a lot of problems !


I just got a new one by clicking the trade button

Error 380

Private Sub BTN_Trade_Click()


If Panel_Trade.Visible = False Then
If Panel_POS_Select.Visible = True Then
Worksheets("Werte").Cells(2, 2).Value = Worksheets("Werte").Cells(57, 3).Value
Worksheets("Werte").Cells(3, 2).Value = Worksheets("Werte").Cells(57, 2).Value
Worksheets("DB_Config").Cells(2, 1).Value = Worksheets("Werte").Cells(2, 2).Value
Worksheets("DB_Config").Cells(2, 2).Value = Worksheets("Werte").Cells(3, 2).Value
Call POS_Commodities
Panel_Trade.POS_Display
Panel_POS_Select.Hide
End If
If Panel_DES_Select.Visible = True Then
Worksheets("Werte").Cells(12, 2).Value = Worksheets("Werte").Cells(57, 3).Value
Worksheets("Werte").Cells(13, 2).Value = Worksheets("Werte").Cells(57, 2).Value
Worksheets("DB_Config").Cells(2, 5).Value = Worksheets("Werte").Cells(12, 2).Value
Worksheets("DB_Config").Cells(2, 6).Value = Worksheets("Werte").Cells(13, 2).Value
Panel_Trade.CB_Route.ListIndex = Worksheets("Werte").Cells(53, 5).Value - 1
Call DES_Commodities
Panel_Trade.DES_Display
Panel_DES_Select.Hide
End If
If Panel_Prices.Visible = True Then
Panel_Prices.Hide
Me.BTN_Commodity_Layer.BackColor = &H101010
Me.BTN_Commodity.ForeColor = &HFFFFFF
End If




There is also this minor display bug where the last digit of the date is not displayed in the new position window :

 

[punkerich]

first, +rep for the effort.

it's. well. ist's working. most of the time...
me thinks with a bit optimising / polishing it could be THE one and only must-have tool for ED!

but, let me give some feedback and perhaps a few wishes for changes:

- surely result of a bad scan, i got an 'index too long' error on start. had just 2 systems in, so i reinstalled and began from scratch.
would it be possible that we get the option to check the scans before saving it in the db?

- why do we have to enter a station name etc. first, before ocr'ing the commodities? the info is in the screenshots, could be easily gotten from there,
so we only had to enter the missing data by hand.

- plz, make the dist. to star either an optional field or set a default of 1, so we could change it if we want to.

- loading times are huge, don't know why. ED starts 2 times faster than the TCE...?

- clicking the right panel in commodities (commodity display) does nothing?

oh, excel 2013 with latest updates, if that matters.

 

[eventure]

Thank you for your detailed report.

That link is for Office 2007, since I have 2013 wouldn't this be better ?
https://www.microsoft.com/en-us/download/confirmation.aspx?id=39358
if so, here is the one for people running 2010:
http://www.microsoft.com/en-us/download/details.aspx?id=10910

Will add the links to the main page for each version. The 2007 version worked on 2013 version so far.

I was able to get the Database Commodities to open and even scan and update it's commodities.

but the Commodity window still doesn't want to open.

Did you have the newest version? There is no Database Commodities anymore, now it called Wares, or did you mean that? You get an information, when hovering above the Commodity button. If not, please update or wait for the new. I will release a small update today to fix UI things.

I just got a new one by clicking the trade button

Error 380

Found the problem, will be fixed next update.

 

[Biffa]

Am I the only one who thinks that this will take all the fun and enterprise out of trading? I'm not knocking the app it looks brilliant but part of the fun of turfing up at new station is wondering if there's anything unusual to profit from on it's market boards.

I actually think this will make trading even more of a grind, just sayin'.

 

[eventure]

but, let me give some feedback and perhaps a few wishes for changes:

- surely result of a bad scan, i got an 'index too long' error on start. had just 2 systems in, so i reinstalled and began from scratch.
would it be possible that we get the option to check the scans before saving it in the db?

You always have the possibility to check the scan. Before you press SAVE, check all the data by clicking through the categories to display the scan results.

- why do we have to enter a station name etc. first, before ocr'ing the commodities? the info is in the screenshots, could be easily gotten from there,
so we only had to enter the missing data by hand.

There are some preparations have to be made, before scanning the commodities. The order is to add the station, to have an ID to assign the commodities to the stations ID. Next big update you got 11k+ unregistered stations in database, so only have to select the name of the station.

- plz, make the dist. to star either an optional field or set a default of 1, so we could change it if we want to.

It's a required field. Its needed for Trade Scout Planner filter setting. But i can add a default value of 1, no problem.

- loading times are huge, don't know why. ED starts 2 times faster than the TCE...?

TCE needs 25 sec. on my PC at work (4x 2 GHz, 4 GB RAM, SSD) with a fresh install. My home PC (4x 4 GHz, 16 GB RAM, SSD) makes it in less time. It depends on your system config.

- clicking the right panel in commodities (commodity display) does nothing?

You mean the Commodity Display mode in the Commodity panel? New Stations without any commodities recorded cant change it, it stays on SHOW ALL, but all others can change it to SHOW STATION BASED (default), that only commodities traded at the station are displayed. A much shorter list.

 

[eventure]

Am I the only one who thinks that this will take all the fun and enterprise out of trading? I'm not knocking the app it looks brilliant but part of the fun of turfing up at new station is wondering if there's anything unusual to profit from on it's market boards.

I actually think this will make trading even more of a grind, just sayin'.

I respect your view, so if you have more fun without it, its okay. But i have a different view of it. I have a lot of fun with it.

 

[punkerich]

well, that sounds very good to me, mucho gracias for the fast and detailed reply.
waiting for the update in anticipation!

 

[Nionor]

Am I the only one who thinks that this will take all the fun and enterprise out of trading? I'm not knocking the app it looks brilliant but part of the fun of turfing up at new station is wondering if there's anything unusual to profit from on it's market boards.

I actually think this will make trading even more of a grind, just sayin'.

You know the information is local right? So the fun in discovering what's on sale in the station is still there.
I don't see this much different then writing down things on paper, just easier and more eco-friendly .
Sure you can share your data with others if you want but I think most here don't and if so just to close friends.

 

[FX2K]

Am I the only one who thinks that this will take all the fun and enterprise out of trading? I'm not knocking the app it looks brilliant but part of the fun of turfing up at new station is wondering if there's anything unusual to profit from on it's market boards.

I actually think this will make trading even more of a grind, just sayin'.

I share your opinion, when it comes to crowdsourced tools.. I have avoided them since early beta's, however this tool is different. This is just a replacement for my pen and paper... saving the forests and all that

Therefore, the above still holds true regarding the 'turfing up at new stations' etc. I won't ever see any market data you capture.. EVER! I will only ever see what I have recorded myself, if I choose to record it.

Yes, it may quickly tell me a decent route from my own data, but thats not really rocket science... A quick glance between pages on my notepad did the same... right up to a T9...
I just like that this has more of an 'in-game' feel to it than notes all over my desk.

 

[punkerich]

oh, one thing: could you plz add the 'add note to station' window to the customizable panels? when i click 'add', its just out of screen. triple-mon here, 3xfhd.
need this for the available outfitting.

 

[eventure]

Update (V1.35c) released:
- Small UI fixes

Nothing more like this small bugfix today. Planned to release a bigger test-version, but my 4 hour programming today turned to dust, because of my asininity. Damn, i get old.

oh, one thing: could you plz add the 'add note to station' window to the customizable panels? when i click 'add', its just out of screen. triple-mon here, 3xfhd.
need this for the available outfitting.

Will do that.

 

[RadBlaster]

Having issue adding new stars into the DB. Everytime I fill out the information require and press the save buttom the following VBA error appears.
When I hit debug it does show where in the code it is erroring but then Excel crash and wants to restart to recovery of the TCE.

 

[eventure]

Having issue adding new stars into the DB. Everytime I fill out the information require and press the save buttom the following VBA error appears.
When I hit debug it does show where in the code it is erroring but then Excel crash and wants to restart to recovery of the TCE.

View attachment 16968View attachment 16969

Hard to say, where the error is. Please try a backup of TCE.mdb to check, if the database is the problem.

 

[punkerich]

well, i think i fubared the install...

i have office 2013 pro, only excel was installed, with your linked 2007 access runtime.
thought it would be better (faster) if i installed the full access, too...
now i get the 1004 error...
uninstalled access, installed 2013 runtime, fresh install of tce, all to no avail.
everytime the same error...

i'm not a smart man.

 

[Vulcan24v]

Can I just say that I have exactly the same problem as Radblaster. After messing for ages I eventually got it to run without an error, doing a full clean install, but as soon as I tried to add the first star into it I got that exact same error.
Not sure what you mean by using a backup, I have found a folder with a backup in it but the install was only a hour or so old before it threw out the error.

 

[RadBlaster]

I concur. I just did a clean install from scratch and still having the same issue.

 

[Cmdr NXS Tripp]

When installed the first thing requested is a Smart Card. Why is this.
Second the Digital Certificate is invalid.

 

[eventure]

When installed the first thing requested is a Smart Card. Why is this.
Second the Digital Certificate is invalid.

Googled about that problem, and it has to do with the certificate. I will check this problem, why is the certificate invalid. But until it was fixed, your only possibility is to change the macro setting of excel to allow all macros.

Can I just say that I have exactly the same problem as Radblaster. After messing for ages I eventually got it to run without an error, doing a full clean install, but as soon as I tried to add the first star into it I got that exact same error.
Not sure what you mean by using a backup, I have found a folder with a backup in it but the install was only a hour or so old before it threw out the error.

I think i found the problem in the export routine. Made some changes for next update.

Update (V1.35d) released:
- Small modifications to the export routine.

 

[Bragolatch]

Getting There.

Update (V1.35d) released:
- Small modifications to the export routine.

Installing the office Microsoft Access 2013 Runtime certainly helped !
the sizes went back to normal, the main panel fit the screen by default ...

Getting no errors !
but I still could open the Commodity only some of the time
could not open Database Commodities at all
and whatever I typed or scan would not save into the database.


When you click save on the Star Database, What is supposed to happen ?
I see wait for a bit then the widow closes.

When I open it again I see the change I have last made for a second then the info goes back to what is was before I made changes.

All that was on 1.35a, Then I saw Update 1.35d

Copied the files over the old ones, started it and got:

Run-time error '91':
Object variable or With block variable not set



Private Sub Workbook_Open()


Dim fso As Object, S As String, ini_File As String, ini_found As Boolean, z As Long, X As Long
Dim textline As String, ArINI(1 To 26) As String

Application.Visible = False
Matrix_ready = False
Main_Hide = False
AppPath = ActiveWorkbook.Path
AppConfig_found = False
NetLog_found = False
OCR_found = False
Set fso = CreateObject("scripting.filesystemobject")
ini_File = AppPath & "\TCE.ini"
Worksheets("Werte").Cells(101, 8).Value = ""
Worksheets("Werte").Cells(102, 8).Value = ""
Worksheets("Werte").Cells(103, 8).Value = ""
Worksheets("Werte").Cells(89, 5).Value = 0
If fso.FileExists(ini_File) = True Then
ini_found = True
Else
ini_found = False
End If

 

[eventure]

Run-time error '91':
Object variable or With block variable not set



Private Sub Workbook_Open()


Dim fso As Object, S As String, ini_File As String, ini_found As Boolean, z As Long, X As Long
Dim textline As String, ArINI(1 To 26) As String

Application.Visible = False
Matrix_ready = False
Main_Hide = False
AppPath = ActiveWorkbook.Path

Did you have other workbooks of excel open? Please check that all instances of excel are closed (Taskmanager Excel.exe). If so and the error still present, add the codeline: ThisWorkbook.Activate before the AppPath = ActiveWorkbook.Path
Save it and restart. Please give feedback. Thanks.

When you click save on the Star Database, What is supposed to happen ?
I see wait for a bit then the widow closes.

When I open it again I see the change I have last made for a second then the info goes back to what is was before I made changes.

After pressing SAVE, all entered data are saved to the database. When opened again the panel shows "Modify Star System" not "Add Star System" and the X-, Y- and Z-values are shown. If you want to change the position of the star system, you are in, you have to enter the distances to the references again, in case of wrong values typed in.