Abandoned [RELEASE] Trade Computer Extension

[eventure]

Beta 5 seems to be a _partial_ winner.

I was able to successfully add CD-69 55 by specifying only the four distances to the reference systems, then selecting "Visited". Note that I had to actually select one of the options in the STATE OF EXPORATION field before the SAVE button would appear.

However, when I subsequently selected DATABASE > STARS to bring up the panel again so I could add a SPECIAL NOTE, two errors occurred:

1. I had to press Enter to get the new note content to "stick" and the SAVE button to display, and
2. Upon pressing save I get the following error:

Error Line: 75

Error (1004) Application-defined or object-defined error.

On the bright side, this error does not seem to crash excel entirely. And also, the special note that I added DID seem to be saved correctly despite the error.

I changed only the ADD NEW routine, modding the code for the EDIT also. That should fix it also. Changing Info SAVE button from AfterUpdate to Change.

The detection routine is canceled on error, so if you got an error, a restart is recommended.

If the Elite owner has changed the background colors (another user mod), will this be handled by your program?

In other words, if the user changes from the default "orange" to another color, will excel display the appropriate colors?

I have not installed it yet, but asking before hand.

Maybe a FAQ?

You cant change the color setting of TCE at this state, but in the future you can. Its alot of work to be done to support this.

Am I right in thinking that :
Since the galaxy map shows distance in light years from one system to the other,
It means that you can add the Star's coordinates in the STAR SYSTEMDATABASE panel from anywhere in said system with the same result ?

You are right. So it is.

 

[eventure]

Update (V1.36 beta 6) released:
- Fixed Star System panel issues
- Added Import panel for old databases (click the button in the Options panel).

 

[Yokai]

I'm offline for the rest of the day and won't be able to test any further, but as far as I can tell, Beta 5 is good to ship. I haven't been able to break anything except the one thing mentioned above about adding a SPECIAL NOTE to a star that I just added. Probably a rare use case, and it's easy to recover by shutting down and restarting TCE.

 

[XLA]

Hello Eventure.
I have been using 1.35b successfully all day.
I have been waiting for the import option. Anyway I have backup up the whole TCE folder before I broke the original.
beta 6 started fine without error. I then did a import which it says was successful.
On the next restart I get the the 5th green cube & i get RTE 9. Below is the debug :

For z = 1 To AzRegStations
ZID = Ar_DBRegStations(z, 17) ' 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)
Next z

Doesn't like the ZX line.....

 

[Yokai]

Am I misunderstanding the concept behind building this?

Install all the pieces, follow all instructions, and then open the game, then the commodities window for each place I am docked, and take snapshots of the commodity price lists, then OCR them at very high resolution, feeding output to excel for manipulation?

I've spent all day on this, and I guess it's my very small resolution preventing this from working at all. I can come nowhere near the resolution needed for correct OCR.

I'm sure some of you with working apps took those screenshots. Would it be impossible (due to copyrights) to share them, like other Elite screenshots I see all over the web?

I wonder if EDev would let loose of the price and commodities data for either this mod, or future mods like it, for you to import directly as raw data, not dependent on screenshots.

Too bad we don't have an "export data" tab in the commodities price window. That would just be too cool.

What screen resolution do you run the game at?

 

[eventure]

Hello Eventure.
I have been using 1.35b successfully all day.
I have been waiting for the import option. Anyway I have backup up the whole TCE folder before I broke the original.
beta 6 started fine without error. I then did a import which it says was successful.
On the next restart I get the the 5th green cube & i get RTE 9. Below is the debug :

For z = 1 To AzRegStations
ZID = Ar_DBRegStations(z, 17) ' 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)
Next z

Doesn't like the ZX line.....

Thanks for the report. Please do this for me: Open the TCE.mdb, open the "Stations" table and look at the row entries 150+. Check the last column (STAR_ID), if there are entries or not. Perhaps you can upload your database? I will then check it, whats wrong.

 

[XLA]

good guess about the star_id. my stations from rows 151 to 176 do not have star_id's.

 

[eventure]

Update (V1.36 beta 7) released:
- Bugfix in import old database routine.

 

