Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.

ron330

R
after installing beta 9 i have been getting errors from excel that causes it to crash about every 5-10min something about EDlog_read file any ideas what could be causing this thinking about reinstalled excel to see if that fixes it
 

eventure

eventure
Infomage said:
I have just tried setting up ftp and I can't make it work :(

My friend has his own server, and he has been able to connect fine, but even though we have compared .ini file options and they match perfectly, my upload and download logs both report unknown server in their first line.

Any clues please anyone?
Click to expand...

Perhaps a firewall/port forward issue.

Crimewave said:
@Infomage has he set up the correct access as to let you read/write to the server? Also Eventure, is it possible to write a quick quide to remove accidentally messed up stations from the database? We have a problem with a station in our database, have no idea what/who did what but we need to remove a station from the database so that we can re-enter the correct information.
Click to expand...

If you have a problem with one station, try to modify it. Fly to another trade station, you don't have in your database. Land on it and open the Modify Trade Station panel. Change all values for the new station, especially the Star System and the System Sector. After saving, go to Trade Commodity and reset all prices to make a scan of the new one.

ron330 said:
after installing beta 9 i have been getting errors from excel that causes it to crash about every 5-10min something about EDlog_read file any ideas what could be causing this thinking about reinstalled excel to see if that fixes it
Click to expand...

Please make a screenshot or tell me the exact error message. Thanks.
 
Last edited:

Crimewave

C
Hi Eventure, the problem is we have 1 station that says it exists in both Inupinie and Menusha however there is no station in Inupinie with that name and when you click on the Menusha one in the list it selects the Inupinie one. When i land at the station in Menusha it shows correctly in the "Current Position" but for some reason is unable to be selected when you click on "Auto Destination" and try to manually select it. I looked in TCE.mdb using microsoft access and in the station category the station is listed 3 times, twice in Menusha and once in Inupinie. Hope that makes sense, hence why i would like to just remove all 3 entries linked to that station name and re-enter it.
 

Infomage

I
Crimewave said:
@Infomage has he set up the correct access as to let you read/write to the server? Also Eventure, is it possible to write a quick quide to remove accidentally messed up stations from the database? We have a problem with a station in our database, have no idea what/who did what but we need to remove a station from the database so that we can re-enter the correct information.
Click to expand...

I can upload using cuteFTP with the credentials he has given me, so I don't think it is a server-side issue.
 

Etyneo

E
Been awhile since I've used TCE (this is likely to become a recurring thing for me) as I tend to switch between trading and combat for income. Last used 1.37g and have a DB from that version. I would like to import this DB into 1.39b9, but saw a page or so back that the import function is gone now. Why was it removed, and is it planned to return?

Additionally, I now see a TCE Setup.xlsm and am wondering what this is for (I suspect I need to use this before the main TCE.xlsm). I don't have time now to go through the thread to see when this file was added (I expect relevant instructions are located in that post), and suggest that relevant instructions be added to the OP.

Edit: Alright, figured out the TCE Setup.xlsm. Still needing to import my old DB, though.
 
Last edited:

eventure

eventure
Infomage said:
I can upload using cuteFTP with the credentials he has given me, so I don't think it is a server-side issue.
Click to expand...

Test by trying to ping the machine in question: "ping ftp.computername" will fail to resolve (with a slightly more meaningful message than the FTP client gives), whereas "ping computername" will respond to ping (unless security software is preventing this).

Also make sure your FTP server is setup to use port 21 (the default), or else you'll have to specify the port when you run ftp.

Etyneo said:
Been awhile since I've used TCE (this is likely to become a recurring thing for me) as I tend to switch between trading and combat for income. Last used 1.37g and have a DB from that version. I would like to import this DB into 1.39b9, but saw a page or so back that the import function is gone now. Why was it removed, and is it planned to return?

