Abandoned [RELEASE] Trade Computer Extension

[Narsil76]

Hi,

In the "Werte" sheet at the "E56" Location the function is:

=INDEX(Prices!A:A;EQUIV(Werte!E55;Prices!B:B;0))

But "Werte!E55" is the commodity name in english, and "Prices!B:B" saves commodity depending on your language (i'm french)

To prevent the error i have to change the function to:

=INDEX(Prices!A:A;EQUIV(RECHERCHEV(Werte!E55;LOC_G oods[[Tradegood]:[Marchandise]];3;0);Prices!B:B;0))

But you could certainly do far better, i don't have check with which function you set the value of "Werte!55" or where is saved the language value

I hope you understand what i have try to explain ...

 

[Distance]

Decided to try the new icons in compact mode and moved them to the right of the screen. Tooltip shows up off screen so it's impossible to read.

Data base is unsuable as it shows on the right and whenever I reset the panel position for the icons and try to change back to classic it positions everything off the screen again.

 

[Bragolatch]

Decided to try the new icons in compact mode and moved them to the right of the screen. Tooltip shows up off screen so it's impossible to read.

Data base is unsuable as it shows on the right and whenever I reset the panel position for the icons and try to change back to classic it positions everything off the screen again.

In PANEL POSITIONS,
(second from the bottom, above power)
MAIN MENU/DATABASE
the last column on the right, change right to left so that the tootips and menus will show on the left of the icons !

 

[BennyBoyW]

OK - something bad happened.
My PC decided to do an emergency shutdown and now I am getting an error every time I run TCE.
The error is "Error in Startsequence Error Line 410 Error (9) Subscript out of range"

Is there anything I can do ? I haven't taken a backup of the database for 14 days

 

[BennyBoyW]

I think I have fixed it. I was running 1.37 and installing the latest Beta and copying my databases in seems to have worked - phew !!!!!

 

[Crimewave]

Hi Eventure, any chance you could make this addon support mysql? Been asked by a friend who says it would be more user friendly for multiple uploads via a server (like the FTP option). I have no clue what any of this means lol but he says he would be willing to help/provide a server for the testing.

 

[BennyBoyW]

OK - I spoke too soon - the problem is back.
"Error in Startsequence Error Line 410 Error (9) Subscript out of range" every time I start TCE.
Any ideas ?

 

[Cmdr Bupu]

Hi Eventure,
I have a Saitek x52 pro controller which I believe you do as well any chance you could make use of the mfd display there are 3 lines which could be used.
line 1 on auto each hop then final destination (changes each hop not everything scrolling)
line 2 on auto sell comm and price
line 3 on auto buy comm and price
or any other info that would just look good.
.
just getting fed up seeing that display sitting there doing nothing
Cmdr Bupu

 

[eventure]

Hi Eventure, any chance you could make this addon support mysql? Been asked by a friend who says it would be more user friendly for multiple uploads via a server (like the FTP option). I have no clue what any of this means lol but he says he would be willing to help/provide a server for the testing.

I have no clue also, because i didnt know much about mysql. My answer is no, sry mate, we have to stick with access.

Hi Eventure,
I have a Saitek x52 pro controller which I believe you do as well any chance you could make use of the mfd display there are 3 lines which could be used.
line 1 on auto each hop then final destination (changes each hop not everything scrolling)
line 2 on auto sell comm and price
line 3 on auto buy comm and price
or any other info that would just look good.
.
just getting fed up seeing that display sitting there doing nothing
Cmdr Bupu

I didnt own a Saitek. I have a CH Fighterstick and Pro Throttle. Sry, no support from here.

OK - something bad happened.
My PC decided to do an emergency shutdown and now I am getting an error every time I run TCE.
The error is "Error in Startsequence Error Line 410 Error (9) Subscript out of range"

Is there anything I can do ? I haven't taken a backup of the database for 14 days

TCE makes a backup every day at first start. Use a database from the BACKUP folder.

 

[Crimewave]

Ok, thanks for the reply though.

 

[BennyBoyW]

TCE makes a backup every day at first start. Use a database from the BACKUP folder.

Thank you so much for your help once again - you are amazing !

 

[Cmdr Bupu]

Could not help myself..
thread 1966 (hopefully) the year I was born.....
.
ps. keep up the fantastic work Eventure..
Cmdr Bupu

 

[eventure]

Update V1.39 beta 9 released: (http://bit.ly/1D1bqDz)
- Bugfix not showing the selected language
- Added a small hide button for the pictograms at the Compact UI
- Bugfix in Trade Lock, when selecting a different station as a new destination
- Modified Mark Large Station checkbox at the Destination panel, so Auto-Destination selecting now only that station type
- Bugfix in Panel Position window.

 

[eventure]

Well buddy you have gone above and beyond now and made this perfect for me. Repped and donated. If I find myself in Germany Ill buy you a cold one or 4

Thank you, drinks are on you

 

[Crimewave]

1 more tiny request from me (i know u wish i would shut up lol) is it possible to put a quick view button for the Star system notes in the Control menu? currently in classic view the only way i can see the notes is either going to Cartography and clicking Add/Edit or going to Control/Panel and click "show". However when u click "show" in the control/panel you then can't edit the note from the Cartography/Edit button so you have to go back to Control/Panel, click "hide" then click Cartography then "edit" to be able to enter text. Just clicking Add/Edit in the cartography panel followed by "hide" in the top right of the cartography panel hides the notes as well. Hope this makes sense

 

[RadBlaster]

Update V1.39 beta 9 released: (http://bit.ly/1D1bqDz)
- Bugfix not showing the selected language
- Added a small hide button for the pictograms at the Compact UI
- Bugfix in Trade Lock, when selecting a different station as a new destination
- Modified Mark Large Station checkbox at the Destination panel, so Auto-Destination selecting now only that station type
- Bugfix in Panel Position window.

That my friend is the bomb for me .... thank you thank you thank you soooo much.

BTW where can I donate some $$ to you. I can't seem to find it??

 

[punkerich]

That my friend is the bomb for me .... thank you thank you thank you soooo much.

BTW where can I donate some $$ to you. I can't seem to find it??

It's in TCE itself, in the options panel.

 

[eventure]

1 more tiny request from me (i know u wish i would shut up lol) is it possible to put a quick view button for the Star system notes in the Control menu? currently in classic view the only way i can see the notes is either going to Cartography and clicking Add/Edit or going to Control/Panel and click "show". However when u click "show" in the control/panel you then can't edit the note from the Cartography/Edit button so you have to go back to Control/Panel, click "hide" then click Cartography then "edit" to be able to enter text. Just clicking Add/Edit in the cartography panel followed by "hide" in the top right of the cartography panel hides the notes as well. Hope this makes sense

The CONTROL > PANEL is only for positioning, therefor all panels are deactivated and no edits are possible.

To open the Star System Note panel, you have to go to the Cartography panel and click on Add or Edit for the corresponding star system. It closes on SAVE or when closing the Cartography panel. You can easily view your notes, when activating the SHOW STAR SYSTEM SUMMARY option at the Options panel.

I cant see there is an advantage to add an additional button to the control menu, because you need two clicks (one at CONTROL and one at your suggested button) to open it. You can do it with two clicks too at the moment (one at CARTOGRAPHY and one at Add/Edit).

I appreaciate any suggestion, so you are very welcome. But here i cant see any improvement, or i didnt understand you right. Also i can say, there will be some changes to the cartography and notes in the future. But for now it will stay as it is.

 

[Infomage]

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?

 

[Crimewave]

@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.