[Yokai]

1360x768, but given I use a different color Elite UI, the screenshot comes out black and white (because I use a blue and white UI)

I'm sure there is another way of doing this which does not depend on screenshots and OCR (at least on the consumers end).

As this program develops and given some time, the data collected by you and others working on the project could be made available as excel import/export updates, or straight out included within the zip.

I needed to know if I understand the current process, or if I got it wrong and I need to "import" some data as opposed to capturing it with screenshots and then OCR-ing it into excel?

Between your HUD color being customized and not game-default, and your screen resolution being much smaller than 1920x1080, I'm sorry but TCE (and EliteOCR) just won't run well for you. Eventure is performing some real magic with what Microsoft Excel can do, and they have to hand-craft the UI font size and boxes, so they've standardized on a "one size fits most" 1920x1080.

 

[eventure]

At this resolution (1360x768), the TCE config window is very small and its text is very tiny (about the size of your multi-colored profile sig here).

At a higher resolution, I think the TCE config window would be "normal" size, or at least readable.

Several screenshots of TCE look like they are bigger than 16:9 aspect ratio.

Yep its 16:10 here. If you cant read anything, use a zoom-value greater than 100%.
With your resolution, you cant use EliteOCR, thats right. But you can use the manual way to enter all prices, as i did before EliteOCR.

 

[Yokai]

Update (V1.36 beta 7) released:
- Bugfix in import old database routine.

I haven't tried beta 7 yet, but I can attest that beta 6 completely fixes all weirdness with adding coords for new stars, or editing star info. So far it seems all pretty rock solid!

 

[Infomage]

Did you encounter crashes with the adding of new star systems? What language of excel you are using?

Just tried this with Beta 3 and it added a new starsystem fine. Guess I have been overtaken by events though since you've re-done the routine. Just installed beta 7... Gonna try and import my old database.

 

[eventure]

I haven't tried beta 7 yet, but I can attest that beta 6 completely fixes all weirdness with adding coords for new stars, or editing star info. So far it seems all pretty rock solid!

Thanks for the feedback. Will expand the new method to all other databases. The import function is the last test for the beta. If all works well, i release the non-beta V1.36 tomorrow as a full-version with and without an installer. A moddified database with only two stations will be included. You only have to delete the standard database file and rename the moddified to TCE.mdb.

 

[Infomage]

Import failed.

I got a message about a truncated value due to scaling, then hit a subscript out of range error.

Spoiler

Oh yes - Excel 2010 English (UK)

 

[Noxx]

Can you add the TCE folder as a trusted place in excel/office? Is the TCE.mdb or Languages.mdb also blank?

I've now added the TCE folders as trusted and can open the .mdb files without warnings (they aren't blank as you can see below), but the problem remains:


What can i try next?
Thanks in advance

 

[eventure]

I've now added the TCE folders as trusted and can open the .mdb files without warnings (they aren't blank as you can see below), but the problem remains:
View attachment 17794

What can i try next?
Thanks in advance

You are using an old panel.mdb. Please use the one from Beta 1.

Update (V1.36 beta 8) released:
- Another bugfix in import old database routine.

 

[Yokai]

Thanks for the feedback. Will expand the new method to all other databases. The import function is the last test for the beta. If all works well, i release the non-beta V1.36 tomorrow as a full-version with and without an installer. A moddified database with only two stations will be included. You only have to delete the standard database file and rename the moddified to TCE.mdb.

Awesome! I'm sure many traders will appreciate having only two stations in the DB that aren't their own collected data! I'll update my guide to mention this alternate DB.

Thanks again for a _really_ nice addon that makes the game richer and more enjoyable!

 

[Infomage]

Update (V1.36 beta 8) released:
- Another bugfix in import old database routine.

Alas, this didn't fix my error... Here's the actual error message before the subscript out of range error. b = 22356 or something like that.

 

[XLA]

beta 8 seems ok. lots of data thanks.

 

[Bragolatch]

@Eventure

You are very consistent at answering all the question here.
Since you didn't comment on any of the subject of my post, #894, on page 60,
I was wondering if you might have missed it.
A lot was going on at the time !

Thanks.