Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.
Hi, Since the last update I have noticed an odd thing when choosing a destination that is not the auto generated one. I used to get a list of only stations I had data from. I now seem to get an entire list of hundreds (most have no data, only name and type) I also get multiples of the same station, see pic, there are three Kaleri Gateways (you can only see two here but when I scroll down there is another).
.


When you install, you have the choice of an near empty database (2 stations) or a pretty extensive one
(22k+ star systems in database. 11k+ unregistered and 150 registered trade stationsions)

As stated on the first post of this tread !


Since you apparently chose the default extensive database, you get alll the empty stations !


The only time I have seen doubles like that is when I did not follow the instructions,
fond on Yokai's very nice guide for TCE : https://forums.frontier.co.uk/showthread.php?t=119873

Basically you've added a new station that was already in the unregistered station list.
The one that has NO DATA is the original unregistered you got with the database.
The one with the update time and price is the one you added.

You were supposed to check ADD UNREGISTERED STATION, before doing an ADD STATION.
Quote from Yokai's :
>>>>
5. In the TRADE STATION DATABASE panel, click the right arrow until you see ADD UNREGISTERED STATION (We always check the unregistered list first).6.Click the STATION NAME field and see if the station you're at is already listed. If so, click it.
If you don't see the station listed, or if the system name itself changes to something other than the system you're really at, use the arrows at the top of the panel to choose ADD NEW STATION.
<<<<


As also stated on Yokai's guide, there is no way yet to automatically remove these.
But I think Eventure is working on that. Might be in a future update.

your options as far as I can see are
1. keep going as is and hope for the option to delete comes in later.
2. restart with new database. Choose the 2 station one if you do not want all the unregistered stations.
3. try to edit the mdb yourself. If you do, make a backup first and be careful to understand the links between tables and of not breaking sequence.

Eventure and/or Yorkai might have better options for you.

Hope this helps,

Enjoy.
 
Thanks, I did recently start with a new database. I am certain I selected the empty one, looking at the size, obviously not.
The system always seems to appear automatically with the correct body number at least. I then fill in the missing parts.

Your explanation seems like the correct one, looks like I might wipe again and start afresh. I had only been filling this one a few hours anyway.

Thanks

-yep just had a look in game. I never had to use that before as I had always used the empty database (I lost it in the last update)

One odd thing is you get a drop down with the station names in the system if you use 'Add unregistered' but if I go to 'Edit registered' I get a dropdown for star systems but no drop down for stations in the system that I select. Maybe it only works if you are in that particular system - just checked, no it doesn't give me a drop down when I edit a registered station. I think this is why it is creating a new one each time I try to edit.

Getting confusing here, I don't see any benefit to using the pre loaded stations, none of the data seems to be auto filling anyway. I'm just going to wipe and start from scratch again.


...OK just re-read Yokai's guide and it makes more sense now that I have encountered these problems. The confusion was the difference between registered and unregistered stations. Maybe we need to think of another way of naming the two lists, 'Add Unregistered' says to me that nothing exists although it really means it does exist just with no data other than the name. Well now I know I shouldn't get it wrong again. It would also help if the add station panel defaulted to the 'Add unregistered' tab.

Still having difficulty with the 'edit registered' I get the star systems in a drop down list (obviously made up of all the known systems) but when I select a system I do not get a selection of stations. I think I should as they are definitely in the database and I am trying it on ones that are fully registered. Any ideas?
 
Last edited:
Morning

There seems to be a bug with the import old database function - it doesn't seem to merge the records together, so end up with duplicates. Everywhere I've been before and had data for now also still has a corresponding unregistered entry still which shows up as a destination with no data.
 
Morning

There seems to be a bug with the import old database function - it doesn't seem to merge the records together, so end up with duplicates. Everywhere I've been before and had data for now also still has a corresponding unregistered entry still which shows up as a destination with no data.

Morning too,

found that issue. With the next update, all station imports are crosschecked with the unregistered stations, so no duplicates more are present.
 
Last edited:
I had chance to use TCE for the first time for a few hours last night, and in fact the first such mod I've used with the game -and it has been nothing short of a REVOLUTION! :D
-Its simply brilliant. I nolonger feel like I'm roaming around 'aimlessly', randomly finding worthwhile Trade. My exploration is now logged too. And it works almost seamlessly with the game. Thanks so much Eventure for your hard work and efforts on this!

FEEDBACK:
I had no issues installing, following Eventure and Yokai's helpful instructions.
I run ED on 21:9 monitor, thats 3440 x 1440i Res and it doesn't display perfectly, but is still fully functional.
Had a couple of bugs/hangs that I will endevour to investigate and provide more info.
It works with TrackIR, though when using the menus, the TrackIR pauses, upon selecting the game window, TrackIR works again, no problem.

