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

Slopey

Volunteer Moderator
It seems that EliteOCR 0.3.5.1 exports it's data in .xlsx format, Slopey's will only import .csv
After converting the .xlsx to .csv, when trying to import the new .csv, Slopey's gives me an "Unable to parse the CSV file..." error.

Would it be possible to import the .xlsx instead in the next update?

Or is there something I'm missing to get the two current versions of software to work together?

Change the file type in the EliteOCR export file dialog. Can get EliteOCR queries over on it's own topic please? I feel like I'm doing support for both sometimes.
 
Hey Slopey, great tool and the OCR tool has made it easier than ever to enter data. I think there may be a bug around intra-system trades and the 'Within Distance' checkbox. I'm currently testing using a system I've entered data for called 'Lemastshi' and when set both From and To to that system and I have the distance filter checked it doesn't show anything. If I uncheck it and click search it shows the data as expected.
 
Change the file type in the EliteOCR export file dialog. Can get EliteOCR queries over on it's own topic please? I feel like I'm doing support for both sometimes.

Sorry about that, I thought there would be a setting in your program, that's why I posted here.
 

Slopey

Volunteer Moderator
Hey Slopey, great tool and the OCR tool has made it easier than ever to enter data. I think there may be a bug around intra-system trades and the 'Within Distance' checkbox. I'm currently testing using a system I've entered data for called 'Lemastshi' and when set both From and To to that system and I have the distance filter checked it doesn't show anything. If I uncheck it and click search it shows the data as expected.

Yeah - I'm aware of that - it's fixed in the next version.
 
How is that different from setting "Lugh" as the From, and "ANY" for To, and then setting "Within Distance" to 100?

It is different in that in what you suggest, Lugh has to be part of the route, what we're talking about is basically defining a bubble and searching for ANY/ANY routes within that bubble, with the center of the bubble being any given system you input. So basically doing an ANY/ANY search with the added criteria that the systems must be within 100ly from lugh in this example, but lugh doesn't have to be part of the route.

Edit: Oh and just to make it clear, I'm not trying to be like "I DEMAND THIS FEATURE", I just thought it was a good idea and wanted to make it clear what was suggested. BPC is already an amazing amazing tool so as far as I care you could retire and still remain a completely awesome contributor to the world of ED.
 
Last edited:

Slopey

Volunteer Moderator
It is different in that in what you suggest, Lugh has to be part of the route, what we're talking about is basically defining a bubble and searching for ANY/ANY routes within that bubble, with the center of the bubble being any given system you input. So basically doing an ANY/ANY search with the added criteria that the systems must be within 100ly from lugh in this example, but lugh doesn't have to be part of the route.

Ahhhhh - ok, so you want to run an Any to Any search, but only for a set of stations within a set distance of a station. I get it now.
 
Ahhhhh - ok, so you want to run an Any to Any search, but only for a set of stations within a set distance of a station. I get it now.

Exactly, because a general any to any search is... insane :p and also it'd be awesome for going like "I now live here due to slave conflict or whatever, lets see what trade opportunities are in the area"
 
Hi Slopey, I started getting this error out of a sudden:
Code:
See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException: Unrecognized configuration section userSettings. (C:\Users\Ionut\AppData\Local\Slopey.com\ED_BPC.exe_Url_j2trlr05sxlnel0fdhnyxhfbyub05lge\4.0.0.1\user.config line 3)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
   at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
   at System.Configuration.BaseConfigurationRecord.ThrowIfInitErrors()
   at System.Configuration.ClientConfigurationSystem.OnConfigRemoved(Object sender, InternalConfigEventArgs e)
   --- End of inner exception stack trace ---
   at System.Configuration.ConfigurationManager.PrepareConfigSystem()
   at System.Configuration.ConfigurationManager.RefreshSection(String sectionName)
   at System.Configuration.ClientSettingsStore.ReadSettings(String sectionName, Boolean isUserScoped)
   at System.Configuration.LocalFileSettingsProvider.GetPropertyValues(SettingsContext context, SettingsPropertyCollection properties)
   at System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider)
   at System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName)
   at System.Configuration.SettingsBase.get_Item(String propertyName)
   at System.Configuration.ApplicationSettingsBase.GetPropertyValue(String propertyName)
   at System.Configuration.ApplicationSettingsBase.get_Item(String propertyName)
   at ED_BPC.Settings.get_UpdateRequired()
   at A.ce60847a8ca1358480ac48a994b33eaa6.c12723b1ad8f9de2ad560c75f58721efc(Object cf31c6b95f279e766a628123301769734, EventArgs c685f2fe3e56b15489d3a72ae97ae0d12)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at DevExpress.XtraEditors.XtraForm.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at DevExpress.XtraEditors.XtraForm.WndProc(Message& msg)
   at DevExpress.XtraBars.Ribbon.RibbonForm.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.0.0.1
    Win32 Version: 4.0.0.1
    CodeBase: file:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/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:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/DevExpress.BonusSkins.v13.2.DLL
