Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.

Bragolatch

Bragolatch
Eventure said:
Hello,

having really trouble to recreate your error. Okay, here i will show you my trying:

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.
3. Going to the galaxy map, checking the first reference SOL, paste the name into the the navigation search box, clicking then into the panel again, entering the distance, hitting enter to complete.
4. Clicking back to the search box, pasting WYRD into, clicking again into the panel, enterering the distance, hitting enter to complete.
5. Clicking back to the search box, pasting VEGA into, clicking again into the panel, enterering the distance, hitting enter to complete.
6. Clicking back to the search box, pasting LOGAD into, 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, panel is closing. Done.

Are you doing it the same way, or what differs? Thanks for helping me here.
Click to expand...

differences :

1. I do not copy an paste de 4 system names, I type them in.
2. I do not press enter to complete !

You did ask me if I pressed enter in a previous post and I answered no. lol
It just didn't register with me that you wanted me to press enter lol
Sorry !

Still, TCE should not be that easy to crash !

I just did it your way, pressing enter for the 4 ref. and I still got an error, but not exactly the same :
error.jpglogin.jpg13.jpg

Followed by error 9

Sub GetExploreData()


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
ReDim ArExTemp(1 To 100, 1 To 5), ArExploData(1 To 1000, 1 To 5)
ReDim ArTemp(1 To AzStars)
' Dim t As Double
' t = Timer
' MsgBox Timer - t & " sec", , "Makrolaufzeit"
x = 0
Worksheets("ExploreData").Range("A2:E1000001").ClearContents
Worksheets("Navigation_Sort").Range("S2:S" & AzStars + 1).ClearContents
Application.Calculation = xlCalculationManual
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)
ArExploData(x, 2) = Ar_DBStars(z, 2)
ArExploData(x, 3) = ArDistance(z)
ArExploData(x, 4) = Ar_DBStars(z, 6)
ArExploData(x, 5) = Ar_DBStars(z, 7)
End If
Next z
' With Application.WorksheetFunction
' Worksheets("Navigation_Sort").Range("S2:S" & AzStars + 1) = .Transpose(ArDistance)
' End With
Application.Calculation = xlCalculationAutomatic
' ArTemp = Worksheets("Navigation_Sort").Range("K2:K" & AzStars + 1)
Worksheets("ExploreData").Range("A2:E" & x + 1) = ArExploData

