To get a report as a file, press the Export to file button .
Specify the desirable file format or several formats at once. Supported formats are HTML, PDF, Еxcel, XML, CSV. For some formats, you may need to specify additional export options.
Reports in the form of files can also be received by e-mail automatically – using jobs and notifications.
Export Parameters
The report file can be assigned any name by entering it manually in the File name field of the export dialog. If the name is not specified, the file is formed with the default name.
Activate the Compress report files box to compress the file into an archive. For HTML, CSV and XML formats, and if the total amount of files exceeds 20 MB, forced archiving occurs even if the checkbox is not checked. With other formats, archiving is performed in accordance with the checkbox state.
The Split chart by: option allows to receive, depending on your selection, a separate chart for each day or week of the reporting period.
Indicate whether it is necessary to attach the map to the exported report. Graphical objects (such as map, chart) can be exported only into HTML or PDF files. Note that the map will be attached to the file only if any graphical elements (such as tracks, markers, geofences, etc.) are selected in the report template. By default, the map is scaled in order fot the track/markers/last unit position to be seen on it. If these elements are not shown on the map, the map is not attached. If the Squeeze in all graphics checkbox is marked, the map is scaled in such a way that geofences are shown on the map along with the above mentioned elements. Only Google Maps can be attached to the report. Furthermore, the map layer can be hidden (using the Hide cartographic basis option) — in this case tracks and markers are shown on the blank background.
The function of using a link to display the location (if the coordinates are available) is supported for the files exported in PDF or Excel. It works as follows: open the exported report (PDF/Excel), place the cursor on the corresponding field of a report, for example, the beginning/end time or address information from the unit (the cursor pointer changes to hand) and click on the link. Google Maps cartographic service will be opened in your browser, where the marker indicates the location. If there is no need to show the location, you can disable links to Google Maps in PDF and Excel files by marking the corresponding checkbox in the export parameters.
In order to disable the function described above, use the Disable links to Google Maps in PDF and Excel files option.
More parameters can be adjusted for some file formats. Those additional parameters are described below.
Usually you export to a file a report that is already in the browser. However, you can also generate a new one according to the parameters set in the left panel. In this case, you should check the Generate report option.
Press OK. Depending on the browser settings, you will be offered to open a file or save it.
Report Formats
HTML
Choose the HTML format to receive a report in the form of a web page, which can be opened in any Internet browser installed on the computer.
PDF is a widely known file format. To view these files Adobe Acrobat Reader is used (for Windows OS only). This type of file is well suited for printing.
You can additionally specify the page orientation (landscape or portrait) and format (A4 or A3) when exporting a PDF-file.
For reports with a large number of columns, the Page width option may also be appropriate. The standard page width is fixed which means it depends on the selected page format and orientation. However, if the table is too wide and does not fit the specified page width, this table will not be exported (only the heading will be displayed). In such cases, you can select automatic page width, and the width of the page will correspond to the largest row in the table. If Auto, compact is selected, the cell width is equal to the length of the largest word in it. If Auto, no wrap is selected, the cell width is equal to the largest phrase in it (no line breaks are applied).
Note that if the automatic page width is selected, the page format and orientation become relative — they define only the height of the page, not the width.
Еxcel
Excel (.xslx) is a popular product from the Microsoft Office suite. Here the data is presented in the form of spreadsheets. The report is divided into several tab pages. The data is automatically stored in tables and is suitable for subsequent processing by the tools of this program.
Note.
When exporting a report to PDF, HTML, Excel the alignment is used. The columns with text (names of sensors, geofences, drivers, users, SMS and notification text, location addresses, etc.) are aligned to the left. The columns with numeric data (time, duration, speed, mileage, fuel, payments, count, etc.) are aligned to the right.
XML
XML represents information in the form of a text file used for storing structured data (instead of existing database files), for exchanging information between programs, and for creating more specialized markup languages (such as XHTML) on its basis.
CSV
CSV is a text file format used for the presentation of tabular data. Each line of this file corresponds to one line of the table, and the columns are separated from each other by a special delimiter character – a comma (,) or a semicolon (;). Each table is saved in a separate file.
To export to a CSV file, you should additionally choose the encoding (utf8, cp1251) and a delimiter (comma or semicolon). Depending on the state of the Show column headers checkbox, the file will start with the header line or immediately with the data.