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.
 

PI Combinations

First post
Author
Previous Topic Next Topic
Leoric Firesword
Imperial Shipment
Amarr Empire
#1 - 2015-06-24 15:15:15 UTC
This may have already been discussed, but my search fu is failing this morning.

Is there a way from the data dump to get the combinations of PI products into a final product?

Example: Mechanical Parts and Consumer Electronics produces Robotics
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-06-27 16:31:16 UTC
planetSchematicsTypeMap is the table you're looking for.

Along with planetSchematics for the name of the schematic.

planetSchematicsTypeMap defines both the inputs (where isinput is 1) and the outputs (where it's 0)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Vinoth Gebrial
State War Academy
Caldari State
#3 - 2015-07-03 19:13:18 UTC
Steve Ronuken wrote:
planetSchematicsTypeMap is the table you're looking for.

Along with planetSchematics for the name of the schematic.

planetSchematicsTypeMap defines both the inputs (where isinput is 1) and the outputs (where it's 0)


Where can I find this table? I don't really know my way around the resources yet
Mr Mac
Dark Goliath
#4 - 2015-07-04 07:09:26 UTC
Vinoth Gebrial wrote:
Steve Ronuken wrote:
planetSchematicsTypeMap is the table you're looking for.

Along with planetSchematics for the name of the schematic.

planetSchematicsTypeMap defines both the inputs (where isinput is 1) and the outputs (where it's 0)


Where can I find this table? I don't really know my way around the resources yet


In MSSQL Database Backup
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2015-07-04 19:25:38 UTC
The official SDE is one option.

The conversions I do is another.

https://www.fuzzwork.co.uk/dump/latest/ for individual tables, and xls versions.

https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2 for a full sqlite database (conversion from official)
https://www.fuzzwork.co.uk/dump/mysql-latest.tar.bz2 for a mysql one.
https://www.fuzzwork.co.uk/dump/postgres-latest.dmp.bz2 for a postgres one.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Vinoth Gebrial
State War Academy
Caldari State
#6 - 2015-07-07 02:05:11 UTC
Thanks. I tried the ones from fuzzwork and they're working great for me.