Importing separate files

  1. Sign in as Administration Console.
  2. Select Other > FTP Setup to ensure that configuration parameters are set for the FTP directory.

    Select System Configuration Parameters to view all configuration parameters for the Administration Console.

    See the Infor Landmark Administration Console Configuration and User Guide.

  3. Sign in as Process Server Administrator and set up file channel configuration. Set up file receivers for all import files.

    See the Process Automation Administration Guide.

  4. After the import source files are created, sign in to Administration Console and select Database > Import to Database.
    Business Class
    Specify the business class for the database import.
    Subdirectory
    Specify an optional subdirectory to place the output database in.
    Command Output Filename
    Specify a file name for the database command output.
    Skip Error File
    Select this check box to prevent the system from saving errors to a separate file.
    Error Filename
    Specify a error file name if you did not select the Do Not Save Errors to File check box.
    Source File Format
    Select CSV to save the file in CSV format.
    Import Filename
    Specify a file name for the import source file.
    Validate Only
    Select this check box to prevent the system from performing any updates. A report is created in the FTP directory.

    The list of errors is not exhaustive and may include items are only a problem on a specific database. The list does not include all of the errors that might be encountered when the import is attempted. For example, the validate option does not verify for duplicates.

    Field Separator, Field Delimiter, Decimal Separator
    Specify the characters to use as field separators, field delimiters, and decimal separators for the output.
    Note: If your string data contains embedded commas, in names and descriptions, for example, use a delimiter other than a comma for the CSV file.
    Date Time Format
    Select the date and time format for the database.
    Locale
    Select the location for the database.
    Encoding Type
    Select the character encoding type to use.

    See the Infor Landmark Administration Console Configuration and User Guide.

    A source directory is created for each business class.

  5. After each Import to Database process for each business class, run the interface program for the solution for which the database was created. to complete the import process.