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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

Getting a List of BPCs

First post
Author
Previous Topic Next Topic
Hippaforalkus Alteranus
Outback Steakhouse of Pancakes
Deepwater Hooligans
#1 - 2015-01-31 20:13:02 UTC
So I have acquired a rather large amount of BPCs, and I would like to sell them. Is there an easy way to list the blueprint copies and their ME/PE and runs? It's a large number so I'd rather not type them up in a list format, but if I could simply copy the info from some where, that'd be great!
Vartan Sarkisian
Tannhauser C-Beam
#2 - 2015-01-31 20:59:02 UTC
No. To my knowledge there is no way (in game at least) for you to show that information.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2015-01-31 21:07:47 UTC
There is an api for it.

One option would be to use google sheets, load https://github.com/fuzzysteve/eve-googledocs-script/blob/master/blueprints.gs into the script editor, then use loadBlueprints to pull them all into the sheet (with an appropriate api key)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Nolen Cadmar
Caldari Provisions
Caldari State
#4 - 2015-02-01 00:14:41 UTC  |  Edited by: Nolen Cadmar
Your other option is using importXML in Google Docs

A1=API Key ID, A2=verification code, A3=character ID (not needed if corp api key)
Here's the formulas to input:

Character-owned BPC's:
=importxml(concatenate("https://api.eveonline.com/char/Blueprints.xml.aspx?keyid=",A1,"&vcode=",A2,"&characterid=",A3),"//row[@quantity=-2]/@typename")

Corp-owned BPC's:
=importxml(concatenate("https://api.eveonline.com/corp/Blueprints.xml.aspx?keyid=",A1,"&vcode=",A2),"//row[@quantity=-2]/@typename")

This will pull up the BPC names. If you want to pull BPO's, change the "quantity=-2" to "quantity>-2" To change the data item you import, just change the "typename" to one of the items in the list below:
itemID
locationID
typeID
typeName
flagID
quantity (-1 for BPO, -2 for BPC, positive number if stack of packaged blueprints)
timeEfficiency
materialEfficiency
runs

Nolen's Spreadsheet Guru Services

Pre-made spreadsheets available covering market, manufacturing and more!

Custom requests welcome!

Sheet Screenshots
Shiloh Templeton
Cheyenne HET Co
#5 - 2015-02-01 14:02:38 UTC  |  Edited by: Shiloh Templeton
jEveAssets - you can create a filter on " 'name' contains 'bpc' "

this will produce a spreadsheet list of your bpc's along with the ME / TE in a far right hand column. I think 'typecount' = runs.

export to a spreadsheet and modify as needed.
Amely Miles
Second Exile
#6 - 2015-02-01 14:04:31 UTC
if you want i could sell you my bpo spreadsheet .... green at end of the product name means we own it ...Red means we don't https://docs.google.com/spreadsheet/pub?key=0Ah_NQEoEKQx6dHEtVEJhaXFIWFFxTUJwcFA3U3FXRFE&gid=3 500mil :)

As I slipped my finger slowly inside her hole, I could immediately feel it getting wetter and wetter.

I took my finger back out and within seconds she was going down on me.

"I really need a new boat," I thought to myself.
Regnar Avastum
#7 - 2015-02-01 16:34:03 UTC
Shiloh Templeton wrote:
jEveAssets - you can create a filter on " 'name' contains 'bpc' "

this will produce a spreadsheet list of your bpc's along with the ME / TE in a far right hand column. I think 'typecount' = runs.

export to a spreadsheet and modify as needed.


This is by far the easier method if you don't want to get into additional work.

Sorry to hijack the thread but I have a related questions. I read a devblog from a while back that stated the contract api gives you the item types included and if it's a bpc/bpo/item. If I'm not mistaken the "rawquantity" the same as with the assets api tells you if it's a BPC or BPO. Am i missing something or does the current contract api not supply this information anymore?

♔ ℜegnar's High-End Spreadsheets ♔™
Nolen Cadmar
Caldari Provisions
Caldari State
#8 - 2015-02-01 16:48:35 UTC
Regnar Avastum wrote:
This is by far the easier method if you don't want to get into additional work.

Sorry to hijack the thread but I have a related questions. I read a devblog from a while back that stated the contract api gives you the item types included and if it's a bpc/bpo/item. If I'm not mistaken the "rawquantity" the same as with the assets api tells you if it's a BPC or BPO. Am i missing something or does the current contract api not supply this information anymore?


Contract Items does have RawQuantity. -1 = BPO, -2 = BPC

Nolen's Spreadsheet Guru Services

Pre-made spreadsheets available covering market, manufacturing and more!

Custom requests welcome!

Sheet Screenshots
Regnar Avastum
#9 - 2015-02-01 21:24:29 UTC
Nolen Cadmar wrote:
Regnar Avastum wrote:
This is by far the easier method if you don't want to get into additional work.

Sorry to hijack the thread but I have a related questions. I read a devblog from a while back that stated the contract api gives you the item types included and if it's a bpc/bpo/item. If I'm not mistaken the "rawquantity" the same as with the assets api tells you if it's a BPC or BPO. Am i missing something or does the current contract api not supply this information anymore?


Contract Items does have RawQuantity. -1 = BPO, -2 = BPC


"/char/ContractItems.xml.aspx"

Using the above the resulting data doesn't seem to include the rawquantity data. Could I be missing something?

♔ ℜegnar's High-End Spreadsheets ♔™
Nolen Cadmar
Caldari Provisions
Caldari State
#10 - 2015-02-01 21:59:40 UTC  |  Edited by: Nolen Cadmar
Regnar Avastum wrote:

"/char/ContractItems.xml.aspx"

Using the above the resulting data doesn't seem to include the rawquantity data. Could I be missing something?


That's the right one. I checked 2 contracts just now (one with a blueprint, and one without), neither had rawquantity. It's listed as a column, but was not present in the data. See screenshot below. Not really sure what's going on here........

http://i.imgur.com/H82uQgw.png

EDIT: I found the dev blog(from 2011) you were referring to. It also claims that raw quantity is an attribute that should be returned.

Link to dev blog
Link to chart with attributes for Contract Items API

Nolen's Spreadsheet Guru Services

Pre-made spreadsheets available covering market, manufacturing and more!

Custom requests welcome!

Sheet Screenshots
Regnar Avastum
#11 - 2015-02-01 22:07:03 UTC
Nolen Cadmar wrote:
Regnar Avastum wrote:

"/char/ContractItems.xml.aspx"

Using the above the resulting data doesn't seem to include the rawquantity data. Could I be missing something?


That's the right one. I checked 2 contracts just now (one with a blueprint, and one without), neither had rawquantity. It's listed as a column, but was not present in the data. See screenshot below. Not really sure what's going on here........

http://i.imgur.com/H82uQgw.png

EDIT: I found the dev blog(from 2011) you were referring to. It also claims that raw quantity is an attribute that should be returned.

Link to dev blog
Link to chart with attributes for Contract Items API


Yep, that's exactly the info I based my tests on. I remember at one point jeveassets had it working so you could see bpcs in contracts but not anymore. That got me wondering.

♔ ℜegnar's High-End Spreadsheets ♔™