Bulk Search Template

To set up a bulk search you will need a CSV with all of your searches. A bulk search CSV can be used once or as a template for future search processes.

A CSV file is easily created in excel but can be made in notepad or any text editor. It is a file type that separates information with a comma. It is the simplest way for Aiimi Insight Engine to read multiple searches in an organised way.

The first value of your CSV must be "Search Name". The file will fail to upload if this says anything else.

Creating a CSV

Create a CSV In Excel

There is a maximum limit of 50 rows and columns and a size restrictions of 1MB or less per CSV.

1. The first cell (A1) must be Search Name.

   • The file will not upload if it is anything else.

The next rows will contain the details of each search and the terms that will be searched within each field. Each search must be on a separate line.

1. Enter a name for the search in column A.

2. In the relevant columns enter the terms to search in that field.

   • Search for multiple terms in the same field by using a pipe (|) between the terms.

   • You can skip a field by leaving the cell blank.

3. In the next row repeat steps 2 & 3 until all your searches are added.

Complete Example

Once you have added all of your searches save your file as a CSV and continue to Create your bulk search.

Read how to set up a Bulk Search in Aiimi Insight Engine.

Create a CSV In a Text Editor

There is a maximum limit of 50 rows and fields and a size restrictions of 1MB or less per CSV.

Each value you add must be followed by a comma (,) with no space after it.

1. The first value of your CSV must be "Search Name,"

   • The file will not upload if it is anything else.

2. The next values in this row should contain the names of all the fields you would like to search followed by a comma (,).

   • Each of these values will be mapped to a field within Aiimi Insight Engine.

   • These values will vary depending on the data you're searching. They should be descriptive to help set up the bulk search within Aiimi Insight Engine.

Example:
Search Name,Business Name,Persons Name,Dates,Address,Contract ID

The next rows will contain the details of each search and the terms that will be searched within each field. Each search must be on a separate line.

1. Enter a name for the search as the fist value of a row followed by a comma (,).

2. For each field assigned in the first row enter the terms that will be searched followed by a comma (,).

   • You can search for multiple terms for the same field by using a pipe (|) with no spaces between the terms.

   • You can skip a field by leaving the value blank and adding the next comma.

3. When you have finished a search, the final value does not need a comma (,) at the end.

   • If you are leaving the final field blank the row will end with the comma that would be before the value.

4. Start a new line for every search and repeat steps 2 - 4 until all your searches are added.

Example Search:
Business Details,Tovicci LTD|Tovicci Limited,Doe,1997,123 Fake Street,C1234

Complete Example:
Search name,Business Name,Persons Name,Dates,Address,Contract ID
Business Details,Tovicci LTD|Tovicci Limited,,1997,123 Fake Street,C1234
Contacts,,Ann Example,,[e-mail],
Owners,Tovicci,John Doe|Jon Doe,,456 Fake Street,

Once you have added all of your searches save your file as a CSV and continue to Create your bulk search.

Read how to set up a Bulk Search in Aiimi Insight Engine.

Example CSV

294B

Example Bulk Search CSV.csv