IBM Connections wiki
IBM Connections 3.0.1 Documentation
Custom Search Scope...
IBM Connections 3.0.1 documentation
You are currently viewing machine translated content. IBM translation might be available. Click
IBM Translated Product Documentation
to see what is available.
Importing statistics and metrics into a spreadsheet
| Edited by
December 14, 2012
You can output statistics and metrics data from IBM® Connections applications to files in the comma-separated-value (CSV) format. You can then import this data into any spreadsheet program that supports the importing of CSV files. After you import the data, you can use available spreadsheet functions to analyze or graph the statistics and metrics.
About this task
You can use some commands to retrieve
® Connection application statistics and metrics and output them to CSV files. For example the FilesMetricsService.savePersonalToFile command returns metrics about files stored in the Files database and outputs them to a CSV file in a path location you specify. See the metrics and commands topics for each application for information on outputting metrics data to CSV files.
Here is a typical example of the steps required to import the statistics file into a spreadsheet. This example uses the
™ spreadsheet, but the steps are similar for other spreadsheet products.
spreadsheet menu, select
Select the CSV file that you want to import, and then click
In the Text Import box, under Separator options, make sure that
to display the file in the
Use the spreadsheet tools to format the chart as you want to.
When you have finished making changes, you can save the file in ODS format.
Viewing and collecting Activities metrics
Viewing and collecting Communities metrics
Viewing and collecting Forums metrics
Viewing and collecting Home page metrics
Viewing and collecting Profiles metrics
Viewing and collecting Search metrics
Viewing and collecting Files metrics
Viewing and collecting Wikis metrics
Files administrative commands
Wikis administrative commands
Edit the article to add or modify attachments.
Compare selected versions
Summary of changes
This version (6)
Dec 14, 2012 12:48:04 PM
Aug 24, 2012 1:37:31 PM
May 2, 2012 8:27:07 AM
Mar 15, 2012 9:16:04 AM
Mar 15, 2012 9:16:04 AM
Apr 6, 2011 3:58:33 PM
Copy and paste this wiki markup to link to this article from another article in this wiki.