Importing Microsoft Excel (csv) Files

Last modified on January 30th, 2017.


This section contains outlined instructions for importing a Microsoft Excel (.csv) file into Innoslate.

  1. Within 'Import Analyzer', ensure the 'Microsoft Excel (.csv)' tab is selected, if not, click on the tab to switch to it.

    Select the Microsoft Excel Tab

  2. Select from the dropdown which schema-based class of entities should be created by default from importing the text. Search or scroll within the dropdown to find your desired class if need be.

    Click in Drop Down

  3. Click on the 'Next >' button to continue to the next step in the process.

    Select Next

  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.

    Drag and Drop the csv File

  5. Once both progress bars reach 100%, click on the 'Next >' button to preview what will be imported.

    Select Next

  6. 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 on the ‘Save’ button. To go back, modify your text and try importing again, click on the ‘< Prev’ button to return to the previous step in the process.

    Select Save

 
Please Note:

Importing Microsoft Excel (csv) Files

Last modified on January 30th, 2017. 


This section contains outlined instructions for importing a Microsoft Excel (.csv) file into Innoslate.

  1. Within ‘Import Analyzer’, ensure the ‘Microsoft Excel (.csv)’ tab is selected, if not, click on the tab to switch to it.

    Select the Microsoft Excel Tab

  2. Select from the dropdown which schema-based class of entities should be created by default from importing the text. Search or scroll within the dropdown to find your desired class if need be.

    Click in Drop Down

  3. Click on the ‘Next >’ button to continue to the next step in the process.

    Select Next

  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.

    Drag and Drop the csv File

  5. Once both progress bars reach 100%, click on the ‘Next >’ button to preview what will be imported.

    Select Next

  6. 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 on the ‘Save’ button. To go back, modify your text and try importing again, click on the ‘< Prev’ button to return to the previous step in the process.

    Select Save

 

Please Note:
  • Schema-based attributes of a class are case-sensitive in Innoslate, therefore column titles are also treated as case-sensitive.
  • Exported columns from Excel must contain either a “Number” or “Name” titled column for successful import into Innoslate.
  • A column titled “Class” must be included for importing more than one class of entity within the same file.
  • If the file only contains rows of the class Statement or Requirement or sub-classes thereof, the file with import as a requirements document.
  • An Excel CSV file will fail to import if it contains an exported Excel row whose Name or Number attribute text is longer than 450 characters.