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)`

Universal DiscoveryContent Pack 28.00 (CP28)

Integrate > Third Party Integrations > Import From Excel Workbook Discovery > How to Import Data from Excel Workbook

How to Import Data from Excel Workbook

This task describes how to run the Import from Excel discovery. The Import from Excel Workbook job imports data from the Probe's file system (or accessible network share), so no credentials are required.

Note

The Import from Excel Sample job is similar to the Import from Excel Workbook job. It differs only by reference to the sample import file.
This integration is configured to run in remote process.

Prequisite- Set up the Import file in Excel

For details on setting up the import file, see How to Set Up an Import File in Excel.
Prerequisite - Set up permissions

Give the Data Flow Probe read permissions on the location on the file system where the import files are stored.
Run the discovery
In the Integration Studio, create a new integration point.
1. Provide a name and description for the integration point.
2. Under Integration Properties > Adapter, select the Import topology from Excel Workbook adapter.
3. Under Adapter Properties > Data Flow Probe, select the Data Flow Probe.
4. Under Adapter Properties > Trigger CI instance select one of the following:
  - Select Existing CI (if you have a valid, existing CI). The Select Existing CI pane appears. Select the CI and click OK.
  - Create New CI (if you need to create a new CI). The Topology CI Creation Wizard appears. Create the CI using the Wizard.
    
    Note For details on the Topology CI Creation Wizard, see "Topology CI Creation Wizard" in the Data Flow Management section of the UCMDB Help.
5. Save the Integration Point.
6. Run the job.
Note For details on running an integration job, see "Integration Studio" in the Data Flow Management section of the UCMDB Help.

Send Help Center feedback