Phone Lines icon GFI Support

Articles in this section

See more

Exporting Activity Data to a CSV File

Author: Abas Lazem Updated

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.

Process

To export activity data:

  1. Log in to the GFI FaxMaker web interface and go to the Reports tab.
  2. 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
  3. In the main pane, click on Export Data.
  4. 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:

  • Outbound messages: The method used by users to send the message.
  • Inbound message: Routing rules matched to deliver the message to internal users.
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:

  • Outbound messages: The email address of the user sending the message.
  • Inbound message: The sender's CSID (if known).
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.