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.
 

extracting material need for all t2 rig BPC
Author
Previous Topic Next Topic
Zosius
The Nordic Associates
Insidious.
#1 - 2012-10-13 13:04:03 UTC
Hello,

I am trying to upload material requirements for t2 rig production into my excel. I've been reading a lot last few days and there might be similar solutions, but perhaps some of them were too complicated for me as I am quite new to DB business.

As I don't need to reinvent another manufacturing tool, all I want is to have production material data for all t2 rig BPC for my self. I found some nice site: http://www.fuzzwork.co.uk/ where you can import XML data for each blueprint, however that is a lot of manual work to do for each bpc and I was wondering if I an have something similar to extract all list. I also encountered some eve dev site - http://wiki.eve-id.net/Bill_of_Materials, but not sure how to make those codes work.

In the end I just want spreadsheet to calculate total t2 salvage needs for a lot of random t2 rig BPCs.

Thanks in advance for your help
Zosius

http://cloakybastard.blogspot.com
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-10-13 17:23:54 UTC  |  Edited by: Steve Ronuken
What ME levels for the blueprints, or would you take care of the ME calculation yourself?

Oh, and how would you want it formatted?

A single sheet of:
rig name(/id), material name(/id), quantity ?

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Zosius
The Nordic Associates
Insidious.
#3 - 2012-10-14 16:38:08 UTC
Hi. All i need is data. All bpc with materials in one sheet. Formatting and formulas i can work on my own. Regarding ME it is usually same -0 as i use them from mag sites

Thanks

http://cloakybastard.blogspot.com
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2012-10-14 17:02:05 UTC
http://www.fuzzwork.co.uk/dump/t2rig.csv

It's missing the 'extra' materials, but as far as I'm aware, the only ones on t2 rigs are RAMs.


In case you're interested, the query is below. The list of numbers are all the market groups for rigs.There might be (probably is) a cleaner way to select them, but this works. (I didn't want to have to go looking at dgmTypeAttributes to find which ones fit into rig slots from that)

select rig.typename,rig.typeid,material.typename,material.typeid,invTypeMaterials.quantity from invTypes rig,invTypes material,invTypeMaterials,invMetaTypes where rig.marketgroupid in ( 1206,1207,1208,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239) and rig.typeid=invTypeMaterials.typeid and invTypeMaterials.materialTypeID=material.typeid and rig.typeid=invMetaTypes.typeid and invMetaTypes.metaGroupID=2;

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Zosius
The Nordic Associates
Insidious.
#5 - 2012-10-15 20:23:07 UTC
That should work fine! Thanks alot Steve!

http://cloakybastard.blogspot.com