These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Pulling Data into Google Docs
Author
Previous Topic Next Topic
Tralminia
All Good CO2 Inc.
#1 - 2013-10-08 19:04:01 UTC
Heya. Wonder if someone can enlighten me.

I use a dynamic spreedsheet in google docs that pulls stuff from the EVE-Central database, and so far so good.

Now, I want to upgrade it so I can see how many items I have in my current orders. I can do that "easily" by exporting the market orders of each toon and importing to google docs, but that involves exporting/importing, messing with files, etc.

Is there a command or a way I can import stuff into the Google Docs, using EVE API, so that is always updated, with no need to use external text files?

Appreciate the info!
m3duza
The Scope
Gallente Federation
#2 - 2013-10-08 19:23:12 UTC
Tralminia wrote:
Heya. Wonder if someone can enlighten me.

I use a dynamic spreedsheet in google docs that pulls stuff from the EVE-Central database, and so far so good.

Now, I want to upgrade it so I can see how many items I have in my current orders. I can do that "easily" by exporting the market orders of each toon and importing to google docs, but that involves exporting/importing, messing with files, etc.

Is there a command or a way I can import stuff into the Google Docs, using EVE API, so that is always updated, with no need to use external text files?

Appreciate the info!



I dont think this is possible, i use a tool called EVe Mentat that you have to manually click export and import on the programme, is your google doc public, i would love a copy for my own use :)
Abdiel Kavash
Deep Core Mining Inc.
Caldari State
#3 - 2013-10-08 19:27:13 UTC  |  Edited by: Abdiel Kavash
http://wiki.eve-id.net/APIv2_Char_MarketOrders_XML

The correct syntax with vCodes is:

https://api.eveonline.com/char/MarketOrders.xml.aspx?keyID=[[key ID]]&vCode=[[vCode]]&characterID=[[character ID]]
Tralminia
All Good CO2 Inc.
#4 - 2013-10-08 21:45:50 UTC
m3duza wrote:
Tralminia wrote:
Heya. Wonder if someone can enlighten me.

I use a dynamic spreedsheet in google docs that pulls stuff from the EVE-Central database, and so far so good.

Now, I want to upgrade it so I can see how many items I have in my current orders. I can do that "easily" by exporting the market orders of each toon and importing to google docs, but that involves exporting/importing, messing with files, etc.

Is there a command or a way I can import stuff into the Google Docs, using EVE API, so that is always updated, with no need to use external text files?

Appreciate the info!



I dont think this is possible, i use a tool called EVe Mentat that you have to manually click export and import on the programme, is your google doc public, i would love a copy for my own use :)



I also use EVE Mentat, but I been using it a bit less lately. As for my doc, ain't really public, but here is the tutorial on how to make one. I just changed some stuff to match my hubs and items

https://www.youtube.com/watch?v=bLm0FQD_cN4

Tralminia
All Good CO2 Inc.
#5 - 2013-10-08 21:56:25 UTC  |  Edited by: Tralminia
Abdiel Kavash wrote:
http://wiki.eve-id.net/APIv2_Char_MarketOrders_XML

The correct syntax with vCodes is:

https://api.eveonline.com/char/MarketOrders.xml.aspx?keyID=[[key ID]]&vCode=[[vCode]]&characterID=[[character ID]]



I had found that site, but It seems I'm utterly ignorant on understanding it.... Even when I use your sintax with my data, it just gives me back a "bad request". Taking it a notch down, is there a tutorial site I can dwell my head on? That would be awsome, if such a thing exists to non-computer geeks.

Thks!