Forum Moderators: open

Message Too Old, No Replies

Xml to Mysql

Xml to Mysql

         

carpromods

3:49 am on Sep 22, 2007 (gmt 0)

10+ Year Member



Hey Webmasters,

I have a client that has supplied me with an XML file to import into cre loaded oscommerce database.

The XML file is a direct export from the MS access database.
when i try to import it into the database it gives me an error. when i view it inside the xml viewer all The file has is the product information with attributes and description and meta tags information.

Is there any easier way to import the XML information into the MYSQL database?

physics

8:49 pm on Sep 22, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I would probably write a Perl script using XML::Simple or something like that to read the XML into a data structure and then insert this into the database.

Not sure if PHPMyAdmin has an XML import mode but it's worth a look also...

carpromods

5:00 am on Sep 23, 2007 (gmt 0)

10+ Year Member



not exactly sure what you mean by that cna you give me an example so i can understand it better?