Importing to the database

Use this procedure to import either a binary or CSV-formatted data file into the database.

If the import encounters errors, the errors for each table are written to CSV files and listed in log files, which are then collected into a jar file named dbimportErr*.zip, where * is a numeric string to give the file a unique name. This file is placed in the FTP directory. To help avoid some obvious import issues, you can run the procedure in a validation mode.

Note: When using this procedure to populate data into a Boolean type field, any value other than zero or blank is imported and set the Boolean field to true.
  1. In the Administration Console, select Database > Import To Database.
  2. On the Import to Database form, specify this information:
    Business Class
    Select the business class to which you want to import data
    Subdirectory
    To import the data from a file in a sub-directory of the FTP site directory, specify that directory. Do not include the FTP site directory as it is defined in the ftpdirectory configuration parameter. Specify /gltxn02022022/ in this field to import from the gltxn02022022 subdirectory, assuming the FTP site directory is defined as AdminConsole in the configuration parameter.
    Do Not Save Errors to File
    Select this check box to skip creating an error file.
    Command Output Filename
    Specify a name for the command output file to override the default value of dbimport.txt.
    Import Error Filename
    Specify a name for the file containing error information to override the default value of dbimportErr.zip.
    Source Format
    Select either Zip File or CSV.
    Input Filename
    Specify the name of the import file.
    Import Options
    • Validate Only: Do not perform any updates. Create a report in the FTP directory.

      The list of errors is not exhaustive and can include items that might only be a problem on a specific database. The list does not attempt to discover all the errors that might be encountered when the actual import is attempted. For example, the validate option does not check for duplicates.

    • Duplicates:Select an option for dealing with duplicate records.
    • Include User Fields: Import any user field data that has been added to the business class.
    Delimiters and Patterns
    • Field Separator: When importing from a CSV file, specify a different separator here if you prefer one other than a comma.
    • Field Delimiter: When importing from a CSV file, specify a different delimiter here if you prefer one other than a double quote character.
    • Decimal Separator: When importing from a CSV file, specify a different decimal separator here if you prefer one other than a period.
    • Date/Time Format: If you are importing from a CSV file, select a format or specify a date/time format string that matches the CSV file.
    • Locale: When importing from a CSV file, select a locale if you prefer to specify one.
    • Encoding Type: Indicate the encoding type of the input file.
    Fields
    Select the fields to import.
  3. Click Submit to process the database import immediately or Schedule to schedule the database import.