Report File Formats
- Thomas Sherman (Deactivated)
Projector offers a range of output formats for your reports. This page introduces you to each of these format types and provides links to more details on using them.
Reports are delivered as UTF-8
Access Database File
The use of access database files has declined significantly over the years. Typically we see users retrieving CSV data via web services and leveraging Business Intelligence tools to combine and analyze data from various software systems. We continue to support this file format.
CSV
Comma Separated Value (CSV) files are a convenient way to export Projector report data because so many software products support them. The files also tend to be small in size and easily transmittable. The report will be sorted by the values in the first column of the report.
Excel (XLSM)
XLSM is a macro enabled Excel file. This is how most users choose to review their report data. Depending on the Report Type the output may be a flat spreadsheet or a pivot table.
JSON / JSONP
JavaScript Object Notation (JSON) is a format typically used by developers. It create an javascript object that can be queried for data. It is supported by a large number of development platforms and javascript libraries. JSONP is a variation of JSON that allows you to execute a function on the returned data immediately. This allows a developer who is designing a client-side website to avoid Cross Origin Resource Sharing (CORS) blocks. JSONP is only available via our Report Web Services.
XML
Projector can export report data in XML format. This data can be imported into Excel or Google Sheets.
XML is very inefficient for large data sets. Please consider using CSV if you need to pull large amounts of data from Projector.