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.
 

Help with Xpath
Author
Previous Topic Next Topic
Metal Saleswoman
The Mechanix
#1 - 2017-01-14 06:10:25 UTC  |  Edited by: Metal Saleswoman
I know XML calls will change soon but I need your help to figure out how to make this.

Im trying to import into a google spreadsheet one type of transaction of the Wallet Journal, in this case the one with typeID 37; so I made:

=importxml("...";"//@refTypeID[.=37]")

It just shows all the 37 IDtype of transaction of the wallet. The problem Is that I want to put another column that shows the date that corresponds to this entries. The call of the attribute is @date. If I do "//@date" it lists all the data entries not only the ones for ItemID 37.

How it would be the Xpath query for this?

Thanks in advance
Blacksmoke16
Resilience.
#2 - 2017-01-14 14:55:55 UTC
Would be something like this: (I didn't have time to test it so if it doesn't work i'll look into it when i get home).

Column 1 for date - =importxml("...";"//@refTypeID[.=37]/@date")
Column 2 for 37 - =importxml("...";"//@refTypeID[.=37]")
Metal Saleswoman
The Mechanix
#3 - 2017-01-14 17:41:13 UTC
Thanks for the reply. It doesnt work, it gives N/A error.
Blacksmoke16
Resilience.
#4 - 2017-01-14 19:59:10 UTC
Tested and working one. This will display the date of every entry with refTypeID of 37. If you get the N/A error it just means you do not have any refTypeID 37s in your journal. You would either have to up the rowCount variable or walk the journal backwards.

Date -> =IMPORTXML("....","//row[@refTypeID=37]/@date")
Metal Saleswoman
The Mechanix
#5 - 2017-01-14 20:51:05 UTC
YES it works Ty so much!