Enterprise Content Management (CSV) Tab

The Enterprise Content Management (CSV) tab displays when you convert an Archive File to Enterprise Content Management (CSV) format. The options on this tab are described below.

Default Thresholds
File Size (MB)
Specify the maximum size of the converted file. Allowable values are 1 to 9,99,999,999,999. The default is 5 MB.
Row Count
Maximum number of records to be written to converted file. If this count is reached, a new file would be created. Specify a value in the range 1 to 9,99,999,999,999. There is no default.
Number of Files
Maximum number files that can be created for a table or view. Specify a value in the range 1 to 9,99,999,999,999. There is no default.
Macro Options
Use File Macro
Select this check box to use a macro to create unique files for each table shown in the grid.
Macro:
Specify the name of the Optim macro to be used to generate the unique file names. For example: Specify the $OBJNAME macro to generate a file name that includes the name of the table or view. For details on using Optim macros to generate file names, refer to the Common Elements Manual, Appendix A. Enhanced File Names.
ECM Options
Select this to display the following:
Meta Data Options
Generate Meta Data
Selecting this check box writes the column names at the beginning of the first record for a table. You can specify the following:
Beginning Label:
You can specify a label, up to 10 characters, to be prefixed before the first column name.
End Label:
Specify a label, up to 10 characters, to be suffixed after the last column name.
Header Delimiter:
Character to be used to separate column names. Specify 1 character. The default is a dash (-).
Null Field Options
Use Null Field Value
Select this check box to replace any column with a null value with a string.
Null Field Value
Specify the string, up to 15 characters in length, to be used as a replacement value for any column that has a null value.
Field Delimiter
This parameter is required. Specify 1 character to separate column values. The default is a comma (,).
Escape Character
Specify a single character to be prepended to any string column values. If you specify an Escape Character, Optim scans all character data. There is no default.
Note: Use caution before specifying an Escape Character, as scanning all character data imposes significant impact on processing.
String Delimiter
Character to delimit string column values. There is no default.
Archive Metadata Options
Select a check box to include metadata for:
  • Archive File Name
  • Archive Description
  • Archive File Creation Date
  • Archive GUID
LOB/XML Options
Include LOB/XML Columns
Select this check box to have a separate file created for each LOB or XML column in each row.
LOB/XML Directory
Fully qualified path to the directory for the LOB/XML column files to be created. If the check box to Include LOB/XML Columns is not selected, the LOB/XML Directory box is unavailable.