Abandoned [RELEASE] Trade Computer Extension

eventure · Jun 15, 2015

Full Version (V1.42) released:

Full-Version 1.42 installer: http://bit.ly/1Qz6wKO
Full-Version 1.42 non-installer: http://bit.ly/1IYWlem

Changelog (incl. beta):
- Added Transfer Database Manager (TDM) for tranfering your old database to the actual version.
- Added reminder, if TCE is hidden and ED was closed.
- Added new TCE Setup (V1.05).
- Added selected Panel_Mode saves to TCE.ini.
- Added Star System Summary automatically hides after your selected intervall of seconds, when the popup appears (jumping to known star systems).
- Reworked complete date saving to database. Now it is saved as a number, free from country format, display of course is formated.
- Fixed date issues, the "dd.mm.yyyy" format of your OS is no longer a requirement.
- Fixed issue saving selection of sold ships of shipyard category.
- Fixed issue with edit location not showing the entered text in some categories.
- Fixed display issues in Classic UI (bottom view).
- Fixed issue in Panel Position window, setting X and Y values not correctly.
- Fixed issue for setting up an Exploration activity.
- Fixed issue outfit notes not displaying correctly at the Trade panel.
- Fixed issue with distance display in Stored Locations area.
- Fixed issue of empty station details in Trade panel.
- Fixed issue of selecting a station in Find Commodity, when its the current station.
- Fixed some issues with filtering in Select Destination panel.
- Modified sorting of stations with same profit and star system.

Compatibility Note:
ALL DATABASES FROM EARLIER VERSIONS ARE NO LONGER COMPATIBLE!
Here comes the new Transfer Database Manager (TDM) into place. It creates a new set of databases from your outdated TCE version, to make them compatible with the actual version. No long needed to copy your database into the new version and hope it will work.
In have to go this way, because i have to prevent core database values differ from user to user. So i make sure, that all users have the same core data.

How it works with the TDM:

View attachment 44593

After installing TCE (with the installer), you will find a new shortcut at your desktop called "Transfer Database Manager".
Open it, you will see the window above. Now you have to select your old TCE folder, normally called "TCE" or perhaps now "TCE.old".
TDM will look after all databases and the TCE.ini file and show you a green check, if TDM found them. For earlier versions, not all listed files are found. That's okay. TDM will add them in the transfer process.
Thereafter you see all stations, that are listed in your old database. Normally all are selected, but you can deselect stations, you did not want anymore. The deselected stations are not transferred into the new database.
Click on START TRANSFER to let TDM do all work, that have to be done for the new version. You see a status info, what TDM is doing at the moment below the selected stations.
When finished, TDM ask you, if you want to integrate the new databases into your new TCE version.
With "YES", all databases and TCE.ini copied into the right place. If you have EliteOCR installed, TDM ask you to copy it into the new folder of TCE. TDM ends afterwards. You are now ready to start TCE.
With "NO", TDM ends and opens the folder of the newly created databases. The TCE.ini was created at the TCE folder. You have to copy the new databases yourself into the DB folder of TCE.

Note:
TDM will not harm, change or move your old database. It remains untouched, so if a problem at the transfer happen, you can do it again and again.
Again a big step for TCE to make your collected data survive the comming updates and modifications of TCE.

Cmdr Bupu · Jun 15, 2015

1.42 full version all seems to be working for me..
still odd niggle with trade scout results.. have to move the window bar down and up to see best results.. even pressing the up button does not do it. only by moving the window bar do I get to see best results??
but everything else works ok database copied over like it should everything else was found. and all working.
keep up the good work. cant wait till you can tell it to choose 2 or 3 or even more stations to make a circular route up.
Cmdr Bupu

eventure · Jun 15, 2015

Cmdr Bupu said:
1.42 full version all seems to be working for me..
still odd niggle with trade scout results.. have to move the window bar down and up to see best results.. even pressing the up button does not do it. only by moving the window bar do I get to see best results??
but everything else works ok database copied over like it should everything else was found. and all working.
keep up the good work. cant wait till you can tell it to choose 2 or 3 or even more stations to make a circular route up.
Cmdr Bupu

Will looking into, came too late, didnt made it into the new version. At least, it is only a display issue. Good you find it.
Trade Route Planner is in work.

Grumpy181155 · Jun 16, 2015

Thanks Eventure it sounds like you have put a lot of work into this.
I did the install and database transfer without a problem and now I will wait until tonight to test it in-game. Great job.
.
edit: - I probably need to add that originally when I did the DB transfer it only found the one station that I had put in since the previous update but that was easily fixed by deleting the current DB and reinstalling one from the backup.

Abil Midena · Jun 16, 2015