Additionally, I now see a TCE Setup.xlsm and am wondering what this is for (I suspect I need to use this before the main TCE.xlsm). I don't have time now to go through the thread to see when this file was added (I expect relevant instructions are located in that post), and suggest that relevant instructions be added to the OP
Click to expand...

The V1.37 database should be compatible with the V1.39. Try to use it. The import button was removed, because there are some errors with it. A standalone database manager will be released, when it is finished.

The TCE Setup is required for the V1.39, because the configuration of TCE is now external with this setup done. It creates a new TCE.ini file.

Crimewave said:
Hi Eventure, the problem is we have 1 station that says it exists in both Inupinie and Menusha however there is no station in Inupinie with that name and when you click on the Menusha one in the list it selects the Inupinie one. When i land at the station in Menusha it shows correctly in the "Current Position" but for some reason is unable to be selected when you click on "Auto Destination" and try to manually select it. I looked in TCE.mdb using microsoft access and in the station category the station is listed 3 times, twice in Menusha and once in Inupinie. Hope that makes sense, hence why i would like to just remove all 3 entries linked to that station name and re-enter it.
Click to expand...

Thats a little complicated, because you want to delete some stations, but the ID continuous numbering have to be untouched. Do the following:
Part I.
1. Delete the three station from the station table, but remember their IDs
2. Take the last three ID entries from the station table and change their ID to the deleted ones.
Now the station table ID numbering is continuous again.

Part II.
1. Find the System IDs (system ID = station ID) for the changed stations (your last three) at the StationPrices table, normally the last entries of the table (81 goods for each station).
2. Copy the data ( 3 x 81 goods) that belongs to the changed Station IDs, except the ID numbers (the System to Stock columns), to the position of the delete stations IDs and overwrite them.
3. Delete the last three Station IDs with their goods (3 x 81) from the StationPrices table including the IDs of the table itself.

If you are unsure to do this correctly, you can send me your database. I will do it for you.

In any case you change values of the database directly, make a backup before.
 
Last edited:

Bragolatch

Bragolatch
Barely had time to play in the last few days and I spent what little time I had on a combat mission,
but I did take the time to test the Locked trade route and it now works flawlessly.

Thanks !

Humm just receive and error, no idea why :

Sub ProcessMessages()

