Add a horizontal export definition

You record an export definition for horizontal export. Each file being exported is a single line in the export file. For each field (column), you must record a fixed width. If the export value is shorter, then it is padded with leaders (such as spaces).

To add an export definition:

1. Go to: General / Configuration / Log / Export definition.
2. Click on: New.
3. Enter a code and description.
4. The export file name is the name used for the file being exported.
5. Select the table that you want to export in Export calculation basis.
6. Select an Export method. Select Entries only (logging required) if you only want to export logged entries from the log.
7. Select Vertically in Export type.
8. Click on: Finish.

To add fields to be exported to the export definition:

1. Open the properties of the export definition.
2. Go to the tab: Columns.
3. Add a field:
   1. Click on: New.
   2. Determine whether you want to add a key field. Key fields are unique fields used to identify records, such as the ID for an employee.
   3. Click on: Next.
   4. The External field name is the name that you want to use in the export file. Here, you can enter the name used in the external application.
   5. Select the Export field type.

      Select Script if you want to combine multiple fields or if you want to make changes to field values.

   6. Click on: Next.
   7. Enter the properties of the fields to be exported. The Column width is the field length in the export file. If the value being exported is shorter than the Column width, then the value is padded with leaders.
   8. Depending on the selection in Export field type, you may need to record additional data.

      For a Field value, select the field and specify additional settings, such as the format. For a script field, you must record the script afterwards.

4.  Click on: Finish.
5. To record a script:
   1. Open the properties of the script field.
   2. Go to the tab: Script.
   3. Supplement the sample script. Add your changes at the indicated place in the sample script.

      For scripts, you can use all of the options of VBScript. For a complete overview of the VBScript options, please see the following website: Visual Basic Script. Some script samples for export are also provided in this Help.

   4. Click on: OK.