Exporting activity data to a CSV
Export fax and SMS activity in a custom date range to a comma separated file. This is useful to track fax and SMS usage in a separate tool, for example, to create pivot charts using GFI FaxMaker data in spreadsheets.
To export activity data, login 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 contains the following columns:
| Column | Description |
|---|---|
| Type | Defines whether the message is a fax or an SMS. |
| Direction | Defines if message is inbound (received) or outbound (sent). |
| Date | The complete date of transmission. |
| Day | The day number of transmission. |
| Month | The month number of transmission. |
| Year | The year of transmission. |
| Time | The full time of transmission. |
| Hour | The hour of transmission in 24-hour format. |
| Minute | The minutes of transmission. |
| Host Name | The name of the GFI FaxMaker server where transmission occurred. |
| Method Submitted / RoutingThe methods used by GFI FaxMaker to determine how to route faxes to internal recipients. 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 (CLIPThe Caller Line Identity Presentation is used to identify the calling party's number. It is also commonly referred to as CLI (Caller Line Identity), CLID (Caller Line Identity Display), CND (Caller Number Display) or just Caller ID.) 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 that 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 that 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 coverpage | Number of pages excluding the coverpage for outbound faxes. |
| Fax Pages including coverpage | Total number of fax pages sent or received. |
| Total Pages/SMS | Total number of fax pages or 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. |