Creating a data search

A Migrator search allows you to create specific search criteria of your data records for a customized migration. This option is not available if the source is a file.

To create a data search

1. In the Data Migration Settings dialog box under Data Settings, select Search Selection from the Data Mode list box.
   If you supply a number in the Number of Entries text box, only the first number of entries that match the search are migrated.
2. To create a search, click the list box next to the Search Criteria text box.
   
3. In the Search Criteria dialog box, enter search criteria. Use the following methods to help build a search:
   • Click Fields to display a menu for fields, selection values, and keywords.

   • Select Fields, Selection Values, or Keywords to display submenus with variables that are specific to the data records you are migrating.

     Important

     Because Migrator relies on the API to generate qualification structures, Migrator does not support using locale-specific formatting in qualification strings. The API supports generic formatting such as dd-mm-yy for dates and number formats without punctuation (such as 15000 instead of 15,000 ). Because of this, do not use spaces, comma-separated values, or any other locale-specific punctuation when entering qualifications in Migrator. For example, when entering a keyword, be sure that there are no spaces. An entry such as*$ TIMESTAMP$* (with a space between the $ and the T ) causes an error.

     Here are some examples of searches you can create:

     'Creator' = "Administrator" AND 'License Type' = "Fixed"

     In this example, Migrator searches for entries created by an administrator user with a fixed license.

     'Creator'= "Jane Doe"

     In this example, Migrator searches for entries created by the user Jane Doe.

4. Click OK to use the search, or Cancel to stop it.
   Your search criteria appear in the Search Criteria field of the Data Migration Settings dialog box.
   Search criteria for data migration