Actions to be Taken When You Failed to Bulk Add/Update Records

This section explains how to solve the issues when you failed to add/update records in bulk.
We provide the information on how to solve various error messages and what to do when you have problems such that empty records are added.

If You Get an Error Message

When you failed to add or update records in bulk, you will get an error message saying "Failed to import the file." in the View.
Click Imported Files to check the details of the error.

The following sections explains the solutions for each error message.

Error "GAIA_IL16" Is Displayed

Error Message

GAIA_IL16: The value of field "field name" at row number R of the file is invalid. Please confirm the field conditions such as "Required field" or "Prohibit duplicate values", and modify the value of the file. If the field type is a Drop-down or a Radio Button, please confirm that the value matches one of the options included in the field settings.

Solutions

  • When a value is required to be entered in the field settings:
    Check if the file contains a value in the field indicated by the error message.

  • When duplicate values are prohibited in "Field Settings":
    Check if the file does not contain the same values as other records in the field indicated by error message.

  • When the field is radio button or drop-down:
    The file may contain a value that is not provided as selectable options in the field.
    Make sure that the file contains one of the selectable options as a value for the field.

  • When the error message indicates a field that is not to be updated:
    The file contains a value that does not meet the conditions specified in the field, as indicated by error message. One of the possible causes is that the file does not contain any values for required fields.
    Check the settings for the field and the values in the file to be imported into the field.

  • When You Try to Import a File Having a Value Exceeding the Maximum Digits
    The file may have a numeric value that exceeds the number of digits configured in the "Total Number of Digits" of "Misc Settings", as indicated by error message.
    Check the value in the "Total Number of Digits" field of "Misc Settings" on the App Settings page.
    Refer to Setting the Significant Digits of Numbers and the Rounding Method

Error "GAIA_IL17" Is Displayed

Error Message

GAIA_IL17: The format of field "field name" at row number R of the file is invalid. In kintone, the supported formats for importing vary for each field type. Check the value of field "field name" at row number R in the file.

Solutions

The file contains the malformed value in the field indicated by the error message.
Correct the format of the value in the file.
About the supported formats for each field type, refer to the "Supported Formats for Each Field Type" page.

Error "GAIA_IL19" Is Displayed

Error Message

GAIA_IL19: Failed to lookup with the value of field "field name" at row number R of the file. The corresponding record cannot be found in the datasource app.

Solutions

The value was imported as a Key for the Lookup field, but it does not exist in the datasource app.
You need to add the value indicated by the error message to the app.

Error "GAIA_IL48" Is Displayed

Error Message

GAIA_IL48: Category "C" specified at row number R of the file does not exist in the App. Open the "App settings" and check that the value exists in the "Categories" settings.

Solutions

The file contains a value that is not provided as selectable options in the Categories, as indicated by the error message.
Make sure that the file contains one of the selectable options as a value in the column associated with the Categories.

Error "GAIA_II02" Is Displayed

Error Message

GAIA_II02: Row number R of the file contains multiple table data. Ensure that only data for one table is included in one row of the file.

Solutions

In a file to import, do not include values from multiple tables in one row.

Example of Data in a File:


Error "GAIA_II03" Is Displayed

Error Message

GAIA_II03: This App contains tables. To import data into tables of Apps, the imported file must contain a flag (indicated by the * symbol) in the first column of each new record. If you do not want to import data from the file into tables of Apps, do not specify columns which indicate fields in the table.

Solutions

  • When you want to import table data:
    Add a column to the beginning of the file, and enter "*" in each row or leave it empty.
    A row with "*" and its subsequent rows without "*" will be added as a record in a table. Each row with "*" becomes the first row of a table.

    Example of Data in a File:

    Each of the following sets of rows is added to a record: rows 2 and 3, rows 4 and 5, and rows 6 to 8.

  • When you do not want to import table data:
    To avoid importing data into the fields in the table, use one of the following ways.

    • Delete columns, which correspond to fields in the table, from the file to import.
    • When you import a file, select "(None)" for all fields of the table under the "Column in File".


Error "GAIA_II08" Is Displayed

Error Message

GAIA_II08: The file contains no value on line number L at the column that is associated with "field name" field. When you associate Created by/Updated by fields with any of the columns in "Column in File", data for Created by/Updated by fields is required in the records that you are trying to import. Select "(None)" from "Column in File" or check that the specified column is correct. In some cases, you may need to correct the file.

Solutions

If you specify "Column in File" for the Created by/Updated by fields when importing records from a file, data for the specified columns needs to be included in the file.
Check if the file contains values in the column indicated by the error message or the specified columns are correct.

If you don't need to specify the Created by/Updated by fields when importing records from a file, select "(None)" from the Column in File. In that case, data for the Created by/Updated by fields will be set to the user who performed the Import from file action.

