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

NoTones · Jan 6, 2015

Slopey said:
I only just picked up your PM today NoTones - no need to be rude. As a rule, I don't acknoweldge all the donations via paypal, aside from a few which I did to confirm they were correct. And anyway - you've told me they may not have even come through?!! How can I respond to something I've possibly not received correctly?

All donations are grateful received, and I've said so on many occasions, but I've not had any other people requesting I thank them personally every time.

i sent the pm again y-day so i guess you could have missed that one, however i sent original msg to check it 2weeks ago and you never responded at-all so its not me being rude

11 Aug 14 PAYPAL *SLOPEY CD xxxx DEB 10.00
and the last one £10 went through 2 weeks ago after checking at the bank today it will be on my next statement

And I probably will be donating again as myself and family are heavily involved in charity work I currently donate £30 a mth to different charities so will no doubt donate again

Chris Majere · Jan 6, 2015

Loaded the program this weekend. If I remember correctly, the number of "Known Systems" was around 1500. This number is now above 2880. Wow!

I love the tool so far. Can now put my pencil and eraser away!

bigtaff · Jan 6, 2015

Hello Slopey,

had a problem at Bounds Hub in Alrai today, OCR'd it, dbl checked the output but when I tried to open it in BPC, got the message back could not parse the file, wrong format.

Tried to attach the file, but the uploader says it is an invalid file?. It's here in dropbox :https://www.dropbox.com/s/gjn34gmn65y4iew/Alrai.Bounds Hub.2015-01-06T15.35.55.bpc?dl=0

Keep up the great work!

Bigtaff

TheRaven · Jan 6, 2015

Troik said:
You should know that even in local mode, all data is always uploaded to the servers, since that is the sole purpose of BPC to gather this data, so you should always strive for correct data.

I guess that is why the trade run that I have been using for a week, now is completely ruined less than 12 hours after my data was uploaded to the server (without my concent).

Traders beware, your trading places can be ruined. My system is now completely out of Palladium, Beryllium AND gold (for the past week I have been the only visitor in the area, now suddenly there is Type9 and Pythons.

Oh well. I might as well update the data so the "leechers" dont waste their time on my, now runied routes.

gda scooby · Jan 6, 2015

So you are happy to use the tools and other people's data, but not to upload your data? What's the definition of a leacher again?

TheRaven · Jan 6, 2015

gda scooby said:
So you are happy to use the tools and other people's data, but not to upload your data? What's the definition of a leacher again?

No (read my previous post, page 113), I was using the tool in local mode, with only my own data (as a prettier version of my excel sheet, as the description for this tool indicates that you can), but it now turns out that my data is uploaded anyway (or anyway it has been uploaded at the last two updates, that dload/upload everything again), and every trade route I have uploaded is ruined within a day (That was not something I worried about before, I just didnt want to upload my sometimes wrong data and ruin other peoples data, and ruin my own database with systems I had not visited and scanned myself).

extraltodeus · Jan 6, 2015

It's been since 3 days that slopey doesn't connect or something. The software runs but it says "market update fail" and the tabs remains gray

TheRaven · Jan 6, 2015

Slopey said:
It's not intended and the latest version should resolve that for once and for all as it now stores settings in the ED4.db file itself (but that won't be apparent until the next update) - that file is always backed up at launch, so if something does get inavertently toggled, you can restore it.

Thank you, that sounds great.

Feedback: For me, the tool feels more responsive after the last two updates - even though after last update it took quite a while to start the programme first, after the last update, but now it is responsive. Win8.1 x64.

Wish: It would be nice with a round trip(or triangle) function though, since I have scanned almost 50 systems in the same area.

Troik · Jan 6, 2015

Quick Tip for people:

I don't expect people to read this thread as religiously as I do, but if you take the few minutes it takes to read Slopeys latest posts here, you'll find that many of your questions have already been answered, feature requests have been acknowledged etc.
Just find the latest posts on his profile, or use this link: https://forums.frontier.co.uk/search.php?searchid=1311817

iAmLegion · Jan 6, 2015

