Exporting from the database

Use this procedure to export from the database. This procedure creates a binary or a CSV file containing data from a Landmark-defined database file. You can load this data into a Landmark system using the Import to Database from FTP form.

You can also create CSV template files that contain only headers but no data. You can do this in two ways: 1) if you export a file that contains no records, then a CSV template file with headers only is created, or 2) if you select the Create Template export option, then a CSV template file is created with headers only even if the file contains records.

Caution: 
Do not use this procedure to export data from a non-Landmark defined database file.
Caution: 
Do not use this procedure to copy GEN (Environment) data from one machine to another.
  1. Navigate to Start > Applications > Administration Console > Database > Export from Database.
  2. On the Export from Database form, specify this information:
    Business Class
    Select the business class 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 dbexport.txt.
    Destination Format
    Select either Zip File or CSV.
    Export Filename
    Specify the name of the export file that will contain the command output file.
    Export Options
    Specify the export options.
    • Do Not Dump Large Objects: Exclude large database objects (LOBs) from the export.
    • Include User Fields: Export any user field data that has been added to the business class.
    • Include Translations: Include translations in a CSV file. If you use this option, the translations will be included in the main export file in a column named in the format: fieldName{locale}, for example name{es_ES}.
    • Create Template: Create a CSV template file that contains only headers even if the database file contains records.
    • Set Name: Specify an index name to export the data using an index sequence.
    • 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
    Specify the delimiters and patterns.
    • Field Separator: If you are exporting to a CSV file and want to use a different field separator than a comma, specify that here.
    • 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.
    • 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 and time format, select the default YYYYMMDD, select ISO Date/Time Pattern, or specify a date format string.
    • Locale: If you are exporting to a CSV file and want to specify a locale, select one.
    Fields
    Select the fields that you want to export.
  3. Click OK to process the database export now, or Schedule if you want to schedule the database export.