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

Slopey

Volunteer Moderator
I have the same problem.

If you read up you'll see I'm aware of it and will fix it in due course.

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

Use UTC Time stamps to avoid time conflicts (/ wrong minutes scines)!!!!!

Yeah - that's how it used to work, but people kept complaining that it was UTC times and not local so I changed it back in V3. It's just a missing setting in the database, I'll have it addressed shortly.

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

and if i install the new 4.2.1.0 from scratch i have 6! Systems in the DB :rolleyes:

Did you install in-place over the 4.2.0.3? The ED4.db file in the BPC directory is NOT changed/removed/replaced by the installer. But if you deleted it, you'll be back to a blank DB.
 
Does the system exist in the BPC? Does the station? If not you'll need to type the station in. You'll also need to be there remember if the BPC knows where you are.

Hi Slopey,

No it had been the first time System and Station. But I manually entered two entries and those worked.

yM7UXFk.jpg


8CphGDz.jpg


on the bottom of second picture you can see the csv file structure of Elite OCR.

Today at 07.01.15 19:45 CET someone else uploaded successful data, but I still get error shown above. So It must be a problem with my Setup.

BPC is 4.2.0.3
EliteOCR 0.3.8.1

German Desktop Game settings English any ideas?
 
Last edited:
fantastic improvements

for some reason, when i set the time and the time to auto update frequency, they both revert to morocco time and 5 mins after clicking o.k.
 
Ok, I have another suggestion, because I'm now getting less impressed with the quality of data in the tool!

Can we have our own personal setting where we can exclude any results where the profit margin is above a certain amount or percentage?

So for example, if unit profit margin is >3000CR then exclude the results?
 

Slopey

Volunteer Moderator
Hi Slopey,

No it had been the first time System and Station. But I manually entered two entries and those worked.

yM7UXFk.jpg


8CphGDz.jpg


on the bottom of second picture you can see the csv file structure of Elite OCR.

Today at 07.01.15 19:45 CET someone else uploaded successful data, but I still get error shown above. So It must be a problem with my Setup.

BPC is 4.2.0.3
EliteOCR 0.3.8.1

German Desktop Game settings English any ideas?

That's not a vaild import file for a start. You need to export as BPC format from EliteOCR.

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

Ok, I have another suggestion, because I'm now getting less impressed with the quality of data in the tool!

Can we have our own personal setting where we can exclude any results where the profit margin is above a certain amount or percentage?

So for example, if unit profit margin is >3000CR then exclude the results?

Right click on any column header and add a filter.

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

fantastic improvements

for some reason, when i set the time and the time to auto update frequency, they both revert to morocco time and 5 mins after clicking o.k.

read 2 posts up....
 
Did you install in-place over the 4.2.0.3? The ED4.db file in the BPC directory is NOT changed/removed/replaced by the installer. But if you deleted it, you'll be back to a blank DB.

Tried both old DB: wont even start (... has stopped working), new DB: 6 Systems
 
Screenshot:
8CphGDz.jpg
For the love of God, please stop adding Station Names in ALLCAPS, it looks horrible. I know the game shows them this way, but "Gamow Station", is way easier to read. If the Station already exists, I think BPC is then case-insensitive, but for a new Station I think it might still be a problem.
Thank you.
 
Wouldn't update. Uninstalled. Reinstalled. Still as slow as before.

So, the SQLite DELETE slowness wasn't what was killing it for me. (Which makes sense as on a virgin database, there's nothing to delete...)
 
Last edited:
just to help some people out that borked their database and are for whatever reason sitting on 5 systems:

here is a DB with the data from the last week or so, around 3700 systems.
www.troik.de/temp/ED4.zip

I will delete the file in 24 hours, so people don't download old data.
 
Mine wouldnt update to start with, then i realised it was just because it was parsing. It was 5% into to and from past experiences (Playing earlier today) it takes about 30 mins or so to finish, so.....