Worksheets("ExploreData").Activate
ActiveWorkbook.Worksheets("ExploreData").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("ExploreData").Sort.SortFields.Add Key:=Range( _
"C2:C100001"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("ExploreData").Sort
.SetRange Range("A1:E100001")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
AzCarto = 0
Do While Worksheets("ExploreData").Cells(2 + AzCarto, 1).Value <> 0
AzCarto = AzCarto + 1
Loop
ArExTemp = Worksheets("ExploreData").Range("A2:E" & z + 1)
Worksheets("Exploration").Range("A2:E1001").ClearContents
Worksheets("Exploration").Range("A2:E" & AzCarto + 1) = ArExTemp
Ar_Carto = Worksheets("Exploration").Range("A2:E" & AzCarto + 1)

End Sub
 
Last edited:

Bragolatch

Bragolatch
Just found another way to make TCE crash.
I would not call it a bug as such but it will probably happen to other people in the long run.
I only thought of trying it because when adding a new station we have to click the right arrow to check if it is in the unregistered list first.


So I went, for the first time, to a star system.

I did not get a pop-up window. So I assumed the system to be in the database already.

Just out of curiosity, I opened the STAR SYSTEM DATABASE.

Then again, out of curiosity, I clicked the right arrow beside ADD STAR SYSTEM RECORD

and received error 381

Could not get the Column property. Invalid property array index.

Can't execute code in break mode


Private Sub ComboBox1_Change()


Dim DataObj As New MSForms.DataObject
Dim s As String

If Saving = False And Panel_DB_Stars.Visible = True And PanelOpen = True Then
StarData(1) = Me.ComboBox1.Column(0)
StarData(2) = Me.ComboBox1.Column(1)
StarData(3) = Me.ComboBox1.Column(2)
StarData(4) = Me.ComboBox1.Column(3)
StarData(5) = Me.ComboBox1.Column(4)
StarData(6) = Me.ComboBox1.Column(5)
StarData(7) = Me.ComboBox1.Column(6)
Me.TextBox1.Value = Me.ComboBox1.Column(1)
Me.TextBox2.Value = ""
Worksheets("Werte").Cells(106, 6).Value = ""
Me.TextBox3.Value = ""
Worksheets("Werte").Cells(107, 6).Value = ""
Me.TextBox4.Value = ""
Worksheets("Werte").Cells(108, 6).Value = ""
Me.TextBox7.Value = ""
Worksheets("Werte").Cells(109, 6).Value = ""
Me.TextBox6.Value = Me.ComboBox1.Column(2)
Me.TextBox7.Value = Me.ComboBox1.Column(3)
Me.TextBox8.Value = Me.ComboBox1.Column(4)
If Me.ComboBox1.Column(5) = "" Then
Me.ComboBox6.ListIndex = 0
Else
Me.ComboBox6.ListIndex = Me.ComboBox1.Column(5)
End If
Me.TextBox9.Value = Me.ComboBox1.Column(6)
s = Me.ComboBox2.Column(1)
DataObj.SetText s
DataObj.PutInClipboard
End If
 

Spicy Weiner

Spicy Weiner
Version 1.36b ........ Started with 2 station db. Noticed that Stellar Cartography is not reporting Current location correctly. Crashes if I press arrow button in Star system Database
"Run-time error '381': Could not get the Column property. Invalid property array index.

Can't execute code in break mode

Private Sub ComboBox1_Change()


Dim DataObj As New MSForms.DataObject
Dim s As String

If Saving = False And Panel_DB_Stars.Visible = True And PanelOpen = True Then
StarData(1) = Me.ComboBox1.Column(0)


New trade scout looks great... can't wait:)

Win7 x64 , 2007 sp3


DOH!!! Ninja'd
 
Last edited:

eventure

eventure
Bragolatch said:
Just found another way to make TCE crash.
I would not call it a bug as such but it will probably happen to other people in the long run.
I only thought of trying it because when adding a new station we have to click the right arrow to check if it is in the unregistered list first.
Click to expand...

Found this problem, got fixed in next update, and i will change, that you didnt have to press enter for the distances boxes. Perhaps that will fix the other problem too.

Spicy Weiner said:
Version 1.36b ........ Started with 2 station db. Noticed that Stellar Cartography is not reporting Current location correctly.
Click to expand...

Will check this.
 
Last edited:

Yokai

Yokai
I have more info about the bug I last posted. You asked me if I had selected an unregistered station just before the crash occurred.

I just flew eabout 100 Ls to a new system, entered an unregistered station there, and then scanned commodities. When the trade window appeared, it selected some random unregistered station as the AUTO DESTINATION, because my SET TRADE DISTANCE value is 30 LY, and I have registered/scanned no other systems yet in my new vicinity. I fully expect to get the same crash when I try to register the _next_ unregistered station in this immediate area. I'll report back either way.

Edit: nope; didn't crash. Was able to register the next station just fine, and also to scan commodities and display the TRADE panel just fine.
 
Last edited:

Entilzar

Entilzar
HI again, I have been using the TCE for a few days now after your recent beta change and its been fine I had entered loads of stations and stars and uploaded a load of commodity markets, until today I loaded up the TCE and when entering the first station details the TCE froze, I then reloaded it and tried again, all seemed fine then I got the commodity market uploaded and it crashed again , giving the very same runtime error 9 I got when I first started using the TCE, which you told me then was a database error, I downloaded the new TCE version b today and tried that one and I still get every time I run the TCE a runtime 9 error, is there away to retrieve the database from yesterday and start from there , if this Database error means starting again every time its gonna be very hard to find the motivation to do it if I can lose everything that easily. the debug was identical tot he info I posted on page 65 of this thread post #974

Enty
 
Last edited:

eventure

eventure
Entilzar said:
HI again, I have been using the TCE for a few days now after your recent beta change and its been fine I had entered loads of stations and stars and uploaded a load of commodity markets, until today I loaded up the TCE and when entering the first station details the TCE froze, I then reloaded it and tried again, all seemed fine then I got the commodity market uploaded and it crashed again , giving the very same runtime error 9 I got when I first started using the TCE, which you told me then was a database error, I downloaded the new TCE version b today and tried that one and I still get every time I run the TCE a runtime 9 error, is there away to retrieve the database from yesterday and start from there , if this Database error means starting again every time its gonna be very hard to find the motivation to do it if I can lose everything that easily. the debug was identical tot he info I posted on page 65 of this thread post #974

Enty
Click to expand...

Each new day, the database is stored at the BACKUP folder. Your error, you have posted is after your "crash", as you said. But please tell me, is excel crashing before you have this error or TCE gives you a error message and after a restart you got it?
 

Entilzar

Entilzar
Eventure said:
Each new day, the database is stored at the BACKUP folder. Your error, you have posted is after your "crash", as you said. But please tell me, is excel crashing before you have this error or TCE gives you a error message and after a restart you got it?
Click to expand...

I get this error after the restart of the excel TCE file, the launcher ICON loads and then the runtime error pops before the 4th block loads on the ICON

I can exit or hit the debug button but the error message is identical to the debug error on post #974

I don't know how to use the backed up database instead tho im not massively familiar with the software.

Edit just for the sake of thouroughness here is the debug error bit

Sub POS_Systems()
Dim Station_ID As Long, ArDiscount As Variant, a As Long, b As Long, c As Long, lLZeile As Long, ArMinPrice(1 To 10000) As Long
Worksheets("Pre_Select").Range("J2:J1001").ClearContents
For a = 1 To AzRegStations
ReDim ArDiscount(AzGoods)
DoEvents
'SystemÍD schreiben
Station_ID = Ar_DBRegStations(a, 1)
For c = 3 To AzGoods + 2
DoEvents
[U]If ArData_Buy(c, Station_ID + 2) <> 0 And ArData_Buy(c, Station_ID + 1) <> "" Then this is highlighted yellow[/U]
ArDiscount(c - 2) = ArData_Buy(c, Station_ID + 2) - ArData_Goods(c - 2, 3)
End If
Next c
ArMinPrice(a) = WorksheetFunction.Min(ArDiscount)
Erase ArDiscount
Next a
With Application.WorksheetFunction
Worksheets("Pre_Select").Range("J2:J" & AzRegStations + 1) = .Transpose(ArMinPrice)
End With
Worksheets("Systems").Activate
Worksheets("Systems").Range("A2:K1001").ClearContents
Worksheets("Systems").Range("A2:K" & AzRegStations + 1).Value = Worksheets("Pre_Select").Range("A2:K" & AzRegStations + 1).Value
ActiveWorkbook.Worksheets("Systems").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Systems").Sort.SortFields.Add Key:=Range( _
"J2:J10001"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Systems").Sort
.SetRange Range("A1:K10001")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With


Enty
 
Last edited:

eventure

eventure
Entilzar said:
I get this error after the restart of the excel TCE file, the launcher ICON loads and then the runtime error pops before the 4th block loads on the ICON
Click to expand...

Thats clear to me, this is the result of the error or crash, you had, when scanning commodities. My interest is, what error or crash you recieved when scanning?
 
Last edited:

Entilzar

Entilzar
Eventure said:
Thats clear to me, this is the result of the error or crash, you had, when scanning commodities. My interest is, what error or crash you recieved when scanning?
Click to expand...

I got a windows pop up saying that the elite OCR programme crashed .

id still like to know how I use a back up database tho because id rather not have to start over gain,.


also on a slighty different note, is there a way to string the log files together so that it shows where I been previously as if I open the TCE on a different day it starts a new list, or even a way to load the old list first?


Enty
 
Last edited:

eventure

eventure
Entilzar said:
I got a windows pop up saying that the elite OCR programme crashed .

id still like to know how I use a back up database tho because id rather not have to start over gain,.


also on a slighty different note, is there a way to string the log files together so that it shows where I been previously as if I open the TCE on a different day it starts a new list, or even a way to load the old list first?


Enty
Click to expand...

Extract a file from the BACKUP folder into you DB folder.
 

Entilzar

Entilzar
Eventure said:
Extract a file from the BACKUP folder into you DB folder.
Click to expand...

UMMm not my day today I think,. non of the 2015.rar files are recognised as valid archives and when win rip opens them they appear empty. ill try and find WinRAR see if there data specific to the archive type.

Enty


Ok the files are specific to win rar and not useable in winzip, so im all up and running again.

Enty
 
Last edited:

CMDR Irshad Azeez

C
EliteOCRcmd.exe has stopped working

Hi Eventure. Need your help with this error.

Just installed TCE and EliteOCR. Tried to scan the market and I get an error message that says "EliteOCRcmd.exe has stopped working" and no market data is updated into the commodity window.
i
I saw that you gave another user this advice -

Eventure said:
Try the following:

Make a screenshot with F10.
Copy the screenshot into the EliteOCR\bin folder
Start your command prompt, navigate to EliteOCRcmd.exe (EliteOCR\bin)
Type: EliteOCRcmd.exe -i "Name of screenshot" -o result.csv and press enter
You got the error again? Check the error report.
Click to expand...

I did this and cmd prompt returns 'Image too small! Minimum market width required 1065px. given 1021px

Not sure what that means.
Can you help?
 

eventure

eventure
CMDR Irshad Azeez said:
Hi Eventure. Need your help with this error.

Just installed TCE and EliteOCR. Tried to scan the market and I get an error message that says "EliteOCRcmd.exe has stopped working" and no market data is updated into the commodity window.
i
I saw that you gave another user this advice -



I did this and cmd prompt returns 'Image too small! Minimum market width required 1065px. given 1021px

Not sure what that means.
Can you help?
Click to expand...

Reduce FOV at the Elite Display Options a little bit, till it fits. You need 44 more pixels.
 

ArakAtak

A
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).
.
gjLcYmz.jpg
 
Status
Thread Closed: Not open for further replies.
Back
Top Bottom