Configuring dbimport options

The DbImport Builder is used to set up dbimport commands.

  1. Select the location from where the input data will come:
    • Directory: data will be imported from a directory.

    • File: data is in a file.

    • Variable: data is stored in a variable, which can be used later in the process.

  2. Specify this information:
    Work file import

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

    Note: 

    Only one business class can be selected during a work file import.

    Work file name

    Specify the name of the work file.

    Error file (zip)

    Specify the path pointing to the file, if any, that contains error information.

    Import from database instead of file system

    Select this check box if the data to be imported 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 will automatically import from the database.

    Include user fields

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

    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 be used to indicate decimal number such as a period (.) or comma (,).

    Duplicate records

    Select the action to be performed 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 be used.

    Locale

    Specify the locale to be used for the date format.

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

    Data area

    Select the data area into where you will 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 will be imported into this data area. Data area must be selected 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 will be loaded.

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

  3. Click OK.

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