Abandoned [RELEASE] Trade Computer Extension

[Bragolatch]

Did you have other workbooks of excel open? Please check that all instances of excel are closed (Taskmanager Excel.exe). If so and the error still present, add the codeline: ThisWorkbook.Activate before the AppPath = ActiveWorkbook.Path
Save it and restart. Please give feedback. Thanks.



After pressing SAVE, all entered data are saved to the database. When opened again the panel shows "Modify Star System" not "Add Star System" and the X-, Y- and Z-values are shown. If you want to change the position of the star system, you are in, you have to enter the distances to the references again, in case of wrong values typed in.

From the error I guessed that it might have been an open file in the background or something like that.

So I closed everything, re copied the 1.35d files over in my install directory. (just in case)

No more error on opening !

The New Database WARES now opens properly !

The COMMODITY button turning orange and to NO STATION, is a very nice feature too !!!

There is still one minor and one major problem:

The minor one is this:


But everyting works and if I hide it and open it again all the number are as they should be !



The Major One :
TCE does not save everything (or I'm using it wrong lol still experimenting here)

When fill out the STAR SYSTEM info with a note, a state, the coordinates...
Click SAVE, it turns into WAIT for about 5 seconds then the STAR SYSTEM window closes.
I open it again and it goes back to MODIFY STAR SYSTEM RECORD,
I see the info I previously entered for a second then dissolve back to what it was before I entered anything.

Should not my SPECIAL NOTE and STATE OF EXPLORATION still be there to be modified ?
And where can I see this SPECIAL NOTE again afterwards ?

I have tried to see the see/add a note by clicking on add in the CARTOGRAPHY panel and got :

Run-time error '1004':
Application-defined or object-defined error

Can't execute code in break



Private Sub UserForm_Activate()


Dim sngWidth As Single, sngHeight As Single
Dim XFactor As Single ' Horizontal resize ratio
Dim YFactor As Single ' Vertical resize ratio
XFactor = GetSystemMetrics(SM_CXSCREEN) / X_RESOLUTION
YFactor = GetSystemMetrics(SM_CYSCREEN) / Y_RESOLUTION
sngHeight = 900
sngWidth = 1430
Me.Width = GetSystemMetrics(SM_CXSCREEN) * 0.75
Me.Height = GetSystemMetrics(SM_CYSCREEN) * 0.75
Me.Zoom = Fix(WorksheetFunction.Min(Me.Width / sngWidth, Me.Height / sngHeight) * 100)
Me.Left = Panel_DB_Stars.Left * XFactor
Me.Top = (Panel_Cartography.Top + Panel_Cartography.Height + 12) * YFactor
Me.TextBox1.Value = Worksheets("DB_Stars").Cells(Worksheets("Werte").Cells(130, 2).Value, 7).Value
Me.Head.Caption = Worksheets("Werte").Cells(123, 2).Text
Me.BTN_Save.Visible = False

End Sub

 

[Bragolatch]

Did you see wha realdragnet is doing with his WaitForPixel command ?
https://forums.frontier.co.uk/showthread.php?t=109213

It's been used before in World of Warcraft, fishing addon, to detect when the lure went down and other such.
But this one is made for ED.

Something like that could be a very nice addition to the your COMMODITY PANEL - START OCR SCAN.
would be quite nice to press it once, sit back and watch it scroll down to the bottom all by itself !

 

[Scouto]

Quick question about the FTP usage, when multiple users are using the upload, are the databases merged or is the one on the FTP being overwritten?

 

[Granty]

Apologies if this is a dumb question, inhave it installed ok, it starts up fine and I can see the menus on top of my desktop but when I altvtab into Elite it vanishes and I see usual Elite window.

It should be integrated right? What do I need to do?

 

[eventure]

Did you see wha realdragnet is doing with his WaitForPixel command ?
https://forums.frontier.co.uk/showthread.php?t=109213

It's been used before in World of Warcraft, fishing addon, to detect when the lure went down and other such.
But this one is made for ED.

Something like that could be a very nice addition to the your COMMODITY PANEL - START OCR SCAN.
would be quite nice to press it once, sit back and watch it scroll down to the bottom all by itself !

Played with it too and the results vary and at the end, its not as reliable as i want it in TCE. So atm i cant see a possiblity using it with TCE.

Apologies if this is a dumb question, inhave it installed ok, it starts up fine and I can see the menus on top of my desktop but when I altvtab into Elite it vanishes and I see usual Elite window.

It should be integrated right? What do I need to do?

You need to switch Elite into borderless window mode.

Quick question about the FTP usage, when multiple users are using the upload, are the databases merged or is the one on the FTP being overwritten?

Each upload overwrites the database in less than a second. Theoretical when two or more users pressing the SAVE button at the same time, the one who has the lowest bandwidth save his database. All others are overwritten. So this function is only for a small party of 3 to 5 users.

There is still one minor and one major problem:

The minor one is this:

But everyting works and if I hide it and open it again all the number are as they should be !

The Major One :
TCE does not save everything (or I'm using it wrong lol still experimenting here)

When fill out the STAR SYSTEM info with a note, a state, the coordinates...
Click SAVE, it turns into WAIT for about 5 seconds then the STAR SYSTEM window closes.
I open it again and it goes back to MODIFY STAR SYSTEM RECORD,
I see the info I previously entered for a second then dissolve back to what it was before I entered anything.

Should not my SPECIAL NOTE and STATE OF EXPLORATION still be there to be modified ?
And where can I see this SPECIAL NOTE again afterwards ?

I have tried to see the see/add a note by clicking on add in the CARTOGRAPHY panel and got :

Run-time error '1004':
Application-defined or object-defined error

Fixed the Control panel display bug and the save bug for Star Systems too. The Cartography error must come from a bad database entry. Tested it here and all runs pretty well.

 

[Bragolatch]

Played with it too and the results vary and at the end, its not as reliable as i want it in TCE. So atm i cant see a possiblity using it with TCE.

Yes, testing with Voice Macro, I also find that the results can vary greatly with every use.

Each upload overwrites the database in less than a second. Theoretical when two or more users pressing the SAVE button at the same time, the one who has the lowest bandwidth save his database. All others are overwritten. So this function is only for a small party of 3 to 5 users.

Thanks for the info, I was also wondering about that too !

Fixed the Control panel display bug and the save bug for Star Systems too.

Fixed How ? Where ? I do not see version 1.35e ! Did you include it in 1.35d ?
Will re-downloading and re-installing it fix these issues ? Or is it coming out later ?

The Cartography error must come from a bad database entry. Tested it here and all runs pretty well.

Got the same error again last night, I only have 2 stations in there, so I'll replace all the databases with the ones you provided. I'll let you know if I get it again.


All of the stars already have coordinates.
Are they pretty accurate ? Or is it worth it to re-enter them everytime we visit a new one ?

 

[Mousejockey]

Out of curiosity, is it possible to get an interface for this that displays on a 2nd monitor instead of the main screen?

 

[Bragolatch]

Out of curiosity, is it possible to get an interface for this that displays on a 2nd monitor instead of the main screen?

Use version 1.35d and use minus x and y values in the Option/Panel to move the windows to a second screen on the left
or increase the x and y values past 1000 (depending on your resolution) to move the windows to a second screen on the right of your main.

Make sure to run Elite in windowed or borderless mode (graphic settings) to be able to use it without loosing sight of your elite graphics.

 

[eventure]

Fixed How ? Where ? I do not see version 1.35e ! Did you include it in 1.35d ?
Will re-downloading and re-installing it fix these issues ? Or is it coming out later ?

All of the stars already have coordinates.
Are they pretty accurate ? Or is it worth it to re-enter them everytime we visit a new one ?

Will be fixed next big update. Have him ready but i must playtest it, before releasing. Here are a small preview:
- 3k more Star Systems (22k+ total), all recalculated (99, and moved to Sol centric (0,0,0) values.
- 11k+ unregistered Trade Stations
- new code optimizations for faster calculations and starting times
- added Info panel to Panel Control
- some bugfixes

 

[Bragolatch]

Will be fixed next big update. Have him ready but i must playtest it, before releasing. Here are a small preview:
- 3k more Star Systems (22k+ total), all recalculated (99, and moved to Sol centric (0,0,0) values.
- 11k+ unregistered Trade Stations
- new code optimizations for faster calculations and starting times
- added Info panel to Panel Control
- some bugfixes

Hoooo Nice ! cant' wait to give it a try, I'll keep at lest one eye on this page !


Another feature I think would be nice,
Let me know if you agree :

- Make the SHIP LOGBOOK persistent, (if it is not already, haven't had time to test it much)
- The ability to stretch it to be able to see more entries at the same time
- add a scroll bar, to be able to range forward and backwards in it.
- have a date entry at the beginning of each new day to make a clear separation.
- Have the ability to insert notes in it

That way it could really serve as a log book, same as any boat captain keeps.
And if it's Database/Datasheet file was made in a presentable way,
with time and use, it could be read like a book/blog !

 

[punkerich]

Will be fixed next big update. Have him ready but i must playtest it, before releasing. Here are a small preview:
- 3k more Star Systems (22k+ total), all recalculated (99, and moved to Sol centric (0,0,0) values.
- 11k+ unregistered Trade Stations
- new code optimizations for faster calculations and starting times
- added Info panel to Panel Control
- some bugfixes

Holy Jeebus! Too sad i'm already married!
Any hint on ETA? Don't know how long i can hold on smashing F5...

 

[eventure]

Another feature I think would be nice,
Let me know if you agree :

- Make the SHIP LOGBOOK persistent, (if it is not already, haven't had time to test it much)
- The ability to stretch it to be able to see more entries at the same time
- add a scroll bar, to be able to range forward and backwards in it.
- have a date entry at the beginning of each new day to make a clear separation.
- Have the ability to insert notes in it

All you listed is possible, and i will think it will come. Seems to me not a big deal to make it. I will add it on my 'todo' list.

Holy Jeebus! Too sad i'm already married!
Any hint on ETA? Don't know how long i can hold on smashing F5...

When testing goes well, i think perhaps weekend. Dont push me to hard, i have a real life also.

 

[Bragolatch]

Fixed the Control panel display bug and the save bug for Star Systems too. The Cartography error must come from a bad database entry. Tested it here and all runs pretty well.

Restarted with brand new install and database as discussed and YES ! no more error.
So far (10 minutes and only 1 station lol) everything works great !

I'm still not finding where I can see the note I put in the DATABASE STAR panel after I added it.
In the STELLAR pannel I can now set EXPLORED
but clicking on ADD under the NOTE column does nothing.
(which is much better then an error and a crash ! lol )
but you said fixed in the next version so I'll wait for that !


Also, I'm probably being thick, but I can't figure out what the credit balance in many of the windows is supposed to be referring to !
I was never asked how much money I have so hos is it figuring out a -750CR balance ???

Thanks so much !

 

[Nionor]

Also, I'm probably being thick, but I can't figure out what the credit balance in many of the windows is supposed to be referring to !
I was never asked how much money I have so hos is it figuring out a -750CR balance ???

I think that is just compared to the galactic average so you quickly can see if it's high or low.

 

[eventure]

Restarted with brand new install and database as discussed and YES ! no more error.
So far (10 minutes and only 1 station lol) everything works great !

I'm still not finding where I can see the note I put in the DATABASE STAR panel after I added it.
In the STELLAR pannel I can now set EXPLORED
but clicking on ADD under the NOTE column does nothing.
(which is much better then an error and a crash ! lol )
but you said fixed in the next version so I'll wait for that !


Also, I'm probably being thick, but I can't figure out what the credit balance in many of the windows is supposed to be referring to !
I was never asked how much money I have so hos is it figuring out a -750CR balance ???

Thanks so much !

Its compared to the galactic average price.

 

[Bragolatch]

New Error

Adding a new Star System

Microsoft Visual Basic

Run-time error '-2147417848 (80010108)':
Method 'Value' of object 'Range' failed


Could not copy the Debug Code because Excel Crashed.

Restarted and tried the same again. Full Excel Crash again with the same error,
but I manage to take a screen shot before it shut down on me :

 

[Filroden]

I'm getting the exact same error even after a complete fresh install.

I wasn't sure if you'd fixed this in 1.35d or the fix was coming in 1.35e?

 

[shadragon]

its 100% free of bad things.

True, excluding Excel of course.

 

[RadBlaster]

Same error for me too when adding in a new Star System.

@Bragolatch ... thanks for capturing this. It was frustrating me to no end trying to get a screen shoot. When blaster Excel crashes and restarts.

 

[NewYears1978]

Just wanted to give props to Eventure. I wrote a simple app in Excel for my own use that has none of the data calling from other sources and whatever else like this..and even it was really tough.

I can't imagine how hard this was to code and get error free!