How Can I Create an XML to Create a Menu?

How to create a SQLite3 database from an XML file?

• Hi all, I have to create a database in SQLite3. I already have the sctructure of this database in an XML file (listing table and column names, attributes and so on). Is it possible to create/import the database in SQLite3 from an XML file? How can I do? Thanks in advance!

• Answer:

  If the data contained in the XML file is small it might be quicker to manually create the database structure using the sqlite3 CREATE commands. If the data contained in the XML file is such that it would take hours to process manually I would suggest using xsl transformation to generate the SQL CREATE statements from the XML file. I use xsl files to transform data stored in XML files into HTML or csv formats for reporting. I don't see why though with a little creativity you wouldn't be able to use xsl to generate a file with all the SQL statements necessary to create the DB contents from the XML file. If you need help on it post some of the xml data, If the data is sensitive you can change it. I'm only interested in how the XML is structured.