[RELEASE] Slopey's BPC Market Tool! - New version!

[Rayman223]

This tool is awesome !
I try to use with EliteOCR.
All works fine but I'm in Belgium and I put the game in French. It's easier for me.

The problem is the EliteOCR do not translate the materials so I can not update de data

A translate system could be created ?


Again, thx for the tool !

 

[Ibastavd]

Cheers Slopey, Merry Xmas to you m8! Great tool...

 

[Schoolboy]

Hi all,

I'll make my first post here in this forum and greet all Commanders.

I fiddled around a bit with the 2 programs and found out, with the latest versions of both, that the import of data from OCR to Slopey is broken in case of using the local db as a poster before said in a YT-Video. In my case, I can't even import the data in a fresh empty db. In the import-window I can't see the commodities. It is only possible, when I use the public db instead. I used the english version of ED with english screenshots.

On the other hand, I would like to use both programs in german with screenshots of my german ED-client. I tried to OCR the Screenies in german and edited the Commodities-db of Elite-OCR to match the correct names. First I deleted the english commoditynames out of the list. The OCR-ratio was at least about 70%. Not very suitable to use often, cuz I had to correct a lot.

I would like to use Slopey as well with german commodities only in local db-mode. So this won't disturb the public uploaded data.
In my opinion, it should doesn't matter to both programs in what language they process the data, as long as it is secured, that the different language data is not mixed.

Is that possible to implement?

Greetings,
Pequi

I think the database is in english so unless slopey makes a translator then I think you'll be stuck with english only I'm afraid. You could ask him and see if he can do that? Its best to ask him in his thread here:

https://forums.frontier.co.uk/showthread.php?t=76081

 

[kuhGene]

Anyone know what's going on here? I might be missing something obvious but I coped pasted all the names so they should be identical - or I'm Blind! Image Here

Have you saved the file from OpenOffice? I've once done that and it separates the data by tabs by default instead of semicolons (the way EliteOCR exports it and BPC expects it). You could open the file in a text-editor and look if that's the case, if yes replace all tabs with semicolons and try again

 

[Slopey]

^^^ This please!

It has been done since yesterday, but it's held against the commod items themselves so will take a while to filter through. I'll update them when I get a moment, but have been busy doing other things today.

 

[Slopey]

2 Slopey
As I know DB better be at last at Third Normal Form, so instead of repeating same text many time you just set put index if name in another table. This make DB smaller and also must make it faster.

It also makes it more diffcult to update, and then i need to worry about unique keys and integrity, which I can't guarentee if people have their own entries in local mode for example, so it's easier just to have one larger verbose data table.

You already have tables for this staff, but seems it not used for normalization right now. And it need at last one more table.

Feel free to write one if you don't like mine

I wish your app and EliteOCR have better integration, like autoload to database information from new screenshot saved in folder or from clipboard(!). Right now it need spend some time for this to do for user.

That won't happen, as EliteOCR isn't 100% accuate, and people don't check the data as it is, populating the BPC with rubbish. I don't want to make that easier!!!! Always CHECK your data before you import it please.

Requesting features:
1) "About" with infomation about version, author and etc,

Eh? See the options page. Version number is at the top of the window, and my name is on the options page - what more do you want.

2) "search in sphere around selected system" - to search for good trades not so far from current location and not making it as start point

A "radius search" will be in a future version.

3) Search for "round trip" with more then 2 systems.

Maybe - there are other tools which do that, I don't see the need as you can stop and recalc anyway quite simply.

P.S. Why DevExpress ?

Because it has the best components, why not DevExpress? And the skinning is better than Infragistics, and the suite is easier to use imho than Telerik. But mostly, because I already have a licence for it.

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

hi,

BPC never ask me for adding Verbose Logging in AppConfig.xml
My files is in C:\Program Files (x86)\Frontier\EDLaunch\Products\FORC-FDEV-D-1002
I always have Unknown location..
So, i put in it myself, but BPC still don't know my position..
Install/reinstal (everything) do nothing but the same..

Do you have the correct Logs directory in the BPC options under the Logs directory field? In your case it should be:

C:\Program Files (x86)\Frontier\EDLaunch\Products\FORC-FDEV-D-1002\Logs

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

Is there a way to see the distance as a column for each result?

Yes - it's shown on the grid if you select "Within Distance"

Also it would be nice if via a filter we can find the shortest route which includes the station distance calculated already...

[/QUOTE]

I'm not doing routing as a) theres a passable one in ED, and b) FD didn't provide coordinates for all systems, so there are big holes in the data prevent optimal routes being found.

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

Getting "Error unable to parse CSV - is it in the correct format?" when using the EliteOCR tool to create a CSV then import. It was working fine earlier today before your update. EliteOCR hasn't been updated, and as far as I can see the CSVs are exactly the same format as before, so has something changed in your program?

Nope. Check your CSV file, it'll be wrong somehow.

 

[SpiralRazor]

This tool is awesome !
I try to use with EliteOCR.
All works fine but I'm in Belgium and I put the game in French. It's easier for me.

The problem is the EliteOCR do not translate the materials so I can not update de data

A translate system could be created ?


Again, thx for the tool !

You have a tool, its called google translate...Other then that, the game british..learn english. Unless you are very good at english id avoid EliteOCR as its VERY particular about what data gets entered and its difficult to catch errors as well.

 

[Slopey]

@Slopey:-

- In an earlier version you could let the BPC create a list of several stations and commodities. Is that a function that might return one day?

