Geek asks and answers

Using XML and XSD to create a populated database

I'm not sure if this is possible, but decided that I would ask and see if I could get any information.

As the name implies, I have an XML file with thousands of lines. I also have an XSD schema file associated with it.

I was wondering if it is possible for me to convert this data to a MySQL database without manually specifying XPath material?

For example, is it possible for Java or Python or any other program to analyze the XSD-based XML structure, retrieve the table columns and populate it with data?

I tried using PHPMyAdmin to import my XML file, but it didn’t work and said that there is a problem which, I think, is related to the fact that it cannot create columns. As far as I know, it can handle CSV files better, so there’s another option for two-step conversion.

Thank.

+5
source share
2 answers

Use XMLImport to load XML from XSD into Excel, save as CSV or format to the desired XML format, such as Wordpress , then import into MySQL.

+1
source

Try XMLPipeDB to create relational databases from XSD files.

+3
source

More articles:


All Articles