Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.

omega9380

omega9380
After loading TCE 1.38 beta 1, with the Clear database, I added Mckee Station in GD 219. I jumped to Wolf 1509, and clicked Database to add the system data, I recieved an error (i should have grabbed that error, I didnt think to.) Now, whenever I try to load TCE, I am getting a "13 Type Mismatch" error.

Debug code:

Code: 
Sub DES_Profit_Reg() 'Profit

    Dim Station_ID_S As Long, Station_ID_Z As Long, ArProfit As Variant
    Dim a As Long, b As Long
    
    Station_ID_S = ActualStationID
    For a = 1 To AzRegStations
        DoEvents
        ReDim ArProfit(AzGoods)
        Station_ID_Z = DES_SysData(a, 1)
        For b = 3 To AzGoods + 2
            DoEvents
[U][B]            If ArData_Buy(b, Station_ID_S + 2) <> 0 And ArData_Buy(b, Station_ID_S + 2) <> "" And ArData_Sell(b, Station_ID_Z + 2) <> 0 And ArData_Sell(b, Station_ID_Z + 2) <> "" And ArData_Sell(b, Station_ID_Z + 2) - ArData_Buy(b, Station_ID_S + 2) > 0 Then[/B][/U]
                ArProfit(b - 2) = ArData_Sell(b, Station_ID_Z + 2) - ArData_Buy(b, Station_ID_S + 2)
            End If
        Next b
        DES_SysData(a, 19) = WorksheetFunction.Max(ArProfit)
        Erase ArProfit
    Next a


End Sub

The bold line of code is what is highlited in the debugger. I am running Excel 2013, I added the TCE cert to my cert store and added my TCE directory to my trusted paths. I'm gonna try replacing TCE.xlsm to see if maybe I accidentally saved it during the last error. Thanks!!

UPDATE: After removing and reinstalling TCE 1.38 beta 1 from scratch as well as using the Clear database again, I just spent 2 hrs exploring systems and entering data. Logged out to do my homework. Went to log in, I cannot run TCE because I am again getting the 13 Type Mismatch error indicated above.
 
Last edited:

omega9380

omega9380
Oh, forgot to mention. PRESTART.BAT needs to be run as admin, and in the installer it is not. Not sure if its just a Windows 8.1 thing or if it happens in 7. I know they upped the security in Win8.1. When I first installed TCE the certs werent automatically added because PRESTART.BAT wasn't run as admin. I was able to fix it by running PRESTART.BAT from an elevated command prompt.
 

Maedhros

Maedhros
Hmmm....

Been playing ED with TCE for past few days now with no problems at all. Upgraded to v1.38b1 last night and carried on without any issues.

However this morning TCE won't load and I get a type 13 mis-match error on the following line of code: -

Sub DES_Profit_Reg() 'Profit

Dim Station_ID_S As Long, Station_ID_Z As Long, ArProfit As Variant
Dim a As Long, b As Long

Station_ID_S = ActualStationID
For a = 1 To AzRegStations
DoEvents
ReDim ArProfit(AzGoods)
Station_ID_Z = DES_SysData(a, 1)
For b = 3 To AzGoods + 2
DoEvents
If ArData_Buy(b, Station_ID_S + 2) <> 0 And ArData_Buy(b, Station_ID_S + 2) <> "" And ArData_Sell(b, Station_ID_Z + 2) <> 0 And ArData_Sell(b, Station_ID_Z + 2) <> "" And ArData_Sell(b, Station_ID_Z + 2) - ArData_Buy(b, Station_ID_S + 2) > 0 Then
ArProfit(b - 2) = ArData_Sell(b, Station_ID_Z + 2) - ArData_Buy(b, Station_ID_S + 2)
End If
Next b
DES_SysData(a, 19) = WorksheetFunction.Max(ArProfit)
Erase ArProfit
Next a

End Sub

I can't see what has changed in the intervening period that would suddenly cause an error.

When upgrading to v1.38b1 I simply copied the TCE.xlsm file rather than doing a full install - was there something else that changed in this version? But if so why do it work fine initially. :(
 

Bragolatch

Bragolatch
CMDR MrChips said:
Apologies if this has already been answered, this thread is getting pretty long and I can't seem to search a specific thread, possibly because I'm new to the forum.
Click to expand...

I missed it at the beginning too,
There are 2 different seach tools :

search.jpg
 

eventure

eventure
omega9380 said:
After loading TCE 1.38 beta 1, with the Clear database, I added Mckee Station in GD 219. I jumped to Wolf 1509, and clicked Database to add the system data, I recieved an error (i should have grabbed that error, I didnt think to.) Now, whenever I try to load TCE, I am getting a "13 Type Mismatch" error.

The bold line of code is what is highlited in the debugger. I am running Excel 2013, I added the TCE cert to my cert store and added my TCE directory to my trusted paths. I'm gonna try replacing TCE.xlsm to see if maybe I accidentally saved it during the last error. Thanks!!

UPDATE: After removing and reinstalling TCE 1.38 beta 1 from scratch as well as using the Clear database again, I just spent 2 hrs exploring systems and entering data. Logged out to do my homework. Went to log in, I cannot run TCE because I am again getting the 13 Type Mismatch error indicated above.
Click to expand...

Maedhros said:
Hmmm....

Been playing ED with TCE for past few days now with no problems at all. Upgraded to v1.38b1 last night and carried on without any issues.

However this morning TCE won't load and I get a type 13 mis-match error on the following line of code: -

Sub DES_Profit_Reg() 'Profit

Dim Station_ID_S As Long, Station_ID_Z As Long, ArProfit As Variant
Dim a As Long, b As Long

Station_ID_S = ActualStationID
For a = 1 To AzRegStations
DoEvents
ReDim ArProfit(AzGoods)
Station_ID_Z = DES_SysData(a, 1)
For b = 3 To AzGoods + 2
DoEvents
If ArData_Buy(b, Station_ID_S + 2) <> 0 And ArData_Buy(b, Station_ID_S + 2) <> "" And ArData_Sell(b, Station_ID_Z + 2) <> 0 And ArData_Sell(b, Station_ID_Z + 2) <> "" And ArData_Sell(b, Station_ID_Z + 2) - ArData_Buy(b, Station_ID_S + 2) > 0 Then
ArProfit(b - 2) = ArData_Sell(b, Station_ID_Z + 2) - ArData_Buy(b, Station_ID_S + 2)
End If
Next b
DES_SysData(a, 19) = WorksheetFunction.Max(ArProfit)
Erase ArProfit
Next a

End Sub

I can't see what has changed in the intervening period that would suddenly cause an error.

When upgrading to v1.38b1 I simply copied the TCE.xlsm file rather than doing a full install - was there something else that changed in this version? But if so why do it work fine initially. :(
Click to expand...

Thanks for reporting. Could you tell me, how many stations you have entered, before the error appears, or perhaps, you could send me your database, to check, where the problem is.
 

atomic7431

A
Hello

help my frustration please lol

I am trying to get this working on a mates pc but no matter which version i install it just stops at the splash screen after selecting the relevant file paths.
I am using office 2013 as i do on my machine, i have installed the relevant access runtime pack.
I have made sure the verbos logging is in the appconfig file.

There seems to be an error window in the background when i alt tab but i can not bring this to the for ground to see what the issue is.

I have tried the newest beta 1.38 and 1.37 all the way up to 1.37g.

Frustrating as i have a version on my pc that works fine but an older version i believe, cant look at present as mate machine is using my leads etc to get this working.

Thanks in advance.

ps. i have tried this with elite dangerous running borderless and without it running at all, also the logs folder in the tce directory contain nothing and i also have to re put the file paths in every time i start up trade computer.
 
Last edited:

eventure

eventure
atomic7431 said:
Hello

help my frustration please lol

I am trying to get this working on a mates pc but no matter which version i install it just stops at the splash screen after selecting the relevant file paths.
I am using office 2013 as i do on my machine, i have installed the relevant access runtime pack.
I have made sure the verbos logging is in the appconfig file.

There seems to be an error window in the background when i alt tab but i can not bring this to the for ground to see what the issue is.

I have tried the newest beta 1.38 and 1.37 all the way up to 1.37g.

Frustrating as i have a version on my pc that works fine but an older version i believe, cant look at present as mate machine is using my leads etc to get this working.

Thanks in advance.

ps. i have tried this with elite dangerous running borderless and without it running at all, also the logs folder in the tce directory contain nothing and i also have to re put the file paths in every time i start up trade computer.
Click to expand...

Please check, if the UAC on that machine is deactivated, or run TCE as admin. If you think, there is an error message behind the splash screen, press enter to debug and at the debugger the filled square to stop TCE. But don't forget, if you close the debugger, to kill Excel with the taskmanager.
 
Last edited:

atomic7431

A
Eventure said:
Please check, if the UAC on that machine is deactivated, or run TCE as admin. If you think, there is an error message behind the splash screen, press enter to debug and at the debugger the filled square to stop TCE.
Click to expand...

thanks just tried it with it on and off and still the same it seems to error straight away
 

Cmdr Bupu

Cmdr Bupu
Eventure said:
Thanks for reporting. Could you tell me, how many stations you have entered, before the error appears, or perhaps, you could send me your database, to check, where the problem is.
Click to expand...

same problems here with latest version.
I installed to a new folder
then imported old database over
and have visited about 3 stations and then flew 30 Ly noticed that tce was not keeping track of current station (I was not touching tce just had it running)
quit out then had same problem as above on exactly same line of code.

- - - - - Additional Content Posted / Auto Merge - - - - -

don't suppose you could add feature to look for "NVIDIA GeForce GTX Titan Black Prototypes" could you. :)
 

atomic7431

A
1.38 also gives me this error a lot but i have the relevant program installed -



ok 1.37b debug

netlog file: found
position data: not found
please check: appconfig.xml

checked and rechecked file paths are correct?



also getting the above now with 1.37g
1.37g debug gives no information at all.
 
Last edited:

Maedhros

Maedhros
Eventure said:
Thanks for reporting. Could you tell me, how many stations you have entered, before the error appears, or perhaps, you could send me your database, to check, where the problem is.
Click to expand...

Thanks for getting back to me Eventure. I've had a close look into the Db and there appears to be a problem in the Station prices. A lot of these are either blank or show commodity id of #82 when at the moment there aren't 82! I believe this must be from when I imported my old Db using TCE. I haven't been back to that part of the galaxy recently so hadn't noticed that no prices were being displayed.

Anyway I have uploaded my Db to Dropbox for you to look at the link is https://www.dropbox.com/s/ds9lstzv75kdjgf/TCE.mdb?dl=0
 

atomic7431

A
just checked my machine and i was still on 1.35 which worked fine, trie 1.37 and it started up but the options were all locked.

1.38 gives me the error sometime 9 sometime 1004 on startup



clean install of 1.37 seems to be working on my machine.
 
Last edited:

eventure

eventure
atomic7431 said:
just checked my machine and i was still on 1.35 which worked fine, trie 1.37 and it started up but the options were all locked.

1.38 gives me the error sometime 9 sometime 1004 on startup

clean install of 1.37 seems to be working on my machine.
Click to expand...

Found the problem, fix will be released soon.

Maedhros said:
Thanks for getting back to me Eventure. I've had a close look into the Db and there appears to be a problem in the Station prices. A lot of these are either blank or show commodity id of #82 when at the moment there aren't 82! I believe this must be from when I imported my old Db using TCE. I haven't been back to that part of the galaxy recently so hadn't noticed that no prices were being displayed.
Click to expand...

Your database is broken, so please use a backup, that is not in that condition. I have to adjust the import function, so it will be disabled for the moment. Use your old one, it should work without import.
 
Last edited:

atomic7431

A
Thanks for the update, 1.37b is now working on mine with the clean install it seems, but i cAant for the life of me get it working on the mates pc. debug is saying check appconfig but it seems fine ?

<AppConfig>
<Display>
<ScreenWidth>1280</ScreenWidth>
<ScreenHeight>720</ScreenHeight>
<FullScreen>false</FullScreen>
<VSync>true</VSync>
<PresentInterval>1</PresentInterval>
<Adapter>0</Adapter>
<Monitor>0</Monitor>
<DX11_RefreshRateNumerator>60</DX11_RefreshRateNumerator>
<DX11_RefreshRateDenominator>1</DX11_RefreshRateDenominator>
<LimitFrameRate>false</LimitFrameRate>
<MaxFramesPerSecond>30</MaxFramesPerSecond>
<!-- If you are looking for the SSAA setting this has moved in to Settings.xml in the save directory
** typically: C:\Users\{username}\AppData\Roaming\Frontier Developments\Elite Dangerous\Options\Graphics.
** If this file does not exist you can generate it by entering the graphics options screen in game
** and hitting apply. You can then add <SSAA>X</SSAA> when X is the SSAA amount (1 by default) -->
</Display>

<Threads
RenderThreadStackSize="1048576"
WorkerThreadStackSize="1048576"
NumWorkerThreads="6"
RenderJobQueueSize="10240"
KernelJobQueueSize="10240"
MinSpareCores="0"
OptimiseForPerformance="1"
UseThreadPriorities="0"
PerformanceScaling="1"
/>

<Files
MaxLoadRetries="10"
/>

<Network
verboselogging="1"
Port="0"
upnpenabled="1"
LogFile="netLog"
DatestampLog="1"
>
</Network>
<GameObjects />
</AppConfig>
Click to expand...
 

eventure

eventure
atomic7431 said:
Thanks for the update, 1.37b is now working on mine with the clean install it seems, but i cAant for the life of me get it working on the mates pc. debug is saying check appconfig but it seems fine ?
Click to expand...

When TCE reports, to check the AppConfig.xml, it doesn't find any information at the netlog file about your position. Please restart Elite to create a new file, load till you are in the game, then start TCE.
 

atomic7431

A
Eventure said:
When TCE reports, to check the AppConfig.xml, it doesn't find any information at the netlog file about your position. Please restart Elite to create a new file, load till you are in the game, then start TCE.
Click to expand...

i am doing that but its just not wanting to play ball lol

ok restarted elite loaded into his current station.
checked folder ond netlog is there.
checked file paths again when trade computer started up all good
same problem freeze and an error i cant get too.
Hit enter says check appconfig.

mate has been on elite since premium beta.

ok now its stopping when loading, hit enter too debug and im getting no error at all and my location appears
 
Last edited:

eventure

eventure
Update (V1.38 beta 2) released:
- Bugfix in profit/distance calculation, when no station is present
- Startup issues fixed.
- Temporary deactivated import button.
 

atomic7431

A
Eventure said:
Update (V1.38 beta 2) released:
- Bugfix in profit/distance calculation, when no station is present
- Startup issues fixed.
- Temporary deactivated import button.
Click to expand...

tested and it does the same, freezes at the splash screen but press enter it loads without error and shows the current location
 

punkerich

punkerich
Eventure said:
Full-Version V1.38 beta 1 released:

Changelog:
- Commodity panel now clears all prices before scanning, when reaching a trade station to prevent issues with previous commodities, that are currently not available and added the activation of the Main panel before screenshot is taken.
Click to expand...

Quick question about this: does it mean one always has to scan the whole market? if not on the first visit, i just scanned the (for me) relevant page(s), when prices differed by a large amount. Would it be too much to ask for this to be optional? :)
 

eventure

eventure
punkerich said:
Quick question about this: does it mean one always has to scan the whole market? if not on the first visit, i just scanned the (for me) relevant page(s), when prices differed by a large amount. Would it be too much to ask for this to be optional? :)
Click to expand...

TCE cant recognize the goods, that were sold at the last visit, but not listed anymore. These values have to be cleaned by manual input or through a full sweep of all goods, to reset them to zero.
I took the second choice, so it is only done, when arriving at a station and before the scan process starts. Any further scan at the same station updates the prices.
Optional choice could only be realized to be practical by adding an additional scan button (perhaps RESET AND SCAN and UPDATE ONLY SCAN). Is that, what you intended?

atomic7431 said:
tested and it does the same, freezes at the splash screen but press enter it loads without error and shows the current location
Click to expand...

Okay, will add an error message routine in the next update, to find the problem. In addtion, could you tell me, how many green dots you see at the splash screen, when to hit enter key?
 
Last edited:
Status
Thread Closed: Not open for further replies.
Back
Top Bottom