Exporting from a work file

Use this procedure to export data from a work file.

  1. In the Administration Console, select Database > Export From Workfile.
  2. On the Export from Workfile form, specify this information:
    Workfile ID
    Select the ID of the work file to export data from.
    Subdirectory
    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 to override 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

    You must enclose the text values in single quotes and numerical values must not enclosed with single quotes.

    Delimiters and Patterns
    • Field Delimiter: When exporting to a CSV file, specify a different delimiter here if you prefer one other than a double quote character.
    • Field Separator: When exporting to a CSV file, specify a different field separator here if you prefer one other than a comma.
    • Decimal Separator: When exporting to a CSV file, specify a different decimal separator here if you prefer one other than a period.
    • 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 immediately or Schedule to schedule the work file data export.