Importing separate files
- Sign in as Administration Console.
-
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.
-
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.
-
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.
- 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.