You are browsing the documentation for iTop 2.1 which is not the current version.

Consider browsing to iTop 3.1 documentation

Managing Lists

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:

A Non-Paginated List

If a list contains more than a (configurable) number of elements, it is displayed as a paginated list:

A paginated list

Toolkit menu

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.

Configure This List

Toolkit operation: Configure This 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:

List Configuration Dialog

eMail

Toolkit operation: eMail

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.

CSV Export

Toolkit operation: CSV Export

The CSV export operation displays a page containing a text/CSV representation of the objects in the list. This is useful for importing the data in a third party application or to process the data in a spreadsheet before re-importing them into iTop.

Interactive CSV export

You can then either:

  • Use the link at the top-left to download the data as a CSV file, then open this file in your favorite spreadsheet application
  • Copy/Paste the data from the text area (use CTRL-A to select all) then paste it into your spreadsheet

How to paste CSV data in Excel 2007/2010

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:

Data Tab in Excel

The following dialog wizard appears:

Excel Text to Columns Wizard

Select “Delimited” and click “Next >”.

Excel Text to Columns Wizard

Select “Comma” and click “Finish”.

The next time you copy/paste CSV data in the same session (without closing and restarting Excel), Excel will automatically perform the text-to-columns conversion with the same settings.

Excel Export

Starting with version 2.1.0 of iTop, a direct export to Excel (XLSX format) is available from the menu:

Toolkit operation: Excel Export

The following dialog box is displayed:

Excel Export options

When clicking “Export” the progress bar is displayed while the Excel file is being built:

Excel Export progress

If the option “Start the download automatically when the export is ready” was checked, the dialog box closes and the download starts automatically as soon as the Excel file is ready. Otherwise the following dialog box is displayed:

Excel export statistics

Add To Dashboard

Every result displayed as a list can be added to one of the editable dashboards. Click on the menu “Add to Dashboard…”:

Toolkit operation: Add To Dashboard

Then select the dashboard to which the list will be added and the type of “Dashlet” to use:

Add To Dashboard Dialog

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.

Create a Shortcut

Toolkit operation: Create a Shortcut

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.

New Shortcut Dialog

The new shortcut is then added to the menu.

2_1_0/user/lists.txt · Last modified: 2018/12/19 11:40 (external edit)
Back to top
Contact us