I’ve exported the database to XML
Is it possible to convert structured XML to become suitable for other database
For exampl
I want to convert this xml structure
<datafield tag="400" ind1=" " ind2=" ">
<subfield code="a">6</subfield>
</datafield>
<datafield tag="245" ind1=" " ind2=" ">
<subfield code="a">introduction</subfield>
</datafield>
<datafield tag="260" ind1=" " ind2=" ">
<subfield code="a">Mohamed , Samy</subfield>
<subfield code="c">2010</subfield>
</datafield>
to this structure
<article_settings>
<article_id>6</article_id>
<locale>en_US</locale>
<setting_name>title</setting_name>
<setting_value>introduction</setting_value>
<setting_type>string</setting_type>
</article_settings>
<article_settings>
<article_id>6</article_id>
<locale>en_US</locale>
<setting_name>cleanTitle</setting_name>
<setting_value>introduction</setting_value>
<setting_type>string</setting_type>
</article_settings>
<article_settings>
<article_id>1</article_id>
<locale>en_US</locale>
<setting_name>abstract</setting_name>
<setting_value>intro to </setting_value>
<setting_type>string</setting_type>
</article_settings>
<article_settings>
<article_id>1</article_id>
<locale>en_US</locale>
<setting_name>sponsor</setting_name>
<setting_value></setting_value>
<setting_type>string</setting_type>
</article_settings>