This tutorial will describe each step required to perform an export collection operation:


Export to XML format:

Use this feature when you want to use the exported collection with softwares like Microsoft Access that support XML files as data importing sources.

After you choose the path and the name of the exported file, DJOBooks will create two files, one with the extension .xml (that will contain all the collection data) the other .xsd (compatible with the format of style file that Microsoft Access and similar software will need to correctly create the new collection): you will need both of them to import your collection to the database software.
If you're importing the collection file to Microsoft Access just create a new empty database and in the External Data tab select XML file option, select then the XML file you exported with DJOBooks and the 'import both data and structure' option. The collection will be correctly added to the new Access database you created.

If you plan to export to an old version of Microsoft Access or to a database software that supports XML files but doesn't recognize .xsd style files, you'll need to import the collection to that software first, then modify the table columns settings to have each column recognized as 'Text' field. For the old version of Access you'll also need to configure the 'Description'column as 'Memo' field instead of 'Text'.
When you're done with that just delete the rows you previously imported to the table and finally import the XML file again to that table, all the fields in the rows should now be handled correctly by your database software.


Export to CST format:

Use this feature when you want to use the exported collection with softwares like Open Office Base that doesn't support XML files as data importing sources.

After you choose the path and the name of the exported file, DJOBooks will create a .txt file with a Comma Separated Text formatting. When importing that file to a database software you will need to manually set the parameters first.
After you create a new empty database and choose to import the collection to a new table, select both the 'Delimited Field' and 'First line of text as column names' options. In the advanced settings dialog window set the field delimiter as '|' and change all the data column format to 'Text' field (your database software might not recognize numbers and dates correctly since formats are dependant upon regional cultures) and the 'Description' column to 'Memo' or 'Long Text' field. You can also choose to add a primary key column to the table.
After you're done with the previous steps perform the importing operation and the collection should be correctly added to the new table of your database software.