Getting this error

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

************** Exception Text **************
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at A.ce60847a8ca1358480ac48a994b33eaa6.c68498225312ad7c83c718059ae8271b7()
at A.ce60847a8ca1358480ac48a994b33eaa6.c5f27308b7c13f6e4630191ce927f1e0d()
at A.ce60847a8ca1358480ac48a994b33eaa6.cadc7deb679d2492377dcc6f6d93a5e8b(Object cf31c6b95f279e766a628123301769734, EventArgs c685f2fe3e56b15489d3a72ae97ae0d12)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
at DevExpress.XtraEditors.BaseControl.WndProc(Message& msg)
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.34014 built by: FX45W81RTMGDR
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
ED_BPC
Assembly Version: 4.2.0.3
Win32 Version: 4.2.0.3
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.33440 built by: FX45W81RTMREL
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.33440 built by: FX45W81RTMREL
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.34239 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.33440 built by: FX45W81RTMREL
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.33440 built by: FX45W81RTMREL
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.33440 built by: FX45W81RTMREL
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.34230 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: 12.0.20806.33440 built by: FX45W81RTMREL
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.33440
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.33440 built by: FX45W81RTMREL
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.33440 built by: FX45W81RTMREL
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.33440 built by: FX45W81RTMREL
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.33440 built by: FX45W81RTMREL
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.34004 built by: FX45W81RTMGDR
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.34014 built by: FX45W81RTMGDR
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.

Ac1dCl0ud · Jan 6, 2015

Also getting this unhandled exception when I specify a "to system" on Best Profit Calculator to search what commodities they need if I dont specify a "to system" the search works but get too much data

Cmdr Sharky · Jan 6, 2015

TheRaven said:
...and every trade route I have uploaded is ruined within a day...

I don't believe that this is anything to do with BPC. In order for it to be true, you would have to be consistently uploading the best trade routes in the database, and people would have to be heading there in droves. I've been grinding the same trade route for a couple of days, one of the best that BPC has to offer at the moment, and I've publicised it and extolled the virtues in several "trade route" threads here on the forum yesterday and today, and I've seen no change whatsoever in the trading prices.

spleeneater · Jan 6, 2015

TheRaven said:
I guess that is why the trade run that I have been using for a week, now is completely ruined less than 12 hours after my data was uploaded to the server (without my concent).

