Database View Reports

Run reports in the Database View in Innoslate.

Innoslate provides the ability to run reports in ‘Database View‘ via the ‘Reports’ feature.

Please note, this article is applicable for all versions of Innoslate 4.

List of Available Database View Reports

The table below outlines all the report types supported by Innoslate. Each of the reports can be customized from the ‘Download Reports Modal’.

  • Basic Tabular Output: A full output of the entities in the database to a .csv file.
  • Comment Report: A table of the user comments from the selected entities to a .xlsx file.
  • Entity Definition Report: An output of all attributes, labels, and relationships for the selected entities to a .xlsx file.
  • Entity Relationship Matrix: A matrix of the selected entities’ relationship to other entities through a single relationship.
  • Entity Table Report: A full output of the entities in the database to a .csv file.
  • History Report: An output of the history and changes of the selected entities to a .xlsx file.
  • Innoslate XML Output: A full output of the database to a .xml file. Note that XML files are only forwards compatible and must be imported to version 3.9.0.15 or later.
  • Innoslate ZIP Output: A full output of the database to a .inno file including files and images.
  • Reqif Output: A full output of the database to a .reqif file.

 

You will find the ‘Reports’ button used to run reports at the top center of the toolbar in ‘Database View’, to the right of the ‘Search’ field.

Screenshot 2023-07-13 at 3.45.45 PM

 

Basic Tabular Output
The Basic Tabular Output report is a full output of the entities in the database to a .csv file. It can be used to import into other Innoslate projects using the Import Analyzer.
chrome_eWuOvzlpmh (1)

Steps to download the Basic Tabular Output report

Step 1: Select Basic Tabular Output from the reports drop-down.

chrome_jZiCwLqVrs (1)

 

Step 2: Select Options to Include.

chrome_FzwHbbmWd8 (1)

 

Step 3: Select the sort option with the number as default.

chrome_yNKbjLi7Jn (1)

 

Step 4: (Optional) Enter a name for the report output file.

chrome_nVFMdpP2A7 (1)

 

Step 5: Click ‘Create’.

The file should begin downloading. Please note that depending on the size of your project, this can take a few moments. The output should look similar to this:

Screenshot 2022-09-23 132905
 

Comment Report

The Comment Report is a table of the user comments from the selected entities to a .xlsx file.

chrome_JV79brNzzo

Steps to download the Comment Report

Step 1: Select Comment Report from the reports drop-down.

chrome_dwmWOYUdMV

 

Step 2: Select Options to Include. All options are selected by default.

Step 3: Select comment options to include. All options are selected by default.

Step 4: (Optional) Enter a name for the report output file.

chrome_QU5i7YhiM0

 

Step 5: Click ‘Create’.

The file should begin downloading. Please note that depending on the size of your project, this can take a few moments. The output should look similar to this:

EXCEL_cO221pEulf

Entity Definition Report

The Entity Definition Report is an output of all attributes, labels, and relationships for the selected entities to a .xlsx file.

chrome_iL1UKUK5v6

Steps to download the Entity Definition Report

Step 1: Select Entity Definition Report from the reports drop-down.

chrome_qUEd91W37u

 

Step 2: Select Options to Include.

chrome_ZLUVWt7NrC

 

Step 3: (Optional) Enter a name for the report output file.

chrome_RJQFU5Lf2f

 

Step 4: Click ‘Create’.

The file should begin downloading. Please note that depending on the size of your project, this can take a few moments. The output should look similar to this:

EXCEL_dWvC0fb8e5
 

Entity Relationship Matrix

The Entity Relationship Matrix is a matrix of the selected entities’ relationship to other entities through a single relationship.

chrome_mpfagqHvOo-1

Steps to download the Entity Relationship Matrix

Step 1: Select Entity Relationship Matrix from the reports drop-down.

chrome_5YyyZ2x1lm

 

Step 2: Select Options to Include.

chrome_N3bTBIMgum

 

Step 3: Select the relationship.

chrome_MwauRRH1o9

 

Step 4: (Optional) Select a relationship Attribute.

chrome_fEUhcp7dFB

 

Step 5: (Optional) Enter a name for the report output file.

