Overview
Exporting fax and SMS activity in a custom date range to a comma-separated value (CSV) file is useful to track fax and SMS usage in a separate tool, for example, to create pivot charts using GFI FaxMaker data in spreadsheets. This article describes how to export activity data to a CSV file.
Solution
To export activity data:
- Log in to the GFI FaxMaker web interface and go to the Reports tab.
- From the left pane under Categories, select the node to export data for:
- All: export activity for both fax and SMS
- Fax: export fax activity only
- SMS: export SMS activity only
- In the main pane, click on Export Data.
- Select the date range for the data to export and click Export to CSV to start the download.
Note: Alternatively, you can also use the Fax Archive data report which provides more customization, scheduling, and filtering.
The exported CSV file contains the following columns:
|
Column |
Description |
|---|---|
| Type | Defines whether the message is fax or an SMS. |
| Direction | Defines if the message is inbound (received) or outbound (sent). |
| Date | The complete date of transmission. |
| Day | The day (number) of the transmission. |
| Month | The month (number) of the transmission. |
| Year | The year of the transmission. |
| Time | The full time of the transmission. |
| Hour | The hour of the transmission (24-hour format). |
| Minute | The minutes of the transmission. |
| Host Name | The name of the GFI FaxMaker server where the transmission occurred. |
| Method Submitted / Routing Mechanism |
The value of this column depends on the direction of the message:
|
| Billing Code | The billing code value of outbound faxes (if specified). |
| Sender Number | The Caller Line Identity Presentation (CLIP) or Caller ID of the fax sender (if available). |
| Sender |
The value of this column depends on the direction of the message:
|
| Recipient Number | The message recipient's number. |
| Recipient Name |
The recipient's name for outbound faxes. Note: This value is not always retrievable by GFI FaxMaker. For example, it can be determined if sending a fax from the web client using the web client address book (if a name is specified), but not retrievable if sending a fax from Microsoft Outlook using the Microsoft Outlook local contacts. |
| Recipient Company |
The recipient's company name for outbound faxes. Note: This value is not always retrievable by GFI FaxMaker. For example, it can be determined if sending a fax from the web client using the web client address book (if a company name is specified), but not retrievable if sending a fax from Microsoft Outlook using the Microsoft Outlook local contacts. |
| Line | The GFI FaxMaker fax line used to transmit the message. |
| Fax Pages excluding cover page | The number of pages excluding the cover page for outbound faxes. |
| Fax Pages including cover page | The total number of fax pages sent or received. |
| Total Pages/SMS | The total number of fax pages or the total number of SMS messages transmitted. |
| Resolution | The quality of fax resolution. |
| Speed | Fax transmission speed. |
| Retries | Number of times that GFI FaxMaker tried to send the fax. Value is 0 if sent fax is successfully transmitted on the first attempt. |
| Call duration (seconds) | Fax call duration in seconds. |
| Status | The transmission result: Success or Failed. |