Summarizing Fields in the Exported CSV Format

  • Updated on Nov 3, 2025
  • Published on Jul 28, 2025
  • 2 minute(s) read
Prev Next

Prerequisites

Ensure that the sufficient space in the folder available in the SFTP server.

  • If the number of messages per folder exceeds the maximum value, the current folder is zipped and sent, and a new folder is created to archive new messages.

  • If the folder size exceeds the maximum limit, the current folder is zipped and sent, and a new folder is created to archive new messages.

Sample CSV

The ZIP file contains two primary folders:

  • Attachment Folder: Stores any relevant attachments.

  • CSV Folder: Contains CSV files that store message data.

The sample CSV file: Sample CSV

Naming Convention for the ZIP File

The naming convention for the ZIP file follows this format:

YYYYMMDD0000-TeleMessage_<file#>_<TimeZipped>.zip

Where:

  • YYYYMMDD: Represents the year, month, and day of file creation.

  • 0000: A static value placeholder.

  • TeleMessage: The fixed prefix for identifying the type of data.

  • <file#>: A sequential number assigned based on the file size or the number of messages. If the contents exceed a set limit (file size or number of messages), additional files are created with incrementing numbers.

  • <TimeZipped>: Denotes the time when the file was zipped, expressed in HHMMSS format.

For example: 202409080000-TeleMessage_1_224500.zip

CSV Format

The following table summarizes all fields in the exported CSV format:

Fields

Description

Source

Displays all supported Capture Mobile sources. The following values are displayed in the Source column:

Network

Display Name

WhatsApp Phone Capture

WHATSAPP_ARCHIVER

Enterprise Number Capture

TELEMESSAGE

Android Capture

ANDROID_ARCHIVER

WhatsApp Cloud Capture

WHATSAPP_CLOUD_ARCHIVER

Telegram Capture

TELEGRAM

Signal Capture

SIGNAL

WeChat Capture

WECHAT

Verizon Network Carrier Capture

VERIZON

ATT Network Carrier Capture

ATT

O2 Network Carrier Capture

TELEFONICA_O2

Rogers Network Carrier Capture

ROGERS

Bell Network Carrier Capture

BELL

TMobile Network Carrier Capture

T_MOBILE

Telus Network Carrier Capture

TELUS

HKCSL Network Carrier Capture

HKCSL

M1 Singapore Network Carrier Capture

M1

3HK Network Carrier Capture

THREE_HK

ConversationID

Displays the unique conversation ID.

ConversationLog

Displays the sequence number, representing the chronological order of the messages in the conversation.

ConversationDateTime

Displays the date and time the message was shared.

Initiator

Displays the phone number of the registered user who initiated the archive entry.

FromName

Displays the first and last name or nickname of the participant who sent the message.

FromNumber

Displays the phone number of the participant who sent the message.

ToName

Displays the first and last name or nickname of the participant who received the message.

ToNumber

Displays the phone number of the participant who received the message.

MessageType

Displays either of the four options:

  • Event: Indicates an event such as deleting a message, editing a message, joining or leaving a group.

  • App Message: Indicates that it is a text message or attachment.

  • Voice call: Indicates that it is a voice call.

  • Video call: Indicates that it is a video call.

MessageText

Displays the message text.

Original Attachment

Displays the file name, seperated with a semi colon (;).

Internal Attachment

Displays the file name, seperated with a semi colon (;).

CallLog - Start Time

Displays the start time of the call.

CallLog – End Time

Displays the end time of the call.

CallLog - Duration

Displays the duration of the call.

CallLog - Status

Displays the status of the call.

Call recording

Displays the file name.

Supervised

Displays Yes if the message sender is monitored, such as in the case of registered user.

GroupName

Displays the group name in case of group chat.

GroupID

Displays the ID of the group.

ConversationType (group type)

Displays the conversation type:

  • Group: Indicates that it is a group chat.

  • Direct: Indicates that it is a personal chat.

Internal

Displays the value as Yes if the conversation is between two registered users under the same manager.

MessageID

Displays the unique identifier of the message. This ID helps trace specific messages, especially when actions such as delete, edit, or reaction events occur.

OriginalMessageID

Displays the identifier of the original message when an event (for example, delete, edit, or reaction) occurs. This allows matching the event message with the original message.