Importing to a work file

Use this procedure to import data to a work file. When data is imported, you can use your application's data interface function to process the work file. See your Landmark application's user guide.

  1. In the Administration Console, select Database > Import To Workfile.
  2. On the Import to Workfile form, specify this information:
    Workfile Business Class
    Select the name of the class to which the work file belongs.
    Work File Name
    Select the work file into which you want to import data.
    Subdirectory
    If you are importing the data from a file in a sub-directory of the FTP site directory, specify that directory.
    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 wfimport.txt.
    Import Error Filename
    Specify a name for the file containing error information to override the default value of wfimportErr.zip.
    Source Format
    Select either Zip File or CSV.
    Import Filename
    Specify the name of the import file.
    Import Options
    Validate Only. Select this check box to validate without importing.
    Delimiters and Patterns
    • Field Delimiter: When importing from a CSV file, specify a different delimiter here if you prefer one other than a double quote character.
    • Field Separator: When importing from a CSV file, specify a different field separator here if you prefer one other than a comma.
    • Decimal Separator: When importing from a CSV file, specify a different decimal separator here if you prefer one other than a period.
    • Line Separator: Specify Windows or Unix as the line separator type.
    • Date/Time Format: If you are importing from a CSV file with a different date/time format that the default (YYYYMMDD), select ISO Date/Time Pattern, or specify a date format string.
    • Encoding Type: Specify the encoding type of the import file.
    • Locale: If you are importing from a CSV file with a locale different than the default, select the appropriate one.
  3. Click Submit to process the work file data import immediately or Schedule to schedule the work file data import.