This article describes the actions you should take when the bulk adding or updating of records fails.

Rows of data that could not be imported from your file can be downloaded in a CSV file that also contains the details of any errors that occurred. This CSV file can be downloaded on the Imported files screen.
After checking the error details in the CSV file, make the necessary corrections to your file.
If the CSV file contains garbled text, refer to the following section.
If the text in your CSV file is garbled

GAIA_IL16: An invalid value is specified in the "***" field mapped column. Check the field settings of the "***" field (e.g., "Required field" setting, "Prohibit duplicate values" setting), and modify the value specified in the file. If the field is a "Drop-down" or "Radio button" field, check that the value specified in the file matches any one of the options set for the field.

No values are entered in required fields. Enter values in the fields specified in the error message.

A field that prohibits duplicates contains a value that already exists in another record. Change the values in the fields shown in the error message to ensure there are no duplicates.
Also, note that values exceeding 64 characters cannot be imported into fields that prohibit duplicates. Check that the number of characters used for the value is not more than 65.

If you imported a file by specifying the Record number field as the Update key (or Key to bulk update with the classic file import method), make sure that the Record number column does not contain a record number that does not exist in the app.

If the field type is Radio Button or Drop-down, the file may contain options that are not defined in the field settings.
Check that the values specified for the field are selectable options of the field.

If a maximum or minimum value is specified in a Text or Number field, any value outside of the specified range cannot be imported.
Also, note that values exceeding 64 characters cannot be imported into fields that prohibit duplicates.
Check the fields indicated in the error message for values that exceed the specified range.

Check that correct values are specified in the Link fields indicated in the error message.

• If Type is set to URL in the Link field's settings, make sure that the URL begins with "http://" or "https://".
• If Type is set to Email address in the Link field's settings, make sure that the email address is in the correct format. (For example, make sure that the "@" symbol is entered as a half-width character.)

For information on the supported formats for each field type, refer to the page below.
Supported formats for adding/updating records

The imported file may contain values that have a large number of digits.
Check the fields indicated in the error message for values that exceed the Total number of digits specified in Misc settings on the App settings screen.

For more information about how to set Total number of digits, refer to the following page.
Setting the significant digits of numbers and the rounding method

GAIA_IL17: Invalid formatting is found in the "***" field mapped column. The supported formatting differs depending on the field type to which the column is mapped. Check that the value specified in the "***" field mapped column is formatted correctly.

The field indicated in the error message contains an incorrect value, as shown in the following example.
Example:

• The file contains string values that are supposed to be imported to a Number field.
• The file contains Date field values that are not in a recognized date format.

Correct the data so that it is in the appropriate format for each field.
For information on the supported formats for each field type, refer to the page below.
Supported formats for adding/updating records

GAIA_IL19: Failed to lookup (retrieve) data using the value specified in the "***" field mapped column. No corresponding record is found in the datasource app.

In the Lookup settings dialog, the value of the field set as the Key field for the Datasource app must exactly match the value registered in the datasource app.

To resolve the error, do one of the following: (1) Modify the datasource app so that it includes values that match those in the file, (2) Modify the file to be imported so that it includes values that match those in the datasource app.

GAIA_IL48: The app does not have the "***" category. Check the app's Categories setting.

The specified value in the file is not found among the app's category options.
Make sure that the value in the file's column mapped to a category is a selectable option in the app's Categories settings.

GAIA_II02: The row contains values for multiple tables. Make sure that you specify values for one table per row.

Do not specify values for more than one table in a single row.
Example of data in the file for import:

GAIA_II03 (or GAIA_II04): You are trying to import data into the app's table. To import data into tables, your file needs to have new record flags, which indicate the start of each record entry, in the first column of data rows. If you do not want to import data into the app's table, do not map file's columns to any of the fields in the table.

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:
  

  The data in rows starting from the one marked with an asterisk (*) up to the row immediately before the next asterisk (*) is treated as a single record when importing or updating records from a file.
  In the example above, the data in the second to third row, the data in the fourth to fifth row, and the data in the sixth to eighth row will be recognized as separate records.
  Preparing a file for adding/updating records with tables

Take one of the following actions so that data will not be imported into the fields in the table.

• Delete the table data in your file for import by deleting the columns for the table.
• Exclude fields in the table from the scope of file import when you import your file.

To exclude fields in the table from the scope of file import, select (None) under File column (or Column in file with the classic file import method) for the columns corresponding to the fields.

GAIA_II08: No value is specified in the "***" field mapped column. If you map the "Created by" or "Updated by" field to your file's column, values for the field are required for records that will be newly added to the app. Carry out any of the following solutions: Select "(None)" for the field in the "Column in file" section when you import the file, check that your field mapping is correct, or modify values in the file.

If you specify columns under File column (or [Column in file] with the classic file import method) for the Created by or Updated by fields when importing records from a file, data for the columns needs to be included in the file.
If a value is missing in the specified column, either add a necessary value or verify that the specified column is correct.

If you don't need to specify columns for either of these fields when importing records from a file, select (None) for them under File column (or [Column in file] with the classic file import method). In that case, the values of the Created by and Updated by fields will be updated to the name of the user who imported the file.

GAIA_II09: The "***" field mapped column contains an invalid login name (e.g., a login name of a user who doesn't exist, a suspended/deleted user, or a user for whom you don't have the view permission) or a value other than a login name. Check that the login name is correct, or contact your cybozu.cn administrator.

The column mapped to the Created by and/or Updated by field may contain login names like the following:

• A value that is not a login name
• The login name of a non-existent, inactive, or deleted user
• The login name of the user who is not using kintone
• The 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) The login name of a guest user who is not the member of the guest space

Make sure that the columns in your file mapped to Created by or Updated by fields contain only one login name of a valid user for each value.
You can find user login names in the following locations:

• Departments & users in Users & system administration (Accessible only by cybozu.cn administrators)
• In the URL of individual users' People page or profile details

If you don't need to specify columns for either of these fields when importing records from a file, select (None) for them under File column (or Column in file with the classic file import method). In that case, data for the Created by and Updated by fields will be set to the user who imported the file.

GAIA_II10: The "***" field mapped column contains one or more line breaks. Remove the line breaks, and specify only one login name.

The column mapped to the Created by and/or Updated by field may contain line breaks.
Make sure to enter only one user login name per column, without any line breaks.

If you don't need to specify columns for either of these fields when importing records from a file, select (None) for them under File column (or Column in file with the classic file import method). In that case, data for the Created by and Updated by fields will be set to the user who imported the file.

GAIA_II12: No value is specified in the "***" field mapped column. If you map the "Created datetime" or "Updated datetime" field to your file's column, values for the field are required for records that will be newly added to the app. Carry out any of the following solutions: Select "(None)" for the field in the "Column in file" section when you import the file, check that your field mapping is correct, or modify values in the file.

If you specify a column under File column (or [Column in file] with the classic file import method) for the Created datetime or Updated datetime field, data must be entered for the column in the file.
Make sure that the specified column has data entered in it, and that the correct column is specified.

If you don't need to specify columns for either of these fields, select (None) for them under File column (or Column in file with the classic file import method). In that case, the values of the Created datetime and Updated datetime fields will be updated to the date and time when the file was imported.

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

Future dates cannot be specified in Created datetime or Updated datetime fields.
Make sure that the columns in your file that are associated with Created datetime or Updated datetime fields contain dates and times earlier than the time when you import the file.

If you don't need to specify columns for either of these fields, select (None) for them under File column (or Column in file with the classic file import method). In that case, the values of the Created datetime and Updated datetime fields will be updated to the date and time when the file was imported.

GAIA_LM01: Failed to import the value into the Lookup field, "***". The field cannot lookup data because there is more than one corresponding record in the datasource app. Select "(None)" for the field in the "Column in file" section when you import the file. To lookup data using the value specified in the "***" field mapped column, manually enter the value into the "***" field on the record.

If any values you are trying to import into the Lookup field have duplicate values in the field's datasource app (i.e., the app where the data you want to retrieve is registered), they cannot be imported from the file.

In this case, register the relevant values one at a time on the New record screen or record editing screen.

GAIA_RE10: The value in the "Key to bulk update" field in record number *** is duplicated in another record.

With kintone, if the import file contains the same value more than once in the column specified under Corresponding file column for the Update key (or Key to bulk update with the classic file import method), the last row that contains the value will be reflected in the relevant record.
Note, however, that depending on the number of rows or the location where duplicates are found, this error might occur.

Make sure that there are no duplicate values in the column specified under Corresponding file column for the Update key (or Key to bulk update with the classic file import method), then try importing the file again.

GAIA_SE02: Data import was stopped either because an error occurred before this row in the imported file, or because the import process was canceled.

This error message appears in the following cases:

• Import was stopped manually.
• An import error occurred when the Stop importing (No rows after the first error will be imported) option was selected for handling errors.

Check the row where the error occurred, then import the file again.

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. Please refer Help for details.

If you have specified a field as the Update key (or Key to bulk update with the classic file import method), you need to specify a file column under File column (or Column in file with the classic file import method) for every field displayed under App field (or [Field in app] with the classic file import method) that is contained in the table you want to import. All columns require a value other than (None), even for fields that don't need to be changed.

If the error still appears even though you have specified corresponding file columns for all of the fields in the table, there is a possibility that the table contains an Attachment field. If a table contains an Attachment field, data in the table cannot be updated. In such a case, select (None) for all the fields in the table to exclude them from the scope of file import.

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.

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.

In some cases, you may find garbled text in the CSV file downloaded on the Imported files screen when you double-click it and open it in Excel.
If this happens, open the file using Excel's feature for importing data from the data source.
For details, refer to the following page.
Microsoft Help: Opening CSV UTF-8 files correctly in Excel

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.

To add Rich text field data with line breaks, the file needs to contain the data in HTML format.
In the file to import, insert ''
at the position where you want to have a line break.