- Is there anyway (without cut and pasting from bpc into excel) that we could select a number of stations and commodities and let the bpc only select from then (like a multiple SystemTo and Commodity list)?

- Is there anyway we might be able to hide systems we want to avoid)?

(I guess the last two would be a select check box for each system?

Currently, nope, and I don't really want to get into that level of filtering, but I might get around to it one day.

 

[SpiralRazor]

This tool is awesome !
I try to use with EliteOCR.
All works fine but I'm in Belgium and I put the game in French. It's easier for me.

The problem is the EliteOCR do not translate the materials so I can not update de data

A translate system could be created ?


Again, thx for the tool !

You have a tool, its called google translate...Other then that, the games british..learn english. Unless you are very good at english id avoid EliteOCR as its VERY particular about what data gets entered and its difficult to catch errors as well.

 

[Firecat]

Is something funky with the commodity list? I can't seem to load data for any commodity past Platinum in the alphabetical sorted list.

Edit: Very odd, but restarting the application solved the above.

 

[Jawada]

I use the tool in offline mode , is there a possibility to backup my current BPC data File ?
Just in case my PC give's up !
Thank you .
Jawada

 

[Dunkhan]

Do you have the correct Logs directory in the BPC options under the Logs directory field? In your case it should be:

C:\Program Files (x86)\Frontier\EDLaunch\Products\FORC-FDEV-******\Logs

That's work

I was pointing in C:\Program Files (x86)\Frontier\EDLaunch\Products\FORC-FDEV-D-1002


thank's

 

[sqzbox1]

Hi Slopey. Just wondered - how would you like us to handle/report the data errors? I don't mean the numbers in the commodity lists - rather the errors in key info such as system names and stations. It is a bit much to expect you to constantly trawl these threads to catch any reports we might put in here. Just in case you do, however, here's one for you - Vonarburg Enterprise is showing as in both V774 Herculis and V775 Herculis - it is only in V775 Herculis so the entry in V774 needs to be deleted.

I would also vote for normalisation. I understand what you are saying above to Filarius and it does make sense, however I tend to think that the issue you talk about, integrity of indexes and such, would be less of a problem than the data errors that are resulting from a lack of normalisation. TBH - no offense meant, the tool is great, really! - but I am finding that the data errors are so prolific that it becomes untrustworthy and hence I find myself not using it as much as I once did. Well, perhaps that is a good thing! Until FD get around to building an API I wonder if all the effort you are spending on BPC is actually worth it for you. I think I would have folded by now!

{EDIT} Oh and one more thing to consider. Parsing the data took 15 minutes! And I have a good machine!

 

[ferret141]

This tool is awesome !
I try to use with EliteOCR.
All works fine but I'm in Belgium and I put the game in French. It's easier for me.

The problem is the EliteOCR do not translate the materials so I can not update de data

A translate system could be created ?


Again, thx for the tool !

Why not set yourself up with an excel macro to replace french phrases with their english counterparts.

 

[ferret141]

Of course you can add stations - the data in the BPC is crowdsourced - you have to type it in! If the station isn't there, nobody's been there yet (or within a reasonable time) so add it yourself with prices please from the "add/update prices" page.

It never occurred to me that the price updater could be used to add stations and commodities. I thought it only featured items already in the database.

See the OP - it's for faster updating of values at your current position.

I can't believe it makes more sense to me now despite it being so tired my head keeps drooping. Only current station right?

Try the "import CSV" button on both the price entry pages (add/Update and Grid, which you've found already)

I was looking for it in the main windows exclusively *facepalm*

Only for systems for which FD provided coordinates in Gamma.

Any plans to import data from EDCN in the near or distant future (I think you have a lot on your plate already as it is)




I feel like I asked some dumb questions. Thanks for answering them.

 

[ChrisJSY]

Have you saved the file from OpenOffice? I've once done that and it separates the data by tabs by default instead of semicolons (the way EliteOCR exports it and BPC expects it). You could open the file in a text-editor and look if that's the case, if yes replace all tabs with semicolons and try again

I'll check tomorrow thanks, but I've always been using OpenOffice and correcting the missing "system" entry each time and worked until the recent update. Will report back when I find out either way.

 

[TheGrayLAN]

173

I keep getting this error "There are rows missing system name!

I have a screen shot but
"

• Sorry, due to extensive link spamming from new user accounts, the usage of hyperlinks within posts and topics are not allowed for your user group.
  
  So link is below
  
  ht tp : // jpst.it/ vbX_

 

[The_Blog]

There is a mistake in the System LHS 3447. The station Yapling Enterprise does not exist. This is probably a typo, because the station Yaping Enterprise DOES exist.

 

[Hadschott]

I don´t know if someone already posted this but the toll has a little buggy information in it, Semiconductors are often Displayed as Superconductors that leds to wrong profit estimates that are far higher than anything else in the list because the system thinks that a 7000ct product is selled somewhere for 700ct (even if this is an totally different product)

So if you see a route that should give you an extremely higher profit than others in the list make sure to look if one of the buy/sell products is Superconductors, because it is most surely wrong information.

 

[Daddyisakook]

Ok, so here'es a question that's probably been asked a thousand times, but I can't find the answer to.

Where do I find the log files that BPC is looking for? I've installed the various versions and its never been able to find them automatically. I direct it to: C:\Program Files (x86)\Frontier\EDLaunch\logs but it never makes a difference. BPC never knows my location.
What am I doing wrong?