Export Report to File

Export Report to File

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.


 Reports in the form of files can also be received by e-mail automatically – using jobs and notifications.

Export Parameters

You can assign any name to the file. This is optional and if it is not specified, the file will be given a default name (e.g. Online_report).

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.

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 Gurtam 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.

If necessary, you can disable links to Google Maps in PDF and Excel files by checking the corresponding box.

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

Chhose 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

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). The fixed width is standard. 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, which means it 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 page height, 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.


    • Related Articles

    • Print Report

      After generating an online report, you can print it without first exporting it to a file. To do this, press the Print button, which is located above the active table or chart only when there is a generated report in the browser window. In the left ...
    • Online Report

      After executing a report, under the Report Templates panel appears another one — Report Results; in the lower right part of the window, tables or charts are displayed. If no information has appeared, it means that there is no required data about the ...
    • Report on Account Contents

      CMS Manager provides an opportunity to view a report on the account contents. The report is presented as a table displaying the amount of all the macro and micro objects included into the account. On the Accounts tab in the table of results, click ...
    • Export to KML/KMZ

      This option allows you to export geofences from all available resources to a file. When you export to KML/KMZ, the list of all available geofences (depending on the item type chosen) is displayed. Check the items you want to export and press OK. ...
    • Export to WLP

      This option allows you to export data from an object to a WLP file or straight to another object. Choose object type (unit/resource/user) in the Export from dropdown list. Then select the export destination — to a file or an item. Export to an item ...