Customer Database Export with /export Command¶
The /export command allows you to export the list of users and chats with whom there was correspondence through the Hotline system, as a CSV file with detailed information about each topic.
How It Works¶
The command only works in the General topic and creates a CSV file with all important information about topics: chat_id, dates, statuses, labels and other data.
Main Features¶
- Export entire customer database
- Filtering by labels
- Detailed information about each topic
- CSV format for further analysis
Export Format¶
The CSV file contains the following fields:
| Field | Description |
|---|---|
chat_id |
Telegram chat/user identifier |
last_date |
Date of last message in topic |
status |
Current dialog status (user_answered, support_answered, closed) |
title |
Topic name |
frontend_type |
Topic type (private, group, channel, etc.) |
topic_link |
Link to topic in backend group |
marks |
Assigned dialog labels (if any) |
ignore_chats |
Flag showing whether chat is included in ignore chats parameter |
CSV Format
CSV file can be opened in Excel, Google Sheets or imported into other CRM systems for further processing.
Calling the Command¶
Export All Topics¶
/export all
Exports complete list of all topics in backend group with all their properties.
Send /export all in General topic and you will receive CSV file with entire customer database.
Export by Label¶
/export MARK_NAME
Exports only topics with specified label.
Quick Help¶
Send command /export without parameters in General topic to get help in English.
Important Notes¶
Access rights
By default, command is only available to connections administrators. Access can be extended via EXTENSIONS_ALLOWED parameter.
Confidentiality
CSV file contains chat identifiers and service segmentation attributes. Follow confidentiality rules when working with exported data. It is recommended to immediately download export files and delete them from chat after completing work.
Regular export
Make regular database exports to create backups.