Add an export descriptor record

To add an export descriptor record:

1. Click Tailoring > Database Manager.

2. In the Form field, type =export, and click Search.

   A list of existing export descriptor records is displayed.
   

3. Select a record from the list, and update the following fields.

   Field	Description
   Export Descriptor Record	Type the unique name for this record.
   Service Manager File Name	Type the name of the Service Manager database table exporting records.
   Format Control Record Name	Type the name of the optional Format Control record to use with the export process. This Format Control record determines how Service Manager formats exported records.
   Field Name	Type the database dictionary name of the fields exporting data. If the field is part of a structure, include the structure name before the field name. If the field is part of an arrayed structure, type only the field name.
   Field Type	Service Manager fills this field automatically using the database dictionary definition of the field. You do not need to type any information in this field.
   Start Pos	Type the number of space characters between the start of a line and the information Service Manager exports from the selected field. This information determines which column and line number Service Manager uses to export the field information. Note: Most external files use a standard of 80 characters per line. If you type a value greater than 80 then each record will use multiple lines.
   Fld Lng	Type the number of characters Service Manager has to write information from the exported field into the external file.
   Array Type	Service Manager fills in the value of this field automatically based on the database dictionary definition of the field. You do not need to manually type any information in this field.
   Array Occ	Type the number of elements in an array that you want Service Manager to export. You can use the Array Occ value to determine the start position of the next field. For example, if you want to export five elements from an array and you allocated 80 character spaces for each element, this field requires a total of 400 character spaces. The next field should begin more than 400 characters spaces from the start of the file.
   Date Format	Type the date and time format for date and time fields. You can use the following tokens to represent units of time: dd — two-digit day mm — two-digit month yy — two-digit year yyyy — four-digit year hh — hours ii — minutes ss — seconds You can use any character to separate these tokens. For example, mm/dd/yyyy hh:ii:ss exports dates and times with slashes between the month, day, and four-digit year and colons between the hours, minutes, and seconds. Note: If you do not include a time format, then Service Manager does not export any time information.

4. Click Add.

Related topics

Data maps
Export descriptor records
Exporting records
Importing records
Purging and archiving records
Master data records
Unload files
Unload script utility

Unload error messages

Export a record list to a text file
Export a record list to an Excel file
Export a record list using an export description record
Export an individual record using an export descriptor record
Export selected records from a table using an export descriptor record
Schedule the exporting of records using an export descriptor record
Schedule the unloading of records
Unload a database dictionary only
Unload a record list
Unload an individual record
Unload records from multiple files
Unload selected records from a file
Update an export descriptor record