1.1.6 清单管理
清单管理
在iTop中,列表很常见。它们可以在指向列表的菜单项或搜索结果以及全局搜索中找到。显示对象列表后,可以在列表上执行的操作始终相同。
例如,下面是联系人列表:
如果列表包含的元素数量超过(可配置),它将显示为分页列表:
从iTop 2.2.0开始,导出操作活动仅可用于终端用户,其中简档包含BULK_READ特权。为了与iTop 2.1.0向后兼容,所有标准简档(角色)都包含此特权,但是如果在安装iTop时自定义了简档(角色),则可能不是这种情况。
工具包菜单
当iTop中显示对象列表时,可以对列表本身执行一定数量的操作(无需在iTop中修改对象)。这些操作通过列表右上方的工具包弹出菜单执行。
配置此列表
第一个可能的运维包括配置列表的外观。您可以选择:
- 显示哪些列以及按什么顺序
- 列表如何排序
- 可以同时显示多少个项目(请参见上面的分页列表)
- 该配置的列表适用于:(仅适用于此特定列表,或者适用于尚未具有特定配置的所有列表)。
所有这些配置都是通过弹出对话框完成的:
发送邮件
该功能在功能的细节上类似于发送邮件功能,不同之处在于,插入到消息中的超链接指向指定的对象列表。
CSV导出
CSV导出功能显示一个配置对话框,该对话框允许:
- 选择格式选项:CSV的分隔符(逗号,分号,制表符或任何其他字符)
- 指定文本限定符(放置在CSV内的文本字符串周围)
- 选择一个字符集
- 对于枚举字段(例如状态),选择是必须对值进行本地化(即使用屏幕上显示的值)还是使用内部(与语言无关)代码。
- 选择要包含在导出中的字段
- 排列列的顺序
要排列列的顺序,请在对话框底部的“列顺序”部分中显示的表中拖放列。要拖动列,请单击列标题。
正确配置导出后,单击导出至构建。如果导出包含大量导出(超过1000行),则会显示进度条。
导出完成后,您可以单击对话框顶部的链接单击此处下载以将结果下载为.csv文件,也可以将导出复制并粘贴为纯文本,来自文本区域:
如何在Excel 2007/2010中粘贴CSV数据
如果您使用copyypaste将导入CSV数据转换为Excel,则所有数据仅放在一列中。幸运的是,这对于数据来说很容易。
在Excel的数据选项卡中,单击“文本到列”图标:
出现以下对话框向导:
选择定界,然后单击下一步>。
选择逗号,然后单击完成。
下次在同一会话中复制CSV数据粘贴时(不关闭并重新启动Excel),Excel将自动使用相同的设置执行文本到列的转换。
Excel导出
从iTop的版本2.1.0开始,可以从菜单中直接将导出转换为Excel(XLSX格式):
显示以下对话框:
Excel导出功能显示一个配置对话框,该对话框允许:
- 选择要包含在导出中的列
- 排列列的顺序
要排列列的顺序,请在对话框底部的“列顺序”部分中显示的表中拖放列。要拖动列,请单击列标题。
当您单击导出时,将生成Excel文件。如果导出的对象列表很大(> 1000),则会显示进度条。导出完成后,您可以通过单击链接顶部的链接单击“下载此处”下载Excel文件。
对于导出大量的数据(例如数千个对象),CSV导出可以比Excel导出快得多。
PDF导出
在iTop 2.2.0和更高版本中可用,有一个新的菜单项导出as PDF:
此菜单生成一个PDF文档,其中包含一个大表,该大表在列表中每个对象包含一行,而每个选定字段则包含一列。
PDF导出功能显示一个配置对话框,该对话框允许:
- 选择呈现PDF的页面大小:A3,A4或Letter
- 选择页面的方向:纵向或横向
- 选择要包含在导出中的列
- 排列列的顺序
要排列列的顺序,请在对话框底部的“列顺序”部分中显示的表中拖放列。要拖动列,请单击列标题。
PDF输出使用等宽的列呈现(即,如果选择了10列,则每列将使用页面宽度的1110)。当选择相对较少的列数(<10)时,看起来会更好。如果您需要生成包含许多列的PDF,请使用“横向”方向。
当您单击导出时,将创建PDF文档。如果要导出的对象列表很大(> 1000),则会显示进度条。导出完成后,您可以通过单击链接顶部的链接单击以下载PDF文件。
添加到仪表板
可以将显示为列表的每个结果添加到其中一个可编辑的仪表板中。单击菜单添加到仪表板:
然后选择要添加列表的仪表板以及要使用的“仪表盘”的类型:
可以通过以下方式将列表添加到仪表板:
- 一个简单的对象列表
- 饼图(通过将给定字段上的对象分组)
- 条形图(通过将给定字段上的对象分组)
- 带有计数对象的表,按给定字段分组
当用户按下“确定”时,新的仪表盘将添加到所选仪表板的末尾(通过在最后使用的单元格之后添加新的单元格)。如果选中了“编辑仪表板”,则立即在仪表板编辑器中打开修改后的仪表板。
参考调整仪表板 有关如何自定义生成的仪表板的信息。
创建一个快捷方式
出现提示时,输入新快捷方式的名称(此名称将显示在菜单中“我的快捷方式”下),然后单击“确定”。
然后将新的快捷方式添加到菜单中。
刷新间隔的最小价值为5秒。
原贴链接:https://www.itophub.io/wiki/page?id=2_7_0%3Auser%3Alists
Managing Lists
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:
Starting with iTop 2.2.0, the Export actions are only available to the end-users which profile(s) include the BULK_READ privilege. 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.
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
The first possible operation consists of configuring the appearance 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)
Which list this configuration will apply to: (Only to this specific list, or to all lists which do not already have a specific configuration).
All this configuration is done via 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.
CSV Export
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 be included in the export
Arrange the order of the columns
To arrange the order of the columns, drag and drop the columns in the table displayed in theColumn order section at the bottom of the dialog. To drag a column click in the header of the column.
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:
How to paste CSV data in Excel 2007/2010
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.
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:
The following dialog box is displayed:
The Excel export action displays a configuration dialog which allows to:
Pick the columns to be included in the export
Arrange the order of the columns
To arrange the order of the columns, drag and drop the columns in the table displayed in theColumn order section at the bottom of the dialog. To drag a column click in the header of the column.
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:
To export large amounts of data (e.g. several thousands of objects), the CSV export can be significantly faster than the Excel export.
PDF Export
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:
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 be included in the export
Arrange the order of the columns
To arrange the order of the columns, drag and drop the columns in the table displayed in theColumn order section at the bottom of the dialog. To drag a column click in the header of the column.
The PDF output is rendered with columns of equal widths (i.e. if there are 10 columns selected, each column will use 1/10th of the page width). It looks better when a relatively small (<10) number of columns is selected. Use the Landscape orientation if you need to generate a PDF with many columns.
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:
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:
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 bar chart (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 dashboardis 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
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.
The minimum value for the Refresh interval is 5 seconds.