Dim Message As MSG
'loop until bCancel is set to True
Do While Not bCancel
'wait for a message
DoEvents
WaitMessage
'check if it's a HOTKEY-message
If PeekMessage(Message, 0, WM_HOTKEY, WM_HOTKEY, PM_REMOVE) Then
'minimize the form
If Main_Hide = True Then
If Menu_Mode = "CLASSIC" Then
If Main_Panel = "TOP" Then
Panel_Menu_top.Show
If Show_ShipLog = True Then
Panel_Logbook.Show
End If
Else
Panel_Menu_bottom.Show
If Show_ShipLog = True Then
Panel_Logbook.Show
End If
End If
Else
' Panel_Buttons_Main.Show
Panel_Picto.Show
Panel_Displays.Show
If Show_ShipLog = True Then
Panel_Logbook.Show
End If
End If
DoEvents
Main_Hide = False
Else
If Menu_Mode = "CLASSIC" Then
If Main_Panel = "TOP" Then
Panel_Menu_top.Hide
Panel_Menu_top.BTN_DB_Stations.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Stations_Layer.BackColor = &H101010
Panel_Menu_top.BTN_DB_Stars.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Stars_Layer.BackColor = &H101010
Panel_Menu_top.BTN_DB_Commodities.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Commodities_Layer.BackColor = &H101010
Panel_Menu_top.BTN_Control.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_Control_Layer.BackColor = &H101010
Panel_Menu_top.BTN_Database_Layer.BackColor = &H101010
Panel_Menu_top.BTN_Database.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Stations_Layer.BackColor = &H101010
Panel_Menu_top.BTN_DB_Stations.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Stations.Visible = False
Panel_Menu_top.BTN_DB_Stations_Layer.Visible = False
Panel_Menu_top.BTN_DB_Stars_Layer.BackColor = &H101010
Panel_Menu_top.BTN_DB_Stars.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Stars.Visible = False
Panel_Menu_top.BTN_DB_Stars_Layer.Visible = False
Panel_Menu_top.BTN_DB_Commodities_Layer.BackColor = &H101010
Panel_Menu_top.BTN_DB_Commodities.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Commodities.Visible = False
Panel_Menu_top.BTN_DB_Commodities_Layer.Visible = False
Panel_Menu_top.BG_Database_Add.Visible = False
If Panel_Options.Visible = False Then
If Panel_Menu_top.BTN_Options_Layer.BackColor <> &H101010 Then
Panel_Menu_top.BTN_Options_Layer.BackColor = &H101010
Panel_Menu_top.BTN_Options.ForeColor = &HFFFFFF
End If
End If
If Panel_DB_Stars.Visible = False And Panel_DB_Stations.Visible = False And Panel_DB_Commodity.Visible = False And Panel_Menu_top.BG_Database_Add.Visible = False Then
If Panel_Menu_top.BTN_Database_Layer.BackColor <> &H101010 Then
Panel_Menu_top.BTN_Database_Layer.BackColor = &H101010
Panel_Menu_top.BTN_Database.ForeColor = &HFFFFFF
End If
End If
If Panel_Trade.Visible = False Then
If Panel_Menu_top.BTN_Trade_Layer.BackColor <> &H101010 Then
Panel_Menu_top.BTN_Trade_Layer.BackColor = &H101010
Panel_Menu_top.BTN_Trade_Label.ForeColor = &HFFFFFF
End If
End If
If Panel_Prices.Visible = False Then
If Panel_Menu_top.BTN_Commodity_Layer.BackColor <> &H101010 Then
Panel_Menu_top.BTN_Commodity_Layer.BackColor = &H101010
Panel_Menu_top.BTN_Commodity.ForeColor = &HFFFFFF
End If
End If
If Panel_Scout_BD.Visible = False Then
If Panel_Menu_top.BTN_TradeScout_Layer.BackColor <> &H101010 Then
Panel_Menu_top.BTN_TradeScout_Layer.BackColor = &H101010
Panel_Menu_top.BTN_TradeScout.ForeColor = &HFFFFFF
End If
End If
If Panel_Cartography.Visible = False Then
If Panel_Menu_top.BTN_Cartography_Layer.BackColor <> &H101010 Then
Panel_Menu_top.BTN_Cartography_Layer.BackColor = &H101010
Panel_Menu_top.BTN_Cartography.ForeColor = &HFFFFFF
End If
End If
Panel_Menu_top.BTN_Commodity.Caption = "COMMODITY"
Panel_Menu_top.BTN_Database.Caption = "DATABASE"
Panel_Menu_top.BTN_Cartography.Caption = "CARTOGRAPHY"
Panel_Menu_top.BTN_TradeScout.Caption = "TRADE SCOUT"
Panel_Menu_top.BTN_Trade_Label.Caption = "TRADE"
Else
Panel_Menu_bottom.Hide
Panel_Menu_bottom.BTN_DB_Stations.ForeColor = &HFFFFFF
Panel_Menu_bottom.BTN_DB_Stations_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_DB_Stars.ForeColor = &HFFFFFF
Panel_Menu_bottom.BTN_DB_Stars_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_DB_Commodities.ForeColor = &HFFFFFF
Panel_Menu_bottom.BTN_DB_Commodities_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_Control.ForeColor = &HFFFFFF
Panel_Menu_bottom.BTN_Control_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_Database_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_Database.ForeColor = &HFFFFFF
Panel_Menu_bottom.BTN_DB_Stations_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_DB_Stations.ForeColor = &HFFFFFF
Panel_Menu_bottom.BTN_DB_Stations.Visible = False
Panel_Menu_bottom.BTN_DB_Stations_Layer.Visible = False
Panel_Menu_bottom.BTN_DB_Stars_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_DB_Stars.ForeColor = &HFFFFFF
Panel_Menu_bottom.BTN_DB_Stars.Visible = False
Panel_Menu_bottom.BTN_DB_Stars_Layer.Visible = False
Panel_Menu_bottom.BTN_DB_Commodities_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_DB_Commodities.ForeColor = &HFFFFFF
Panel_Menu_bottom.BTN_DB_Commodities.Visible = False
Panel_Menu_bottom.BTN_DB_Commodities_Layer.Visible = False
Panel_Menu_bottom.BG_Database_Add.Visible = False
If Panel_Options.Visible = False Then
If Panel_Menu_bottom.BTN_Options_Layer.BackColor <> &H101010 Then
Panel_Menu_bottom.BTN_Options_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_Options.ForeColor = &HFFFFFF
End If
End If
If Panel_DB_Stars.Visible = False And Panel_DB_Stations.Visible = False And Panel_DB_Commodity.Visible = False And Panel_Menu_bottom.BG_Database_Add.Visible = False Then
If Panel_Menu_bottom.BTN_Database_Layer.BackColor <> &H101010 Then
Panel_Menu_bottom.BTN_Database_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_Database.ForeColor = &HFFFFFF
End If
End If
If Panel_Trade.Visible = False Then
If Panel_Menu_bottom.BTN_Trade_Layer.BackColor <> &H101010 Then
Panel_Menu_bottom.BTN_Trade_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_Trade_Label.ForeColor = &HFFFFFF
End If
End If
If Panel_Prices.Visible = False Then
If Panel_Menu_bottom.BTN_Commodity_Layer.BackColor <> &H101010 Then
Panel_Menu_bottom.BTN_Commodity_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_Commodity.ForeColor = &HFFFFFF
End If
End If
If Panel_Scout_BD.Visible = False Then
If Panel_Menu_bottom.BTN_TradeScout_Layer.BackColor <> &H101010 Then
Panel_Menu_bottom.BTN_TradeScout_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_TradeScout.ForeColor = &HFFFFFF
End If
End If
If Panel_Cartography.Visible = False Then
If Panel_Menu_bottom.BTN_Cartography_Layer.BackColor <> &H101010 Then
Panel_Menu_bottom.BTN_Cartography_Layer.BackColor = &H101010
Panel_Menu_bottom.BTN_Cartography.ForeColor = &HFFFFFF
End If
End If
Panel_Menu_bottom.BTN_Commodity.Caption = "COMMODITY"
Panel_Menu_bottom.BTN_Database.Caption = "DATABASE"
Panel_Menu_bottom.BTN_Cartography.Caption = "CARTOGRAPHY"
Panel_Menu_bottom.BTN_TradeScout.Caption = "TRADE SCOUT"
Panel_Menu_bottom.BTN_Trade_Label.Caption = "TRADE"
End If
Else
' Panel_Buttons_Main.Hide
Panel_Picto.Hide
Panel_Displays.Hide
End If
Panel_Cartography.Hide
Panel_DB_Commodity.Hide
Panel_DB_Stars.Hide
Panel_DB_Stations.Hide
Panel_DES_Select.Hide
Panel_Info.Hide
Panel_Logbook.Hide
Panel_Options.Hide
Panel_POS_Select.Hide
Panel_Prices.Hide
Panel_Scout_BD.Hide
Panel_Trade.Hide
Panel_Summary.Hide
Main_Hide = True
If Menu_Mode = "CLASSIC" Then
If Main_Panel = "TOP" Then
Panel_Menu_top.Calc.Caption = "PROCESSING"
Panel_Menu_top.Calc.Visible = False
Else
Panel_Menu_bottom.Calc.Caption = "PROCESSING"
Panel_Menu_bottom.Calc.Visible = False
End If
End If
PanelOpen = False
Call ChkEliteProcess
If EDRun Then
AppActivate ("Elite - Dangerous (CLIENT)")
End If
DoEvents
End If
End If
'let the operating system process other events
DoEvents
Loop

End Sub


I also had another error that I could not note because it happened on shutdown.
It's was my fault but might be nice to know. So, just for your info :

Basically I started TCE but Hid it when I started combat and completely forgot about it.
Later I stopped ED and shut down the computer, I then saw a TCE error pop before the shut down killed it.
 
Last edited:

Crimewave

C
Hi again Eventure, thanks so much for the help. Sent you a pm. Also i forgot to mention the reason i wanted the "star system notes" button was because i would like to leave the little window that you type in to add notes to to stay onscreen (even if it's just to be able to see any notes made for that system) without having the much larger "star system summary" window popping up every jump.
 

Infomage

I
Eventure said:
Test by trying to ping the machine in question: "ping ftp.computername" will fail to resolve (with a slightly more meaningful message than the FTP client gives), whereas "ping computername" will respond to ping (unless security software is preventing this).

Also make sure your FTP server is setup to use port 21 (the default), or else you'll have to specify the port when you run ftp.
Click to expand...

I am using the exact same lines from TCE.ini as my friend, and his is working...

Also, can ping the ftp by server name (first thing I tried lol)

I will get him to double-check the port number though.
 
Last edited:

eventure

eventure
Altion said:
Hi Eventure.
You can add the translation into Russian language? Is ready to help.
Click to expand...

TCE is not ready for translation yet, EliteOCR cant read russian language too. The first step in translating TCE is to german and frensh. So your wish is registered but its not a priority.
 
Last edited:

punkerich

punkerich

eventure

eventure
Full-Version and Update (V1.39) released:

Changelog (including beta versions):
- New compact UI with pictograms (changable at the Options panel). At the Panel Position window you can also select, to which side the database buttons are displayed.
- New Hotkey selection procedure. It can only be selected through the TCE_setup.
- TCE_Setup V1.01 included.
- Options panel revised.
- Search Route at the Trade panel depends now on your actual star system, not on the last station visited.
- New checkbox at the Destination panel to highlight large stations only.
- Changed "BODY ID" to "SECTOR".
- Colored red to wrong (50% over or under the min/max price of the good) OCR data at Commodity panel now.
- Panel displays faster and no more white flash on opening.
- Panel Position window now free movable.
- Changed Jurisdiction to Allegiance.
- Added scrollbars to notes.
- Added sort option for all headers at the Trade Scout panel.
- Added buy/sell prices for commodites, when in Trade Lock Mode.
- Added a small hide button for the pictograms at the Compact UI.
- Modified Mark Large Station checkbox at the Destination panel, so Auto-Destination selecting now only that station type.
- Bugfix in database saving routine produces "overflow".
- Bugfix in Wares Database panel.
- Added two new columns to Station database table, change will apply automatically.
- Bugfix in Star System Summary panel not updating inside of a star system
 
Last edited:

Bragolatch

Bragolatch
Eventure said:
Full-Version and Update (V1.39) released:

Click to expand...

Been trading with Full-Version 1.39 non-installer for a bit over an hour now and so far everything is working fine !!!



I do not know if this is possible, but it would be nice if
When on a Locked Trade Route,
if we Update Scan or Manually Update the commodity that we are currently trading at one of the two stations in the route,
It would also update the prices shown in the Locked Trade Route automatically,
Without having to unlock, search and lock it again !
 
Last edited:

BennyBoyW

BennyBoyW
@Eventure
I cannot quite work out why but the problems I have been having with EliteOCR and TCE on a multiple monitor setup are now far worse than before.
I have to exit TCE after scanning each page of a commodity market - restarting seems to make the link between TCE and EOCR work again.
This means I have 4 - 5 restarts on every station's commodity page.
Has something changed in this area ?
 
Status
Thread Closed: Not open for further replies.
Back
Top Bottom