Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.
Size Zoom and left screen

Update (V1.35) released:
- Optimizations and fixes for all panels.
- New Panel Control for adjusting all panels in X, Y and zoom-level. It is found in the Control menu and added a new Panel.mdb, because it gets a new structure. You have to adjust all panel to the desired position again, sorry. The old Panel.mdb will be overwritten.
- Options panel moved to Control menu, a Ship Logbook button replaces the Options panel button.
- Added Clipboard text for destination stations.
- Bugfix for EliteOCR working directory.
- Locking Stations database and Cartography button, when the star system is not in the database.
- Commodity button lock, until you are at a recorded station.
- A Donate button, if someone want to support TCE.


WoW Thanks !
I've only played with windows sizing/positioning so far but it's great !

Now I just have to read your howto and figure out how to use all this info at my fingertips :)


Small thing thought,
You can't type the minus sign in the positioning window.
(for those with an extra monitor on the left of main)
It's easy to get around it by doing it in the Panel.mdb or by copy and pasting a negative value straight in the positioning panel.



Also, as a nice to have future update suggestion, how hard would it be to add small up and down arrows to increase and decrease the value in the boxes ?
Would be cool to just press a small button and see the panel move around the screen. Makes for fast and easy precision adjustment.
 
Sounds good! But as this project is still in development, I suggest to avoid conversion of existing databases and go straight into a new database structure. If there is any demand, you can maybe add a simple external tool, which converts the data.
BTW: the trade advisor just suggests only the second best commodity in the return path.

It's your work and your decision Eventure,
But I have to agree, you would probably save a lot of time and hassle by making the new database as you would like it,
implement and test it in a new version, once satisfied then make a conversion tool.

People who already have an extensive database will keep using the version they have until the tool is available.

All those who do not mind too much will switch to the new version and provide testers.
They can always keep a backup of their old data for later import also.

Another really nice feature that could be added if it is not already there, would be for an easy way to export and import our database so that we could share it with friends.
Especially with wings coming, people should start to work more as groups.

I saw the FTP tool, but is there a server already setup ?
Is this already setup so that many people can connect to the same FTP and share one database ?
 
Couple of issues I'm getting so far:

Clicking 'commodity' or 'database -> commodities' does nothing for me.** (Clicking it works now that the Station has been added to the database so that was an error on my part, possible to have a notification to alert users about station being missing?)

Clicking 'control -> panels -> commodity' makes the commodity panel appear however clicking anywhere in the panel gives a Microsoft Visual Basic "run-time error 13: type mismatch" notification then the TCE closes. (worked in v1.33 not in v1.35a)

When entering a new system, clicking save gives a Microsoft Visual Basic "run-time error -2147417848 (80010108): Method 'value' of object 'range' failed" notification then the TCE closes. (Happens in both v1.33 and v1.35a)

Ship Log shows nothing at all, even after travelling to different systems. (worked in v1.33 not in v1.35a)



It seems like most of the problems were coming from having the newest version of Excel, went back to my old Excel 2007 and installed SP3, and I'm getting no errors at all now.

Only issue now is the FTP options has to be unchecked then checked again to allow upload to the database.
 
Last edited:
How does it work when it works? Is it just click the Start OCR button and the trade values appear?

Yes pretty much. Scroll the commodity market screen to the top. Now in tce click start ocr. You should get the please wait message. When it returns to start ocr again, click the left or right arrows on the tce form to flick through the commodity types until you see ones that are on your commodity market screen. You can then check the prices and double click them to edit any errors. Once happy you scroll your commodity market screen down ( just as you would in the standalone ocr) and repeat. There is no export or import required as tce does it all for you.
 
The commodity panel is not being displayed when clicked. It turns orange and processing is displayed but nothing appears. 1.35a
 
Check if your 'current position' is saying the station your docked at, I made a similar mistake when trying to display the commodity panel.
 
This is a great idea, but I'm afraid it's not really usable on a non-widescreen display (1280x1024). The smaller dialogs can just be put on my second screen, which is fine, but the bigger stuff - and the always-present bar across the top - don't fit on one screen.
This would really benefit from the ability to keep things that are meant to overlay the game below 1280 wide, and things on the second monitor below 1024.

EDIT: Never mind, just realised that "Z" on the panel control is a zoom option. That's not what I automatically think of when I see "x,y,z" ;-)
 
Last edited:
2015-02-21_12-28-03.jpg

The Star system record panel does not open according to the x,y set in the panel control.
 
The Star system record panel does not open according to the x,y set in the panel control.

Thanks for reporting, found the issue, will be fixed next update.

when I click the Commodities database button, nothing happens.

The Commodity Database button is temporary disabled due to a language translation problem. It is only used to add a new commodity or change the name/galactic average. Next update you can access it again.

Not tried it yet but you say we need Excel, as I recall when my old man did stuff in exce he was able to package it with a run time library so it
could be used on machines without excel installed, maybe worth ooking into
smile.png

Hmm...., TCE its not only VBA code, i use a lot of worksheets, e.g. for sorting things. In VBA, sorting is a nightmare to me.

You can't type the minus sign in the positioning window.
(for those with an extra monitor on the left of main)
It's easy to get around it by doing it in the Panel.mdb or by copy and pasting a negative value straight in the positioning panel.

Also, as a nice to have future update suggestion, how hard would it be to add small up and down arrows to increase and decrease the value in the boxes ?
Would be cool to just press a small button and see the panel move around the screen. Makes for fast and easy precision adjustment.

I thought, it may be not nessesary to add negativ values. Thanks for the feedback. Will add the possibility to enter a minus sign in next update.
 
Last edited:
Another really nice feature that could be added if it is not already there, would be for an easy way to export and import our database so that we could share it with friends.
Especially with wings coming, people should start to work more as groups.

I saw the FTP tool, but is there a server already setup ?
Is this already setup so that many people can connect to the same FTP and share one database ?

You can share your data though a FTP server. I use my Fritzbox, easy to setup.

Couple of issues I'm getting so far:

Clicking 'commodity' or 'database -> commodities' does nothing for me.** (Clicking it works now that the Station has been added to the database so that was an error on my part, possible to have a notification to alert users about station being missing?)

Clicking 'control -> panels -> commodity' makes the commodity panel appear however clicking anywhere in the panel gives a Microsoft Visual Basic "run-time error 13: type mismatch" notification then the TCE closes. (worked in v1.33 not in v1.35a)

When entering a new system, clicking save gives a Microsoft Visual Basic "run-time error -2147417848 (80010108): Method 'value' of object 'range' failed" notification then the TCE closes. (Happens in both v1.33 and v1.35a)

Ship Log shows nothing at all, even after travelling to different systems. (worked in v1.33 not in v1.35a)



It seems like most of the problems were coming from having the newest version of Excel, went back to my old Excel 2007 and installed SP3, and I'm getting no errors at all now.

Only issue now is the FTP options has to be unchecked then checked again to allow upload to the database.

Fixed that FTP button issue in next update.
When opening the Panel Control, all panels are disabled beside the Main and the Control itself. You should hear a "bing", if you click on the unhidden panels, but nothing more.

EDIT: Never mind, just realised that "Z" on the panel control is a zoom option. That's not what I automatically think of when I see "x,y,z" ;-)

Will rename Z to "Zoom" and Commodity Database to Wares Database for better understanding.
 
Last edited:
Couple of issues I'm getting so far:

Clicking 'commodity' or 'database -> commodities' does nothing for me.** (Clicking it works now that the Station has been added to the database so that was an error on my part, possible to have a notification to alert users about station being missing?)

Clicking 'control -> panels -> commodity' makes the commodity panel appear however clicking anywhere in the panel gives a Microsoft Visual Basic "run-time error 13: type mismatch" notification then the TCE closes. (worked in v1.33 not in v1.35a)

When entering a new system, clicking save gives a Microsoft Visual Basic "run-time error -2147417848 (80010108): Method 'value' of object 'range' failed" notification then the TCE closes. (Happens in both v1.33 and v1.35a)

Ship Log shows nothing at all, even after travelling to different systems. (worked in v1.33 not in v1.35a)



It seems like most of the problems were coming from having the newest version of Excel, went back to my old Excel 2007 and installed SP3, and I'm getting no errors at all now.

Only issue now is the FTP options has to be unchecked then checked again to allow upload to the database.



Getting all the same errors on Excel 2013
Thought it was just me and was trying to figure out was I was doing wrong lol
Humm I'm sure I must still have my old copy of 2007 somewhere !

Is it supposed to work or will it later work on 2013 ???
 
Update (V1.35b) released:
- Fixed Star System panel not in position
- Renamed Commodity Database to Wares Database and Z-Value into Zoom
- Allowing negative position values for all panels
- Fixed FTP up-/download button issue
- Info display, when a button is locked (Commodity and Station Database).

Note: Do not overwrite the Panel.mdb again, if you used V1.35 or V1.35a before and adjusted the panels.

Getting all the same errors on Excel 2013
Thought it was just me and was trying to figure out was I was doing wrong lol
Humm I'm sure I must still have my old copy of 2007 somewhere !

Is it supposed to work or will it later work on 2013 ???

If the Shiplog is empty, check the AppConfig.xml, if there is the entry VerboseLogging="1" under NETWORK. Otherwise please give me a screenshot and the debug code block, so i can help. Thanks.
 
Last edited:
I just tried it on my brothers system today, he has a brand new Office 2013 and I couldn't get the TCE to work, mostly the same issues I was having, installed my Office 2007 + SP3 and it worked a charm.
 
Yes pretty much. Scroll the commodity market screen to the top. Now in tce click start ocr. You should get the please wait message. When it returns to start ocr again, click the left or right arrows on the tce form to flick through the commodity types until you see ones that are on your commodity market screen. You can then check the prices and double click them to edit any errors. Once happy you scroll your commodity market screen down ( just as you would in the standalone ocr) and repeat. There is no export or import required as tce does it all for you.

OK, so here's a screenshot. OCR just doesn't want to play for me it seems. I have turned off GUI effects.

When I click Start OCR Scan, it says "Please wait" but then comes back with no data. :(

Any suggestions please? This is the killer feature for me!
OCR Not working.jpg
 
Status
Thread Closed: Not open for further replies.
Back
Top Bottom