Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
|A single word||
||Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".|
You can specify that the search results contain a specific phrase.
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.
Two or more words in the same topic
|Either word in a topic||
|Topics that do not contain a specific word or phrase||
|Topics that contain one string and do not contain another||
|A combination of search types||
- Exporting records
- Export descriptor records
- Unload error messages
- Unload files
- Add an export descriptor record
- Delete 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
- Update an export descriptor record
Update an export descriptor record
Applies to User Roles:
To update an export descriptor record:
- Select the records to export.
- From the file.prompt.dbu.g form, also known as the unload/export utility, click Export Ext.
- If Service Manager displays a list of existing export descriptor records, select the export descriptor record to use.
- Click Edit Record.
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.
- Click Save.
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