Export account history to local file

The Account History window is an invaluable tool in keeping track of L$ transactions in-game. What I'd really like, though, is the ability to save the entire account history to a local file -- like XML or comma delimited. That way we could easily access and analyze it offline in Excel or other software.

*bump*

Copy/paste from Account History into Notepad isn't an acceptable way to keep a permanent record of your SL finances. Getting that info into Excel or other app for analysis is very difficult.

It would be a lot easier if Account History could be saved as a delimited file. For example, these lines...

Saturday May 1, 2004

12:46 100 - Joe User bought Blue T-shirt
01:13 100 - Jane User bought Brown Shoes
02:01 1000 - Bob User paid you

Could be saved as...

Date,Time,Amount,User,Transaction_Type,Object
05/01/04,12:46,100,"Joe User","purchase","Blue T-shirt"
05/01/04,01:13,100,"Jane User","purchase","Brown Shoes"
05/01/04,02:01,1000,"Bob User","payment",""

That would make it so much easier to work with. Could sort and summarize and all kinds of nice things.

Please add this, Linden Hippos.

Excellent!

I support this suggestion fully.

I have assisted in coding vendors, and rather than rely on emails, which have a tendency to be lost, or scripts reset, etcetera, I came up with a way for vendor sales to show up in the Account History in something more meaningful than "so and so paid $ into vendor xyz".

The Account History is a much more stable system, as it is part of SL. Unfortunately the accessibility of it is limited to paging back and forth and hoping that an entry isn't too old. A simple "save to file" would be nice.

Most online banks allow this... essentially the Account History is your hookup to the "Bank of SL"

*BUMP*

And... the account history doesn't itemize payments. If I pay Joe L$500 and Fred L$300, all I see in my account history is that I paid L$800, plus anything else I may have paid for, like downloads.

This *must* change.

Credits and debits should be tracked on the same page like a General Ledger and should be exportable to a comma-delimited file for analysis in other applications.

Transactions should have a new transaction type field that denotes what kind of transaction it was (dwell payment, group dividend, manual payment, etc.), with more meaningful transaction descriptions. "Joe Schmoe paid into", followed by a blank is not a meaningful description.

With so much real-world value placed on in-world transactions, these features MUST be implemented. The lack of an audit trail is going to lead to serious problems on a mini-Enron scale.

If you go to "Your Account" on the secondlife.com website, under "Transaction History" you can d/l a spreadsheet of your transactions on a day-by-day basis.

- Ace

Cubey;

Myself & Moopf both have products which can let you do this. While definetely having an export from SL would be damn handy (and eventually critical); in the mean time there are alternatives.

-Adam

In our account summary on the WEBSITE (https://secondlife.com/account/transactions.php), we are supposed to be able to download an EXCEL SPREADSHEET of this information. There's even an Excel icon there. But when you click on it, IE doesn't know what to do with the link and Firefox downloads what is actually there - a PHP file that is formatted in tables with the transaction details.

I have bugged this several times, but I guess the Lindens don't plan on fixing it because they haven't even responded.

Ace, does yours actually download? I get errors every time I try, because it's not actually an Excel file.

Holy poop. How long has that been there? Obviously someone at LL listens.

Ok, that's a step in the right direction, but where are the descriptions? It says "object sale", but I sell dozens of different objects. What did they buy, and where?

How far back does it go? Do I have to download individual days? Why not monthly reports?

That's great that it's in Excel format (it's harder to implement than CSV), but now it's harder for me to append the days into a larger file for analysis.

And how do we find a particular day? Say I want to see June 30. Do I have to click through over a month of daily reports to get to it? If we could download monthly reports, that's not a problem.

I'd say this is an excellent start, but it's useless for anything meaningful without a lot of painstaking downloads and pasting individual days together.

My original request stands:

* Monthly downloadable files in CSV format.

* Add a meaningful description field. Where's the object name and the location of the object? The transaction type field is great: "Give Inventory", "Object Sale", but they're useless unless we know which objects were given or sold. "Upload Charge" for what file?

This feature is nice, but it doesn't even come close to answering our needs.

Firefox was quite happy to do it for me...

You've been feeding it the wrong type of cookies, I reckon!

Downloads a file called secondlife.xls, even offers to open it in openoffice for me...

(Firefox 0.9.2 by the way)

Adam, I'm aware of your vendor, and it's a nice one. However, I'm interested in tracking more than just payments recieved through object sales.

I have no problems downloading, and it opens just fine with OpenOffice (I despise Microsoft Office and refuse to use it).

- Ace

Yeah, unfortunately there's no scripted way of tracking that. Although this looks interesting; I'm toying with integrating the just discovered LL data into a mysql table of my own to do some aggregate analysis of.

-Adam

Capital idea, Cubey! You have my endorsement.

I like this idea.

Especially if it were done in a format easily imported to Excel / Access / etc

-Hiro Pendragon

I'm impressed that they went through the trouble to encode it in Excel format... But that means you have to use Excel, or something that can work with Excel files, like Open Office. I'd MUCH rather the data was in CSV format, even if it's just an option.

As for how much they store, seems like it's just a month. Any attempt to get data earlier than that returns the one-month-ago page.

Yes, the CSV format is much preferred. Putting the file into Excel is limiting to a lot of users, and those user with Excel can open CSV anyway.

The biggest problem with the current situation is that the downloads are daily, rather than monthly. Why would anyone need only a single day of data?