Exporting a custom AR System report
You can save or export data to use in forms, in a spreadsheet, or in other applications. You can also save or export data from an external application to use in a form. You can export the results of a report to the following file formats:
- export (file extension .arx)
- XML (file extension .xml)
- Comma-separated value (file extension .csv)
The file formats that you select for exporting depend on the original data source and how you will use the data. You can use these formats to import data to a form with Data Import. CSV files can also be imported to other applications, such as Microsoft Excel.
To export AR report
- Select the report from the list.
- In the Destination field, select whether to send the report to the screen, a file, or a printer.
- In the Format field, select the output format for the report.
- Run the report.
Using AR Export format
AR Export (.arx) is the default file type. It yields the cleanest results when data is exported and imported within . The AR Export format properly formats data that you import into a form by using Remedy Data Import.
When an attachment is exported in AR Export format from a browser, a .zip file is created that includes the .arx file and the attachments.
Using AR XML format
AR XML (.xml) is a Remedy XML standard derived from the W3C XForm standard, and it contains several elements that are required for use. To import XML data into a form by using Remedy Data Import, your data must conform to the AR XML data specification. Data exported to the AR XML file type conforms to this specification. You can also convert XML data obtained outside of to the AR XML standard.
Conversely, you can export AR XML data, parse it with any tool that parses documents that conform to the XForm specification, and use the data outside of . For information about XForms, see the W3C website.
Attachments are handled in the same manner as in the .arx file type.
Using comma-separated values format
You can use the comma-separated values (.csv) format if you plan to use the report data in other applications. For example, if you want to use the report data in a Microsoft Excel spreadsheet, export it as a .csv file, open Excel, and import the data into the Excel file.
Consider these tips while using the CSV format:
- You cannot export the content of an attachment with a .csv file. If you export a .csv file with an attachment, only the file name of the attachment is exported.
- When you use CSV report format and specify the output destination as Screen, the report is not displayed on the screen. However, you can download the report in CSV format.
Using record, column, and compressed formats
When you select Record, Column, or Compressed format in the ReportCreator form in a browser, the report is saved as an HTML file (for example, report.rep.html). The compressed format is not supported in a browser. If you select Compressed, the report is displayed in Column format instead.
Where to go from here