In iTop, lists are quite common: many menu items point to lists, the search results displays lists 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:

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 in configuring the appearence of the list. You can choose:

• Which columns are displayed and in which order
• How the list is sorted
• How many items will be displayed at the same time (see paginated lists above)
• To which list this configuration will apply: Only to this specific list, or to all lists which do not already have a specific configuration.

All this configuration is done through the popup dialog:

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:

• Select the format options: separator character for the CSV (comma, semicolon, tab or any other character)
• Specify a “text qualifier” character (to be placed around text strings inside the CSV)
• Pick a character encoding
• Choose, for enumerated fields (like statuses) whether the values must be localized (i.e. use the values as they appear on-screen) or use the internal (language independent) codes.
• Pick the fields to include in the export
• Arrange the order of the columns

When your export is properly configured, click “Export” to build it. If the export contains a huge 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 are put in just one column. 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:

• Pick the columns to include in the export
• Arrange the order of the columns

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:

Starting with iTop 2.2.0, a new menu item “Export as PDF…” is available:

This menu generates a PDF document with one big table with 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:

• Select the page size for rendering the PDF: either A3, A4 or Letter
• Select the orientation of the page: Portrait or Landscape
• Pick the columns to include in the export
• Arrange the order of the columns

When you click on “Export”, the PDF document 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 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:

• A plain list of objects
• A pie chart (By grouping the objects on a given field)
• A barchart (By grouping the objects on a given field)
• A table with the count of objects, grouped on a given field

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.

When prompted, enter the name for your new shortcut (this is the name that will appear under “My Shortcuts” in the menu), and click Ok.

The new shortcut is then added to the menu.