SUGGESTION:
1. If the panels could be 'centrally alligned', that would be of benefit for the 21:9 monitor users. Currently, the menu panels are all 'left alligned' and it looks fugly.
(-do this in the panels tab, change the menu position.)
2. If the panels could be resized, that would be awesome. I had a fiddle in the options, but didn't seem to change anything.
(-do this in the panels tab, change the zoom option.)
3. A HOTKEY to HIDE all panels would be a big improvement imo. Sometimes, its a little tricky to hide them individually and can loose precious seconds when being shot at.
4. A small panel to display route info would be good, currently the only way I've found to see route info is contained in a panel that covers 50% of the screen.
5. If the Panels could have Alpha/transparancy, it would be awesome.

Just ideas really, generally I'm really impressed by Eventures ideas and direction on this! Great job dude, I look forward to seeing where this goes, it has made my game SO MUCH more enjoyable :)

EDIT: I've edited the above, as I've since learned I was doing a couple things wrong.
 
Last edited:
This tool appears to be extremely useful, Nice job Eventure.
I did make a slight alteration to the ships log position as it hid some information when in commodities view, I changed the Y-axis to 510 instead of 600.

I personally would have liked a blank database, as the auto trade feature is a good idea. I opted to reset all the trade item prices back to zero for those two stations, which has done the trick. I did take a couple of hours and attempted to blank the database myself, but after adding a further 3 stations, I hit an error I handn't expected, and decided to forget that idea.

I've already made a profit on a single trip with a hawler of over 17K in about 15 mins, the highest for me yet. The hardest part is making this profit on every trip, going to take some time to get that working.

All in all though, this works well.
 
I had chance to use TCE for the first time for a few hours last night, and in fact the first such mod I've used with the game -and it has been nothing short of a REVOLUTION! :D
-Its simply brilliant. I nolonger feel like I'm roaming around 'aimlessly', randomly finding worthwhile Trade. My exploration is now logged too. And it works almost seamlessly with the game. Thanks so much Eventure for your hard work and efforts on this!

FEEDBACK:
I had no issues installing, following Eventure and Yokai's helpful instructions.
I run ED on 21:9 monitor, thats 3440 x 1440i Res and it doesn't display perfectly, but is still fully functional.
Had a couple of bugs/hangs that I will endevour to investigate and provide more info.
It works with TrackIR, though when using the menus, the TrackIR pauses, upon selecting the game window, TrackIR works again, no problem.

SUGGESTION:
1. If the panels could be 'centrally alligned', that would be of benefit for the 21:9 monitor users. Currently, the menu panels are all 'left alligned' and it looks fugly.
(-do this in the panels tab, change the menu position.)
2. If the panels could be resized, that would be awesome. I had a fiddle in the options, but didn't seem to change anything.
(-do this in the panels tab, change the zoom option.)
3. A HOTKEY to HIDE all panels would be a big improvement imo. Sometimes, its a little tricky to hide them individually and can loose precious seconds when being shot at.
4. A small panel to display route info would be good, currently the only way I've found to see route info is contained in a panel that covers 50% of the screen.
5. If the Panels could have Alpha/transparancy, it would be awesome.

Just ideas really, generally I'm really impressed by Eventures ideas and direction on this! Great job dude, I look forward to seeing where this goes, it has made my game SO MUCH more enjoyable :)

EDIT: I've edited the above, as I've since learned I was doing a couple things wrong.

Thanks for your feedback,

to 3: A HOTKEY may be possible, i have to test it with the new functions required for this.

to 4: You mean a route info to reach your "Auto/Selected Destination"? If so, then use the Route Makers for this. Do the following:

  • Activate Route Markers at the Options panel
  • Select a destination (skip, if your destination was set)
  • Open the Trade panel and click on the button at FIND ROUTE TO. Let TCE calculate the route info.
  • Close the Trade panel.
Now you see some Route Marker with names of star systems below the Main panel (max. 7 at the moment). Thats the list of jump markers, you have to travel (from left to right), to reach your destination.

to 5: Thats not possible, because Alpha/Transparancy values are used to make all userforms (panels) look, as they are. Cant make it to both, because i dont know, how to do this atm or if its possible at all.
 
Found this problem, got fixed in next update, and i will change, that you didn't have to press enter for the distances boxes. Perhaps that will fix the other problem too.

You already do not really have to ! if I put something in the note box it works, without ever having pressed the enter key !
Now that I know that I have to put something in the note box, it's not a big deal.


But you could make it even better by giving the user more reason the press the enter key.

It would be nice if pressing enter and/or tab would copy the name of the next reference system into the clipboard,
like you when we select a destination.
So the process would then be more like this:

1. Flying into a star system, that TCE didnt have into its database (crosschecked with Cartography panel and Navigation).
2. Reaching the system, TCE displays the Star System Database panel, the name automatically entered. And the name of the first reverence system is copied to the clipboard
3. Going to the galaxy map, Paste the first reference, into the the navigation search box, clicking then into the panel again, entering the distance, hitting enter to complete. the name of the second reverence system is copied to the clipboard
4. Clicking back to the search box, pasting into it, clicking again into the panel, enterering the distance, hitting enter to complete.the name of the third reverence system is copied to the clipboard
5. Clicking back to the search box, pasting into it, clicking again into the panel, enterering the distance, hitting enter to complete.the name of the fourth reverence system is copied to the clipboard
6. Clicking back to the search box, pasting into it, clicking again into the panel, enterering the distance, hitting enter to complete.
7. Now the SAVE button appeared, the State of Exploration Combobox is highlighted. Didnt touch the Star System Note box.
8. Pressing SAVE or hide, panel is closed and the selected destination is copied to the clipboard.



