Hi.
Have I gone blind, or is the return trip checkbox missing?
Thanks.
Have I gone blind, or is the return trip checkbox missing?
Thanks.
[RELEASE] Slopey's BPC Market Tool! - New version!
- Thread starter Slopey
- Start date
ShadowGar
Banned
Slopey, our group has been bugging me to find a private database tool to store everything like your tool but I have been having a hard time finding anything. So I had to ask, will your web version of your tool and a private database be released at some point for guys like me that wants to host our own site privately for just members only and not public access?
I've taken it off for now, as per the news item nobody ever reads. It's not been there for around 4 weeks now.
It'll be making a return shortly
Apologies, I clearly missed that one
Last edited:
Is there any way to basically force the BPC to show old data, as in EVER entered by anyone?
"okay, ugh, clear my database and redownload to deal with duplicate entries for filling out a station and every single commodity that will now show up in the BPC. Whatever. Now let's go back to that system I was at just the other day-wait, why are there now zero stations listed in my BPC here?"
I mean, I punched in two stations for Glusargiz last night (oddly enough, they had the exact same commodities list, prices, and stocks. Gotta love that Dynamic economy). Now I look in the BPC after punching in two stations at HIP 116436 and it's back to no stations listed for Glusargiz. Asvienses is also deciding to not list any stations for me anymore. Will the stuff I just entered in for HIP 116436 just vanish/refuse to show up in the BPC for me unless somebody updates it within 24 hours?
Can't even turn to Thrudd's for punching in "new" stations because the page just sits there when I try to use my ranked up permissions to add new stations, so it's starting to look like I'm just out of luck for wanting to use any trade programs for anything but what is already there, and already popular.
Is there is some answer that doesn't involve telling me "Oh, just open up a datafile and make sure 65k row(s) of code are consistent, totally easy we swear!" (Is admitting I'm no good at digging through code and worried ill break something trying to attempt such advice considered rude? probable will be) for getting stations to not just vanish on me, let alone get listed in the first place? How can I even tell if the stations I've been entering data for even matters when less than a day later my BPC decides "What stations?".
I mean, it will still spit out plenty of trade routes with what is already in there (Note to self, get around to buying that Type-6). But it's looking like I'm wasting my time trying to contribute or look for anything off the BPC beaten path if places I've visited less than a day ago are just a blank.
EDIT: While I didn't enter them into the BPC again, I just did trip to Glusargiz system. Chacornac Hub, and Bauman Dock indeed have identical listings, prices, and stocks. Didn't accidentally U turn and enter the same station's numbers for two places.
Anybody need two empire stations nearby eachother that have 1,225,586 Lepidolite each?
"okay, ugh, clear my database and redownload to deal with duplicate entries for filling out a station and every single commodity that will now show up in the BPC. Whatever. Now let's go back to that system I was at just the other day-wait, why are there now zero stations listed in my BPC here?"
I mean, I punched in two stations for Glusargiz last night (oddly enough, they had the exact same commodities list, prices, and stocks. Gotta love that Dynamic economy). Now I look in the BPC after punching in two stations at HIP 116436 and it's back to no stations listed for Glusargiz. Asvienses is also deciding to not list any stations for me anymore. Will the stuff I just entered in for HIP 116436 just vanish/refuse to show up in the BPC for me unless somebody updates it within 24 hours?
Can't even turn to Thrudd's for punching in "new" stations because the page just sits there when I try to use my ranked up permissions to add new stations, so it's starting to look like I'm just out of luck for wanting to use any trade programs for anything but what is already there, and already popular.
Is there is some answer that doesn't involve telling me "Oh, just open up a datafile and make sure 65k row(s) of code are consistent, totally easy we swear!" (Is admitting I'm no good at digging through code and worried ill break something trying to attempt such advice considered rude? probable will be) for getting stations to not just vanish on me, let alone get listed in the first place? How can I even tell if the stations I've been entering data for even matters when less than a day later my BPC decides "What stations?".
I mean, it will still spit out plenty of trade routes with what is already in there (Note to self, get around to buying that Type-6). But it's looking like I'm wasting my time trying to contribute or look for anything off the BPC beaten path if places I've visited less than a day ago are just a blank.
EDIT: While I didn't enter them into the BPC again, I just did trip to Glusargiz system. Chacornac Hub, and Bauman Dock indeed have identical listings, prices, and stocks. Didn't accidentally U turn and enter the same station's numbers for two places.
Anybody need two empire stations nearby eachother that have 1,225,586 Lepidolite each?
Last edited:
I don't think so. IIRC, the server-side database automatically purges entries older than 48 hours. I believe you can set your local app to keep entries for arbitrary (if not infinite) lengths of time, but once an entry older than 48h is gone, it's gone.
Thanks for the heads up, in hindsight I really should have realized this due to the million mentions of "48 hours old". Thing is, it hasn't even been 24 hours since I punched in some of my examples, I guess the purge happens faster if it's a not very profitable or visited system?
I know for a fact this thing will still be amazingly helpful because so long as it involves stuff the BPC considers to exist, it will spit out a zillion 100k trades within X radius starting from Y system for "Baby's first Typr-6" cargo capacity and investment. If your primary concern is the space dollars, then nothing to worry about.
For what the BPC set out to do, it seems to do it incredibly well. So if the only "Problem" is stations entered for novelty or personal reasons (Hey, an actual Empire owned extraction station bigger than a platform!... Yes I know there are better independent owned ones two feet away that actually have Indium, what's your point?) may not last if I end up having to clear my DB for any reason, oh well.
@Slopey: Does the fix zero timestamps start from scratch everytime or can I kill it in the middle? I've been killing it when I go to bed/work.
The first time I ran it at the weekend it ran for 9 hours and did 600,000 updates. I've been running it on the evenings and mornings doing 120,000 and 50,000 respectively and it is still not complete.
If it is updating null timestamps surely it is just an update/where statement?
The first time I ran it at the weekend it ran for 9 hours and did 600,000 updates. I've been running it on the evenings and mornings doing 120,000 and 50,000 respectively and it is still not complete.
If it is updating null timestamps surely it is just an update/where statement?
I'm pretty sure that's a "no", if you want to use this tool then the price is that you share your data with everyone.
Slopey
Volunteer Moderator
It starts from scratch - but I dunno why it should take so long. It's transaction based however so if you quit it, it won't do anything. If you're rocking 600,000 rows, you'll have a load of historical data in there. That's about 11,000 systems worth - might be an idea to clear down the ED4.db (or back it up then delete it) and let the BPC populate from scratch.
- - - - - Additional Content Posted / Auto Merge - - - - -
No - you'll only ever get the last 48 hours max from an update, so if you don't use the BPC for a week, then launch it, you'll only get the last two days updates.
Note that I'm re-writing the web version at the moment (almost finished - it's a proper web app version of the BPC now), which DOES search the entire historic database. However, note that I purge that data from time to time so the oldest record is around the 1st Jan currently.
- - - - - Additional Content Posted / Auto Merge - - - - -
Nope. I have no desire to release a private version I'm afraid. There are other tools out there which could do that with shared data files etc... The purpose of the BPC is to share information ultimately - if I put it out as a single user/group system, everyone will keep their data to themselves, and the core purpose of the tool is lost. There are several other offline only tools, and I don't see the need to become yet another one of those.
I'm trying your tool, but I found a lot of exagerately wrong prices, in many occasions.
Today I found Semiconductors sold @ 6,569 Cr in a distant system (exciting, so I made the travel) while actually the correct price was 736 Cr when I got there. Totally useless. Same yesterday for another couple of commodities, while the ones of today were missing, so apparently they are a new entry.
How does this happen? Maybe something wrong with OCRs or just jokes?
Today I found Semiconductors sold @ 6,569 Cr in a distant system (exciting, so I made the travel) while actually the correct price was 736 Cr when I got there. Totally useless. Same yesterday for another couple of commodities, while the ones of today were missing, so apparently they are a new entry.
How does this happen? Maybe something wrong with OCRs or just jokes?
Could be a typo, could be a troll, highly unlikely to be an OCR error as that ususally is missing digits rather than extra ones. A price 10 times the normal rate should always be treated with high suspicion, I suppose it's possible that there are events that briefly spike the prices but I've not heard of that happening ever. I hope you entered the correct price so that no-one else made the same mistake!
Slopey
Volunteer Moderator
Could be either - please update them to the correct values
- - - - - Additional Content Posted / Auto Merge - - - - -
Hi All
If you're getting issues when searching with "Object reference not found" errors etc - can you please try the following:
In the BPC program directory - you'll see 3 Layout_*.xml files (Layout_BPC_Grid.xml, Layout_System_Grid.xml, Layout_Commod_Grid.xml).
Please delete them, then restart the BPC.
See if that helps. I think the errors are coming about after I changed the timestamp columns back to minutes from actual times, and the layouts haven't maybe been overwritten.
Cheers,
S.
What are we supposed to be looking at there? There's no Semiconductors listing on those screenies, what's wrong and what should it be? *Edit* Oh, is it the sell price for copper? I have noticed that sometimes my price updates appear straight away, and sometimes they don't.
Not sure what the "mins aged" columns are supposed to be, I've never seen them before, but there are positive and negative numbers there. I guess it's supposed to be the age of the data, in which case negative numbers don't make sense unless there is a timezone discrepancy. If I update it now, and you're in Australia, it could look like data from 11 hours in the future, and it could override data that you entered afterwards because of that.