Error "GAIA_II09" Is Displayed

Error Message

GAIA_II09: The file contains a value other than a login name or an invalid user on line number L at the column that is associated with "field name" field (The user may not exist or have been suspended/deleted. In some cases, you may not be able to view the user). Make sure that the login name is entered correctly or contact your Users & System Administrator.

Solutions

The file may contain the following values in the place indicated by the error message:

  • A value other than login name
  • Login name of the user who don't exist or have been suspended or deleted
  • Login name of the user who are not using kintone
  • Login name of the user in the department for which you don’t have view permission.
  • Login name of the guest who is not the member of the space if the app belongs to a guest space.

Make sure the file contains only one login name of a valid user in the columns associated with the Created /Updated by fields.

If you don't need to specify the Created by/Updated by fields when importing records from a file, select "(None)" from the Column in File. In that case, data for the Created by/Updated by fields will be set to the user who performed the Import from file action.

Error "GAIA_II10" Is Displayed

Error Message

GAIA_II10: The file contains a line break on line number L at the column that is associated with "field name" field. Remove the line break and specify only one user login name.

Solutions

The column in the file indicated by the error message might have a line break.
The file should contain only one user login name, and do not contain any line breaks in the columns associated with the Created by/Updated by fields.

If you don't need to specify the Created by/Updated by fields when importing records from a file, select "(None)" from the Column in File. In that case, data for the Created by/Updated by fields will be set to the user who performed the Import from file action.

Error "GAIA_II12" Is Displayed

Error Message

GAIA_II12: The file contains no value on line number L at the column that is associated with "field name" field. When you associate Created datetime/Updated datetime fields with any of the columns in "Column in File", data for Created datetime/Updated datetime fields is required in the records that you are trying to import. Select "(None)" from "Column in File" or check that the specified column is correct. In some cases, you may need to correct the file.

Solutions

If you specify "Column in File" for the Created datetime/Updated datetime fields when importing records from a file, data for the specified columns needs to be included in the file.
Check if the file contains values in the column indicated by the error message or the specified columns are correct.

If you don't need to specify the Created datetime/Updated datetime fields when importing records from a file, select "(None)" from the Column in File. In that case, data for the Created datetime/Updated datetime for the imported records will be set to the date and time when the file was imported.

Error "GAIA_II13" Is Displayed

Error Message

GAIA_II13: The file contains a future date on line number L at the column that is associated with "field name" field. You need to specify a past date.

Solutions

You cannot specify a future date and time for Created datetime/Updated datetime when importing records from a file.
Check the file to make sure that the columns associated with Created time/Updated Datetime fields contains the date and time is earlier than that of the import from file action.

If you don't need to specify the Created datetime/Updated datetime fields when importing records from a file, select "(None)" from the Column in File. In that case, data for the Created datetime/Updated datetime for the imported records will be set to the date and time when the file was imported.

Error "GAIA_TM03" Is Displayed

Error Message

GAIA_TM03: The number of rows in table "table name" exceeds the maximum of 5,000.

Solutions

The maximum number of rows you can add to a table is 5,000.
Make sure that the file you import has less than 5,000 rows for a table.

Error "GAIA_RE10" Is Displayed

Error Message

GAIA_RE10: The value in the Key to Bulk Update field in record number R is duplicated in another record.

Solutions

Check the file to import and make sure that there are no duplicate values in the field that is specified as "Key to Bulk Update" field.

An Error Is Displayed When a Table Has Some Fields That Are Not Associated With "Column in File"

Error Message
To update fields in a table, select "Column in File" for all the fields in the table. You cannot update some tables; for example, a table which contains "Attachment" field. For details, see the Help.

Solutions

If you have selected "Key to Bulk Update", you need to specify "Column in File" for all fields in the table displayed in "Field in App".

However, if the table contains the following fields, you cannot perform a bulk update.

  • Attachment field
  • Lookup field, when "Prohibit duplicate values" is disabled for the key field.

For details on how to update tables in bulk, refer to the "Adding and Updating Records Including Tables in Bulk" page.

An Error Is Displayed When Failed to Start Importing Data into a Table

Error Message

Failed to start importing the file, because the app settings were updated while you configured the file import. Possible causes are: "fields were added into the table" or "settings of the fields in the import file were changed". Please confirm the updated settings and change the import data, then try to import the file again.

Solutions

While displaying the screen to import data from file, field addition/change was performed in the form setting screen.
Add/change the corresponding field in the file, and then try to import the file again.

An Empty Record Is Created

A blank line in a file is added as an empty record. Delete the blank lines from the file, if any.

No Line Breaks for the Values Imported into the Rich Text Field

To add the data of rich text fields including line breaks, the file need to contain the data written in HTML format.
Insert "<br>" on the positions where you want to use line breaks in the file to import.