Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Caluran
Dark Ghost Industries
0
|
Posted - 2015.07.07 16:27:26 -
[1] - Quote
Been out of the game for a while and came back to find that the googledocs spreadsheet I used to use to work out profit per item no longer pulls from the API anymore.
Is there any way to get access to that data using the new API system or is it back to manually updating books in excel? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5411
|
Posted - 2015.07.07 17:14:26 -
[2] - Quote
https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs
It never used the Eve api.
(if it's to do with the order api for your own orders, google finally stopped their dumb 'we'll lowercase everything for xpath' policy, which confused the hell out of people. So you'll need to properly capitalize things)
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Caluran
Dark Ghost Industries
0
|
Posted - 2015.07.07 17:27:51 -
[3] - Quote
Ahh thank you that's just what I was looking for. |
Enison
Moira. Villore Accords
2
|
Posted - 2015.07.14 16:58:43 -
[4] - Quote
dumb question and sorry to hijack, but how do you use those functions with excel? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5440
|
Posted - 2015.07.14 17:18:14 -
[5] - Quote
Enison wrote:dumb question and sorry to hijack, but how do you use those functions with excel?
You can't, unfortunately.
You'd have to rewrite them in VBA, which is a pain to do, and then save it as a macro enabled sheet.
It's not impossible, but it's a pain in the neck.
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Enison
Moira. Villore Accords
2
|
Posted - 2015.07.15 00:57:41 -
[6] - Quote
oh, sorry i should rephrase. How do i get them into a spreadsheet application? i dont see how you integrated it into yours |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5441
|
Posted - 2015.07.15 11:48:04 -
[7] - Quote
Enison wrote:oh, sorry i should rephrase. How do i get them into a spreadsheet application? i dont see how you integrated it into yours
https://youtu.be/wNIfpPOOo0M?t=10m28s
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Kennedy Lincoln
Federal Defense Union Gallente Federation
0
|
Posted - 2015.07.15 12:41:26 -
[8] - Quote
Holy crap you guys are smart. I cannot wait to try and tackle this. Old programmer here and I am ready to learn! Anyone remember assembler? Fortran? |
Bad Bobby
Bring Me Sunshine In Tea We Trust
933
|
Posted - 2015.07.15 13:22:05 -
[9] - Quote
Kennedy Lincoln wrote:Anyone remember assembler? I'm actually debugging an assembler I/O routine for a Sega Megadrive multi-tap atm.
|
Enison
Moira. Villore Accords
2
|
Posted - 2015.07.16 00:03:52 -
[10] - Quote
cool so i got it to work, but I guess i cant use the function to call a large amount of data. i have a list of all the type_ids in the game and im trying to get them all, but it looks like you cant get more then 2000 things at a time. doing =loadSystemPrices(Sheet1!A2:A23700) results in an error. I had to make like 11 different calls to get everything |
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5447
|
Posted - 2015.07.16 00:35:05 -
[11] - Quote
Not entirely sure why it doesn't work with more than 2k things, as it splits it into batches of 150 and does them separately.
may be a memory issue, with the larger result set. If so, nothing I can do about it, it's just google saying 'nah'
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |