Abandoned [RELEASE] Trade Computer Extension

[Bragolatch]

No problem, debug is offline for this routine, because of crashing.

Update (V1.36 beta 4) released:
- Another moddified save routine for the star systems issue.

First thing that happened after beta 4 update is error 91

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


None of my paths have changed !

Deleted TCE.ini
Restarted
Selected Paths
Everything OK !



In TRADE INFORMATION
SET TRADE RANGE
is not applied to the results
I can set it to 10 or to 200, I get the same results list.

It would be nice to be able to click on the headers
STATION DISTANCE PRICE STOCK
to reorder the results accordingly.

Same thing applies to all of the lists.
I realize this might be a tall order !
But It would greatly enhance the tool !!!

 

[Bragolatch]

Just noticed,
when adding a new station,
there is no setting to say that said station doesn't have a commodities market !

Also, no biggie, but wondering why 2 of the stations I added are doubled up in DESTINATION.

Adding a station doesn't update an unregistered station ?
If that's the case, it is going to get very complicated/confusing as the database grows !!!
I still do not quite grasp why you had to make that registered/unregistered distinction.
Just leaving it incomplete should be enough for anybody to understand.
And even if it is complete with the wrong info, they have to option to correct it when they get there.
Which they will have to do as thing changes all the time anyway !


Either way, having a drop down selection box for the STATION NAME,
as you already do for the STAR SYSTEM name,
could help a lot when adding/editing a station.
Right now it shows us the info of the last one we entered.
If there was another one station already in the database in the system, registered or not, we can't see it.

 

[RadBlaster]

I did complete fresh install of the 1.36beta1 with all the update in sequence from 2 to 3.

But I'm still unable to added a new star to the data base. When I click save after putting all the references distances, it will throw the following error.

 

[eventure]

First thing that happened after beta 4 update is error 91

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

This problem occurs when having multiple instances of excel running.

In TRADE INFORMATION
SET TRADE RANGE
is not applied to the results
It would be nice to be able to click on the headers
STATION DISTANCE PRICE STOCK
to reorder the results accordingly.I can set it to 10 or to 200, I get the same results list.

What result list you mean? When changing the Trade Range, the number of stations at the Destination panel changes subject to the given range and the Auto-Destination displays a new recommended station, when its last are out of the range. At the Trade Scout panel, the Trade Range didnt change any results, because all stations are checked. The Trade Scout panel gets an overhaul when finding time for it.

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

I did complete fresh install of the 1.36beta1 with all the update in sequence from 2 to 3.

But I'm still unable to added a new star to the data base. When I click save after putting all the references distances, it will throw the following error.

Please use beta 4. Please test, if it works. Need feedback.

 

[Noxx]

Hi,

From this thread it seems like an excellent tool, kudos.
I searched the thread but didn't find any other posts with my problem.

After installing everything as instructed, and opening the TCE.xlsm, excel indicates that there is unreadable content and i can only proceed after excel tries to repair the file and deletes /xl/vbaProject.bin in the process.

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<logFileName>error016680_01.xml</logFileName>
<summary>Er zijn fouten aangetroffen in bestand C:\Program Files (x86)\Frontier\EDLaunch\TCE\TCE.xlsm</summary>
<removedParts summary="Hier volgt een lijst van verwijderde onderdelen:">
<removedPart>Verwijderd onderdeel: /xl/vbaProject.bin-onderdeel. (Visual Basic for Applications (VBA))</removedPart>
</removedParts>
</recoveryLog>


I made sure that the certificates are ok and i tried the 3 latest betas, all give the same problem.

I have the Dutch version of Excel Professional Plus 2010 (32bit) and installed the Access 2010 runtime as you linked.

Needless to say, after opening the repaired version nothing appears in ED.

Hope you can help me, thanks in advance!

 

[eventure]

Just noticed,
when adding a new station,
there is no setting to say that said station doesn't have a commodities market !

The only reason to add a station without a commodity market to your TRADE computer is, when it has a blackmarket.

Also, no biggie, but wondering why 2 of the stations I added are doubled up in DESTINATION.

Adding a station doesn't update an unregistered station ?

Did you added a new station or you registered a station? When registering an unregistered station, the unregistered will be deleted in saving process.

I still do not quite grasp why you had to make that registered/unregistered distinction.
Just leaving it incomplete should be enough for anybody to understand.
And even if it is complete with the wrong info, they have to option to correct it when they get there.
Which they will have to do as thing changes all the time anyway !

There have to be a separation, because all registered stations have their prices, the unregistered have no price data. If i would mix them, all stations (11k+) must have a price data. That overextent the database in an unnessesary way.

Either way, having a drop down selection box for the STATION NAME,
as you already do for the STAR SYSTEM name,
could help a lot when adding/editing a station.
Right now it shows us the info of the last one we entered.
If there was another one station already in the database in the system, registered or not, we can't see it.

There is a dropdown, when registering a station. It displays only the stations resident in the system. When adding a new system, you have to enter the name of the station yourself.
If you want to edit a special system, please select it through the Position panel, go to Database > Stations to change the values.

Hi,

From this thread it seems like an excellent tool, kudos.
I searched the thread but didn't find any other posts with my problem.

After installing everything as instructed, and opening the TCE.xlsm, excel indicates that there is unreadable content and i can only proceed after excel tries to repair the file and deletes /xl/vbaProject.bin in the process.

Please look here https://forums.frontier.co.uk/showthread.php?t=103401&p=1769692&viewfull=1#post1769692. Veskandar reinstalled excel and that fixed the problem. I would recommend it too or try to update excel to the newest service pack. Use Windows Update multiple times, till no updates are found for excel.

 

[Filroden]

Could you add another economy type - the high tech / industrial economy? It's needed for Jameson Memorial in SHINRARTA DEZHRA.

Thanks

 

[eventure]

Could you add another economy type - the high tech / industrial economy? It's needed for Jameson Memorial in SHINRARTA DEZHRA.

Thanks

Will do that.

Please can someone tell me, adding a new star system works with beta 4?

 

[Bragolatch]

The only reason to add a station without a commodity market to your TRADE computer is, when it has a blackmarket.

If you get attacked in the middle of a long trade route, having a list of stations with repair services is also very appreciated !!!

Did you added a new station or you registered a station? When registering an unregistered station, the unregistered will be deleted in saving process.

I added a new station, I did not want to add an Unregistered station, because I misunderstood the title of that window lol
and now of course I see the dropdown menu I was looking for, Thanks !

May I suggest renaming the menu from ADD UNREGISTERED STATION to REGISTER A STATION.
Seems less confusing to me, but then again I'm not a native English speaker so I might be wrong.

Anybody else has an opinion on this ?

and as feedback

I registered both the unregistered station with the same name and system as the one I already added as a new station.

It seemed to work, TCE accepted it and but in some of the windows I still see duplicates
and in TCE.mdb there are duplicates because I was not at the stations when I added them so I have each with the proper body and with 0 as body.

I can remove the duplicates directly from the mdb ? they are the last 2 in the list so it should not cause problems ?
Or would you prefer I leave them there to test your future remove station feature ?

There have to be a separation, because all registered stations have their prices, the unregistered have no price data. If i would mix them, all stations (11k+) must have a price data. That overextent the database in an unnessesary way.

Humm, what would happen if I started adding many stations and did not add/scan any of the commodities list ?

What result list you mean? When changing the Trade Range, the number of stations at the Destination panel changes subject to the given range and the Auto-Destination displays a new recommended station, when its last are out of the range. At the Trade Scout panel, the Trade Range didnt change any results, because all stations are checked. The Trade Scout panel gets an overhaul when finding time for it.

I have boxed in green what I meant about the range not affecting the search.
I thought that changing the SET TRADE RANGE in that box would affect the result in the BEST BUY LOCATIONS
in the other green box below it.

Originally Posted by Bragolatch
It would be nice to be able to click on the headers
STATION DISTANCE PRICE STOCK
to reorder the results accordingly.I can set it to 10 or to 200, I get the same results list.

I have boxed in red the headers that could be made clickable to show those list in different orders.
All similar headers in other windows could also be made active.

 

[Yokai]

@ Eventure: I've created the initial draft of my guide for your tool over in the guides forum:
https://forums.frontier.co.uk/showthread.php?t=119873

It currently covers installation pain points and two of the main tasks users will frequently want to do. There's still a lot to come in the next few days but this should help folks who are asking for installation help and the really basic "how to" stuff, especially concerning "editing registered stations" versus "adding new stations".

I'm about to test adding a star system with Beta 4 right now. BRB with success or failure report.

 

[Yokai]

Beta 4 still errors out when adding star system:

Error Line: 30

AzStars: 22378 Error (-2147417848) Method 'Value' of object 'Range' failed.

On the bright side, when you click OK to dismiss the error, Excel does now successfully complete its "repair" routine and automatically relaunches TCE, which is in a good state when it comes back up.

 

[Noxx]

Thx, updating Office solved it.

Next problem: when i start it up i get the TCE splash screen with the planet, but i get the 380 fault (zoom values must be between x & x)

Please check, if you have the new Panel.mdb in the DB folder, here it looks like:

ID	Panel	X-Coord	Y-Coord	Z-Coord
1	Main	0	0	100
2	Options	5	72	100
8	Trade	68	72	100
7	Position	165	72	100
9	Destination	165	72	100
11	TS_Bidirect	178	72	100
12	TS_Multi	178	72	100
10	Commodity	978	100	100
13	Cartography	1010	72	100
4	DB_Stations	1110	72	100
5	DB_Stars	1110	72	100
6	DB_Commodity	1110	72	100
3	ShipLog	1110	802	100

So when i try to open Panel.mdb, it says my PC doesn't trust it and i see a blanco file.

 

[Yokai]

@ Bragolatch

Check the guide I linked to just a few posts above. The trick with adding data for a station you haven't seen before is to:

1. Always start by right-arrowing over to ADD UNREGISTERED STATION.
2. Click the STATION NAME field and see if the station you're at is already listed.
   1. If so, then fill out the station details there.
   2. If not, then left arrow back to ADD NEW STATION and enter the details there.

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

Beta 4 still errors out when adding star system:

Error Line: 30

AzStars: 22378 Error (-2147417848) Method 'Value' of object 'Range' failed.

On the bright side, when you click OK to dismiss the error, Excel does now successfully complete its "repair" routine and automatically relaunches TCE, which is in a good state when it comes back up.

BTW, Eventure, if you want to try this for yourself and debug locally, here are two stars within 200 LS of SOL (kinda near Achenar) that aren't yet in your db and will trigger the dialog:

ICZ NX-T B3-4
CD-69 55

 

[eventure]

BTW, Eventure, if you want to try this for yourself and debug locally, here are two stars within 200 LS of SOL (kinda near Achenar) that aren't yet in your db and will trigger the dialog:

That's the problem, my version here didn't make an error, when saving a new star system. I will do make a workaround, so i hope this way it can be done too.

Update (V1.36 beta 5) released:
- And again another moddified save routine for the star systems issue. This time its completely different.

 

[eventure]

So when i try to open Panel.mdb, it says my PC doesn't trust it and i see a blanco file.

Can you add the TCE folder as a trusted place in excel/office? Is the TCE.mdb or Languages.mdb also blank?

1. Always start by right-arrowing over to ADD UNREGISTERED STATION.
2. Click the STATION NAME field and see if the station you're at is already listed.
   1. If so, then fill out the station details there.
   2. If not, then left arrow back to ADD NEW STATION and enter the details there.

Tip: If you select a station as you destination, that is unregistered (has NO DATA), the Station Database panel displays the ADD UNREGISTERED STATION option as default, when opened.

 

[Snowdog]

What if I only have access to Excel 2002, I am guessing it will not work, i that correct?

 

[eventure]

What if I only have access to Excel 2002, I am guessing it will not work, i that correct?

I think so, try the new version with beta 5 update to test it. Please tell us, if it works. Thanks.

 

[Yokai]

Beta 5 seems to be a _partial_ winner.

I was able to successfully add CD-69 55 by specifying only the four distances to the reference systems, then selecting "Visited". Note that I had to actually select one of the options in the STATE OF EXPORATION field before the SAVE button would appear.

However, when I subsequently selected DATABASE > STARS to bring up the panel again so I could add a SPECIAL NOTE, two errors occurred:

1. I had to press Enter to get the new note content to "stick" and the SAVE button to display, and
2. Upon pressing save I get the following error:

Error Line: 75

Error (1004) Application-defined or object-defined error.

On the bright side, this error does not seem to crash excel entirely. And also, the special note that I added DID seem to be saved correctly despite the error.

 

[Bragolatch]

@ Bragolatch

Check the guide I linked to just a few posts above. The trick with adding data for a station you haven't seen before is to:

1. Always start by right-arrowing over to ADD UNREGISTERED STATION.
2. Click the STATION NAME field and see if the station you're at is already listed.
   1. If so, then fill out the station details there.
   2. If not, then left arrow back to ADD NEW STATION and enter the details there.

Yep, I had made the mistake and the post before you made your guide which is very nice by the way !

Can you add the TCE folder as a trusted place in excel/office? Is the TCE.mdb or Languages.mdb also blank?

Access actually gives you the choice to open it anyway and a hook you can remove so it won't ask again,
if you have added the certificates in the trusted root as instructed.

@Noxx have you done it again after re-installing Office ???

Tip: If you select a station as you destination, that is unregistered (has NO DATA), the Station Database panel displays the ADD UNREGISTERED STATION option as default, when opened.

Good tip, Thanks !

@Yokai

Another small add to the manual


and before I forget again,

@Eventure

Am I right in thinking that :
Since the galaxy map shows distance in light years from one system to the other,
It means that you can add the Star's coordinates in the STAR SYSTEMDATABASE panel from anywhere in said system with the same result ?

 

[Yokai]

Beta 5 seems to be a _partial_ winner.

I was able to successfully add CD-69 55 by specifying only the four distances to the reference systems, then selecting "Visited". Note that I had to actually select one of the options in the STATE OF EXPORATION field before the SAVE button would appear.

However, when I subsequently selected DATABASE > STARS to bring up the panel again so I could add a SPECIAL NOTE, two errors occurred:

1. I had to press Enter to get the new note content to "stick" and the SAVE button to display, and
2. Upon pressing save I get the following error:

Error Line: 75

Error (1004) Application-defined or object-defined error.

On the bright side, this error does not seem to crash excel entirely. And also, the special note that I added DID seem to be saved correctly despite the error.

One small update to this error in Beta 5. One that above-quoted error occurs, the "auto-station-detect-on-landling" code can't run correctly. If I land at a new doc the CURRENT POSITION does not update. I had to quit and restart TCE to get it to update to the station I was actually at.