----------------------------------------
DevExpress.Utils.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/DevExpress.Utils.v13.2.DLL
----------------------------------------
DevExpress.XtraBars.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/DevExpress.XtraBars.v13.2.DLL
----------------------------------------
DevExpress.XtraEditors.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/DevExpress.XtraEditors.v13.2.DLL
----------------------------------------
DevExpress.Data.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/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:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/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.XtraCharts.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/DevExpress.XtraCharts.v13.2.DLL
----------------------------------------
DevExpress.Charts.v13.2.Core
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/DevExpress.Charts.v13.2.Core.DLL
----------------------------------------
DevExpress.XtraGrid.v13.2
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/DevExpress.XtraGrid.v13.2.DLL
----------------------------------------
DevExpress.XtraCharts.v13.2.UI
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/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:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/DevExpress.Printing.v13.2.Core.DLL
----------------------------------------
DevExpress.XtraCharts.v13.2.Wizard
    Assembly Version: 13.2.9.0
    Win32 Version: 13.2.9.0
    CodeBase: file:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/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:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/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:///D:/Games/EDLaunch/Products/FORC-FDEV-D-1002/Logs/Devart.Data.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.

Any idea what's wrong?
 
Nope. But did you really install the BPC in your ED Logs directory????? Why?

Nope! Not sure why it was thinking that, I reinstalled it and it appears to work for now. Was confused since I didn't do anything to it and just started throwing errors.
 
I have refrained from using your tool (or any) in the past, but this makes it interesting... I might have to check it out ;)
Thanks Slopey.

Edit: Hmm, actually I don't think I need to, not even in offline / local mode.. trading in ED seems to be much improved over the earlier gamma releases.. not perfect... missing 'snapshots' which is why I considered this tool in the first place, but overall more logical.
Trade is still in that you can take a bath buying a product that is logically supplied in one place and trying to sell in another also that should be logically a consumer.

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

UPDATED to v4.0.0.1 - 1831UTC 16-12-14

Hi All

<snip>
In other news, CSV importing is ready to go (just need to prod seeebek about something), and EDDM updating will be added in due course (nobody seems to be using it at the moment, but Wolvie is excited as usual ;)).
.

I can't get it to import from a CSV to save my life. I'm using EliteOCR 0.3.5 and your trade tool 4.0.0.1. Is there some trick I'm not doing right?
 
Thanks Slopey! I don't find trial and error trading fun at all, I think its stupid, as if in 3300 you wouldnt have immediate access to commodities data at your finger tips.

When they advertise "Play it your own way," what they mean is "Play it the way we want you to play, which is fly empty to some stations gathering data and hope it stays current when you load up with trade goods and make the runs for real."
 
Not sure what I am doing wrong but when I hit the Save data button after manually entering a commodity I just get a crash to desktop.

I am at Fujimori Terminal in STKM 1-626. To test the uploading of data out I am trying to upload the price of explosives. I enter the following:

I type 'S' in the system field - immediately STKM 1-626 comes up so I choose that.

Fujimori Terminal does not appear in the dropdown list so I enter that (as written here).

