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 will be imported and will set the Boolean field to true.
  1. Select Start > Applications > Administration Console > 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
    If you want 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. For example, if the FTP site directory is defined in the configuration parameter as "AdminConsole" and you want to import from a sub-directory of that called "gltxn02022022", then specify /gltxn02022022/ in this field.
    Do Not Save Errors to File
    Select this check box if you do not want to create an error file.
    Command Output Filename
    Specify a name for the command output file if you do not want to use the default value of dbimport.txt.
    Import Error Filename
    Specify a name for the file containing error information if you do not want to use 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 will not be exhaustive and may include items that might only be a problem on a specific database. Also, 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: If you are importing from a CSV file with a different field separator than a comma, specify that here.
    • Field Delimiter: If you are importing from a CSV file with a different delimiter than a double quote character, specify that here.
    • Decimal Separator: If you are importing from a CSV file with a different decimal separator than a period, specify that here.
    • 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: If you are importing from a CSV file and want to specify a locale, select one.
    • Encoding Type: Indicate the encoding type of the input file.
    Fields
    Select the fields that you want to import.
  3. Click OK to process the database import now, or Schedule if you want to schedule the database import.