Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.
Update (V1.40 Beta 7.3 Test-Version) released:




Changelog:
- Another fix for the error in Station Database panel, when saving (line 220).

Because i cant recreate the issue, this is a release only for users having this issue. All others dont need this update! Please report, if it is working now. Thanks.

I'm back already :)

Was able to delete a STAR SYSTEM note without error but the note was back after TCE restart.

I can now add at Note to a station entry in the TRAVEL LOGBOOK,
it shows for all entries for that station and is still there after TCE restart :)


I still get the error with no debug or other info when deleting from the TRAVEL LOGBOOK thought.
214741848.jpg


And there is still not color or icon to mark which travel logbook entry has a note.
 
Last edited:
Thanks for trying. Fixed the issue for the next release.



You didnt tell me any additional info of that issue. Any debug info here?

sorry, i were in a hurry, and couldn't reproduce this yet, but i keep trying.
with 7.3 i can add new stations though, where beta 6 crashed.
will continue testing this evening.
 
I still get the error with no debug or other info when deleting from the TRAVEL LOGBOOK thought.
View attachment 38482

Okay,

there are three ways to edit/delete Star System Notes:
1. At the Star System Database panel
2. At the Trade panel
3. At the Cartography panel

Please tell me, which way is working or not.

If all three ways won't work, then you have to check you Office installation. You are the only one, who has this particular problem. No one else replied to my call to report, if he had the same issue as you, so i assume that it is working.

If some work and some not, i will continue to look where the problem can be.

Waiting for your report.

@Found an issue, that changes made to Star System Notes in Trade panel did not display in Cartography panel without restarting.
 
Last edited:
When adding a new station, you will sometimes receive this error. When you click on OK, excel is restarted. Data for the new station are not saved.
In the field range up to write a character "," but it seems there should be a character "."?
Excel 2013
https://yadi.sk/i/ma6g5Qoigt2WE
 
Okay,

there are three ways to edit/delete Star System Notes:
1. At the Star System Database panel
2. At the Trade panel
3. At the Cartography panel

Please tell me, which way is working or not.

If all three ways won't work, then you have to check you Office installation. You are the only one, who has this particular problem. No one else replied to my call to report, if he had the same issue as you, so i assume that it is working.

If some work and some not, i will continue to look where the problem can be.

Waiting for your report.

@Found an issue, that changes made to Star System Notes in Trade panel did not display in Cartography panel without restarting.


i double-checked all of the mentionened ways for the notes, with 7.3 all of them worked as intended (for me).
 
Okay,

there are three ways to edit/delete Star System Notes:
1. At the Star System Database panel
2. At the Trade panel
3. At the Cartography panel

Please tell me, which way is working or not.

If all three ways won't work, then you have to check you Office installation. You are the only one, who has this particular problem. No one else replied to my call to report, if he had the same issue as you, so i assume that it is working.

If some work and some not, i will continue to look where the problem can be.

Waiting for your report.

@Found an issue, that changes made to Star System Notes in Trade panel did not display in Cartography panel without restarting.


Sorry, I saw many report with the same -2147417848 error,
I was sure it was all related !
I didn't realize I was the only one with this specific bug.
And that you were doing all of this only for me.
Thank you so much !!!
Here is my report with my current Excel install.



1. There is no notes "At the Star System Database panel"
and no save option appear at the STAR SYSTEM SUMMARY if that is what you meant.
Star System Database.jpgStar System Summary.jpg


2. So far I have always used the cartography panel for all my tests
and I do still have the problem in 7.3
I've tested this with absolutely nothing else then TCE running, not even ED.

Editing has never been a problem before,
it used to work, As long as I left at least 1 character behind.
but with 7.3, from the cartography panel, I get no error on deleting, editing or adding a note.
everything seems to work fine, but the note is back to its previous state, not deleted, edited or added after I restart TCE.


3. Adding a Star System note from the Trade Panel works,
but it does not appear in the Cartography Panel until I restart TCE.
and it does not ever appear in the Travel LogBook in the Star System Entry for that System !

Adding a Station Note from the Trade Panel also works,
and it appears right away in the Travel LogBook !
I can also add a station note from the Travel LogBook and it's visible right away in the Trade Panel.

I can edit a System and Station note from the Trade Panel,
but again, the change to a System note does not appear in the Cartography Panel until TCE is restarted.
A change to a Station note appears in the Travel LogBook right away.
and if I change a Station note from the Travel LogBook, it show in the Trade Panel right away.


I can delete a Station note from the TRADE PANEL or TRAVEL LOGBOOK without any problem
they update each other right away and the note is still gone after I restart TCE !!! :)


Trying to delete a "Star System Entry" or "Sector" note from the Travel LogBook gives me :
del Star system entry note from travel logbook.jpg



Deleting a Star System note from the Trade Panel (last station) I get :
Delete from Trade Panel.jpg or sometimes but rarely this one : delete from selected position.jpg

TCE does not crash.
after I click ok and re-open the Trade Panel, the note appears empty
but the note is still there in the Cartrography panel :
Trade vs Carto.jpg

if I try to delete a second note from the trade panel (recommended station) before restarting TCE I get :
deleting again from Trade panel after the first error.jpg
and after I restart TCE both notes are back in the Trade Panel.


So, everything that has to do with Station Notes works perfectly !!!
Any Chance you can apply the Station Notes codes/formatting to Star Systems notes ???

Or if you want to give up the search I understand, it's a lot of work for only 1 user when it works for everybody else !

Enough for tonight and I am away tomorrow,
but I will try to un-install and re-install Excel completely on the day after that if you think it can help.
And if that does not work I can always try to go back to find and settle to an earlier version that did the trick.
 
Last edited:
1. There is no notes "At the Star System Database panel"
and no save option appear at the STAR SYSTEM SUMMARY if that is what you meant.

Oh yes, oh yes, i am getting old :), of course i removed the ability here, because of the issue.

Editing has never been a problem before,
it used to work, As long as I left at least 1 character behind.
but with 7.3, from the cartography panel, I get no error on deleting, editing or adding a note.
everything seems to work fine, but the note is back to its previous state, not deleted, edited or added after I restart TCE.

Interesting, that i have to check!

3. Adding a Star System note from the Trade Panel works,
but it does not appear in the Cartography Panel until I restart TCE.
and it does not ever appear in the Travel LogBook in the Star System Entry for that System !

I can edit a System and Station note from the Trade Panel,
but again, the change to a System note does not appear in the Cartography Panel until TCE is restarted.


Yes,i found that issue, as mentioned above.

Trying to delete a "Star System Entry" or "Sector" note from the Travel LogBook gives me :
View attachment 38665

Deleting a Star System note from the Trade Panel (last station) I get :
View attachment 38689 or sometimes but rarely this one : View attachment 38688

TCE does not crash.
after I click ok and re-open the Trade Panel, the note appears empty
but the note is still there in the Cartrography panel :
if I try to delete a second note from the trade panel (recommended station) before restarting TCE I get :
and after I restart TCE both notes are back in the Trade Panel.


All these errors have to do with the export to database routine as you see. Internally TCE changed your doing, but the data didnt moved to the TCE.mdb. Thats why you see the unchanged note after restarting.

So, everything that has to do with Station Notes works perfectly !!!
Any Chance you can apply the Station Notes codes/formatting to Star Systems notes ???

Or if you want to give up the search I understand, it's a lot of work for only 1 user when it works for everybody else !

Enough for tonight and I am away tomorrow,
but I will try to un-install and re-install Excel completely on the day after that if you think it can help.
And if that does not work I can always try to go back to find and settle to an earlier version that did the trick.

Unfortunately, the coding is the same for all exports (add or mod entries), only the file name, table name and the data to write changes. But i will check it again, to be absolutely sure.

All issues above have to do with exporting, so i think it could be the access runtime, not Excel itself. Did you installed the file from the mainpost? If installed, you did it because of issues with your Office prior or as a precaution? Try to reinstall it.

