Welcome to the Second Life Forums Archive

These forums are CLOSED. Please visit the new forums HERE

Can't download XLS file of transactions

Keiki Lemieux
I make HUDDLES
Join date: 8 Jul 2005
Posts: 1,490
04-25-2007 00:37
I have reported this problem several times to LL. I can't download my linden transactions for certain days. When I go the transaction history query page and select queries which include certain dates, and then try to download the info, I get a blank page. For most days it works perfectly, on others not at all. However I can get the XML version to download. The problem is I can't figure out an easy way to convert XML to CSV. I've searched around via google and all I find is commercial products that do way more than I need.

Anyone got a quick and easy way to convert XML to CSV?
_____________________
imakehuddles.com/wordpress/
AWM Mars
Scarey Dude :¬)
Join date: 10 Apr 2004
Posts: 3,398
04-25-2007 04:34
I found this programme that will do what you need... http://www.stylusstudio.com/csv_to_xml.html

or this one..
http://www.download.com/CZ-Excel-Converter/3000-2079_4-10583721.html?tag=lst-0-4

or this one..
http://www.download.com/Parse-O-Matic-Free-Edition/3000-2248_4-10648641.html?tag=lst-0-5

or this one..
http://www.forgram.com/?referrer=Google

Have you tired downloading the xls (excel) versions of transactions and using query filters?
_____________________
*** Politeness is priceless when received, cost nothing to own or give, yet many cannot afford -

Why do you only see typo's AFTER you have clicked submit? **
http://www.wba-advertising.com
http://www.nex-core-mm.com
http://www.eml-entertainments.com
http://www.v-innovate.com
Keiki Lemieux
I make HUDDLES
Join date: 8 Jul 2005
Posts: 1,490
04-25-2007 09:10
From: AWM Mars
I found this programme that will do what you need... http://www.stylusstudio.com/csv_to_xml.html

or this one..
http://www.download.com/CZ-Excel-Converter/3000-2079_4-10583721.html?tag=lst-0-4

or this one..
http://www.download.com/Parse-O-Matic-Free-Edition/3000-2248_4-10648641.html?tag=lst-0-5

or this one..
http://www.forgram.com/?referrer=Google

Have you tired downloading the xls (excel) versions of transactions and using query filters?

Thank you.

What filters are available besides date which I have used?
_____________________
imakehuddles.com/wordpress/
Athena Sterling
Voided Earthing
Join date: 1 May 2006
Posts: 186
04-25-2007 09:13
fyi, i have found that when downloading the cvs, doing it one day at a time works fine, doing multiple days seems to cause the blank page error.
_____________________
Solo Junkies Skybox ( secondlife://Solo Junkies/192/192/ ) : The oldest and largest solo based gaming arcade for a reason, pure and simple honesty...
Keiki Lemieux
I make HUDDLES
Join date: 8 Jul 2005
Posts: 1,490
04-25-2007 09:18
As far as I can figure out, the first three options are actually ways to convert CSV and other formats to XML, not the other way around. And the last option looks like an addon for Excel. I don't use Excel, I use Open Office.
_____________________
imakehuddles.com/wordpress/
Keiki Lemieux
I make HUDDLES
Join date: 8 Jul 2005
Posts: 1,490
04-25-2007 09:19
From: Athena Sterling
fyi, i have found that when downloading the cvs, doing it one day at a time works fine, doing multiple days seems to cause the blank page error.

Not for me. April 16th is bugged for me. Any query including that date fails for me, including just trying to download that day.
_____________________
imakehuddles.com/wordpress/
AWM Mars
Scarey Dude :¬)
Join date: 10 Apr 2004
Posts: 3,398
04-25-2007 10:09
If you apply Data filters to the columns of any excel worksheet, it automatically parses the content information into keywords, which you can select as a priority (say Date for instance), it will automatically reformat the sheet into those parameters. You can also apply custom filters.
If you can write macros, you can apply macro functions to do this in a more controlled way.

On the link for Stylus Studio, I found this statement [Stylus Studio® 2007 XML Enterprise Suite includes Convert to XML, a visual tool for extracting XML data from any file format including CSV, tab separated, binary data files, EDI, or any other flat format, as well as many other data import/export utilities for RDBMS, XML, ADO, and more!]

This link http://www.forgram.com/?referrer=Google offered a cleaner solution.

This link http://www.download.com/CZ-Excel-Converter/3000-2079_4-10583721.html?tag=lst-0-4 is a comand line conversion programme Quote [CZ Excel Converter is a powerful batch document converter that converts between XLS, HTML, XML, MTH, CSV, TEXT, DBF, Lotus 1-2-3, WKS, WQ1, SLK, and DIF. The software supports batch conversion, command line, and folder watcher. Batch conversion ability allows you to convert unlimited number of files at a time.]
_____________________
*** Politeness is priceless when received, cost nothing to own or give, yet many cannot afford -

Why do you only see typo's AFTER you have clicked submit? **
http://www.wba-advertising.com
http://www.nex-core-mm.com
http://www.eml-entertainments.com
http://www.v-innovate.com
Keiki Lemieux
I make HUDDLES
Join date: 8 Jul 2005
Posts: 1,490
04-25-2007 10:19
From: AWM Mars
If you apply Data filters to the columns of any excel worksheet, it automatically parses the content information into keywords, which you can select as a priority (say Date for instance), it will automatically reformat the sheet into those parameters. You can also apply custom filters.
If you can write macros, you can apply macro functions to do this in a more controlled way.

On the link for Stylus Studio, I found this statement [Stylus Studio® 2007 XML Enterprise Suite includes Convert to XML, a visual tool for extracting XML data from any file format including CSV, tab separated, binary data files, EDI, or any other flat format, as well as many other data import/export utilities for RDBMS, XML, ADO, and more!]

This link http://www.forgram.com/?referrer=Google offered a cleaner solution.

This link http://www.download.com/CZ-Excel-Converter/3000-2079_4-10583721.html?tag=lst-0-4 is a comand line conversion programme Quote [CZ Excel Converter is a powerful batch document converter that converts between XLS, HTML, XML, MTH, CSV, TEXT, DBF, Lotus 1-2-3, WKS, WQ1, SLK, and DIF. The software supports batch conversion, command line, and folder watcher. Batch conversion ability allows you to convert unlimited number of files at a time.]

Thank you again for your suggestions. As for solutions in Excel. I don't have Excel. I have Open Office and I cannot find a way in Open Office to easily convert XML to CSV.

As to the two programs you re-linked. I downloaded both of them and tried them both. They are programs designed to export to XML, not export from XML.
_____________________
imakehuddles.com/wordpress/
AWM Mars
Scarey Dude :¬)
Join date: 10 Apr 2004
Posts: 3,398
04-25-2007 11:44
I think you missed reading the quote I put in with the link

This link http://www.download.com/CZ-Excel-Co...tml?tag=lst-0-4 is a comand line conversion programme Quote [CZ Excel Converter is a powerful batch document converter that converts between XLS, HTML, XML, MTH, CSV, TEXT, DBF, Lotus 1-2-3, WKS, WQ1, SLK, and DIF. The software supports batch conversion, command line, and folder watcher. Batch conversion ability allows you to convert unlimited number of files at a time.]

As it is a comand line converter, you can download the XLS versions and convert that into XML?? Or anything remotely compatible with Open Office.
_____________________
*** Politeness is priceless when received, cost nothing to own or give, yet many cannot afford -

Why do you only see typo's AFTER you have clicked submit? **
http://www.wba-advertising.com
http://www.nex-core-mm.com
http://www.eml-entertainments.com
http://www.v-innovate.com
Keiki Lemieux
I make HUDDLES
Join date: 8 Jul 2005
Posts: 1,490
04-25-2007 15:08
From: AWM Mars
I think you missed reading the quote I put in with the link

This link http://www.download.com/CZ-Excel-Co...tml?tag=lst-0-4 is a comand line conversion programme Quote [CZ Excel Converter is a powerful batch document converter that converts between XLS, HTML, XML, MTH, CSV, TEXT, DBF, Lotus 1-2-3, WKS, WQ1, SLK, and DIF. The software supports batch conversion, command line, and folder watcher. Batch conversion ability allows you to convert unlimited number of files at a time.]

As it is a comand line converter, you can download the XLS versions and convert that into XML?? Or anything remotely compatible with Open Office.

The whole point is that I cannot download the XLS version for certain dates. Open Office can directly read XLS files and I wouldn't need to convert anything if I could download the XLS version. I can only get the XML version which Open Office cannot open directly into a spread sheet.

That is why I need something that converts XML to CSV. When I downloaded that program from your link, I could not see how to do that. It appeared that it was designed to convert things to XML, not from XML. Yes the description implies that you can convert things back and forth between XML and CSV, but I could not figure it out.

If you have actually used that software to convert XML to CSV, I would appreciate it if you could confirm that and give me hints on how to do that.
_____________________
imakehuddles.com/wordpress/
AWM Mars
Scarey Dude :¬)
Join date: 10 Apr 2004
Posts: 3,398
04-26-2007 08:14
sorry, I have excel so never have that problem. I trawled the internet for an hour to find suitable programmes, but not to actually test them. Try http://www.download.com they have a wealth of programmes there.
_____________________
*** Politeness is priceless when received, cost nothing to own or give, yet many cannot afford -

Why do you only see typo's AFTER you have clicked submit? **
http://www.wba-advertising.com
http://www.nex-core-mm.com
http://www.eml-entertainments.com
http://www.v-innovate.com
AWM Mars
Scarey Dude :¬)
Join date: 10 Apr 2004
Posts: 3,398
04-26-2007 08:19
ORRRR.. try this link again http://www.forgram.com/?referrer=Google

QUOTE:
XML to XLS
XML to CSV

another link on that page to another product states:
Shred XML to Tables. Export to XLS, MDB or CSV. Free Trial. US$49 buys.
:UNQUOTE
_____________________
*** Politeness is priceless when received, cost nothing to own or give, yet many cannot afford -

Why do you only see typo's AFTER you have clicked submit? **
http://www.wba-advertising.com
http://www.nex-core-mm.com
http://www.eml-entertainments.com
http://www.v-innovate.com
Keiki Lemieux
I make HUDDLES
Join date: 8 Jul 2005
Posts: 1,490
04-26-2007 09:37
Thank you again for trying. However, like I pointed out above, this program is not a standalone program it is an add-on for Microsoft Excel. I need Microsoft Excel to run it. From the read me file:
From: someone
Import or convert XML data into MS Excel with one click using "XMLtoXLS". This XML file utility is a Microsoft Excel Add-In to convert XML data to an Excel spreadsheet.
_____________________
imakehuddles.com/wordpress/
Keiki Lemieux
I make HUDDLES
Join date: 8 Jul 2005
Posts: 1,490
04-26-2007 15:38
After quite a bit of editing of the XML file, I got it work with a utility called Exult.
_____________________
imakehuddles.com/wordpress/