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.