Update an export descriptor record

To update an export descriptor record:

1. Select the records to export.
2. From the file.prompt.dbu.g form, also known as the unload/export utility, click Export Ext.
3. If Service Manager displays a list of existing export descriptor records, select the export descriptor record to use.
4. Click Edit Record.

5. Fill in the following fields.

   Field	Description
   Export Descriptor Record	Type the name used to identify this record uniquely.
   File Name	Type the name of the Service Manager table used to export 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 Names	Type the database dictionary name of the Service Manager field used to export records. 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, you only need to type the field name.
   Field 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.
   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 used to export the field information. Most external files use a standard of 80 characters per line. If you type a value greater than 80 then each record uses 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 from an array to be exported for this field. 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 per element, this field requires a total of 400 character spaces. The next field should start 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.

   
   
6. Click Save.

Related topics

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

Add an export descriptor record
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

Unload error messages
Load error messages and notifications