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 Management2017.11

Administer > Database administration > Data persistence > Importing records

Importing records

A system administrator can import ITSMA Service Management records from an external unload file using the Database Manager. Service Management 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 Management as a manual foreground process or as an automated scheduled background process.

How Service Management imports records depends upon the format of the source file. When importing unload files, Service Management uses the database dictionary stored in these files to determine where and how to import records into Service Management. The database dictionary inside an unload file determines whether Service Management updates or ignores duplicate records in the existing system. When importing text files, Service Management 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

Send Help Center feedback