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.
Words and Phrases
| 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. |
Using Boolean Operators
| 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 |
|
- Data persistence
- Database dictionary
- Keys and indexes in Service Manager
- Data maps
- Exporting records
- Importing records
- Import descriptor records
- Load error messages and notifications
- Unload files
- Add an import descriptor record
- Import a character-delimited text file
- Import a fixed-width text file
- Load an unload file
- Schedule the importing of records using an import descriptor record
- Schedule the loading of an unload file
- View the contents of an unload file
- Unload script utility
- Purging and archiving records
- Add, delete or update a master data record
- Database record auditing
- IR Expert
- Record retrieval
- Queries
- Database performance tuning
- Running the database maintenance utility
Importing records
A system administrator can import Service Manager records from an external unload file using the Database Manager. Service Manager can import records from all three formats of unload files (binary unload, text unload, and formatted text unload) as well as from two formats of text files (fixed-width and character-delimited text files). You can import records into Service Manager as a manual foreground process or as an automated scheduled background process.
How Service Manager imports records depends upon the format of the source file. When importing unload files, Service Manager uses the database dictionary stored in these files to determine where and how to import records into Service Manager. The database dictionary inside an unload file determines whether Service Manager updates or ignores duplicate records in the existing system. When importing text files, Service Manager requires an import descriptor record to tell it where and how to import records. You can define an import descriptor record during the import process or prepare one in advance.
An import descriptor record defines:
- The external file source
- The internal destination table
- The format used to identify fields in the imported file
- Fixed-width fields
- Character-delimited fields
- The rules for handling duplicate records
- Ignore duplicate records
- Replace duplicate records
- Update duplicate records
- The optional Format Control record to apply
- The names of destination fields for import records
- The date format to use
- The number of elements from an array to import
Related topics
Data maps
Exporting records
Import descriptor records
Unload files
Purging and archiving records
Unload script utility
Master data records
Add an import descriptor record
Import a character-delimited text file
Import a fixed-width text file
Load an unload file
Schedule the importing of records using an import descriptor record
Schedule the loading of an unload file
View the contents of an unload file
Load error messages and notifications