Excellent release Eventure.

Everything working great here. I like the dbase transfer, and other features you added.

Now if we could only get FD to change their 6's so they don't look exactly like 8's....

Bragolatch · Jun 16, 2015

Full Version (V1.42) released

Eventure said:
Full Version (V1.42) released:

Full-Version 1.42 installer: http://bit.ly/1Qz6wKO

Full-Version 1.42 non-installer: http://bit.ly/1IYWlem

After installing TCE (with the installer), you will find a new shortcut at your desktop call "Transfer Database Manager".
Open it, you will see the window above. Now you have to select your old TCE folder, normally called "TCE" or perhaps now "TCE.old".
TDM will look after all databases and the TCE.ini file and show you a green check, if TDM found them. For earlier versions, not all listed files are found. That's okay. TDM will add them in the transfer process.
Thereafter you see all stations, that are listed in your old database. Normally all are selected, but you can deselect stations, you did not want anymore. The deselected stations are not transferred into the new database.
Click on START TRANSFER to let TDM do all work, that have to be done for the new version. You see a status info, what TDM is doing at the moment below the selected stations.
When finished, TDM ask you, if you want to integrate the new databases into your new TCE version.
With "YES", all databases and TCE.ini copied into the right place. If you have EliteOCR installed, TDM ask you to copy it into the new folder of TCE. TDM ends afterwards. You are now ready to start TCE.
With "NO", TDM ends and opens the folder of the newly created databases. The TCE.ini was created at the TCE folder. You have to copy the new databases yourself into the DB folder of TCE.

Note:
TDM will not harm, change or move your old database. It remains untouched, so if a problem at the transfer happen, you can do it again and again.
Again a big step for TCE to make your collected data survive the comming updates and modifications of TCE.

I got a few errors when Transfering my v1.42 beta to db to v1.42 Full install

Then a few more when I first started TCE v1.42 Full
The first one was hidden under the splash screen and I could not see it but when I selected Excel and pressed enter,
TCE's splash screen move to the top left and I was then able to take pics of the subsequent errors :

TCE did start but since I'm out in the black 1000 Ly from sol the trade panel was empty.
So I went in Current position to select a station and the list was there and seemed ok other then the problem with the price of Narcotics :

but when I selected a station I received :

Sub DES_Profit_Reg() 'Profit

Dim Station_ID_S As Long, Station_ID_Z As Long, ArProfit As Variant
Dim a As Long, b As Long

If POS_StationID <> 0 Then
Station_ID_S = POS_StationID
For a = 1 To AzRegStations
DoEvents
ReDim ArProfit(AzGoods)
Station_ID_Z = DES_SysData(a, 1)
For b = 3 To AzGoods + 2
DoEvents
If ArData_Buy(b, Station_ID_S + 2) <> 0 And ArData_Buy(b, Station_ID_S + 2) <> "" And ArData_Sell(b, Station_ID_Z + 2) <> 0 And ArData_Sell(b, Station_ID_Z + 2) <> "" And ArData_Sell(b, Station_ID_Z + 2) - ArData_Buy(b, Station_ID_S + 2) > 0 Then
ArProfit(b - 2) = ArData_Sell(b, Station_ID_Z + 2) - ArData_Buy(b, Station_ID_S + 2)
End If
Next b
DES_SysData(a, 23) = WorksheetFunction.Max(ArProfit)
Erase ArProfit
Next a
End If
End Sub

I sent you a PM Eventure, with links to my db before and after the transfer.

doing the exact same thing in my backup of v1.42 beta 2 (before transfer) the prices are ok

and the trade panel opens properly, showing the RECOMMENDED STATION, without error :

punkerich · Jun 16, 2015

Hi Bragolatch!
The one with narcotics is easy: FD modified the prices, smuggling update, well sort of.
take a look, notice the update times:

View attachment 44753

Bragolatch · Jun 16, 2015

v1.42 Full Works like a charm (so far )

punkerich said:
Hi Bragolatch!
The one with narcotics is easy: FD modified the prices, smuggling update, well sort of.
take a look, notice the update times:

Wish I had filled up a T9 before that update !
That would have been and Instant 4 millions in profit lol

Thanks for the hint !

Eventure has my db so we'll see what he has to say because I still get errors on line 430 when I start TCE v1.42 Full
and the error 9 with the same debug code when I select a CURRENT station,
even if I change the average market price for Narcotics or if I select a station with a "normal" REBATE

but it works fine with v1.42 beta 2 !

Thank you EVENTURE !!!

I followed your instructions to fix the 2 errors in my db
re-Transferred it, started v1.42 Full, selected a CURRENT POSITION and the trade panel opened up properly,
All without any errors

RobH · Jun 16, 2015