Traders beware, your trading places can be ruined. My system is now completely out of Palladium, Beryllium AND gold (for the past week I have been the only visitor in the area, now suddenly there is Type9 and Pythons.

Oh well. I might as well update the data so the "leechers" dont waste their time on my, now runied routes.

you DO know that when FD restarts or takes down the servers that when they come up commods change , quantities , prices , etc all change right? sometimes stuff stays the same , but its not set in stone. Dont go accusing the community of being leechers without knowing what youre talking about.

ive been doing runs between the same systems for weeks. One day on my way to the system the restart notification came up. I arrived , docked and sold my goods , then waited for the restart. Upon logging back in commodities that used to be there were gone , stuff that wasnt there before was , and available quantities changed. and ive even elaborated in this very thread that ive been running from Sol to Anlave because it was lucrative.

Last but not least - If any of those type 9s and whatnot that you saw didnt have CMDR in the name - they were NPC's. Npc trading also effects available quantity. again - before you rage that some leech , leeched your route because you put it in the bpc - think a little.

CmdrJacks · Jan 6, 2015

Normalisation would help with that and if you want to do it properly you'd mark an entry as deleted, without actually deleting it using a table with id as foreign key. These entries can then be deleted in a background thread when you're not doing anything else (lookups and creation are quick). Hell, if you're using a server anyway just let the server do the admin on a proper central sql database. Obviously, you don't have to answer to me or anyone else and I think your tool plugs a hole in the game (albeit, maybe a bit too powerfully).

Slopey · Jan 6, 2015

extraltodeus said:
It's been since 3 days that slopey doesn't connect or something. The software runs but it says "market update fail" and the tabs remains gray

Been working fine for me the last 3 days - which version are you on? New version out later tonight with faster parsing.

The Weasel · Jan 6, 2015

Hi - I had this out of bounds error with the 'multi select tool' option active - recently each time I have opened the BPC it has reported that the log file is not found - the speech options have been reset as well as the multi select tool - this always causes the "out of bounds" error on my system -

So I manually backup my .db, while BPC does this automatically - if the program resets and trys to reload - it is always parsing - if you wait for that to end and restart your backup file has gone as the program creates a single backup.db which it overwrites. So a new version that updates, requires you to reload if the Auto-update is active - the multitool is set, the program crashes - if you then try to restart the backup is replaced and your local DB can be lost.

So each time I shut ED & BPC - I do a manual backup to a sub folder of the 2 .db files.

EDIT: Great tool - Slopey has done great work and [post above] continues to support it brilliantly - but on some systems [language, region and local settings] the behaviour can be different. This is not a result of Slopey's great work, just the quirk of regionisation and windows platforms and programs loaded. Adapt and conquer - then the program works perfectly for me.

Slopey · Jan 6, 2015

CmdrJacks said:
Normalisation would help with that and if you want to do it properly you'd mark an entry as deleted, without actually deleting it using a table with id as foreign key. These entries can then be deleted in a background thread when you're not doing anything else (lookups and creation are quick). Hell, if you're using a server anyway just let the server do the admin on a proper central sql database. Obviously, you don't have to answer to me or anyone else and I think your tool plugs a hole in the game (albeit, maybe a bit too powerfully).

Don't need normalisation, as it's more difficult to administer when people are adding their own data to the back end. But anyway, INSERT OR REPLACE performance is transactions and a few pragmas is now pretty good.

Lazaruslong · Jan 6, 2015

TheRaven said:
No (read my previous post, page 113), I was using the tool in local mode, with only my own data (as a prettier version of my excel sheet, as the description for this tool indicates that you can), but it now turns out that my data is uploaded anyway (or anyway it has been uploaded at the last two updates, that dload/upload everything again), and every trade route I have uploaded is ruined within a day (That was not something I worried about before, I just didnt want to upload my sometimes wrong data and ruin other peoples data, and ruin my own database with systems I had not visited and scanned myself).

It sounds like you really want cmdr's log (https://forums.frontier.co.uk/showthread.php?t=74171&highlight=trading+tool) not Slopey's. Just your data locally, nothing uploaded for others to use and nothing downloaded so you won't feel guilty about leaching others work.

Slopey · Jan 6, 2015

TheRaven said:
No (read my previous post, page 113), I was using the tool in local mode, with only my own data (as a prettier version of my excel sheet, as the description for this tool indicates that you can), but it now turns out that my data is uploaded anyway (or anyway it has been uploaded at the last two updates, that dload/upload everything again), and every trade route I have uploaded is ruined within a day (That was not something I worried about before, I just didnt want to upload my sometimes wrong data and ruin other peoples data, and ruin my own database with systems I had not visited and scanned myself).

Your added data has ALWAYS been uploaded when you're in local mode, since the very first verison of the BPC. If you want to keep your data totally private - this is NOT the tool you're looking for as I've said on many occasions.

But it's unlikely that uploading that data made everyone zoom to that route - look at the current fave in Asasne (or whatever it's called) - we've all been hitting it for days and it's moved around 10% down in profitability.

I've yet to have a coherent example where the BPC has demonstrably destroyed a trade route. To date, it's never happened as far as I can tell unless there were only 7 tons of stuff on the station in the first place.

Slopey · Jan 6, 2015

NoTones said:
i sent the pm again y-day so i guess you could have missed that one, however i sent original msg to check it 2weeks ago and you never responded at-all so its not me being rude

As you're aware, I found them - I had to trawl through each entry as it doesn't show your email addy where your forum name was referenced so they're tricky to tie back from just a glance.

I've also added a note to the options page in the next version to point out that by default, I don't acknowledge them, but I'll try and set a message on Paypal to that effect.

However, it's very much appreciated, and thank you.