> # Exporting Data Collections in Readable Format

> You can export the RRD files used by Performance Manager to a freeware tool called rrdtool and export the collection to an XML file. Cisco MDS SAN-OS Release 2.1(1a) introduces the inability to export data collections in comma-separated format (CSV). This format can be imported to various tools, including Microsoft Excel. You can export these readable data collections either from the DCNM-SAN Web Services menus or in batch mode from the command line on Windows or UNIX. Using DCNM-SAN Web Services, you can export one file. Using batch mode, you can export all collections in the pm.xml file.

> Note DCNM-SAN Web Server must be running for this to work.

> You can export data collections to Microsoft Excel using DCNM-SAN Web Server.

> ## DETAILED STEPS

> 1. Click the Performance tab on the main page.

> You see the overview table.

> 2. Click the Flows sub-tab.
> 3. Right-click the name of the entity you want to export and select Export to Microsoft Excel.

> You see the Excel chart for that entity in a pop-up window.

> You can export data collections using command-line batch mode.

> ## DETAILED STEPS

> 1. Go to the installation directory on your workstation and then go to the bin directory.
> 2. On Windows, enter .\pm.bat export C:\Program Files\Cisco Systems\MDS 9000\pm\pm.xml <export directory>. This creates the csv file (export.csv) in the export directory on your workstation.
> 3. On UNIX, enter ./pm.sh export /usr/local/cisco_mds9000/pm/pm.xml <export directory>. This creates the csv file (export.csv) in the export directory on your workstation.

> When you open this exported file in Microsoft Excel, the following information displays:

> - Title of the entity you exported and the address of the switch the information came from.
> - The maximum speed seen on the link to or from this entity.
> - The VSAN ID and maximum speed.
> - The timestamp, followed by the receive and transmit data rates in bytes per second.

> Copyright 2010-2013, Cisco Systems, Inc. All rights reserved.