Bulk upload via CSV

Topic(s) within a topic group can be updated in batch via CSV upload. Below are the steps of uploading topic(s) CSV.

How to update articles in bulk with CSV

1. Download the CSV file
First, download the CSV file.
On the topic group list page, click the [Download] link of the target topic group.

Image (fetched from Gyazo)

The download settings page will be displayed. Set the details and click [Topics download].

Image (fetched from Gyazo)

Reference) For more details on topic download setting, see Management screen manual - Downloading topics.

2. Editing the CSV file
Modify the file downloaded in step 1.
Please take note of the following when modifying CSV files.

Required fields
The following are required items.

  • Topic ID *Only required when updating an existing topic. Leave blank when adding a new topic
  • Public
  • Date
  • Category
  • Title

New / update / delete behaviour
The behaviour of the content changes as follows depending on the topic ID.

  • If the topic ID is empty, a new topic will be created
  • If the topic ID exists, the corresponding topic will be updated.
  • If the topic ID is specified with the value "1" in the delete flag field, the corresponding topic will be deleted.

Recommended default values
It is recommended to upload the CSV file without modifying the following fields of the downloaded CSV:

  • Group Name
  • Season

3. Uploading the CSV file
Upload the CSV file created in step 2.

On the topic group list page, click the [Upload] link of the target topic group. Image (fetched from Gyazo)

The upload setting screen will be displayed. Set the details and click [Send].
Image (fetched from Gyazo)

Note) For more details on the upload setting screen, see Management screen manual - Uploading topics.

The topic(s) will be updated once the file is uploaded.
Please take note of the following when uploading CSV files.

Data limit for uploads
Please limit the number of lines in the CSV file to a maximum of 1000 lines.
If there are more than 1000 lines, please split the upload into multiple CSV files. The upload size limit is not specifically defined, as it depends on a variety of factors. However, if the amount of data is too large, a timeout may occur, and the file cannot be uploaded. It's recommended to upload large data as multiple files instead.

About line break code
Please use "LF" or "CR/LF" for line break(s) in the CSV file.

About text encoding
Please use "shift_jis" for the CSV text encoding.