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.
 

Import a corp hangar from a WH POS in a google spreadsheet

First post
Author
Previous Topic Next Topic
Tecka Grethys
Terminus Technologies Inc.
Strictly Unprofessional
#1 - 2015-02-20 08:05:46 UTC
Hello,

We live in WH and we have several POSes which have several divisions.

- Is it possible to import the content of POS_i/division_k in a google spreadsheet ?

- And of course, if yes... how ?

Thanks for the tip ! Cool
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-02-20 14:07:45 UTC
Yes, it's possible. Not easy, but possible.


What you'll find below is a script to load everything (or everything in a particular location) into a sheet.
https://github.com/fuzzysteve/eve-googledocs-script/blob/master/assetloader.gs



It's a modification of https://forums.eveonline.com/default.aspx?g=posts&m=2750367 because google deprecated the xml api that it used.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Tecka Grethys
Terminus Technologies Inc.
Strictly Unprofessional
#3 - 2015-02-20 14:55:32 UTC  |  Edited by: Tecka Grethys
Ok... so I added the script in the Code.gs file (I already have your stuff about loadRegionPrices in it ^^').

Then I create a new sheet in the google doc, then...

- What should I write in my cell A1 ?
- Something like "=assetList(...,...,...,...,...)" ?
- Could you give me an example ?


What I would like more precisely is 2 things :
- the content of the corporate hangar, division 3 of my POS (which is in WH) called "MyPOS".
- the content of the personnel hangar of the character "Tecka Grethys" which is in the POS called "MyPOS"


Thanks for your help !
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2015-02-20 18:50:55 UTC
try =assetlist(

it should then tell you what goes next :)

unfortunately, the asset api doesn't put names on things. you'd have to use the location api for that. if you only have one in a system, then use the system id to narrow it down.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Alundil
Rolled Out
#5 - 2015-02-20 21:24:36 UTC
This also works (have used)
https://forums.eveonline.com/default.aspx?g=posts&t=336800&find=unread

I'm right behind you
Tecka Grethys
Terminus Technologies Inc.
Strictly Unprofessional
#6 - 2015-02-23 10:59:49 UTC
Steve Ronuken wrote:
try =assetlist(
it should then tell you what goes next :)

unfortunately, the asset api doesn't put names on things. you'd have to use the location api for that. if you only have one in a system, then use the system id to narrow it down.


Ok... So I wrote :

=assetList(char,3XXXXX2,vkjhIUGuigfyLKjIUGlkJKGUKIhuKLIlioIUglkjLkhUyfUygflkLIHs,91111116,60004588)

(I changed the ID in my examples)
For keyID and vCode, I got the info from the API management section on eve Gate.
Fort the characterID, I went on my eve Gate profile, right click on the image of my toon, opened the URL in another window which was https://image.eveonline.com/character/91111116_200.jpg so deduced my character ID was 91111116.
For the location, I used an excel file I found on this forum Stations.csv and Ctrf+F "rens" to find 60004588,"Rens VI - Moon 8 - Brutor Tribe Treasury" so I deduced that le location was 60004588.

This resulted in a vicious #ERROR! in my cell. Damn it ! What am I doing wrong ? Oops


Moreover, I tried the command above to practice but in the end, I want the location to be a Wormhole in which I have several POS.
I managed to Ctrl+F J115549 in your file mapDenormalize.csv and got (I changed the number of the WH for the example) :

31000064,5,5,,21000317,11000001,,7.623932940921427e18,2.5414278752797844e16,-9.515323739209255e18,3429877445682.741,J115549,-0.99,,
40353704,3800,6,31000064,21000317,11000001,,0,0,0,295600000,"J115549 - Star",-0.99,,
40353705,2016,7,31000064,21000317,11000001,40353704,56471119662.36225,11723135593.012558,33879024510.098106,4030000,"J115549 I",-0.99,1,
40353706,11,7,31000064,21000317,11000001,40353704,116300466678.25133,21256216213.984417,-57365882643.07828,5890000,"J115549 II",-0.99,2,
40353707,14,8,31000064,21000317,11000001,40353706,116345602131.15161,21258845615.84532,-57134840095.32812,230000,"J115549 II - Moon 1",-0.99,2,1
40353708,11,7,31000064,21000317,11000001,40353704,-24778799870.081963,-149835994.0848205,-236822220878.87427,11420000,"J115549 III",-0.99,3,
etc...


Should I decude that the location ID of the Wormhole is 31000064 ?
But then, how can I distinguish my different POSes ? Is 40353707 the location of my POS on Planet II-Moon 1 ?


At last, I don't know if I should use the type char or corp. What I want is the corp hangar, division 3.


I'm sorry if I look like a noob here, it's just that... I am. Lol


@Alundil : Thanks, I saw this tool but what I'm trying to do is to use the information in a google spreadsheet.


Thanks for your replies !! Cool
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2015-02-23 13:16:11 UTC
Umm...

I /think/ what you want to do, is download everything, look for the 'thing' which contains everything, and use that as the parent ID. I think. I've not played with this, (before now, I've just used jeveassets)

Pulling everything isn't going to be slower than pulling just what you want (it has to pull everything). So you could then just see about filtering it. (on the data tab.)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Tecka Grethys
Terminus Technologies Inc.
Strictly Unprofessional
#8 - 2015-02-23 13:45:22 UTC
Steve Ronuken wrote:
Umm...

I /think/ what you want to do, is download everything, look for the 'thing' which contains everything, and use that as the parent ID. I think. I've not played with this, (before now, I've just used jeveassets)

Pulling everything isn't going to be slower than pulling just what you want (it has to pull everything). So you could then just see about filtering it. (on the data tab.)


Ok so I'll pull everything and filter it afterwards. But atm, it doesn't pull anything because... #ERROR! Ugh
Ortho Loess
Escalated.
OnlyFleets.
#9 - 2015-02-23 18:30:10 UTC
Tecka Grethys wrote:
Ok so I'll pull everything and filter it afterwards. But atm, it doesn't pull anything because... #ERROR! Ugh


Asset list is a massive pain to use with something like google docs, largely due to caching.

Something like the character sheet, if you request it again before the cache timer expires, it just gives you cached data. (This is known as short cache style, or modified short.)

The asset list uses the long cache style and has a pretty long timer too. With this system, if you request it again without waiting out the cache timer it just returns an error. Iirc, the timer for assetList is 6 hours, so you can't do a request any more frequently then this.

tl;dr: caching is vital when using assetList!
Tecka Grethys
Terminus Technologies Inc.
Strictly Unprofessional
#10 - 2015-02-24 08:11:04 UTC
Ok, so I waited for more than 6 hours, validated the cell again but... same #ERROR! again Oops

I have no idea what to try now. :/
Tecka Grethys
Terminus Technologies Inc.
Strictly Unprofessional
#11 - 2015-02-26 09:46:00 UTC
Steve Ronuken wrote:
(before now, I've just used jeveassets)


Would jeveassets be of any help for my google doc ?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#12 - 2015-02-26 20:54:23 UTC
probably not.

It's a standalone program, for asset management.

http://eve.nikr.net/jeveasset

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Tecka Grethys
Terminus Technologies Inc.
Strictly Unprofessional
#13 - 2015-02-27 06:20:54 UTC
Erf, no then. I want to get the assets information into a google spreadsheet. Dammit.