iTop User's Manual
iTop User's Manual
In iTop, lists are quite common. They can be found in menu items which point to lists, or the search results, as well as the global search. Once a list of objects is displayed, the operations that can be performed on the list are always the same.
For example, below is a list of Contacts:
If a list contains more than a (configurable) number of elements, it is displayed as a paginated list:
BULK_READprivilege. For backwards compatibility with iTop 2.1.0, all standard profiles include this privilege, but this may not be the case if the profiles have been customized in your installation of iTop.
When a list of objects is displayed in iTop, a certain number of operations can be performed on the list itself (without modifying the objects in iTop). These operations are executed through the toolkit popup menu at the top-right of the list.
The first possible operation consists of configuring the appearance of the list. You can choose:
All this configuration is done via the popup dialog:
Advanced case: If your list displays multiple classes of objects (eg. SELECT a,b FROM Person AS a JOIN UserRequest AS b…), then you cannot save the configuration
Only for this list, but when you save it for
Default for all lists, it will only impact lists which do select exactly the same classes with the same alias, for eg if another list is based on that query (SELECT a2,b FROM Person AS a2 JOIN UserRequest AS b…), then the configuration saved on the first list will not apply.
This action is similar to the eMail action on the details of an object, except that the hyperlink inserted into the message points to the specified list of objects.
The CSV export action displays a configuration dialog which allows to:
When your export is properly configured, click Export to build it. If the export contains a large amount of data, (more than 1000 lines) a progress bar is displayed.
When the export is complete, you can either click on the link Click here to download at the top of the dialog box to download the result as a .csv file, or copy and paste the export as plain text from the text area:
If you use copy/paste to import CSV data into Excel, all the data is put in one column only. Fortunately, this is easy to change.
In the Data tab of Excel, click on the Text To Columns icon:
The following dialog wizard appears:
Select Delimited and click Next >.
Select Comma and click Finish.
Starting with version 2.1.0 of iTop, a direct export to Excel (XLSX format) is available from the menu:
The following dialog box is displayed:
The Excel export action displays a configuration dialog which allows to:
When you click on Export, the Excel file is built. If the list of objects to export is large (>1000), a progress bar is displayed. Once the export is complete, you can download the Excel file by clicking on the link Click here to download at the top of the dialog box:
Available in iTop 2.2.0 and later, a new menu item Export as PDF is available:
This menu generates a PDF document with one big table containing one row per object in the list and one column for each selected field.
The PDF export action displays a configuration dialog which allows to:
When you click on Export, the PDF document is created. If the list of objects to be exported is large (>1000), a progress bar is displayed. Once the export is complete, you can download the PDF file by clicking on the link Click here to download at the top of the dialog box:
Every result displayed as a list can be added to one of the editable dashboards. Click on the menu Add to Dashboard:
Then select the dashboard to which the list will be added and the type of “Dashlet” to use:
A list can be added to a dashboard either as:
When the user presses Ok, the new dashlet is added at the end of the selected dashboard (by adding a new cell after the last used cell). If Edit the dashboard is checked, then the modified dashboard is immediately opened in the dashboard editor.
Refer to Editing Dashboards for information about how to customize the resulting dashboard.