Abandoned [RELEASE] Trade Computer Extension

ProfChaos · May 24, 2015

Unfortunately I still have the same error as before with 7.2

- - - Updated - - -

However it now saves before crashing which is definitely an improvement.

(sorry about the double post, can't edit yet.)

NRCrosby · May 24, 2015

Same here Eventure, one of the things in my settings don't know if its true for others but the station database panel is to large so shipyard doesn't display but is to far down off the bottom of the screen. I use to shrink it to 95% regular size and that did the trick but I noticed you commented on resizing it so I put it back to 100% and then just moved the panel up to 45 I think that made shipyards visible

screenshot below
https://www.dropbox.com/s/f5o98kb4jqvinas/Screenshot 2015-05-24 00.57.51.png?dl=0

PS I just arrived at VELA DOCK and couldn't get TCI to recognise its location kind of the same problem as before show me in medb space location 42 commodities tab say NO STATION. So I eventually went in a deleted the unregistered station and just tried adding a new station and thats when my troubles began with this error before I was getting a differnent error one of the ones mentioned earlier about notes saving or something.

punkerich · May 24, 2015

ProfChaos said:
Ok I am using Excel 2013 and I got this error after successfully registering one station and then trying to add a new one. It seems to crash every second time I try to add or register a station. This is the new error message.http://i.imgur.com/Nlb3yEv.jpg

with beta 7, i got the same error. beta 6 worked for me, though.
perhaps this is of any help circling in this one.

eventure · May 24, 2015

Update (V1.40 Beta 7.3 Test-Version) released:

Update 1.40 Beta 7.3 Test-Version: https://www.dropbox.com/s/yqixev9bw9ugbv4/TCE_V1.40beta7.3test_update.zip?dl=0 (Full-Version V1.40 Beta 1 required)

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.

Coterie · May 24, 2015

Eventure,

I suffered from the Line 220 error when creating a new station in an existing system but the upgrade to 7.3 solved the problem before I could even raise it.

Great work!

CMDR Coterie

CMDR Corleone · May 24, 2015

For all your hard work and dedication hitting the reputation button seems like way too little recognition. Thank you for this, I'm in your debt.

NeutronCorean · May 24, 2015

Good day,
first of all thanks for your hard work.

I switched to the beta 7.3 cause i was suffering from the range bug.

I do however now have a another bug creeping in.

Even though ELITEOCR recognises the right value for a specific comodity in a station. The Trade window uses a wrong value.

Consumer Technology is shown with 907 C, scanne with 7.456 c (and saved of course). I also had resetted all prices and started a new OCR Scan just to end with the same wrong value in the DB.

Regards,
NeutronCorean

NeutronCorean · May 24, 2015

Ok
in the next station the bug is also appearing. Apparently Consumer Technology isnt saved as scanned and recognised by the OCR.

The trade Advisor Window however shows the wrong price but the correct Profit.

Regards,
NeutronCorean

eventure · May 24, 2015

NeutronCorean said:
Good day,
first of all thanks for your hard work.

I switched to the beta 7.3 cause i was suffering from the range bug.

I do however now have a another bug creeping in.

Even though ELITEOCR recognises the right value for a specific comodity in a station. The Trade window uses a wrong value.

Consumer Technology is shown with 907 C, scanne with 7.456 c (and saved of course). I also had resetted all prices and started a new OCR Scan just to end with the same wrong value in the DB.

Regards,
NeutronCorean

So, you saying, that the value displayed at the Commodity panel differs from the value of the Trade panel?
If so, please try to set the value manually and save it. Differs the Trade panel again? If you open the Commodity panel again, what value is displayed for the commodity? The right or the wrong?
It is only one station or more? It is only one commodity or more?
Could be a problem with your database. Perhaps, can you upload it, so i have a look?

NeutronCorean · May 24, 2015

Eventure said:
So, you saying, that the value displayed at the Commodity panel differs from the value of the Trade panel?
If so, please try to set the value manually and save it. Differs the Trade panel again? If you open the Commodity panel again, what value is displayed for the commodity? The right or the wrong?
It is only one station or more? It is only one commodity or more?
Could be a problem with your database. Perhaps, can you upload it, so i have a look?

@Commodity Panel and Trade Panel differ, even in the Trade Panel theres a dfference for the same commodity. WHile one list the wrong price and the wrong profit based on the Gal. Avg. The second one down left side lists the wron price but correct profit.

I set the value manually and saved it. The trade panel differed still.
The Commodity pabel shpws the right price. So far only one commodity but multiple Stations.

Sure, what do you need exactly ? And where can i put it for you to get ?

Regards,
NeutronCorean

NeutronCorean · May 24, 2015

Yes they do differ.
I set the price manually, didnt get updated. So far 2 Stations and 1 Commodity have been affected.

What exactly do you need and where can i put it ?

Regards,
NeutronCorean

eventure · May 24, 2015

NeutronCorean said:
Yes they do differ.
I set the price manually, didnt get updated. So far 2 Stations and 1 Commodity have been affected.

What exactly do you need and where can i put it ?

Regards,
NeutronCorean

Your TCE.mdb file. Make a dropbox account and load it up, post your link to it via PM, if you like.

@Fixed, was a database problem.

punkerich · May 25, 2015

with 7.3 i got a runtime 9, directly when clicking search route in the trade scout.

eventure · May 25, 2015

punkerich said:
with 7.3 i got a runtime 9, directly when clicking search route in the trade scout.

Any debug info?

john211murphy · May 25, 2015

I get
Runtime Error '381'
Could not get the column property
Invalid property array value.

This occurs when I Create a New Commander. (after SAVE)
the error window is hidden behind the Database window.

I am using Excel 2013.

Regards

eventure · May 25, 2015

john211murphy said:
I get
Runtime Error '381'
Could not get the column property
Invalid property array value.

This occurs when I Create a New Commander. (after SAVE)
the error window is hidden behind the Database window.

I am using Excel 2013.

Regards

Thanks for finding, of course you have to select a space craft to save. Will be fixed in next release.

punkerich · May 25, 2015

at dest. panel, searching for star: 'wolf':

View attachment 38439

rngFilterRange.AutoFilter Field:=3, Criteria1:=ftr, Operator:=xlAnd ' system
Else
rngFilterRange.AutoFilter Field:=2, Criteria1:=ftr, Operator:=xlAnd ' station
End If
ftr = "<=" & Val(Panel_DES_Select.TB_Distance.Value)
rngFilterRange.AutoFilter Field:=11, Criteria1:=ftr, Operator:=xlAnd ' Distance
Else
If Panel_DES_Select.TB_Filtertext.Value <> "" Then
ftr = "*" & CStr(Panel_DES_Select.TB_Filtertext.Text) & "*"
If Panel_DES_Select.OB_Stars.Value Then
rngFilterRange.AutoFilter Field:=3, Criteria1:=ftr, Operator:=xlAnd ' system
Else
rngFilterRange.AutoFilter Field:=2, Criteria1:=ftr, Operator:=xlAnd ' station
End If
End If
If Panel_DES_Select.TB_Distance.Value <> "" Then
ftr = "<=" & Val(Panel_DES_Select.TB_Distance.Value)
rngFilterRange.AutoFilter Field:=11, Criteria1:=ftr, Operator:=xlAnd ' Distance
End If
End If
Set rngFilterRange = Nothing
wsZiel.Activate
wsZiel.Range("A2:W20001").ClearContents
wsQuelle.Range("A2:W20001").SpecialCells(xlCellTypeVisible).Copy wsZiel.Range("A2:W20001")
Worksheets("DES_SystemData").Range("A1:W20001").AutoFilter

End Sub

eventure · May 25, 2015

punkerich said:
at dest. panel, searching for star: 'wolf':

View attachment 38439

Thanks for trying. Fixed the issue for the next release.

punkerich said:
with 7.3 i got a runtime 9, directly when clicking search route in the trade scout.

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

Tigerclaw · May 25, 2015

Hi, i took a little break and just wanted to update my TCE from 1.37f to 1.40 B7.
Unfortunately i cannot import my old database. 1.39 worked fine with copying the mdb into the Db folder but with 1.40 B1 he gets an error.
The first Errormessage is hidden behind the little loading screen. I just can touch the X to continue. Second error is:
Error in Starting Sequence
Errorline 550
Error (9) Index außerhalb des gültigen Bereichs.

Any neccessary steps in a previous version i have to do? Didn´t found any hint in the release notes, just to copy the mdb as usual...

Thanks for help ;-)

TC

eventure · May 25, 2015

Tigerclaw said:
Hi, i took a little break and just wanted to update my TCE from 1.37f to 1.40 B7.
Unfortunately i cannot import my old database. 1.39 worked fine with copying the mdb into the Db folder but with 1.40 B1 he gets an error.
The first Errormessage is hidden behind the little loading screen. I just can touch the X to continue. Second error is:
Error in Starting Sequence
Errorline 550
Error (9) Index außerhalb des gültigen Bereichs.

Any neccessary steps in a previous version i have to do? Didn´t found any hint in the release notes, just to copy the mdb as usual...

Thanks for help ;-)

TC

Please upload it, i will see, what i can do?