Excellent Eventure

The transfer worked flawlessly. Many thanks for this new release. Looking forward to trying it out.

Rob

BennyBoyW · Jun 16, 2015

I got an error in transfer of old database
"Error in Export Mod Data
Error Line 50
Error (-2147217865) The Microsoft Access database engine cannot find the input table or query 'PanelPosition'. Make sure it exists and that its name is spelled correctly"

- - - Updated - - -

Works fine if I ignore my panel.mdb though

BennyBoyW · Jun 16, 2015

Oh no it doesn't - if I then click OK to integrate data then I get a "Run Time Error '53' : File not Found"

- - - Updated - - -

And if I debug then it looks like it is not finding "Personal.mdb".

eventure · Jun 16, 2015

I am looking into the Taskbar issue (it pops up on using TCE) at the moment and i encountered some weiredness. So i need your help in checking some things and reporting back, if it can be reproduced on your side.

My resolution is 1920x1200 and i using only one monitor.

If i set the X and Y value for the main panel to zero, no taskbar appears when using TCE.
Any other value for both let the taskbar appear.
Please test it yourself, if this behavior can be reproduced.

It applies both to compact and classic UI.

Thanks.

eventure · Jun 16, 2015

BennyBoyW said:
I got an error in transfer of old database
"Error in Export Mod Data
Error Line 50
Error (-2147217865) The Microsoft Access database engine cannot find the input table or query 'PanelPosition'. Make sure it exists and that its name is spelled correctly"

- - - Updated - - -

Works fine if I ignore my panel.mdb though

BennyBoyW said:
Oh no it doesn't - if I then click OK to integrate data then I get a "Run Time Error '53' : File not Found"

- - - Updated - - -

And if I debug then it looks like it is not finding "Personal.mdb".

CMDR Ross said:
yep I got that one. went back to the old version for now.

Yep, found the issue. Releasing an update for it soon.

eventure · Jun 16, 2015

Transfer Database Manager Update (V1.01) released:

TDM V1.01 Update: http://bit.ly/1BkEkUX

Changelog:
- Fixed issue, if some station data is missing.
- Fixed issue, if double entries detected for star systems.
- Fixed issue, if panel.mdb differs from TCE V1.41.
- Fixed issue, if personal.mdb is missing.

punkerich · Jun 16, 2015

Eventure said:
I am looking into the Taskbar issue (it pops up on using TCE) at the moment and i encountered some weiredness. So i need your help in checking some things and reporting back, if it can be reproduced on your side.

My resolution is 1920x1200 and i using only one monitor.

If i set the X and Y value for the main panel to zero, no taskbar appears when using TCE.
Any other value for both let the taskbar appear.
Please test it yourself , if this behavior can be reproduced.

It applies both to compact and classic UI.

Thanks.

with triple-mon (5760*1080), both values to zero, taskbar appears nonetheless.

what do you mean with 'if some station data is missing'? should we redo the import, just to be sure?
or is there a way to check if everything went well? i got no errors whatsoever with the import.

eventure · Jun 16, 2015

punkerich said:
with triple-mon (5760*1080), both values to zero, taskbar appears nonetheless.

what do you mean with 'if some station data is missing'? should we redo the import, just to be sure?
or is there a way to check if everything went well? i got no errors whatsoever with the import.

No need, if no error happened. Bragolatch database missing the value for star distance, so TDM produces an error.
If using 0/0, the main panel displays at the top/left of your middle monitor or the left one?

Noisy Cosmos · Jun 16, 2015

A BIG question... Is this legal? Or is it a reason to be banned or something?

Thank you so much, looks really useful.

eventure · Jun 16, 2015

Noisy Cosmos said:
A BIG question... Is this legal? Or is it a reason to be banned or something?

Thank you so much, looks really useful.

No worries, it is absolutely legal and replaces only your pen and paper.

punkerich · Jun 16, 2015

Eventure said:
No need, if no error happened. Bragolatch database missing the value for star distance, so TDM produces an error.
If using 0/0, the main panel displays at the top/left of your middle monitor or the left one?

it displays on the left one (which is fine. don't change that. eventure, plz!)

yyy · Jun 16, 2015

Abil Midena said:
I don't think you're suppposed to mess with the mdb to add Os and Sap. I did not, and it's working ok for me.

Maybe restore your mdb to before you changed them, then add them from within TCE (database/wares/add new). OCR is probably fine. Give it a shot.

Thanks for the suggestion. I restored a previous TCE.mdb I had and added the wares from TCE UI. Sadly OCRing OSMIUM didn't work. At this stage I don't know whats wrong and don't know what else I can do. I've spent many days collecting prices and would hate to lose them all.