Starting from version 1.50 ADC can export its internal database into some external formats (enhancing standard reports feature). Just select ”File | Export | Database…” menu item (please note that it is available only if the current database contains at least one disk); ADC will prompt you for the file name, and after confirmation all the descriptions (for the files and folders on a given disk) will be exported.
Currently four external database formats are supported (you have to select one):
CSV-files (comma-separated values) - may be useful for further import into MS Excel,
DBF-files - may be useful for further import into MS Access or any DBF-compatible software,
SQL-files - may be useful for further import into MS SQL or My SQL database (for web publishing),
XML-files - common HTML extension files format.
You can select either single Volume (Disk) or all disks stored in current ADC database file to be exported.
You can also select either single Category or all categories for export.
In Objects field you can select what data you want to export – files only, folders only, or both files and folders.
On the Export fields panel you can select fields of ADC database to be included in resulting file, please note that you should select at least one field for export operation to be proceed! You can use Check all, Uncheck all or Invert all buttons to apply the appropriate action on the fields selection.
Then you have to select Output file name – you can either enter the filename manually (please take into account what the current directory is) or use Browse button.
On the Comments panel you can select how you want to store Comments field in the resulting file. Comments text field can be stored either As is (please note that in some case it may cause problems with import of the resulting file), or Removing line-breaks (CR/LF chars will be skipped to convert multi-string text into single line), or Keeping first line only (only text until first CR/LF will be stored). You can also set the Comment field size (in chars) – this value can not be longer than 4096 (text longer than the entered value will be skipped). Of course these options will take effect only if the Comment field is chosen for exporting.
If the option Skip item with empty Comments is enabled – only files (or/and folders) with non-empty description will be exported (this option will take effect even if the Comment field is not chosen to be exported).
The option Store Comment as MEMO is available if the DBF file is selected as target type. If this option is selected – the comment text will be stored as MEMO field in additional file with the same name as DBF file and extension “.FPT” – this will require a less of total size and can avoid some problems with further importing in MS Access application.
As the final step you have to click on the Export button to perform operation using selected options (you can repeat this as many times as you need – for example changing fields for each disk or category), to close Export dialog click on the appropriate button (please note that fields selection will be stored for further use).