Transaction History Revamp

I am rather frustrated by SL's web based transaction history. I have spent countless hours making sure I name pay objects (such as the Rent-O-Matics) to fit their location and description, yet, the transaction history only shows it as "Object Pays".

What is the purpose of having a detailed transaction history if it leaves out the actual details? Does anyone know if SL will be revamping the transaction history to actually be more detailed and accurate? Does anyone else care?

I am an accountant by trade and useful tools are always needed. I threw out my abacus a couple of centuries ago!

I would enjoy your thoughts and maybe some feature solution ideas.

This has been brought up many, many times. I would love to be able to download more then just one day at a time too. Also, a better way to find days for transactions. I agree that the system needs to be revampt. I also see much bigger issues that I hope is keeping them too busy to worry about this.

This has been brought up many, many times. I would love to be able to download more then just one day at a time too. I would love to see a way to get all the data between two dates. Also, a better way to find days for transactions. I agree that the system needs to be revampt. I also see much bigger issues that I hope is keeping them too busy to worry about this.

Hmm, I'm not having this experience at all.

I, too, renamed all the rentos to reflect their sim, building location, price, etc. and I'm seeing them on my in-world transaction history as "JOE BLOW PAID PHAROS RENTER $250".

That's in-game -- but perhaps on the website that falls out? I'd have to see.

I've also noticed that on the "Last 10 items purchased in world" that the named rentomatic thingie is showing up.

I agree there is a problem with lack of detail, however. I can't tell whether a $50 is paid to me directly, or paid into a tip jar or a raffle machine or a casino sometimes, and that makes it hard if I have to do a refund or check someone's word against the transaction history.

I assume that Timmy was talking about the webside of the trans history. That is what I was talking about. If they could make waht we see on the web page the same as what is shown in game, I think a lot of people would be happier.

And there's no transaction information at all for groups.

Though I agree that there are issues higher on the priority chain, I think revamping the web based transaction history should get a nudge as it does affect the economy. The inworld system is just shy of being useless, so I rely more and more on the web based transaction history, especially when I don't have time to get in world.

I agree, the website transaction history is much less useful than it could be -- it omits vital information, such as the object name. The excel spreadsheet download is ... interesting. But it would be so much easier to get the info as comma-delimited text, and as monthly, not daily, files. If I'm looking for one transaction that occurred a few weeks ago sometime, I don't really want to download a couple dozen individual files then open them one by one.

Monthly CSV downloads please!

Though I am an Excel Spreadsheet user (ok, I can hear the boos already , I can see the usefulness of a CSV download for non-Excel users. I agree as well that we should be able to download one month at a time or better yet, within specified dates. That would be useful as well.

With a CSV containing all transaction information you could easily write a php/perl script to do whatever you needed it to do (even show a user's purchases on your website), or even a VB/C++ application to find trends and most popular products (if one doesn't exist, but this could also be done in PHP/Perl).

I decided a while ago the in-game and excel data records are inadequate, so I don't use them. Each of my vendors is hooked to a central server, which records (in memory) each transaction from each vendor, as well as sending an email to my RL email address with the record for each transaction. My email client takes those messages and files them into a special folder.

The record includes date and time, the vendor, the buyer name & key, the amount paid, and the item name sold.

The record is formatted as a single line, with colon separators, which makes them easy to import into anything I want, and do any detailed analysis.

- Jon

Jon that's great, but what you did was reinvent the wheel. Why can't SL retool/revamp their transaction history to make it more usable?

Yeah, I know, but I needed a solution now, not when LL gets around to fixing things. I decided to do my own, rather than using one of the available systems, because I like to know what's going on behind the scenes...

The other reason I did my own was because I needed the buyer's key, so I can do auto-updates when I add new features. That one feature is important enough to me to justify the effort it took to script the system.

- Jon

Kudos to your ingenuity, Jon!

But since I don't have your scripting &/or coding skill, I would like the website Transactions show more & allow for date-specified downloads. I'd also like to see searches by product/ location/ buyer/ etc become a new feature.

I am not a math person, really. I'd like to see relevant data without having to go buy a spreadsheet proggie. I can't see where it would be all that difficult for the website to display whatever user-specified level of detail is desirable.

Robin posted a reply to the Hotline for a question like this:

/invalid_link.html

I think the real issue is people who sell a lot of small items during a given day would be hammering the database with queries.

I'm starting to think maybe I should fix up my vendor/server for public consumption, and put it on the market for a reasonable price...

- Jon

Timmy, what i find myself doing is matching times with the web version that i export into excel and the in world transaction history. I could be crazy and say that LL should make the "business tools" better, but then someone might say i want LL to do everything for me.

I agree that the transaction history should be changed so we can see who put money where, not just that someone gave you money.

I do the matching as well and I know pretty much where everything is going to, both expenditures and receipts. That doesn't mean that though I am getting a thorough and easy to digest transaction history. I don't think any of us are asking LL to do everything for us, but we want what they do offer to be the best, not some half-baked idea.