From ICIHelp8.2
| Line 1: | Line 1: | ||
| − | + | = Exporting Search Results = | |
You can export the search results to Excel as a spreadsheet (.xlsx) file. | You can export the search results to Excel as a spreadsheet (.xlsx) file. | ||
| Line 6: | Line 6: | ||
To export: | To export: | ||
| − | #'''Click''' the ''Search'' | + | #'''Click''' the ''Search'' [[File:Saving your Search1.png|RTENOTITLE]] tile from any ICM page. This opens the ''[[Using_Advanced_Search|Search]] ''page in a new tab. |
#Define the search criteria and '''click''' the ''Search'' icon. The search results are displayed. | #Define the search criteria and '''click''' the ''Search'' icon. The search results are displayed. | ||
| − | #'''Click''' the ''Export '' | + | #'''Click''' the ''Export ''[[File:Export.png|RTENOTITLE]] icon and choose the Excel or CSV formats. The results are exported in the selected file format. |
#The ''Entity Code'' column (if one exists, such as the Agreement Code in the figure below) contains a link to the actual Entity. '''Clicking '''it takes you to the Entity ''Details'' page. If the Entity Code column is missing, you can add the Code attribute to the list of Select Columns. | #The ''Entity Code'' column (if one exists, such as the Agreement Code in the figure below) contains a link to the actual Entity. '''Clicking '''it takes you to the Entity ''Details'' page. If the Entity Code column is missing, you can add the Code attribute to the list of Select Columns. | ||
<div class="image-green-border">[[File:Export2Excel-EntityCode.PNG|Export to Excel has link to the Entity Code]]</div> | <div class="image-green-border">[[File:Export2Excel-EntityCode.PNG|Export to Excel has link to the Entity Code]]</div> | ||
Revision as of 12:29, 14 March 2018
Exporting Search Results
You can export the search results to Excel as a spreadsheet (.xlsx) file.
To export:
- Click the Search
tile from any ICM page. This opens the Search page in a new tab. - Define the search criteria and click the Search icon. The search results are displayed.
- Click the Export
icon and choose the Excel or CSV formats. The results are exported in the selected file format. - The Entity Code column (if one exists, such as the Agreement Code in the figure below) contains a link to the actual Entity. Clicking it takes you to the Entity Details page. If the Entity Code column is missing, you can add the Code attribute to the list of Select Columns.
