Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Jeremy Kamira
22
|
Posted - 2016.04.09 22:20:16 -
[1] - Quote
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
57
|
Posted - 2016.04.10 00:45:24 -
[2] - Quote
There's a CREST endpoint up on Singularity for testing that gives you the contents of a NPC corporation's loyalty store. |
|
Jeremy Kamira
22
|
Posted - 2016.04.10 04:00:09 -
[3] - Quote
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
5972
|
Posted - 2016.04.10 17:10:26 -
[4] - Quote
https://github.com/fuzzysteve/lpLoader may be of interest
My lp store will be up to date shortly.
I'm running again for CSM 11, and I'd appreciate your vote.
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Jeremy Kamira
22
|
Posted - 2016.04.14 21:49:54 -
[5] - Quote
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
136
|
Posted - 2016.04.15 07:44:13 -
[6] - Quote
requireditems is an array. seems importJSON has issue with it |
Jeremy Kamira
22
|
Posted - 2016.04.15 20:42:05 -
[7] - Quote
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 |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |