Jibility supports the ability to import and add new capabilities to your map from an Excel spreadsheet.

Note; currently, this import feature does not support updating your capability map. It supports adding new capabilities only.

The use cases for this feature are

1) You have an existing capability map from a roadmap document that you want to export and re-import into another roadmap document;

2) You have a library of capabilities in another software product, and you want to import these into your Jibility roadmap; or

3) You have an existing capability map and you want to make bulk changes that are easier to make in Excel and then re-import this into Jibility.

To import capabilities from Excel, select the Capabilities step and click on the import capabilities button illustrated below.

If an error occurs during import, a pop-up window (as illustrated below) will display the error messages. You can retain a copy of all the error messages by manually selecting the messages in the text box and enter CTRL-C or click the "Copy & Close" button to automatically copy the messages to the clipboard. You can then paste the messages in a notepad or spreadsheet to analyze and address each error.

NOTE: after successfully importing your capabilities you have the opportunity to Undo the import by clicking on the Undo button shown in the bottom left corner (as illustrated below). The Undo button will disappear after 5 seconds.

When importing capabilities, the layout of the newly imported capabilities are as follows

1) All imported capabilities are laid out from left to right and top to bottom, starting from the last row of the existing capability map. The Number column determines the capability order (Understanding the Hierarchical Sequence Number section).

2) If the existing capability map is empty or has less than five capability columns, then the imported capabilities will be added to the capability map row by row to a span of five columns.

In the following example, the existing capability map has one capability. The imported capabilities will start from the second row and fill five columns.

3) If the existing capability map has five or more capability columns, then the imported capabilities will be added to the capability map row by row to a span matching the existing number of columns.

In the following example, the existing capability map has eight columns. The imported capabilities will start from the second row and span eight columns.

TIPS: you can add some dummy capabilities to indicate how many columns to span when importing. Once the import is completed, just delete the dummy capabilities.

The import capability feature is designed to import from an Excel spreadsheet similar to the Excel file created by the export function in the Capability Map publish document feature.

Here is an example of an Excel file for the Insure North sample roadmap.
​

The following is a description of the expected Excel file format:

1) The import Excel file must have a header on line six.

2) The import Excel file must have at least two header columns: Number and Name.

3) The import Excel file may have a similar structure to the Jibility capability map export file. Here is how the import capabilities feature will treat each column.

The Number column in the import Excel file defines the imported capability layout order and the sub-capability structure. The Number column value must have a format of X, X.Y or X.Y.Z, where X, Y, and Z are numbers.

1) X is where X is a number for the level 1 capability;

2) X.Y is where Y is a number for the level 2 capability within X; and

3) X.Y.Z is where Z is a number for the level 3 capability within X.Y

The following example is a list of three level 1 capabilities

Importing the above list would create the following three level 1 capabilities.

The following example shows a hierarchy of level 1, level 2 and level 3 capabilities.

Importing the above list would create the following nested capability.

When importing capabilities, you may encounter error messages. Error messages may appear in the a popup window or as a snack bar.

The following is a description of each message.

Snack Bar Error messages appear as a line at the bottom of the page as illustrated below.

The following is a description of the error messages