Export all participating topics at once

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.

  1. Open the settings panel in the lower left corner of Typetalk.
  2. Click on Export in the Manage Organization category.
  3. Click Export in the Message Export column and click Start Export.
  4. When the export is ready, the administrator who performed it will be notified by email.
  5. 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

For administrators

For members

0 people think that it is helpful. Was this helpful for you?

Have a question we didn't answer?

Contact support