Rockwell Automation 1756-HIST2G FactoryTalk Historian ME 2.2 - Manual (Page 64)

F ACTORY T ALK H ISTORIAN ME M ODULE U SER ’ S G UIDE
54
Exporting Data
Exporting data will export all points that have been returned after you’ve executed a
search. The export process creates a CSV (comma-separated values) document that
can be opened by Microsoft Excel. If you have selected a few rows to be displayed
and click [Export], all row data will be exported. If you want to export a subset of
rows, enter more specific search criteria. To export data:
1. Click [Export].
2. In the dialog that appears, select a location for your data on your client computer.
3. Either accept the default name or enter a file name of your choice. The file is
named points.csv by default. If you change the file name, .csv must be the file
extension.
4. Accept the default values for the following fields and click [Save].
‡
Save as type: The default type is HTML File.
‡
Language: The default language is Unicode.
5. Click [Save].
Viewing Archive Data
To view archived data in FactoryTalk Historian ME, click on View Data, and then
click Archive Data in the left-side navigation. This page displays a list of tags and the
latest value collected for each point. By highlighting each point, you can enter a time
period and view archive data that was collected for that period. Archive data collected
for a point may only be viewed for one point at a time.
If you are using IE 7.0 and want to export to Excel, you must install hot fix 929863
(http://support.microsoft.com/kb/929863.) This fix addresses an Excel file export
issue on the Current Data page. You must manually add the
[HKEY_CLASSES_ROOT\.csv] “PerceivedType”=”document” registry value for the
.csv document type.”
The FactoryTalk Historian DataLink Excel Reporting Tool provides a Historian Add-In
for Microsoft Excel. If you export more than 65,535 rows of FactoryTalk Historian ME
events to FactoryTalk Historian DataLink using the Compressed Data (Start Time/
End Time) configuration page, Excel generates an ”r;Output exceeds dimension”
message.