And who knows, with any luck adding this feature might also solve my bug :)
 
But you could make it even better by giving the user more reason the press the enter key.
All this provides TCE since V1.36 beta1 (forget to note). Now changed the input from AfterUpdate event (hitting ENTER required) to Change event (no ENTER required). Auto-activating Elite window is disabled temporary, but will come back in V1.37 beta2 (with hitting enter only).


Update (V1.37 beta1) released:

- New Trade Scout panel (updated HOW TO OPERATE section at the main page).
- Bugfix and code optimizations at Import panel: When importing a station, the unregistered station entry, if existing, will be deleted.
- Bugfix and code optimizations at Main panel (Bottom panel especially).
- Bugfix and code optimizations at Star System Database panel: Hitting ENTER when filling in the distances no longer required. Clipboard use of all reference star names.
- Bugfix and code optimizations at Trade Station Database panel: Add Unregistered Station is now default, except when landed on a registered station.
- Bugfix and code optimizations at Commodity panel: Activating Elite window, when screenshot was taken.
- Bugfix and code optimizations at Cartography: Always centered on your position.
- Bugfix and code optimizations at Position panel: Distances are now correctly listed, when jumping to other star systems.
- Bugfix and code optimizations at Destination panel: Rare issue not showing any trade station, distances are now correctly listed, when jumping to other star systems.
 
Last edited:
Update V1.37 beta1

I am still getting the same error if I try to save a station without a note, but It doesn't matter, I think you are a genius ! :)
(I will try re-installing office completely, as a test, soon)

I love the new Trade Scout !
and even more the auto clipboard of the add star panel !!!!

Thank you !

If the Hide panels hotkey is possible, that will be very nice too !

Just curious, Are you still planning on upgrading the Shiplog ?




As a test I edited a note from the CARTOGRAPHY panel, erased the space and clicked save.

I receive a different error, hope it helps :

Run-time error 5 :

Invalid procedure call or argument


Private Sub BTN_Save_Click()


Dim i As Long
Me.BTN_Save.Caption = "WAIT"
DoEvents
If FTP_Enabled = True Then
Call Download_DB
Worksheets("DB_Stars").Range("A1:G100000").ClearContents
Call DB_Importer(AppPath & "\DB\TCE.mdb", "Stars", "DB_Stars", Range("A1"))
End If
i = Asc(Me.TextBox1.Text)
If i = 13 Then
StarData(7) = ""
Else
StarData(7) = Me.TextBox1.Value
End If
For i = 1 To AzCarto
If StarData(1) = Ar_Carto(i, 1) Then
Ar_Carto(i, 5) = StarData(7)
i = AzCarto
End If
Next i
Star_SOK = True
Call ADO_Export_Mod(AppPath & "\DB\TCE.mdb", "Stars")
Worksheets("DB_Stars").Activate
Worksheets("DB_Stars").Range("A1:G100000").ClearContents
Call DB_Importer(AppPath & "\DB\TCE.mdb", "Stars", "DB_Stars", Range("A1"))
ActiveWorkbook.Worksheets("DB_Stars").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("DB_Stars").Sort.SortFields.Add Key:=Range( _
"A2:A1000001"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("DB_Stars").Sort
.SetRange Range("A1:G1000001")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
 
Last edited:
Just curious, Are you still planning on upgrading the Shiplog ?

As a test I edited a note from the CARTOGRAPHY panel, erased the space and clicked save.

I receive a different error, hope it helps :

Run-time error 5 :

Invalid procedure call or argument

Nice finding, got fixed next beta update.

Yes, the Ship Log is a new project. Any inspirations, what it should hold and log? It will be persistant with a new database file, in case of problems with the main.
 
Last edited:
Eventure, I've come across another station, Unsanctioned Outpost, and it looks different. How do I go about getting it added to the Database with Picture. Are you already aware of it?
 
Love the new beta. The default panel focus for editing/adding stations is great and makes things much easier. Trade scout looks fantastic and the auto copy for star names is very handy. If only we could automate the whole process of adding a new system!

Thanks
 
Okay, i added a Hotkey feature for the next beta version. Release will be tomorrow.

@ALL:
I want to thank you all for the great testing work, you have done so far and for your kind words for this project. You are a great community.

Good night to all,

Eventure
 
I couldn't find anything on this but is there anything special I need to to to "update"?

I'm using the zip and not the installer, to try the new beta is it just a case of dragging the files in and overwriting the old files?
 
I couldn't find anything on this but is there anything special I need to to to "update"?

I'm using the zip and not the installer, to try the new beta is it just a case of dragging the files in and overwriting the old files?

Yep just copy files over from downloaded zip file and overwrite the old files.
 
Status
Thread Closed: Not open for further replies.
Back
Top Bottom