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.
 

LP Store Database

First post First post
Author
Previous Topic Next Topic
Jeremy Kamira
#1 - 2016-04-09 22:20:16 UTC
Are there any complete LP Store Databases our there? The most recent one i can find is the one from Kronos listed here ( https://forums.eveonline.com/default.aspx?g=posts&t=197115 ) and none of the bigger websites (Fuzzworks, Ellatha) have their LP stores up to date.
CCP Tellus
C C P
C C P Alliance
#2 - 2016-04-10 00:45:24 UTC
There's a CREST endpoint up on Singularity for testing that gives you the contents of a NPC corporation's loyalty store.
Jeremy Kamira
#3 - 2016-04-10 04:00:09 UTC  |  Edited by: Jeremy Kamira
CCP Tellus wrote:
There's a CREST endpoint up on Singularity for testing that gives you the contents of a NPC corporation's loyalty store.


Wow thanks, haven't ever pulled from Sisi/Crest but im sure il figure it out. Thanks again!
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2016-04-10 17:10:26 UTC  |  Edited by: Steve Ronuken
https://github.com/fuzzysteve/lpLoader may be of interest Smile

My lp store is now up to date Big smile

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Jeremy Kamira
#5 - 2016-04-14 21:49:54 UTC
Alright, so i managed to pull CREST into my spreadsheet using the importJSON script found here, http://blog.fastfedora.com/projects/import-json (I am using V1.2.1, the most recent), but am encountering a few problems. Here is my current formula.

=importJSON("https://api-sisi.testeveonline.com/corporations/1000026/loyaltystore/","/items/item/name,/items/requiredItems","noInherit,rawHeaders")

Here is an example sheet i shared that has my problem.

https://docs.google.com/spreadsheets/d/1J696WKMR17DtYlO4VNgd4inUgwoSLzzB-Sxhd-HdSHc/edit#gid=1760816075

For some reason, there are a few required items that it is cutting off. For example, the Griffen Navy Issue. There is nowhere on the sheet that lists the griffen.

Looking around, i can't really find any reason why it wouldn't be working so i'm assuming it is a problem with the script.
Mr Mac
Dark Goliath
#6 - 2016-04-15 07:44:13 UTC  |  Edited by: Mr Mac
requireditems is an array. seems importJSON has issue with it

Edit: just checked your doc. seems first item in array is missed. maybe check index
Jeremy Kamira
#7 - 2016-04-15 20:42:05 UTC
Another user had the same bug and the solution was posted on the GIthub page, thought i would post for anyone else having the same problem. Seems to fix it for me.

https://github.com/fastfedora/google-docs/issues/12