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.
 

Excel XML Data in wrong order?
Author
Previous Topic Next Topic
Agent Type
Royal Amarr Institute
Amarr Empire
#1 - 2012-08-22 18:40:59 UTC
Hello,

I am importing all wallet transactions for multiple characters from their XML data pages to an Excel spreadsheet. I am having the problem that when I import the data it comes together in the wrong order. It goes;

8/19
8/20
8/21
8/22
8/14
8/15
8/16
8/17
8/18
8/10
8/11

Etc, etc, etc. But, when I go to look at the XML data on the webpage it starts at 8/22 and goes in descending order. I do not seem to be able to sort the data by date in Excel (I assume because I am importing the data). Anyway, any help would be greatly appreciated since this is hurting my ability to organize the data and use pivot tables to read the data.

Thanks a lot for any help!
Javajunky
Federal Navy Academy
Gallente Federation
#2 - 2012-08-22 20:18:35 UTC
You might want to try posting this in the technology lab instead.

Nice job getting it into Excel. I've had some challenges getting it to go into Excel or Access perhaps we can talk about some services fo ISK? Any questions related to a Microsoft product usually get hate spam and people tell you to switch to google docs because they never noticed how google open admits it will whore out any piece of information it can about you.
Agent Type
Royal Amarr Institute
Amarr Empire
#3 - 2012-08-22 20:39:07 UTC
Javajunky wrote:
You might want to try posting this in the technology lab instead.

Nice job getting it into Excel. I've had some challenges getting it to go into Excel or Access perhaps we can talk about some services fo ISK? Any questions related to a Microsoft product usually get hate spam and people tell you to switch to google docs because they never noticed how google open admits it will ***** out any piece of information it can about you.


Thanks for the tip! I will post it there now. I'd be happy to offer you any help free of charge. I actually have the exact same spreadsheet in Google Docs (which, had the same problem sometimes), but found it to be a vastly inferior program compared to Excel. It was very nice having the spreadsheet stored on the cloud, but the limit on the number of formulas and the deadly slow speed of loading turned me off of it and onto Excel.
Agent Type
Royal Amarr Institute
Amarr Empire
#4 - 2012-08-23 20:46:57 UTC  |  Edited by: Agent Type
Solved!

Just go to the sheet with your XML data.

Select Developer tab.

Click Map Properties.

Select "validate data against schema for import and export".

Solved!

Edit: I had this problem in Google docs as well, so maybe something similar will solve the problem there if anyone else is experiencing it.