Converting xml data to csv data

[bimeldip]

Is it posibble to develop codes to convert and xml data to csv data ?
If it is...can i know if there are any online toturials that i can follow to learn on this ?

[scissors]

While I'm pretty sure there are some IDEs out there that can do that, I would recommend an XSLT to do so.

[jkmyoung]

If you have an xml in the following form:
<table>
<row>
<data>value</data>
<data>value</data>
</row>
</table>

You can easily create either scripts or xslt to convert the document. eg. xslt:

<xsl:template match="row">
  <xsl:for-each select="data">
    <xsl:value-of select="."/>
    <xsl:if test="not(last())">,</xsl:if>
  </xsl:for-each>
  <xsl:text>
</xsl:text><!-- new line -->
</xsl:template>

However, if you have a very large document and performance is an issue, I would try an alternative to XSLT since XSLT requires a decent amount of overhead to build a DOM.

As it is, we'd have to know what languages you can work with, and the form of your input to know more.

[bimeldip]

Hi,
i want to convert xml data to csv data so that i can export it into MySQL database....using php or javascript...the aren't much working examples online....can anyone suggest any tutorial online site for me to visit...?
Thanks

[jkmyoung]

You need to break this down into 2 seperate tasks:

1. Convert xml to csv.
2. Load csv into MySQL

For #2, you're probably going to be using PHP as opposed to javascript.
One way is here:
http://dev.mysql.com/doc/refman/5.0/en/load-data.html

LOAD DATA LOCAL INFILE '/importfile.csv'
    INTO TABLE test_table
    FIELDS TERMINATED BY ','
    LINES TERMINATED BY '\n'
    (field1, field2, field3);

For #1, again taking advantage of existing XSLT processors would probably be the easiest for you, using the XSLT given above.
http://ca3.php.net/manual/en/functio...orm-to-xml.php

<?php
 
// Load the XML source
$xml = new DOMDocument;
$xml->load('collection.xml');
 
$xsl = new DOMDocument;
$xsl->load('collection.xsl');
 
// Configure the transformer
$proc = new XSLTProcessor;
$proc->importStyleSheet($xsl); // attach the xsl rules
 
echo $proc->transformToXML($xml);
 
?> 

[bimeldip]

Hi,
Just out of curiousity....can we export xml data to mySQL database directy?
Without converting it to csv?
Thanks for helping...!!!

[asearle]

Hi guys,

I've been following this thread as I also need to export to CSV (so that the user can import to Excel) but unfortunately I cannot use any server-side actions (e.g. PHP).

I am using XSLT along with JavaScript and so am hoping that someone can point me towards a HOWTO that shows me how I could (easily) export data (often already dynamically filtered in with JavaScript/XSLT) to file.

Any tips here would be most welcome.

Regards,
Alan Searle

[jkmyoung]

Old way of doing it with javascript:
http://www.w3schools.com/xsl/xsl_client.asp
but instead of using document.write, save the result to a file.

Another way:
http://developer.mozilla.org/en/docs...ransformations

Converting xml to csv with xslt:
http://www.thescripts.com/forum/thread696548.html

I'm unaware of how to bulk load xml with mySQL; there are definitely methods with MSSQL, using mapping schemas.

[asearle]

These tips look great. Many thanks: I will experiment with these techniques and am sure that one will fit my needs.

There is one other thing that I will need to sort out which is how to save the result to a separate (text) file or maybe open directly in Notepad.

Here I have been googling on key words but tend to come up with a lot of commercial products offering this functionality. That's very nice but really I would like to understand the whole process and be able to do it myself so was wondering whether you have any pointers to a HOWTO showing how this can be done (maybe with javascript)?

Many thanks,
Alan Searle