Configuring dbimport options

• Directory: Data is imported from a directory.

• File: Data is in a file.

• Variable: Data is stored in a variable, which you can use later in the process.

Work file import

Select this check box to indicate that the import is a work file.

Note: 

You can only select one business class during a work file import.

Work file name

Specify the name of the work file.

Error directory

Specify the error directory path that stores the created error file. The error file is named in this format dbImport_<BusinessClassName>_error.csv.

Import from database instead of file system

Select this check box if the data to import is in the File Storage business class.

The key for the table depends on the selected location in step 1. For example, if you selected Directory and specified C:\temp, and the business class being imported is PfiWorkunit, then the key will be C:\temp\PfiWorkunit.csv.

Note: 

In a multi-tenant environment, the dbimport function automatically imports from the database.

Include user fields

Select this check box if the import data contains user fields that you must import.

Field separator

Specify the character used to separate each column in the exported data. Comma is standard in CSV format and the default for export.

Field delimiter

Specify the character used to wrap each column data. Quotation mark is standard in CSV format and the default for export.

Decimal separator

Specify the character to use to indicate decimal number, such as a period or comma.

Duplicate records

Select the action to perform if import data contains data that is already in the database:

• None: Ignore record and move to the next record.

• Overwrite: Overwrite the record.

• Update: Update the record.

• Ignore: Ignore duplicates. This is similar to the option None but does not record any errors.

Line separator

Select whether the line separator used in the import data is Unix style or Windows style.

Encoding type

Select the encoding used in the import data.

Date/time format:

Specify the date and time format to use.

Locale

Specify the locale to use for the date format.

Locale is used in combination with the date/time format.

Data area

Select the data area into where you import the data.

Use variable for data area

Specify a variable that holds the data area name such as <!appProdline>. If a value is specified here, data is imported into this data area. You must select a data area to build the command.

Modules

Select one or more modules in which to import data.

This is a list of available modules in the specified data area.

Modules/Business classes

Select one or more business classes in which to import data. If none is selected, all files in the specified directory are loaded.

This is a list of business classes for the selected modules.

The selected fields are displayed in the Activity information section of the General tab.