Export a Database to an XML File or Import an XML Database

General

  • The functions can be used to export the content of a database to an XML file or to import an XML file into Vertex database.
  • When exporting a database to an XML file, the program suggests opening the file in Excel. This is useful if the content of the database is to be modified, because mass changes are particularly fast in Excel.
  • If you want to import the XML file edited in Excel back to Vertex database, save the file in XML format and keep the file format.
  • Note that when importing an XML file into the Vertex database, all current data in the database will be lost and its content will be the data in the XML file.

Export a database to an XML file

  1. Select System | Databases | Maintenance > Export to XML File.
  2. Browse and select the database and click Open.
    • The program opens the Windows dialog box Save As.
  3. Accept or enter the name of the XML file and select the folder to save, and click Save.
    • The program asks Open file in Excel?
  4. If necessary, open the XML file in Excel by answering Yes or
    • Skip opening the file by answering No.
    • To open the file in Excel successfully, you must allow Excel macros to run.
    • Excel may still ask you how to open the XML file and suggest: As an XML table.

Import an XML file into a Vertex database

  1. First, back up the database whose contents you intend to replace with an XML file.
    • Copy the files d_DATABASE and d_DATABASEc to somewhere safe.
  2. Select System | Databases | Maintenance > Import from XML file.
  3. Select the database whose contents will be replaced with the contents of the XML file.
  4. Select the XML file that describes the database.
    • The program checks the validity of the XML file and tells you if it is not valid.
    • If the content of the XML file is valid, the program issues a warning stating that all data (X rows) will be deleted from the database and replaced with new data (Y rows).
  5. Answer the confirmation question
    • Continue: The content of the database will be the content that was in the XML file.
    • Cancel: The content of the database is not touched.