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.
 

Import your personal blueprints efficiency levels

First post
Author
Previous Topic Next Topic
Jaseac
Ghost of Shadow Union
#1 - 2017-01-25 15:38:49 UTC
Is it possible to import into a spreadsheet the blueprints you own into column a, and then for column b your material efficiency, and column c your time efficiency? And if so what is the formula to do it?
Tau Cabalander
Retirement Retreat
Working Stiffs
#2 - 2017-01-25 18:30:46 UTC
I recommend posting such questions in the EvE Technology Lab, where the API gurus hang-out.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2017-01-25 21:07:16 UTC
Jaseac
Ghost of Shadow Union
#4 - 2017-01-26 02:19:25 UTC
Steve Ronuken wrote:
if it's for google docs

https://github.com/fuzzysteve/eve-googledocs-script/blob/master/blueprints.gs




I spent 3 hours trying to get that to work, will not work for me, consistent errors with the url's its trying to connect to
Cire Xinehp
Noir.
Shadow Cartel
#5 - 2017-01-26 13:11:11 UTC  |  Edited by: Cire Xinehp
Jaseac wrote:
Is it possible to import into a spreadsheet the blueprints you own into column a, and then for column b your material efficiency, and column c your time efficiency? And if so what is the formula to do it?



Yes is it.

Ok, here you go:

This will give you your character list for the selected account, this is where you get your character id to use in the next part.

https://api.eveonline.com/account/Characters.xml.aspx?keyID=[INSERT KEY ID]&vCode=[INSERT VERIFICATION CODE]


This will give you all prints for the selected character with Print name, ME, TE, Runs Etc

https://api.eveonline.com/char/Blueprints.xml.aspx?keyID=[INSERT KEY ID]&vCode=[INSERT VERIFICATION CODE]&characterID=[INSERT CHARACTER ID]


You'll need to the convert this XML to CSV format (there are tools free tools online that can make this easier) and you can then import that into Google docs/Excel.


Where the columns for Runs = -1 this identifies those which are BPOs
Jaseac
Ghost of Shadow Union
#6 - 2017-01-26 18:10:42 UTC  |  Edited by: Jaseac
First part:
I entered my information,tried to convert it but says its an invalid xml.

If typing it directly into the address bar this is what it shows.

This XML file does not appear to have any style information associated with it. The document tree is shown below.
eveapi version="2"
currentTime 2017-01-26 17:56:27 currentTime
error code="106"
Must provide userID, keyID, or accessToken parameter for authentication.
error
cachedUntil 2017-01-27 05:56:27 cachedUntil
eveapi

Second part

Same thing.
Cire Xinehp
Noir.
Shadow Cartel
#7 - 2017-01-26 19:11:03 UTC  |  Edited by: Cire Xinehp
Jaseac wrote:
First part:
I entered my information,tried to convert it but says its an invalid xml.

If typing it directly into the address bar this is what it shows.

This XML file does not appear to have any style information associated with it. The document tree is shown below.
eveapi version="2"
currentTime 2017-01-26 17:56:27 currentTime
error code="106"
Must provide userID, keyID, or accessToken parameter for authentication.
error
cachedUntil 2017-01-27 05:56:27 cachedUntil
eveapi

Second part

Same thing.


You've setup your API key to allow viewing of blueprints etc?

And then replaced the sections in the link with the correct corresponding parts?

If you're stuck feel free to eve mail me your API and I'll put it together.