chrome_stHJxsXvCG


Step 6: Click ‘Create’.

The file should begin downloading. Please note that depending on the size of your project, this can take a few moments. The output should look similar to this:

EXCEL_Fh1izlYAw3

Entity Table Report

The Entity Table Report is a comprehensive output of the entities in the database to a .csv file. It offers a detailed snapshot of the entities, useful for backups or for importing into other Innoslate projects or tools.

Step 1: Select Entity Table Report from the reports drop-down.

Screenshot 2023-07-10 at 8.56.36 AM

 

Step 2: Click "Select Options" to Include entity categories.

Screenshot 2023-07-10 at 9.02.20 AM

 

Step 3: Select the relationship.

Screenshot 2023-07-10 at 9.02.28 AM

 

Step 4: (Optional) Enter a name for the report output file.

Step 5: Click ‘Create’.

The file should begin downloading. Please note that depending on the size of your project, this can take a few moments. The output should look like this:

Screenshot 2023-07-10 at 9.29.42 AM

History Report

The History Report is an output of the history and changes of the selected entities to a .xlsx file.

chrome_1ceZCV6F4J

Steps to download the History Report

Step 1: Select History Report from the reports drop-down.

chrome_dAacYzGDOK

 

Step 2: Select Options to Include.

chrome_Uv0U4wjhST

 

Step 3: (Optional) Enter a name for the report output file.

chrome_55cR6BEuB8

 

Step 4: Click ‘Create’.

The file should begin downloading. Please note that depending on the size of your project, this can take a few moments. The output should look similar to this:

EXCEL_IZxuW34WuP

 

Innoslate XML Output

The Innoslate XML Output is a full output of the database to a .xml file. It is primarily used when you want to migrate data between different Innoslate instances or for archival purposes.

Step 1: Select Innoslate XML Output from the reports drop-down.

Screenshot 2023-07-10 at 9.20.31 AM

 

Step 2: Use the "Search Query" tab to include the specified query in database the user wants to export.

Screenshot 2023-07-10 at 9.22.46 AM

- In this example, the Label is classified as "Modified Model" from the "Action" entity class. 

Step 3: Determine the export options using the drop-down tab.

Step 4: (Optional) Enter a file name for the report output file.

Step 5: Click ‘Create’.

The file should begin downloading. Please note that depending on the size of your project, this can take a few moments. The output should look like this:

Screenshot 2023-07-10 at 9.27.36 AM

Note: XML files are only forwards compatible and must be imported to version 3.9.0.15 or later.

Innoslate ZIP Output

The Innoslate ZIP Output is a full output of the database to a .inno file, including files and images. It allows users to store a complete representation of their project, which is particularly useful for creating backups, archiving projects, or transferring them between different Innoslate instances. 

Step 1: Select Innoslate ZIP Output from the reports drop-down.

Screenshot 2023-07-10 at 9.30.28 AM

 

Step 2: Use the "Search Query" tab to include the specified query in database the user wants to export.

Screenshot 2023-07-10 at 9.22.46 AM

- In this example, the Label is classified as "Modified Model" from the "Action" entity class. 

Step 3: Determine the export options using the drop-down tab.

Step 4: (Optional) Enter a file name for the report output file.

Step 5: Click ‘Create’.

The file should begin downloading. Please note that depending on the size of your project, this can take a few moments. The .inno file has been exported and can be used to be imported and utilized in other functional methods.

Reqif Output

The Reqif Output provides a full output of the database to a .reqif file. The Requirements Interchange Format (ReqIF) is a standard for exchanging requirements between different software tools. With the Reqif Output, you can export your Innoslate project's data in a format that can be read by other tools that support the ReqIF standard.

Steps to download the Reqif Output

Step 1: Select Reqif Output from the reports drop-down.

Screenshot 2023-07-10 at 9.41.10 AM

Step 2: (Optional) Enter a name for the report output file.

Step 3: Click ‘Create’.

The file should begin downloading. Please note that depending on the size of your project, this can take a few moments. The .reqif file has now been downloaded into your device.

Tutorial Video

 

To continue learning about Database View, Click Here.

(Next Article: Database Management)