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 create CSV template files that contain only headers without any data. A template file is generated automatically when you export a file that has no records. Alternatively, you can select the Create Template export option to generate a header-only CSV file, even if the source 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. In the Administration Console, select Database > Export From Database.
  2. On the Export from Database form, specify this information:
    Business Class
    Select the business class from which you want to export data.
    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 dbexport.txt.
    Destination Format
    Select either Zip File or CSV.
    Export Filename
    Specify the name of the export file that contains the command output file.
    Export Options
    Specify the export options:
    • Do Not Dump Large Objects: Exclude large database objects or 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. Using this option includes the translations 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

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

    Delimiters and Patterns
    Specify the delimiters and patterns:
    • Field Separator: When exporting to a CSV file, specify a different field separator here if you prefer one other than a comma.
    • Field Delimiter: When exporting to a CSV file, specify a different delimiter here if you prefer one other than a double quote character.
    • 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 and time format, select the default YYYYMMDD, select ISO Date/Time Pattern, or specify a date format string.
    • Locale: When exporting to a CSV file, select a locale if you prefer to specify one.
    Fields
    Select the fields to export.
  3. Click Submit to process the database export immediately or Schedule to schedule the database export.