If want to try a different version, i am very interested to see, what version is working! The V1.39 is under outdated versions available, if you need older versions, i glady give them to you.

Eventure
 
Last edited:
Using Windows 8.1 x64, Office 2013 installed, but also went and got the runtime specified for 2013.

Version 1.40 Beta 7.

Adding new station -> Yorates -> Lichtenberg Gateway ( wasn't in prepopulated unregistered )

Enter information, click save ( I'm currently in the station services menu )

"Method 'Range' of object '_Worksheet' failed"
 
7.3 appears to fix.

Using Windows 8.1 x64, Office 2013 installed, but also went and got the runtime specified for 2013.

Version 1.40 Beta 7.

Adding new station -> Yorates -> Lichtenberg Gateway ( wasn't in prepopulated unregistered )

Enter information, click save ( I'm currently in the station services menu )

"Method 'Range' of object '_Worksheet' failed"
 
Answering from my phone so no new data,
just some thought.

Unfortunately, the coding is the same for all exports (add or mod entries), only the file name, table name and the data to write changes. But i will check it again, to be absolutely sure.

The data for Star and Station notes is in the same format and in the same file and one works but not the other so that only leaves a difference in the table name or in the coding. Maybe the ":" as you mentioned before. I can't check from here if the Station Note tab has it or not.

All issues above have to do with exporting, so i think it could be the access runtime, not Excel itself. Did you installed the file from the mainpost? If installed, you did it because of issues with your Office prior or as a precaution? Try to reinstall it.

I installed it by default because the instructions said so but since I have the full version of Access it might not be needed. I will try without for a while after I re-install Office.

If want to try a different version, i am very interested to see, what version is working! The V1.39 is under outdated versions available, if you need older versions, i glady give them to you.
Eventure

Yes, probably, I'll let you know after the other test.
 
Update (V1.40 Beta 7.4 Test-Version) released:



Changelog:
- Changed the export routine to SQL for Star System Notes at the Cartography panel.

eventure, with this version my destination panel is not showing _any_ stations where should be a hundred or so.
absolutely empty list. fiddlling with the trade range or filter doesn't help. nada, nothing.
 
eventure, with this version my destination panel is not showing _any_ stations where should be a hundred or so.
absolutely empty list. fiddlling with the trade range or filter doesn't help. nada, nothing.

What is with your position detection? Is it correct?
What shows your Position panel, all stations? What distances?

I didnt changed nothing to it, beside the fix for the filtering. All is working here. Is it the beta, that TCE didnt detecting your position correctly?
 
Last edited:
eventure, with this version my destination panel is not showing _any_ stations where should be a hundred or so.
absolutely empty list. fiddlling with the trade range or filter doesn't help. nada, nothing.

Update 1.40 Beta 7.4 Test-Version - Starting splash screen says v1.40 beta 8 :)

Same here !
No more destinations
and I still get the same error deleting a STAR SYSTEM note from the Trade panel

7.4.jpg

But it now works flawlessly from the CARTOGRAPHY panel !!! :)
 
Last edited:
Update 1.40 Beta 7.4 Test-Version - Starting splash screen says v1.40 beta 8 :)

Same here !
No more destinations
and I still get the same error deleting a STAR SYSTEM note from the Trade panel


But it now works flawlessly from the CARTOGRAPHY panel !!! :)

Good to here, will change the whole export to SQL asap. What shows your Position panel? All stations there? If you revert to 7.3, did you see all stations? Are you using the PP beta?
 
Good to hear, will change the whole export to SQL asap. What shows your Position panel? All stations there?

Yes all stations appear properly in the Position Panel !
I deleted a few STAR SYSTEM notes from the Cartography panel and restarted TCE a few times, all was going well but then,
I do not know what happened, I started getting this error on startup :
7.4 Error line 589.jpg
and trying to access the Cartography panel now give me:
7.4 Error 9.jpg
Sub GetExploreStatus()

