[vc_row][vc_column width=”1/1″][vc_empty_space][vc_column_text]This post explains how to easily import or export a list of users, domains and applications in bulk from a Microsoft Excel file with CAST Highlight, without any API skills required.[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column width=”1/1″][vc_row_inner][vc_column_inner][vc_column_text]Organizations didn’t wait CAST Highlight for having a list of applications that compose their portfolio. Very often, this list is stored somewhere in a Microsoft Excel file. This list is a very good starting point when establishing a new portfolio within CAST Highlight to automatically populate your instance and to make application onboarding even faster. In December 2020’s release, we developed a tool that will read a pre-formatted Excel file containing your app names, domains, and users. This feature will help you start your application portfolio assessment lightning fast. Here is how it works.[/vc_column_text][vc_empty_space][vc_column_text]

Step 1. Download the tool

[/vc_column_text][vc_column_text]The tool is a simple JAR that comes with an empty Microsoft Excel file (.xlsx) and a README file. As always, it’s preferable to take a look at the README prior to doing anything with the tool 😉[/vc_column_text][vc_empty_space][vc_btn title=”Download the tool” style=”classic” color=”primary” align=”left” i_icon_fontawesome=”fa fa-download” add_icon=”true” link=”url:https%3A%2F%2Fdoc.casthighlight.com%2Ftools%2Fexcel%2FHighlight-Excel.zip||target:%20_blank|”][vc_empty_space][vc_column_text]

Step 2. Edit the Excel File

[/vc_column_text][vc_column_text]Prior to adding data in the Excel file, it is recommended to “sync” it with your Highlight instance so that you’ll start with root domain information. To do so, simply run this command line below. Make sure your Excel file is not open at this time.[/vc_column_text][vc_empty_space][vc_column_text]

> java -jar Highlight-Excel-{version} export --host={host}/WS2/domains/{companyId}

--access-token={token} --file={destination file}

[/vc_column_text][vc_empty_space][vc_gallery images=”8672,8673″ link_full=”true” version=”carousel” img_size_carousel=”Ninzio-Half” columns_carousel=”2″][vc_empty_space][vc_column_text]You can now open and edit the Excel file which is made of three tabs:[/vc_column_text][vc_empty_space][vc_column_text]

• Domains: list here the domains you want to create in your portfolio. A domain is a hierarchical container of applications and users that will drive result aggregation, actions and user permissions in CAST Highlight’s dashboards. Domains can also contain sub-domains, indicated in the tab with a ‘Parent’ domain. The clientRef column is strongly recommended and can be used to map CAST Highlight domain identifiers to your internal nomenclature.
• Users: now that you have defined domains and sub-domains of your portfolio, you can invite users and enroll them with the appropriate role (portfolio manager, domain or application contributor, results viewer) and domain-level access. The clientRef column is strongly recommended and can be used to map CAST Highlight user identifiers to your internal nomenclature.
• Applications: list in this tab the applications you want to create, with their corresponding domain and contributor. The clientRef column is strongly recommended and can be used to map CAST Highlight application identifiers to your internal nomenclature.

[/vc_column_text][vc_column_text]

[/vc_column_text][vc_empty_space][vc_column_text]

Step 3. Import objects in bulk into CAST Highlight

[/vc_column_text][vc_column_text]Now that you have all your domains, apps and users listed in the Excel file, you’re all set to run the command line to import this information in your CAST Highlight instance. The command line is a JAR that takes the mandatory parameters below. Make sure your Excel file is not open at this time for this step as well.[/vc_column_text][vc_empty_space][vc_column_text]

• The host: this is the url of the Highlight platform where your instance is located (e.g. https://demo.casthighlight.com) appended with the API entry point and your company identifier
• Access token of a user with a Portfolio Manager role, at the root level of the portfolio (see this article on how to create a user token)
• Path & name to the Excel file you just created (and saved)

[/vc_column_text][vc_empty_space][vc_column_text]

> java -jar Highlight-Excel-{version} import --host={host}/WS2/domains/{companyId} --access-token={token} --file={destination file}

[/vc_column_text][vc_empty_space][vc_column_text]Once the command completes, you can manually log into your instance to check objects have been properly imported.[/vc_column_text][vc_empty_space][vc_gallery images=”8674,8675″ link_full=”true” version=”carousel” img_size_carousel=”Ninzio-Half” columns_carousel=”2″][vc_empty_space][vc_column_text]That’s all folks. Don’t forget, as my uncle used to say: “With great power comes great responsability”. Don’t hesitate to contact CAST if you would like to try the tool in a sandbox prior to going live…[/vc_column_text][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]