File Format for Importing Document Sequences
You can import document sequences to your application by creating separate text files containing document sequence categories, document sequences, and document sequence assignments. You can then upload these files to the Oracle WebCenter Content document repository.
Here are a few things that you need to keep in mind while creating these files:
- Use a vertical bar or pipe ( | ) as a delimiter between fields for both the header and the value rows.
- According to the Oracle WebCenter Content specification, set the file encoding to UTF-8 without the Byte Order Mark (BOM).
- The first line in the file must be a header line, and the files must look exactly the same as shown in the sample file.
The following sections contain specific details about each file format.
Here's the supported file types for Document Sequence Data Loaders:
| Artifact | File Type |
|---|---|
| Document Sequence Data Loaders | DOCUMENT_SEQUENCE_CATEGORY |
| DOCUMENT_SEQUENCE | |
| DOCUMENT_SEQUENCE_ASSIGNMENT |
Document Sequence Category
To create a file containing document sequence categories, include the headers specified
in this table:
| Header | Data Type | Data Size | Description | Required or Optional |
|---|---|---|---|---|
ApplicationId |
Number | - | This value determines the application that your document sequence belongs to. | Required |
CategoryCode |
String | 30 | This value displays the category code associated with the document sequence type. | Required |
ModuleType |
String | 60 | This value displays the module type associated with the document sequence type. | Required |
ModuleKey |
String | 60 | This value displays the module key associated with the document sequence type. | Required |
TableName |
String | 30 | This value displays the name of the table. | Required |
CategoryName |
String | 80 | This value displays the category name associated with the document sequence type. | Required |
Description |
String | 240 | This value displays the description of the document sequence code. | Required |
Document Sequence
To create a file containing document sequences, include the headers specified in this
table:
| Header | Data Type | Data Size | Description | Required or Optional |
|---|---|---|---|---|
Name |
String | 30 | This value displays the name of the document sequences. | Required |
ApplicationId |
Number | - | This value determines the application that your document sequences belong to. | Required |
ModuleType |
String | 60 | This value displays the module type associated with the document sequences type. | Required |
ModuleKey |
String | 60 | This value displays the module key associated with the document sequences type. | Required |
Type |
String | 1 | This value displays the type name associated with the document sequences. | Required |
DeterminantType |
String | 30 | This value displays the determinant type name associated with the document sequences. | Required |
StartDate |
Date | - | This value displays the beginning of the date range during which the document sequences code is active and visible on the page. The format is dd/MM/yyyy. | Required |
EndDate |
Date | - | This value displays the end of the date range during which the document sequences code is active and visible on the page. The format is dd/MM/yyyy. | Optional |
InitialValue |
Number | - | This value displays the initial value of the document sequences. | Optional |
AuditTableName |
String | 30 | This value displays the name of the audit table. | Optional |
DisplayMessage |
String | TODO | This value displays the message. | Optional |
ValidateTransactionDate |
String | 1 | This value displays the validated transaction date. | Optional |
Document Sequence Assignment
To create a file containing document sequence assignments, include the headers specified
in this table:
| Header | Data Type | Data Size | Description | Required or Optional |
|---|---|---|---|---|
Name |
String | 30 | This value displays the name of the document sequences assignment. | Required |
CategoryCode |
String | 30 | This value displays the category code associated with the document sequences assignment. | Required |
MethodCode |
String | 30 | This value displays the method code associated with the document sequences assignment. | Required |
StartDate |
Date | - | This value displays the beginning of the date range during which the document sequences code is active and visible on the page. The format is dd/MM/yyyy. | Required |
EndDate |
Date | - | This value displays the end of the date range during which the document sequences code is active and visible on the page. The format is dd/MM/yyyy. | Optional |
DeterminantValue |
String | 30 | This value displays the determinant value of the document sequences. | Required |