Add a vertical export definition

You record an export definition for horizontal export. Each field value being exported is on a separate line.

A vertical export often has the columns:

• A key: to determine the employee to which the value pertains, Field value (key field).
• A field code: external field name
• The value of a field: field value. The lines, which are printed one below the other and comprise a Record, are created on the Fields tab.

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 Horizontally in Export type.
8. Click on: Finish.

To record the export definition column layout:

1. Open the properties of the export definition.
2.  Go to the tab: Columns.
3. Record the column layout of the export file, for example a field name followed by a field value.

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.

6. Click on: OK.