I switched to task manager and ended the task, downloaded the new version from the link provided and just hit install. Didnt uninstall or anything, and all works fine.
Well, better than fine, takes 0 seconds to Parse and all the stations are there. I`m still not sure how it works though.

An awful lot of the data is outdated (presumably beacuse it hasnt been updated) but i`m not sure how to update it, other than using the OCR program. Is that neccessary? I have used the OCR program before, and it works great. I wasnt using the required 1080p resolution though so i couldnt update it as a BPC, which is a shame beacuse i did a load of screenshots and ran them through and the accuracy was 100%.I`m not enitrely sure how to take those Hi Res screenies and really dont want to have to install further apps to be able to (got enough random crap on this laptop as it is)

Anyway, keep up the good work Slopey, It makes such a massive difference to making money to start with.
 
25 minutes now - 42 systems. Is there a log produced that you could use to diagnose this, Slopey?
 
Last edited:

Slopey

Volunteer Moderator
I have no idea what you're talking about - but I guess you mean it's been parsing for 25 minutes? A little more verbose would be handy. Anyway...

Are you on 4.2.1.0 ?

How large is your database? Have you cleared it down recently (if you don't want to keep it that is).

Backup your ED4.db to somewhere safe, then delete it out of the BPC directory, then restart the BPC and see how that goes (provided you're on 4210 that is).

It doesn't take longer than 1 minute for me on many computers (6+) at this end, from a blank DB or a full 48 hour download.
 
I have no idea what you're talking about - but I guess you mean it's been parsing for 25 minutes? A little more verbose would be handy. Anyway...

Are you on 4.2.1.0 ?

How large is your database? Have you cleared it down recently (if you don't want to keep it that is).

Backup your ED4.db to somewhere safe, then delete it out of the BPC directory, then restart the BPC and see how that goes (provided you're on 4210 that is).

It doesn't take longer than 1 minute for me on many computers (6+) at this end, from a blank DB or a full 48 hour download.

Again, I uninstalled. My database is non-existant. Sitting on 76 systems now. Yes, 4.2.1.0, fresh download. Full uninstall. Full reinstall.

Why it is taking sooooooo long to download? Has to be a network code issue.
 
Vendraen, i suspect you have the same problem i do: the (online) DB was wiped and only systems added within the last 48 hours since the wipe will ever be downloaded to a blank DB (after clean install) - i myself still dont understand why, but that's like it is as of now

Edit: or well i guess it saves traffic but it's certainly no improvement
 
Last edited:
Vendraen, i suspect you have the same problem i do: the (online) DB was wiped and only systems added within the last 48 hours since the wipe will ever be downloaded to a blank DB (after clean install) - i myself still dont understand why, but that's like it is as of now

Wha...? You mean... the software... doesn't get itself a complete copy of a database with all known systems, so that we can at least run rough searches? O_O Mmmkay. That's a little...weird.

It needs to have every. single. known. system. Pure and simple. Heh.
 
Parsing works fine on my side, but I keep getting a NullReferenceException with the flight log from time to time. Ah, those null objects, we love them... or not :D
If I click "Continue" on the JIT dialog then refresh the top 20 systems visited it's ok until it comes up again. Seems like a problem with the DataGrid component.

System.NullReferenceException: Object reference not set to an instance of an object.
at DevExpress.XtraGrid.Views.Grid.ViewInfo.GridViewInfo.UpdateCellAppearance(GridCellInfo cell, Boolean always)
at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawRegularRowCell(GridViewDrawArgs e, GridCellInfo ci)
at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawRegularRow(GridViewDrawArgs e, GridDataRowInfo ri)
...
...
 
I had a problem with this too tonight, I couldn't seem to update to the new version, so I downloaded it and reinstalled. Then it wouldn't download anything, either auto or manually. So, I downloaded the zip file on the post above (#1799) and copied the extracted db file over mine. That gave me the 3k+ systems, with old prices. I then used the option to delete the prices database, did a manual download (which now worked), and off it went- with very fast parsing :)

Cheers Slopey!
 
Getting the same Unhandled exception. Wasn't using the tool at all, but it was sitting on the Flight Log tab.

Code:
See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
   at DevExpress.XtraGrid.Views.Grid.ViewInfo.GridViewInfo.UpdateCellAppearance(GridCellInfo cell, Boolean always)
   at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawRegularRowCell(GridViewDrawArgs e, GridCellInfo ci)
   at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawRegularRow(GridViewDrawArgs e, GridDataRowInfo ri)
   at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawRow(GridViewDrawArgs e, GridRowInfo ri)
   at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawRows(GridViewDrawArgs e)
   at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawContents(GridViewDrawArgs e)
   at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.Draw(ViewDrawArgs ee)
   at DevExpress.XtraGrid.Views.Base.BaseView.Draw(GraphicsCache e)
   at DevExpress.XtraGrid.GridControl.OnPaint(PaintEventArgs e)
   at DevExpress.Utils.Drawing.ControlPaintHelper.PaintWithErrorHandling(PaintEventArgs paintEventArgs, Int32 layer)
   at DevExpress.Utils.Drawing.ControlPaintHelper.ProcessWMPaint(Message& m)
   at DevExpress.XtraGrid.GridControl.CheckProcessMsg(Message& m)
   at DevExpress.XtraGrid.GridControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18444 built by: FX451RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
ED_BPC
    Assembly Version: 4.2.1.0
    Win32 Version: 4.2.1.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/ED_BPC.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.34238 built by: FX452RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
DevExpress.BonusSkins.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.BonusSkins.v13.2.DLL
----------------------------------------
DevExpress.Utils.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.Utils.v13.2.DLL
----------------------------------------
DevExpress.XtraBars.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraBars.v13.2.DLL
----------------------------------------
DevExpress.XtraEditors.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraEditors.v13.2.DLL
----------------------------------------
DevExpress.Data.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.Data.v13.2.DLL
----------------------------------------
System.Speech
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Speech/v4.0_4.0.0.0__31bf3856ad364e35/System.Speech.dll
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Algorithms
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/System.Algorithms.DLL
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 10.0.0.0
    Win32 Version: 11.0.50938.18408 built by: FX451RTMGREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
DevExpress.XtraGrid.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraGrid.v13.2.DLL
----------------------------------------
DevExpress.XtraCharts.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraCharts.v13.2.DLL
----------------------------------------
DevExpress.Charts.v13.2.Core
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.Charts.v13.2.Core.DLL
----------------------------------------
DevExpress.XtraCharts.v13.2.UI
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraCharts.v13.2.UI.DLL
----------------------------------------
DevExpress.Printing.v13.2.Core
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.Printing.v13.2.Core.DLL
----------------------------------------
AutomaticUpdater
    Assembly Version: 2.6.18.4
    Win32 Version: 2.6.18.4
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/AutomaticUpdater.DLL
----------------------------------------
DevExpress.XtraCharts.v13.2.Wizard
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraCharts.v13.2.Wizard.DLL
----------------------------------------
System.Data.Linq
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18408
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Linq.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
Devart.Data.SQLite
    Assembly Version: 5.2.264.0
    Win32 Version: 5.2.264.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/Devart.Data.SQLite.DLL
----------------------------------------
System.Transactions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Devart.Data
    Assembly Version: 5.0.1056.0
    Win32 Version: 5.0.1056.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/Devart.Data.DLL
----------------------------------------
System.EnterpriseServices
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.Numerics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
WindowsBase
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
Anonymously Hosted DynamicMethods Assembly
    Assembly Version: 0.0.0.0
    Win32 Version: 4.0.30319.18444 built by: FX451RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
 
Back
Top Bottom