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.
 

Google spreadsheet eve centrial API problems

First post
Author
Previous Topic Next Topic
kassi Yaken
Strategic Exploration and Development Corp
Silent Company
#1 - 2015-02-18 22:49:21 UTC
Hi I have a Google spreadsheet that has eve central API's in it it use to work but now it says #VALUE! What do I need to do to fix this

https://docs.google.com/spreadsheet/ccc?key=0AsyiT1k6dt7adFBZdUhUZnc3SlFiY2FyQVA1Rlo3NkE&usp=docslist_api
VolatileVoid
Viking Clan
#2 - 2015-02-19 14:47:14 UTC
Nolen Cadmar
Caldari Provisions
Caldari State
#3 - 2015-02-20 21:44:59 UTC
Yea...importXML is a bad choice for Eve-Central nowadays. It seems to work fine for Eve-Marketdata. Steve Ronuken's google script (linked above) is the easiest way to get EC data into GDocs.

Nolen's Spreadsheet Guru Services

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

Custom requests welcome!

Sheet Screenshots
Shorlas Magaskawee
Gold Moon Industries
DammFam
#4 - 2015-03-09 00:42:59 UTC
VolatileVoid wrote:
May use this replacement https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs


I can't for the life of me get this figured out how to use this. Even making a replica of his demo I can't make it work.
Nolen Cadmar
Caldari Provisions
Caldari State
#5 - 2015-03-09 01:02:46 UTC  |  Edited by: Nolen Cadmar
Shorlas Magaskawee wrote:
VolatileVoid wrote:
May use this replacement https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs


I can't for the life of me get this figured out how to use this. Even making a replica of his demo I can't make it work.


1) click Tools→Script Editor
2) Delete whatever is in there by default.
3) Copy and paste the code from that github repo.
4) Click the Save button.

There are 2 functions that you can now use:
• loadRegionPrices
• loadSystemPrices

The formulas work like this:
=loadRegionPrices(TypeID Range,RegionID)
=loadSystemPrices(TypeID Range,SystemID)


Example:

Type ID's in A1→A10
System ID in B1

In C1, you would type in:
=loadSystemPrices(A1:A10,B1)


If you do not include a system ID or region ID, the script will use Jita, and The Forge, respectively. You can also type the region or system ID into the formula rather than referencing a cell.

Nolen's Spreadsheet Guru Services

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

Custom requests welcome!

Sheet Screenshots
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2015-03-09 01:50:31 UTC
Be aware, the functions /require/ an array of typeids. They don't work on single ids.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter