Chat now with support
Chat with Support

Unified Communications Analytics 8.8.3 - User Guide

Introducing Quest UC Analytics Viewing UC Analytics insights Modifying UC Analytics insights Exporting and importing UC Analytics insights Automatically exporting and sending insights (subscriptions) Appendix A:Questions and Answers for UC Analytics insights Appendix B:List of UC Analytics insights

Can I export data from an insight?

You have several format options for exporting data from an insight. You can export all the data from an insight to one of the following file formats:

When you are displaying an insight, click Export at the top right of the insight.
Click Export.

When viewing an insight, you can export a specific view (such as a graph, chart, or table) by clicking (Export) at the right corner of the view.

Only data from a main insight can be exported. You cannot export the data viewed through the details browser. For more information about the details browser, see Drilling down to detailed information .

Limitations when exporting data

There are certain limitations for exporting data for an entire insight, depending on the type of insight (aggregate or details) and the format to which you are exporting:

If you are exporting to .pdf or .docx format, and you have select Auto as the Layout option, if an insight contains a table with more than eight columns, the export function automatically switches the page layout to landscape to improve any word wrapping. The font size may also be adjusted to fit the entire insight on the page.

If you have selected Landscape or Portrait as the Layout option, the specified layout is used.

If you export to .csv (raw) or .tsv (raw) output, the values in the exported file reflect the data exactly as it is stored in the data engine. The raw file does not contain the view titles, time is always UTC, and units of measurement are in base units.

Raw format is intended for third-party processing. It is not intended for viewing in a spreadsheet application such as Microsoft Excel. Excel will attempt to interpret the data according to your local operating system settings. The raw export always uses the English Invariant locale.

If you export to formatted (localized) or formatted (UTC) .csv or .tsv format, the values in the exported file are the same as viewed in the insight. Units of measurement will be scaled in the same way that they are scaled in the insight. Also, the header data in the formatted .csv or .tsv file would include the view titles from the insight and information about the insight such as insight title, Insight description, “generated by” information, the selected date range, insight generation date, and selected filters.

For example, if you exported an insight to a .csv (raw) file, the size values would show as bytes. However, if you exported the same insight to formatted (localized) or formatted (UTC) .csv format, the size values would show as MB if that is how the insight displays sizes. For the localized format, the export values use local time. For the UTC format, the values use UTC time.

The export feature uses your user profile settings to format data for the formatted (localized) and formatted (UTC) .csv or .tsv formats. Your user profile settings are also used for the pdf,.docx, or MHTML formats. For information about configuring your user profile, see Changing formats for date, time, and digit separators and Overriding the time zone offset .

You can export insights to three different .csv file formats: .csv formatted (localized), .csv formatted (UTC), and .csv (raw).

In a localized .csv file, the DateTime and numeric values are created based on the DateTime format and decimal/thousand separators settings that you specified in your UC Analytics user profile. For information about configuring your user profile, see Changing formats for date, time, and digit separators and Overriding the time zone offset .

In a raw .csv file, numeric values are formatted in English Invariant locale. DateTime values are formatted using sortable date time format (yyyy-MM-dd HH:mm:ss).

When you open these files in a localized version of Microsoft Excel on a European operating system (such as German, French, and so on), the files appear to be malformatted.

To allow Excel to correctly interpret the data, use the following procedure.

Click the Data tab and select the From Text option.
In step 1 of the Text Import Wizard, ensure that the Delimited option is selected and click Next.
In step 2 of the Text Import Wizard, select Comma under Delimiters and click Next.
Select DMY for localized .csv format.
Select YMD for raw .csv format
Click the Advanced button.
Specify the Decimal separator as . (period) and the Thousands separator as , (comma), and click OK.
Click Finish.

Exporting insights from and importing insights to an insights home page

On an insights home page, such as the My Insights page, you can export one or more selected insights to a file. You can then import the file to add these insights to a different home page.

If you send the export file to other users, they can import these insights to their home pages. For example, suppose you have several customized insights that you want to provide to other users in your company. You would use the following steps to provide these insights to other users.

On a home page, click Manage Insights.
Click Export.
Select Save to save the file with the default name (insights.txt).
Select Save As and specify a name for the .txt file.and the location to which the file is saved.

After you have exported the insights, you can send the .txt file to other users who can import the insights to their home pages.

NOTE: If you have no insights on your home page, select Import insights from an insights file on the UC Analytics Welcome page.
Click Chose File.
Click Import.

If you are trying to import an insight from a different version of UC Analytics, UC Analytics will check the insight definition, customize version, and upgrade the insight.

Automatically exporting and sending insights (subscriptions)

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating