Exporting from a work file

Use this procedure to export data from a work file.

  1. Select Administration Console > Database > Export from Workfile.
  2. On the Export from Workfile form, specify this information:
    Workfile ID
    Select the ID of the work file that you want to export data from.
    Subdirectory
    If you want to export the data to a file in a sub-directory of the FTP site directory, specify that directory.
    Command Output Filename
    Specify a name for the command output file if you do not want to use the default value of wfexport.txt.
    Destination Format
    Select either Zip File or CSV.
    Export Filename
    Specify the name of the export file.
    Export Options
    Filter String - Limit the output based on the specified filter value for the index keys of the file. For example: FinanceEnterpriseGroup=’XYZ’ and AccountingEntity=’0001’ and Status=9

    Text values should be enclosed in single quotes while numerical values should not.

    Delimiters and Patterns
    • Field Delimiter: If you are exporting to a CSV file and want to use a different delimiter than a double quote character, specify that here.
    • Field Separator: If you are exporting to a CSV file and want to use a different field separator than a comma, specify that here.
    • Decimal Separator: If you are exporting to a CSV file and want to use a different decimal separator than a period, specify that here.
    • Date/Time Format: If you are exporting to a CSV file and want to specify a date/time format, select the default (YYYYMMDD), select ISO Date/Time Pattern, or specify a date format string.
  3. Click Submit to process the work file data export now, or Schedule if you want to schedule the work file data export.