ExportTool
The indexed link and full text index types, the triple index type for reverse relation metadata and the metadata database themselves are supported by all Axiell software, but exporting data from databases with these table types can only be done either through Axiell Collections or via exporttool.exe. Axiell Designer and export.exe however, are not capable of such exports and probably won’t ever be as they will be deprecated in favour of exporttool.exe. Exporttool.exe has been developed to support all current database table types used by Collections and to thereby replace Designer and export.exe for Adilb Tagged, CSV (comma-separated fields) or (Grouped) Adlib XML export jobs.
The export jobs themselves can still be made in Designer and all options are supported in exorttool.exe. However, some options can be overridden via exporttool.exe command-line options.
Remember that after creating the export job in Designer, you should not run it from Designer if your database contains the new types of indexes: then always use the tool.
The command line syntax of this tool is:
Exporttool.exe -p <path to export job folder> -e <name of export job> -l <optional path to log file>
Complete list of command-line arguments:
Argument |
Alternative argument |
Optional / Mandatory |
Description |
-e |
--export-job= |
mandatory |
Name of export job file, without path. |
-t |
--type= |
optional |
Set it to the desired export format: Tagged, CSV or AdlibXml. AdlibXml exports to the Grouped variety. If this option is set, it overrides the default Adlib Tagged format to which a Designer export job would normally export. |
-r |
--resolve-links= |
optional |
Set to true or false. If set, it overrides the Links option set in the export job. |
-p |
--path= |
optional |
Full or relative path to the export job file folder: enclose it in double quotes if the path contains spaces. If no path is provided, the export job file should be present in the current exporttool.exe folder. A relative path should be relative to the folder containing exporttool.exe. |
-m |
--occurrence-mode= |
optional |
For a CSV export it is important to indicate if you'd like All occurrences (which is also the default), only the First occurrence or the Preferred occurrence of repeated media reference fields to be exported and the first of all other fields. (For Preferred, if no preferred media reference is found, the first media reference is exported by default.) If you select All, you may also want to specify the occurrence separator text (see below) because all occurrences will be concatenated as if they were a single field value. |
-s |
--occurrence-separator |
optional |
If for a CSV export, you selected occurrence mode All, you'll probably also want to specify the occurrence separator text because all occurrences will be concatenated as if they were a single field value. By default, a new line is used as separator. Choose a text or character other than a comma or new line because the comma is already used to separate fields. Enclose it in double quotes. |
-f |
--export-file= |
optional |
Optionally specify an alternative file name to the file name specifed in the export job, possibly including a (relative) path. By default, the file is placed in the folder containing the export job file. |
-l |
--log-file= |
optional |
Path to optional log file: include the desired log file name in the path, e.g. mylog.txt. |
--help |
|
optional |
Display this list of argu-ments. |
--version |
|
optional |
Display version information about exporttool.exe. |