Skip to main content

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

tip

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

tip

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.

Support

If you have any other questions, please contact us or check out Our Slack Community.

Contact form
Join Kuroco Slack community