You can export data for topics in which you are a participant at once.
This feature is available on all plans.
Note: This feature is only available for administrators.
Export and download
You can export topic data at once by following the steps below.
- Open the settings panel in the lower left corner of Typetalk.
- Click on Export in the Manage Organization category.
- Click Export in the Message Export column and click Start Export.
- When the export is ready, the administrator who performed it will be notified by email.
- Click the download link in the body of the email.
You must be logged in to Typetalk to download exported files. The download link issued will expire in one week. If a week has passed since the export was performed, please perform the export again.
Export file format
The data to be exported consists of a single zip-compressed file. The zip file contains a folder for each topic, and each folder contains the following 5 CSV files.
- topic.csv
- messages.csv
- tags.csv
- members.csv
- attachments.csv
The zip file name is in the format "Topic ID - Topic Name". If some symbolic characters not allowed in your operating system (e.g. / ? <) are used in the topic name, they will be replaced by underscore (_).
topic.csv
Contains data about the topic itself.
| Column | Description |
| Topic ID | Identify the topic. |
| Topic name | Name given to the topic. |
| Topic description | Description filled out to the topic. |
| Archive state |
Topic archive status (*) Archived topics are marked as "Archived”. |
| Creation date and time | Date and time the topic has been created. |
| Last posted date and time | Last date and time member posted a message to the topic. |
| Author ID | Unique ID of the topic author. |
| Author Nulab ID | ID inside the system that identifies the topic creator. |
| Author email | Email address of topic author |
messages.csv
Contains message data posted to the topic.
| Column | Description |
| Topic ID | Identify the topic. |
| Post ID | Identify the message. |
| Contributor ID | Unique ID of the message author. |
| Contributor name | Account name of the message author. |
| Posted message | Posted message to the topic |
| Post date and time | Date and time the message has been posted. |
tags.csv
Contains data about the summary created on the topic.
| Column | Description |
| Topic ID | Identify the topic. |
| Tag ID | Identify the tag. |
| Tag name | Name given to the tag. |
| Post ID | Post ID of the message with tag |
members.csv
Contains account data participating in the topic.
| Column | Description |
| Topic ID | Identify the topic. |
| Account ID | Unique ID of the account. |
| Account Nulab ID | ID inside the system that identifies the account. |
| Account name | Account name |
| Mail address | Email address of the account |
attachments.csv
Contains data related to the files attached to the topic.
| Column | Description |
| Topic ID | Identify the topic. |
| Post ID | Post ID of the message with the file attached |
| File name | Attached file name |
| File URL (Web) |
URL to access the attached file (*) Access is allowed only while authenticated in the web app |
| File URL (API) |
URL to access the attached file ※ Access is allowed only when authorized by a bot or OAuth client. |
Troubleshooting
If you are unable to unzip the downloaded zip
If you unzip a zip file with a long topic name, it may exceed the OS path length limit and cannot be unzipped. Move to a higher-level directory and extract the file, or shorten the long topic name and rerun the export.
Export other data
In addition to this, the following data export functions are available