MySQL Forums
Forum List  »  Connector/Node.js

xml format and importing
Posted by: IGGt .
Date: February 09, 2011 04:00AM

Hi Guys,

I have an XML file that I need to import into a MySQL database, but the xml format I am being given is not like anything I have seen before. It looks like:

<xml xmlns:s='uuid:xxx'
xmlns:dt='uuid:xxx'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='dt1' rs:ctout='30'>
<s:AttributeType name='ID' rs:number='1' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' dt:maxLength='255'/>
</s:AttributeType>
##this continues with a lot more <s:AttributeType> and <s:datatype>##
</s:ElementType>
</s:Schema>

<rs:data>
<z:row ID='123' Case_Create_Date='2011-02-02 11:59:30' Contact='Bob' . . . />
## This continues with all the data on a single line ##
</rs:data>
</xml>


Ideally I would like to use the schema section to create a table from, and then import the data element accordingly, but I have neve seen an XML file in this format, where the data is grouped on a single line, as opposed to being in individual tags.


Has anyone got any experience of working with this type of file? and could anyone suggest ways of importing it?

Options: ReplyQuote


Subject
Written By
Posted
xml format and importing
February 09, 2011 04:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.