What to Do If Adding/Updating Records in Bulk Failed

Article Number:040726

This article describes actions you should take when bulk adding or updating of records fails.
On this article, you can find error messages and the respective solutions as well as the actions you should take when you encounter other problems (e.g., an empty record is added).

If an error message appears

When bulk adding or updating of records fails, an error message "Failed to import the file." is displayed on the "View" screen.
Click Imported Files to display the "Imported Files" screen. Error message

Edit your file for import referencing the error message displayed on the "Imported Files" screen and save the file. To retry the file import using the edited file, click Retry Upload. On the "Import from File" screen displayed, upload the edited file.
Example of the "Imported Files" screen For details on how to access the "Imported Files" screen and what kind of information it provides, refer to Checking the Status of File Import.

The following sections explain the solutions for each error.

If the error "GAIA_IL16" appears

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

  • If the Required field check box is selected in the field settings:
    Check the file and see if a value is specified in the position indicated by the error message.

  • If the Prohibit duplicate values check box is selected in the field settings:
    Check the file and see if a value specified in the position indicated by the error message is different from that in any other records.
    Also, if the Prohibit duplicate values check box is selected for a field, you cannot import a value of more than 64 characters into the field. Check that the number of characters used for the value is not more than 65.

  • If the field type is "Radio button" or "Drop-down":
    A value that is not provided as the field's selectable options may be specified in the file.
    Check that the values specified for the field are those that are provided as the field's selectable options.

  • If the field type is "Text" or "Number":
    If the maximum or minimum value for the number of characters or numbers is specified in the field settings, any value outside of the specified range cannot be imported.
    Also, if the Prohibit duplicate values check box is selected, you cannot import a value of more than 64 characters into the field.
    Check the file and see if a value specified in the position indicated by the error message is within the specified range.

  • If the field type is "Link":
    It is considered that the URL or e-mail address specified in the position indicated by the error message is not in the correct format.

    • If Type is set to URL in the "Link" field's field settings, check that the URL begins with "http://" or "https://".
    • If Type is set to E-mail address in the "Link" field's field settings, check that the e-mail address is in the correct format (for instance, check that a half-width @ is used).

    Details on the formatting for each field type are explained in Supported Formats for Adding/Updating Records.

  • If your file for import contains values that have a large number of digits:
    The file's value indicated by the error message may be larger than the number set for Total Number of Digits in Misc Settings.
    Check the value set for Total Number of Digits in Misc Settings on the App Settings screen.
    Reference: Setting the Significant Digits of Numbers and the Rounding Method

If the error "GAIA_IL17" appears

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 may have a malformed value in the field indicated by the error message.
Example:

  • The file contains string values that are supposed to be imported to a Number field.
  • The file contains malformed date values that cannot be recognized as a date.

Correct the data so that the data is in the appropriate format for each field.
Details on the formatting for each field type are explained in Supported Formats for Adding/Updating Records.

If the error "GAIA_IL19" appears

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.

If the error "GAIA_IL48" appears

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.

If the error "GAIA_II02" appears

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 your file for import, do not specify values of multiple tables in one row.

Example of data in the file for import:
Example of data in the file for import:

If the error "GAIA_II03" or "GAIA_II04" appears

Error message

GAIA_II03 (or GAIA_II04): 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

  • If you want to import data into tables:
    Check that the first column of your file for import is specified in accordance with the format suitable for importing data into tables. Specifically, check the following points:

    • Check that the first column name is "New Record Flag".
    • Check that an asterisk (*) is specified in the first column of the rows where data of each record begins and that other cells in the column are left blank.
      (In the case of GAIA_II04 error) Check that an asterisk (*) is specified in the first column of the row where data of the first record begins.

      Example of data in the file for import:
      Example of data in the file for import: Data specified in rows starting from the row with an asterisk (*) until the row above the one with the next asterisk (*) is recognized as the data of a single record when you add or update records via file import.
      If you import a file in the example above, data in the second row to third row, fourth row to fifth row, and sixth row to eighth row is each recognized as a single record.

  • If you do not want to import data into tables:
    Take one of the following actions so that data will not be imported into fields in the tables.

    • Delete table data in your file for import by deleting columns for the tables.
    • Exclude fields in the table from the scope of file import when you import your file.
      Example setting To exclude fields in the table from the scope of file import, select (None) for all these fields in the Column in File column.


If the error "GAIA_II08" appears

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.

If the error "GAIA_II09" appears

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 Kintone Users & System Administrator.

Solutions

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

  • A value that is not a login name
  • Login name of an inactive/deleted user or the user who does not exist
  • Login name of the user who is not using Kintone
  • Login name of the user in the department for which you don’t have view permission
  • (If the destination app of the file import belongs to a guest space) Login name of a guest user who is not the member of the 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.

If the error "GAIA_II10" appears

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.

If the error "GAIA_II12" appears

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.

If the error "GAIA_II13" appears

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.

If the error "GAIA_RE10" appears

Error message

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

Solutions

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

If an error appears indicating that corresponding file columns are not set for some fields in a table

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 more details, refer to the Help.

Solutions

If you have selected the Key to Bulk Update check box, you need to specify corresponding file columns for all the fields in the table which are displayed in under Field in App. You must also specify corresponding file columns for fields whose data has not been modified in the file.

If the error still appears even though you have specified corresponding file columns for all the fields in the table, there is a possibility that the table contains any of the following fields:

  • "Attachment" field
  • "Lookup" field (If Prohibit duplicate values is disabled for the field specified as the Key Field)

If a table contains either of the fields above, you will not be able to import data into any of the fields in the table when updating existing records via file import.
In such a case, select (None) for all the fields in the table to exclude them from the scope of file import.


If an error appears indicating that the system 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

Field settings are changed or new fields are added while the "Import from File" screen is displayed.
Apply the changes to the file for import, and then try importing the file again.

If an empty record is added

If a CSV file for import has a row that contains only delimiters which you have specified when you import the file (comma, semicolon, space, or tab), the row will be imported as an empty record.
Open the CSV file using a text editor or other equivalent software and delete the row that contains only delimiters.

If the text of a "Rich text" field is not displayed in multiple lines

To add the data of rich text fields including line breaks, the file need to contain the data written in HTML format.
In the file to import, insert ''
at the position where you want to have a line break.