Gigs Taggart
The Invisible Hand
Join date: 12 Feb 2006
Posts: 406
|
07-07-2006 18:57
On the economic data XML, the links on the web site have the date format wrong.
For example, if you click for Today's XML it gives you June 6 (2006-06-07) instead of July 7th (2006-07-06).
The date in the link is year-day-month when it should be year-month-day.
Also in the real island data for today 2006-07-06. <field name="Islands Owned (end of Month)" value="1105"/> <field name="Islands Added During Month" value="-1"/>
Is this what happens when islands are deleted?
I would think that islands added wouldn't subtract out the deleted ones.
|
Morpheus Linden
Lost in the Dreaming
Join date: 29 Jun 2006
Posts: 9
|
07-08-2006 15:26
From: Gigs Taggart On the economic data XML, the links on the web site have the date format wrong.
For example, if you click for Today's XML it gives you June 6 (2006-06-07) instead of July 7th (2006-07-06).
The date in the link is year-day-month when it should be year-month-day.
I assume you're referring to https://secondlife.com/account/transactions.php ? You are right that dates should be YYYY-MM-DD, and that's what I see when I d/l the XML. My only guess is that you are referring to the XML filename. For the filenames (for both the XML and the XLS), I left out the year componant to try to keep the filenames more manageable (smaller). The format of the filename is always a date range (even if that date range is just one day), so it would be SL-transactionsMM_DD-MM_DD.xml. I can see how at first glance you could see DD-MM in the middle and think it backwards, but that's not the case. If you in fact mean something else, please respond in this thread, but I don't see it. From: Gigs Taggart Also in the real island data for today 2006-07-06. <field name="Islands Owned (end of Month)" value="1105"/> <field name="Islands Added During Month" value="-1"/>
Is this what happens when islands are deleted?
I would think that islands added wouldn't subtract out the deleted ones.
I can't speak to that. I can only tell you that I do nothing special transformation-wise as I pull it out of the DB. (And that it wouldn't surprise me that we'd store a negative number for islands added to indicate island deleted.) HTH, Morpheus Linden
|