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.
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 |
|
|
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 | ^ (caret) |
cat ^ mouse
|
A combination of search types | ( ) parentheses |
|
- 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
Unload an individual record
Applies to User Roles:
System Administrator
To unload an individual record:
- Click Tailoring > Database Manager.
- Type the form or file name that contains the record to unload.
- Select the Administration Mode option. You must select this option to ensure that Service Manager displays the unload options in the target form.
- Click Search.
- Click the form used to search for the record.
- Fill in optional search criteria.
- Click Search.
- Select the record to unload.
- Click More or the More Actions icon for the record, and then select Export/Unload.
-
Fill in the following fields.
Field Description External File Name Type the name and path of the file used to save the record. By default, this file is located in the RUN folder of the Service Manager server. Member This field is obsolete. Unload Type Select the operating system file type to use for the external file. Append to File Select this option to add records to the end of an external file of the same name. If a external file of the same name does not exist, Service Manager creates a new file. If this field is cleared, then Service Manager overwrites any existing file of the same name. Use Data Map Select this option to use a pre-defined data map when unloading the selected records. Using a data map may result in Service Manager unloading more records than you originally selected to unload. Prompt for Data Map Select this option to enable a confirmation message to use a data map for each record unloaded. This option is only valid if the Use Data Map option is also enabled. Suppress Messages Select this option to hide all messages that the unload process generates. Export Mode — Binary Select this option to save the external file in Service Manager’s binary unload format. Only the Service Manager Database Manager can read this binary file format. Export Mode — Text Select this option to save the external file in Service Manager’s text format. This format is human readable but is not intended for export to other applications other than Service Manager’s Database Manager. Export Mode — Formatted Text Select this option to save the external file in a user-defined text format. This format is intended for export to other applications. If you select this option, you must type a valid Service Manager form name in the Form Name field. Form Name Type the name of the Service Manager form to use when exporting records as formatted text. This option is valid only with the Formatted Text option is selected. If the text format description does not already exist, Service Manager prompts you to create it. Dbdict Load Options — Create file if not there, and update if present Select this option if the data saved in this external file should replace existing data in the target Service Manager system. Dbdict Load Options — Create file if not there, but do not update if present Select this option to ignore data saved in the external file that already exists in the target Service Manager system. Dbdict Load Options — Create file if not there, and update if present, including keys Select this option if the data saved in this external file should replace existing data in the target Service Manager system including the database keys. Dbdict Load Options — Create file if not there, and update if present, including SQL mapping Select this option if the data saved in this external file should replace existing data in the target Service Manager system including the database SQL mapping. Dbdict Load Options — Create file if not there, and update if present, including keys AND SQL mapping Select this option if the data saved in this external file should replace existing data in the target Service Manager system including the database SQL mapping and the database keys. Record Load Options — Add/update records Select this option if the records saved in this external file are to replace any existing records in the target Service Manager system. Record Load Options — Only add new records Select this option to ignore records saved in the external file that already exist in the target Service Manager system.
- Click Unload/export.
Related topics
Data maps
Exporting records
Export descriptor records
Unload files
Importing records
Purging and archiving records
Unload script utility
Master data records
Load/unload implications of case-sensitivity
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 records from multiple files
Unload selected records from a file
Update an export descriptor record
Unload error messages