Bulk upload via CSV

CSV uploads enable you to update content within a content structure in bulk.

Batch updating articles via CSV

1. Download the CSV file

On the content structure list screen, click the [Download] link for the content structure you want to edit.

Image from Gyazo

Configure the settings on the download screen and click [Download contents].

fetched from Gyazo

See: Content download for more information on the download file settings.

2. Edit the CSV file

Take note of the following when modifying the downloaded CSV file.

Required fields

The CSV file must include following fields:

  • Topic ID (see below)
  • Published
  • Date
  • Category
  • Title

Creating, updating, or deleting topics

  • To add a new topic, leave the topic ID blank.
  • To update an existing topic, fill in the correct topic ID with the new information.
  • To delete an existing topic, set a value of 1 in the "delete flag" field.

Suggested default values

We recommend uploading your CSV file without modifying the following fields in the downloaded file:

  • Group name

Uploading image files

To upload image files, enter the following in the image item settings field and upload the images in a ZIP file along with the CSV file:

path::filename

To include a description of the image, enter the following in the image item settings field:

path::filename
(image description)

3. Upload the CSV file

On the content structure list screen, click [Upload] for the content structure you want to edit.

Image from Gyazo

Configure your file settings on the upload screen and click [Upload]. The content(s) will be updated once the uploaded file is processed.

Image from Gyazo

See: Content upload for more information on the upload file settings.

Take note of the following when uploading CSV files.

Upload data limit

Limit the number of rows in the CSV file to a maximum of 1,000. For datasets containing more than 1,000 rows, split the upload into multiple CSV files.

There is no hard size limit for the upload, since this depends on various factors. But timeouts may occur for large datasets, and the file upload may fail as a result. Therefore, we recommend uploading large datasets in multiple files.

Line breaks

For line breaks in the CSV file, use LF or CR/LF.

Character encoding

For the encoding of the CSV file, select Shift-JIS.

If you have any other questions, please use our contact form or Slack workspace.