Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.

eventure

eventure
Uploaded correction of TCE V1.05. Forgot to change version number and reverted back the add for larger resolutions. will try to fix it later.
 

eventure

eventure
Demonmaker said:
excel 2013
Error on startup
View attachment 10228View attachment 10229
TCE installed in this location
View attachment 10230
two locations on the PC for ED.

C:\Program Files (x86)\Frontier\EDLaunch (Does NOT contain products folder)
and
C:\Users\Lee\AppData\Local\Frontier_Developments (DOES contain Products folder)

I get NO prompting from v 1.5 on any of the games install locations and have tried placing the TCE folder into BOTH filepaths, with the same resulting error.
Click to expand...

Marco errors was a problem of using different version of Excel. I will check it, when i have time.
Now you can install TCE wherever you want. At start you got a window for selecting the NetLog folder. Its in the Products folder of ED.
 

Lee Storm

Lee Storm
Eventure said:
Now you can install TCE wherever you want. At start you got a window for selecting the NetLog folder. Its in the Products folder of ED.
Click to expand...

I dont get any prompts due to the error. I'll have to wait and see if you can resolve the issue.
Thanks though, looks great.
 

eventure

eventure
Demonmaker said:
I dont get any prompts due to the error. I'll have to wait and see if you can resolve the issue.
Thanks though, looks great.
Click to expand...

I think i found a solution, need time to implanting and testing it. Excel 2013 changed the API calls for userforms staying on top.
 

Antmax

Antmax
Look forward to getting this running in win8.1 and Excel 2013. I've been using other tools honestly only using data I added myself. Even if it means a non productive trip. So this will be excellent. Especially whn you can leave notes, looks like no need to alt-tab switch.
 

Lexic Dart

L
TCE runtime error 13

Hi,
We are using Office 2010 SP2, Windows 8.1 x64 & TCE_v1.05. We are getting Microsoft Visual basic run-time error '13': Type mismatch when trying to use the Stellar Cartography option.
Also it is not picking up are current location and I have not yet worked out how to tell it where I am.
The log file location is also empty too.
Let me know if you need any further information
Regards
Lexic Dart
 

eventure

eventure
Lexic Dart said:
Hi,
We are using Office 2010 SP2, Windows 8.1 x64 & TCE_v1.05. We are getting Microsoft Visual basic run-time error '13': Type mismatch when trying to use the Stellar Cartography option.
Also it is not picking up are current location and I have not yet worked out how to tell it where I am.
The log file location is also empty too.
Let me know if you need any further information
Regards
Lexic Dart
Click to expand...

Error comes, because position not found. Find the netlog file folder in the products directory of ED. if you selected it correctly, then no error appears.
I will lock Cartography panel, when NetLog Path not entered in the next version.
 
Last edited:

Magellon

M
I wish Frontier would just contact you and have you fit them up with something that could be tagged into the right hand screen where all your other data is. It is a real surprise to me that they didn't think to include an automatically updating logbook of your travels with every star jump, station exit/entry time and financial transaction, every time some engaged you, when you engaged them and the time and bounty when something blew up. After a session you could go back and decipher how it all played out, and then show your friends you bagged an Anaconda in your Adder. <I just dreamed up tha last part, LOL> Seriously, I don't think it would be hard for FD to make a logbook. Within the logbook, it should automatically update the prices of all commodities sold at a station when you visit Commodities Market. An index at the fore of the book would allow you to jump to any station to look up a price. Well I hope this becomes a project for them to deliver to us.
 

Jack Shaftoe

Jack Shaftoe
Eventure said:
Error comes, because position not found. Find the netlog file folder in the products directory of ED. if you selected it correctly, then no error appears.
I will lock Cartography panel, when NetLog Path not entered in the next version.
Click to expand...

Having the same problem myself. Looking under my Elite Dangerous folder, in the 'Products' folder there is only a 'FORC-FDEV-D-1002' folder. Inside that folder is a folder called 'logs'. When I direct your TCE to that folder, it still has me in the wrong system, and clicking on things brings up the same "runtime error 13". Am I directing it to the proper folder?
 

ReaperAlex

ReaperAlex
Great work :) just wanted to talk a bit about where you can take this in the future (right now getting it working on all the other users PC's is more than enough of a headache :) )

EliteOCR can save the commodity info as a flat text file, eg:

Code: 
System;Station;Commodity;Sell;Buy;Demand;;Supply;;Date;
Summerland;Henry O'Hare's Hanger;Hydrogen Fuel;90;94;;;182399;High;2014-12-30T03:06:18+00:00;
Summerland;Henry O'Hare's Hanger;Clothing;393;;34787;Med;;;2014-12-30T03:06:18+00:00;

so you'd not need to get your head round what the python code is doing, just pick one of the export formats it supports and write and import routine.

the BPC format might be the best to use as it's designed to work with Slopey's Best Profit Calculator, and what that says to me is the format has more chance of staying stable as it's for a 3rd party ;)

in fact it would be interesting to see what you and slopey could do if you got your heads together. slopeys crowd sourced data combined with your game overlay and rich set of tools would be a real winner!

seeing as how excel is quite limiting what with the cost and all, and open office even more limiting with the VBA it supports, have you thought of porting your code to either .Net, or if it's easier VB6? i've done well over 10 years worth of VB6 and VBA coding, and i've really enjoyed the brief amount of time i've been able to spend in .net (ok, one project involved working with a laser, so that made me biased ;) ). i'm impressed with the way you've been able to create the UI, i had no idea excel was capable of overlays like that! guess it just goes to show, if you never get a requirement to do something then you might never know a certain feature even exists.
 

th03bgt

th03bgt
I've tried to do a little debugging... blindly as I have no idea what i am doing...

Running the prestart.bat file in a cmd window with admin, i get

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Windows\system32>cd "c:\program files (x86)\frontir\tce"
The system cannot find the path specified.

C:\Windows\system32>cd "c:\program files (x86)\frontier\tce"

c:\Program Files (x86)\Frontier\TCE>prestart.bat

c:\Program Files (x86)\Frontier\TCE>verify 1>nul

c:\Program Files (x86)\Frontier\TCE>certutil.exe -store trustedpublisher | fin
dstr "Trade Computer Extension"

c:\Program Files (x86)\Frontier\TCE>IF '1' == '0' goto importCertLocal

c:\Program Files (x86)\Frontier\TCE>verify 1>nul

c:\Program Files (x86)\Frontier\TCE>certutil.exe -addstore -f "TrustedPublisher"
"TCE\TCE.cer"
TrustedPublisher
DecodeFile returned The system cannot find the path specified. 0x80070003 (WIN32
: 3)
CertUtil: -addstore command FAILED: 0x80070003 (WIN32: 3)
CertUtil: The system cannot find the path specified.

c:\Program Files (x86)\Frontier\TCE>goto importCertLocal

c:\Program Files (x86)\Frontier\TCE>verify 1>nul

c:\Program Files (x86)\Frontier\TCE>certutil.exe -store CA | findstr "Trade Co
mputer Extension"

c:\Program Files (x86)\Frontier\TCE>IF '1' == '0' goto importCertRoot

c:\Program Files (x86)\Frontier\TCE>verify 1>nul

c:\Program Files (x86)\Frontier\TCE>certutil.exe -addstore -f "CA" "TCE\TCE.cer"

CA
DecodeFile returned The system cannot find the path specified. 0x80070003 (WIN32
: 3)
CertUtil: -addstore command FAILED: 0x80070003 (WIN32: 3)
CertUtil: The system cannot find the path specified.

c:\Program Files (x86)\Frontier\TCE>goto importCertRoot

c:\Program Files (x86)\Frontier\TCE>verify 1>nul

c:\Program Files (x86)\Frontier\TCE>certutil.exe -store root | findstr "Trade
Computer Extension"

c:\Program Files (x86)\Frontier\TCE>IF '1' == '0' goto installFont

c:\Program Files (x86)\Frontier\TCE>verify 1>nul

c:\Program Files (x86)\Frontier\TCE>certutil.exe -addstore -f root "TCE\TCE.cer"

root
DecodeFile returned The system cannot find the path specified. 0x80070003 (WIN32
: 3)
CertUtil: -addstore command FAILED: 0x80070003 (WIN32: 3)
CertUtil: The system cannot find the path specified.

c:\Program Files (x86)\Frontier\TCE>goto installFont

c:\Program Files (x86)\Frontier\TCE>cscript "TCE\install_font.vbs"
Microsoft (R) Windows Script Host Version 5.8
Copyright (C) Microsoft Corporation. All rights reserved.

Input Error: Can not find script file "c:\Program Files (x86)\Frontier\TCE\TCE\i
nstall_font.vbs".

c:\Program Files (x86)\Frontier\TCE>




When I ran the install.exe within the zip file (using th 1.05), it came up with errors in the cmd window but keeps closing before I could read it, so I dragged the tec folder to the frontier directory as I read it can now be installed anywhere.

Still getting vba complie errors in excel 2013.
 

blacky75

blacky75
New issue: I had to reinstall ELITE DANGEROUS.... so I d/l it again and installed it. I wanted to reinstall your tool again, now the install exe just get into the processes and never starts... impossible to end the process, a reboo is requiered to get rid of. ->oups, no copy of the originalm folder.. so now I can't even install it anymore.

tia :D
 
Last edited:

eventure

eventure
To all Excel 2013 users: i can't support you, because i dont have Office 2013. So dont install it. It doesnt work. I will note this at the front page.

Error 13 folks: Please find first the netlog*.log file in the game folder of ED with a simple file search of windows. If you find it, point TCE to the folder it habors the file. If ýou cant find it, expand file search on your whole system.

Today i release a non-installer version of TCE. If someone of you is capable and willing of making TCE Excel 2013 compatible, please PM me. I will send you the password to look into the code.
 

th03bgt

th03bgt
Eventure said:
To all Excel 2013 users: i can't support you, because i dont have Office 2013. So dont install it. It doesnt work. I will note this at the front page.

Error 13 folks: Please find first the netlog*.log file in the game folder of ED with a simple file search of windows. If you find it, point TCE to the folder it habors the file. If ýou cant find it, expand file search on your whole system.

Today i release a non-installer version of TCE. If someone of you is capable and willing of making TCE Excel 2013 compatible, please PM me. I will send you the password to look into the code.
Click to expand...

Just a quick thanks for your efforts...

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

In the spirit of ED, if you started a fund drive for a copy of 2013, I'd be happy to give a donation.
 
Status
Thread Closed: Not open for further replies.
Back
Top Bottom