I choose Explosives from the Commodity drop down list, enter 365 in the 'Sell box'. Click Add, Click Save Data. Result is a crash to desktop with no error message. Running Win 8.1 and BPC 4.0.0.1

What am I missing, something simple I am sure?

Appreciate any help.
 
I'm having troubles with uploading CSV's. When trying to upload the CSV nothing happens, no crash, no loading nothing whatsoever. Have tried with a couple of csv's and none of them are working. This is with the station name and starport registered. Any tips?Have tried reinstalling .net framework 4.52 but no use.
 
Last edited:
Not sure what I am doing wrong but when I hit the Save data button after manually entering a commodity I just get a crash to desktop.

I am at Fujimori Terminal in STKM 1-626. To test the uploading of data out I am trying to upload the price of explosives. I enter the following:

I type 'S' in the system field - immediately STKM 1-626 comes up so I choose that.

Fujimori Terminal does not appear in the dropdown list so I enter that (as written here).

I choose Explosives from the Commodity drop down list, enter 365 in the 'Sell box'. Click Add, Click Save Data. Result is a crash to desktop with no error message. Running Win 8.1 and BPC 4.0.0.1

What am I missing, something simple I am sure?

Appreciate any help.

OK, please ignore this. It seems that BPC was pointing to my EDlaunch\log folder. When I changed this to 'EDLaunch\Products\FORC-FDEV-D-1002\Logs' all was well.

Great tool, thanks Slopey!
 
Any idea why the commodity picker on the Commodity Data tab is full of system names instead of commodities?

*Edit* Re-starting seems to have fixed it.

On the subject of the commodity data, if you click on the commodity name and start typing something beginning with "A", e.g. "Aquaponic Systems", the first "A" immediately populates the name with "ANY" and starts searching! Several minutes later, after it's populated the list with every commodity at every known station in the galaxy, you can finish typing in the name of the commodity that you are actually looking for.
 
Last edited:
Hi Slopey,
really really nice that you put all this effort in the tool!
I am really exited about the import function to get it running with Elite OCR.

I am trying to import from a csv file right now but it does not work. I select the file and click open but nothing happens.
No error message but nothing happens.

In addition the Tool does not recognize where I am at the moment. It always says Acihaut..

Any idea how to fix that?

All the best,
Undoreal
 

Slopey

Volunteer Moderator
Hi Slopey,
really really nice that you put all this effort in the tool!
I am really exited about the import function to get it running with Elite OCR.

I am trying to import from a csv file right now but it does not work. I select the file and click open but nothing happens.
No error message but nothing happens.

In addition the Tool does not recognize where I am at the moment. It always says Acihaut..

Any idea how to fix that?

All the best,
Undoreal

Read up a bit - it's covered in depth earlier in the topic. Or pop into the BPC chatroom and someone will help.

You need to add VerboseLogging="1" into your AppConfig.xml, then set the log directory correctly in the BPC *and* in EliteOCR - (Elite OCR queries should be done in EliteOCR's topic please).
 
Last edited:
It doesn't bother me if others use this stuff... but I like the in-game tools, even if I make less. A game is a challenge, and conquering the challenge is fun. It makes sense that a station would only really know supply and demand. It makes sense that you might have to pay for trade data from local systems.
That's like saying it makes sense you can't find out what the Nikkei index is doing in the UK. People who trade have reasons to know as much about the market as possible and when they have that need someone fills it. You can go to CNN, CNBC, Fox News, and about 30 other places and you can find out any and all given markets on the planet. You could also bet in 33xx there would be more data sources and the only limitation would be how fast the information can get there. This "You can only get information about the market in this station," is an artifact from the original Elite which was limited to the 38k data and program you could cram into a crappodore 64 or Crapple //e.
 
Trade is still in that you can take a bath buying a product that is logically supplied in one place and trying to sell in another also that should be logically a consumer.

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



I can't get it to import from a CSV to save my life. I'm using EliteOCR 0.3.5 and your trade tool 4.0.0.1. Is there some trick I'm not doing right?
Found the problem with the CSV I had EliteOCR set to Horizontal Export which gorked the whole thing out. Thanks for the amazing tools that should already be in game.
 
Back
Top Bottom