These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

SDE, Blueprint Base Materials & an Idiot

First post
Author
Previous Topic Next Topic
Valix VonVoggelVoff
School of Applied Knowledge
Caldari State
#1 - 2014-08-09 20:13:51 UTC
Hey guys.

After spending 2 days trawling the forums, the internet, racking my brain and getting through way too many cancer sticks I've given in. I've installed the MS SQL thing, restored the database and everything works fine. Does what it says on Noise's website. Further than that, I will admit I have no clue. I don't know any programming languages, I've never worked with databases and my only experience with SQL was when I did one of those myphp websites.

My end goal is to have an excel spreadsheet with a list of (T2) module blueprints & their base bill of materials, basically as seen in game when you do a show info on an untouched BP. Then I can do my own thing with that. It *sounds* to me like a very simple task, judging by what I've read, and while I am an intelligent guy, I'll readily admit it makes me feel stupid enough to cry into my pillow.

Query the database for a T2 BPO's BoM and output it into a readable format. Then copy / export / magic? it into excel.

I'd like to be able to groups at once. Like all the battlecruisers or all the shield modules T2 BPOs.


That's it. Can anyone help. Either give me some code that can do something like that, possibly with an example group or point me in the direction of something already done? I'm 90% positive that someone somewhere has the exact thing I'm looking for - An excel sheet with column of blueprints, a row of materials and lots of numbers in between.

Thanks.
Rutger Janssen
Chanuur
The Initiative.
#2 - 2014-08-09 21:23:20 UTC
The MS SQL release doesn't contain the blueprint info, you'll need to parse the blueprints.yaml file. Or maybe use a conversion from Steve.

If you can't program, you'll have a hard time doing it yourself. Either you use free websites available or pay someone to create the customised tools you want. Developing tools like that take hours/days and I consider them very valuable trade secrets.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2014-08-09 21:55:09 UTC
If you use the conversion I've done (see the SDE link on my site) take a look at the industryActivityMaterials.xls file. (bz2 files can be uncompressed by 7zip)

You'll probably also want the invTypes and industryActivityProducts files too.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Valix VonVoggelVoff
School of Applied Knowledge
Caldari State
#4 - 2014-08-09 22:49:54 UTC  |  Edited by: Valix VonVoggelVoff
Steve Ronuken wrote:
If you use the conversion I've done (see the SDE link on my site) take a look at the industryActivityMaterials.xls file. (bz2 files can be uncompressed by 7zip)

You'll probably also want the invTypes and industryActivityProducts files too.



Steve my man you are legend. While I may be doing it the long way and very unorthodox, you have given me exactly what I want. Albeit I only needed 2 of the sheets you recommended I think (it's quite possible I have made terrible mistakes :P).

No custom programs needed, no coding, only taken about 20 minutes, didn't have to pay anyone although I did use your conversions (merely opened in excel. Now I just need to do a little research into how to make the materials go into rows while the blueprints just stay columned. Also manually delete T1 stuff and other things I don't want. You know what I mean. =)

Cheers

http://i.imgur.com/zePes0l.jpg