Dim SX As Double, SY As Double, SZ As Double, ZX As Double, ZY As Double, ZZ As Double, SID As Long, ZID As Long, z As Long, SZD As Double, ArDistance(1 To 50000) As Double
Dim ArExTemp As Variant, ArTemp As Variant, ArExploData As Variant, a As Long, zeile As Long, lLZeile As Long, ArStars As Variant, x As Long, ArRegSt As Variant, ArURegSt As Variant
ReDim ArExploData(1 To 100000, 1 To 8)

ArRegSt = Worksheets("DB_Stations").Range("Q2:Q" & AzRegStations + 1)
ArURegSt = Worksheets("DB_Stations_UR").Range("Q2:Q" & AzURegStations + 1)
' Dim t As Double
' t = Timer
' MsgBox Timer - t & " sec", , "Makrolaufzeit"

If ActualStarID <> Worksheets("ExploreData").Cells(2, 1).Value Or JR_Changed = True Then
x = 0
Worksheets("ExploreData").Range("A2:H1000001").ClearContents
Worksheets("Navigation_Sort").Range("S2:S" & AzStars + 1).ClearContents
SID = ActualStarID
SX = Ar_DBStars(SID, 3)
SY = Ar_DBStars(SID, 4)
SZ = Ar_DBStars(SID, 5)
For z = 1 To AzStars
ZID = Ar_DBStars(z, 1) ' Ziel Stern
ZX = Ar_DBStars(ZID, 3)
ZY = Ar_DBStars(ZID, 4)
ZZ = Ar_DBStars(ZID, 5)
ArDistance(z) = Round(Sqr(WorksheetFunction.Power((SX - ZX), 2) + WorksheetFunction.Power((SY - ZY), 2) + WorksheetFunction.Power((SZ - ZZ), 2)) + 0.000001, 2)
If ArDistance(z) <= Jump_Limit Then
x = x + 1
ArExploData(x, 1) = Ar_DBStars(z, 1) ' ID
ArExploData(x, 2) = Ar_DBStars(z, 2) ' Name
ArExploData(x, 3) = Ar_DBStars(z, 8) ' Class
If Ar_DBStars(z, 8) = "" Then
ArExploData(x, 4) = "?"
Else
If Ar_DBStarTypes(Ar_DBStars(z, 8), 3) = 0 Then
ArExploData(x, 4) = "NO" ' Scoop
Else
ArExploData(x, 4) = "YES" ' Scoop
End If
End If
ArExploData(x, 5) = WorksheetFunction.CountIf(Worksheets("DB_Stations").Range("Q2:Q" & AzRegStations + 1), Ar_DBStars(z, 1)) + WorksheetFunction.CountIf(Worksheets("DB_Stations_UR").Range("Q2:Q" & AzURegStations + 1), Ar_DBStars(z, 1)) ' #Stations
ArExploData(x, 6) = Ar_DBStars(z, 6) ' ExploreStatus
ArExploData(x, 7) = ArDistance(z) ' Distance
ArExploData(x, 8) = Ar_DBStars(z, 7) ' Notes
End If
Next z
Worksheets("ExploreData").Range("A2:H" & x + 1) = ArExploData
Worksheets("ExploreData").Activate
ActiveWorkbook.Worksheets("ExploreData").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("ExploreData").Sort.SortFields.Add Key:=Range( _
"G2:G100001"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("ExploreData").Sort
.SetRange Range("A1:H100001")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
AzCarto = Worksheets("Data").Cells(14, 5).Value
Ar_Carto = Worksheets("ExploreData").Range("A2:H" & AzCarto + 1)
End If

End Sub

If you revert to 7.3, did you see all stations?
I get these 2 errors on startup :
Error line 560.jpgError line 589.jpg
But Yes all destinations are there :)

Are you using the PP beta?

Not sure what PP beta is ?
I am still on Excel 2013 x64 if that is the question.
Not had time to uninstall office yet and since you seem to be getting it to work I'll wait a bit more on that unless you would like me to do it.
 
Last edited:
Status
Thread Closed: Not open for further replies.
Back
Top Bottom