Exporting activity reports to CSV files

To create a hardcopy of a report generated by BigFix, export the report to a CSV file and print it.

To create the CSV report file schedule it as an activity in the Create scheduled Activity window opened from the Administration > Scheduled Activities menu. For additional information see Creating Scheduled Activities.

You can also use the CSV file to create charts and statistics based on the information in the report.

A Web Report exported to a CSV file has an Excel-compatible CSV format. Any string containing characters that might be interpreted as a formula by Microsoft Excel such as "+myfield", are transformed in literal strings as shown in the following example: 
"=""+myfield"""
The following characters are handled in this way: + (plus), - (minus), / (slash), * (asterisk) and = (equal).
Web Reports will insert the result in double quotation marks during the generation of the CSV file for each string whose value satisfies one of the following criteria:
  • contains a double quote
  • starts or ends with a space or horizontal tab
  • contains a carriage return (CR) character (often occurs in multiple values)
  • contains a line feed (LF) control character (often occurs in multiple values)
  • contains a comma (often occurs in multiple values or in time values, as LastReportTime or LastReportSent).