Import Analyzer

Importing Microsoft Excel (.csv) Files

Import Microsoft Excel (.csv) Files into Innoslate through the Import Analyzer.

Open the 'Import Analyzer' and select the ‘Excel (.csv)’ tab.

Select from the drop-down menu which document type you'd like the analyzer to use. This will indicate what classes for the analyzer to recall for the next step. 

Select from the drop-down menu which schema-based class of entities should be created by default from importing the text. Search or scroll within the drop-down menu to find your desired class.

Select from the drop-down menus which attribute you’d like the analyzer to use when fetching existing and related entities. Search or scroll within the drop-down menus to find your desired attributes.

Below is a table mapping out the options available by Document Type.
  None Compilation Document Test Suite
Default Class Options All All Classes, All Statement, Requirement Test Case
Fetch Existing

Global ID, Name, Number

Global ID, Name, Number Global ID, Name, Number Global ID, Name, Number
Fetch Related Global ID, Name, Number Global ID, Name, Number Global ID, Name, Number Global ID, Name, Number
4. Select 'Next' to Proceed to Step Two.

import csv 4

Drag and drop your .csv file over the drop area, or click within the drop area to browse your computer’s file system to select the file to upload.

import csv 5

When your ‘Analyzer Progress’ bar reaches 100 percent, ‘Done,’ click the ‘Next’ button to proceed to Step Three.

import csv 6

Using the ‘Custom Field Mapping’ wizard, select the entities you wish to import/migrate to Innoslate and mapping to entity attributes. Note your options here are predetermined based on the options chosed in the 'Step 1 Configure' of the Analyzer.

Then, click the ‘Next’ button to proceed to Step Four.

import csv 7

Verify the preview of the import is what you were expecting. To finish the import process and save the entities to your current project’s database, click the ‘Save’ button.

To go back, you can remap and modify as needed even re importing again by clicking the ‘< Prev’ button.

import csv 8

Importing Relationships

In order to import relationships using the CSV importer, the CSV file must be formatted in a specific way in order to be read correctly by the Import Analyzer.

  1. Start with a CSV with basic headers.

    rel1
  2. Add the relationship name as a column title.

    csv-import-with-rels-1
  3. Fill in the information as you normally would.

    csv-import-with-rels-2
  4. Next, find the global ID of the target entity you would like to relate the entity to. There are multiple ways of doing this. One way is to look at the metadata.

    rel4
  5. Copy and paste the Global ID into the relationship name column in the CSV.

    csv-import-with-rels-3
  6. If the target entity is in another project, you will need to find the Project ID of the target entity. This can be found by looking at the URL.

    rel6
  7. Enter the Global IDs into their respective columns, and if the relationships are cross-project, followed by a ‘-‘ and the project ID in the CSV. Note: The CSV Importer can handle cross-project relationships as long as the user has permission for both projects.

    csv-import-with-rels-5

  8. Hit save when you are done, then go to the Import Analyzer. In step 1, make sure “Select the attribute you’d like analyzer to use when fetching related entities:” is set to Global ID.

    rel8
  9. Continue with the import process as usual, and note the mapping in step 3. Make sure the relationship and Project ID is mapped correctly.

    import-csv-with-rels-6
  10. Once Analyzer has finished, you should see the number of new and updated entities. Hit save, and you are all done.

    rel10

Tutorial Video

 

To continue learning about Import Analyzer, Click Here.

(Next Article: Importing Innoslate Export (.inno, .xml) Files)