Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.41

Administer > Database Administration > Data persistence > Exporting records > Add an export descriptor record

Add an export descriptor record

Applies to User Roles:

System Administrator

To add an export descriptor record:

Click Tailoring > Database Manager.
In the Form field, type =export, and click Search.

A list of existing export descriptor records is displayed.

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.

Click Add.

Send Help Center feedback