Converting to XML format

You can convert data in an extract file into XML format.

1. Expand a folder in the Directory Explorer that contains the convert service, expand the Convert Services node, and double-click the convert service to edit.
   The Convert Service Editor opens.
2. Select the Target File Options tab.
3. In the Target file format list, select XML.
4. In the Target file name field, enter a name of the target file, which will be used for tables that do not have a target files specified. Select Use file macro to enter Optim™ file macros that dynamically create unique target file names for each table.
5. Use the Object Files tab to optionally define thresholds for converted files or enter target file names for the converted tables.

   To modify the default thresholds, click Edit Thresholds to open the Target File Defaults window and modify the defaults. Use the grid to override the default thresholds for an object.

   To generate unique files for tables, use the grid to enter file names if a macro is not used or to override the macro. The grid is populated with table names in the associated table map.

   The following guidelines apply to files generated for a specific table:

   • If you do not specify a file name, the service will create a file with the name specified in the Target file name for the service.
   • If you do not specify a fully-qualified path for the file, the converted file will use the same location as the Target file name for the service.
6. Use the XML Options tab to define formatting options for the XML files.
7. Save the convert service.