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.
 

I'm a noob and need api xml help
Author
Previous Topic Next Topic
Chic Botany
Doomheim
#1 - 2014-05-23 14:25:42 UTC
So I had some bright idea of creating a member logging tool and got a very rough version in google spreadsheet, but wanted to expand on this with the roles & titles the member has.

I've tried various options and can't get the member security to get the roles each member has against their name.

I can get the name + character ID fine from member security, but then I get stuck.

I have the base query in A1

https://api.eveonline.com/corp/MemberSecurity.xml.aspx?keyID=**MYKEY**&vCode=**MYCODE**

So I start off with

=IMPORTXML($A$1,"eveapi/result/rowset/row/@name") in the first column and yup gets me a list of character names
=IMPORTXML($A$1,"eveapi/result/rowset/row/@characterid") in the next column and it gets me the list of character ID's

Then ????
I've tried many things, and I figure it's something to do with my xpath_query that google wants, but I can't seem to get a list of roles that correlates with the characters, the only thing I've managed to get is a random list of roles by using:
=IMPORTXML($A$1,"eveapi/result/rowset/row/rowset/row/@rolename")
and that just brings a column up with a list of roles that don't match the character in the first column Shocked

So I think maybe I've reached the end of google spreadsheets ability, if I import the membersecurity.xml into excel it gives me the character name several times in the column and then the roles assigned to that character, but google isn't that friendly.


So maybe I need to go database driven instead of using spreadsheets, and run queries instead.

The issue I've got is getting the xml data into a mysql database, I've got a little knowledge of php & mysql but I'm struggling to get any further.
I figure I need something like yapeal but that might as well be translated from swahili via a blind chinese rice husker.
I've tried installing it on a website I've got and then worked out it needs to be run from a command line instead of a brower.

Can anyone point me in the right direction? if I can get the data the database and work out how to run cron jobs to keep it up to date, I can probably figure the rest out.

Thanks

C B Big smile
qu1ckkkk
The Warp Core Stabilizers
#2 - 2014-05-23 15:49:37 UTC
Chic Botany wrote:
So I had some bright idea of creating a member logging tool and got a very rough version in google spreadsheet, but wanted to expand on this with the roles & titles the member has.

I've tried various options and can't get the member security to get the roles each member has against their name.

I can get the name + character ID fine from member security, but then I get stuck.

I have the base query in A1

https://api.eveonline.com/corp/MemberSecurity.xml.aspx?keyID=**MYKEY**&vCode=**MYCODE**

So I start off with

=IMPORTXML($A$1,"eveapi/result/rowset/row/@name") in the first column and yup gets me a list of character names
=IMPORTXML($A$1,"eveapi/result/rowset/row/@characterid") in the next column and it gets me the list of character ID's

Then ????
I've tried many things, and I figure it's something to do with my xpath_query that google wants, but I can't seem to get a list of roles that correlates with the characters, the only thing I've managed to get is a random list of roles by using:
=IMPORTXML($A$1,"eveapi/result/rowset/row/rowset/row/@rolename")
and that just brings a column up with a list of roles that don't match the character in the first column Shocked

So I think maybe I've reached the end of google spreadsheets ability, if I import the membersecurity.xml into excel it gives me the character name several times in the column and then the roles assigned to that character, but google isn't that friendly.


So maybe I need to go database driven instead of using spreadsheets, and run queries instead.

The issue I've got is getting the xml data into a mysql database, I've got a little knowledge of php & mysql but I'm struggling to get any further.
I figure I need something like yapeal but that might as well be translated from swahili via a blind chinese rice husker.
I've tried installing it on a website I've got and then worked out it needs to be run from a command line instead of a brower.

Can anyone point me in the right direction? if I can get the data the database and work out how to run cron jobs to keep it up to date, I can probably figure the rest out.

Thanks

C B Big smile


Shameless plug
You may want to check out SeAT https://github.com/eve-seat/seat. While still a very young project, its actively progressing into something quite rad :D

It comes with a frontend, but you are not forced to use this. The backend updaters can be run standalone and have your own web tools developed around that. This should at least help with the need of getting API related information into the database.

HTH

Proud developer of SeAT! A Simple Eve API & Corporation Management Tool.

Project Page: https://github.com/eveseat/seat
Chic Botany
Doomheim
#3 - 2014-05-23 15:59:40 UTC
Thanks qu1ckkkk I'll give it a look later, my head was spinning so I decided to step away from the project for a bit and do some other spreadsheet instead.