Checking the status of file import

記事番号:040727

Data can be imported to an app from an Excel or CSV file.
On the Imported files screen, you can check the status of the files you've imported.

The Imported files screen lets you check the following:

  • The progress of each of your imported files
  • Errors in your file for import (if your file import failed)

Accessing the "Imported files" screen

To show the Imported files screen, perform one of the following actions.

  • Click a link in the message that is displayed at the top of the View screen while your file is being imported or when your file import action has failed.
    Screenshot: The screen displayed while the file is being imported Screenshot: The screen displayed when file import has failed
  • Click the Settings icon (the gear-shaped icon) at the top of kintone, then select Imported files.
    Screenshot: The "Imported files" link is highlighted

Checking the status of an imported file on the "Imported files" screen

The Imported files screen displays up to 20 items per page showing the progress and results of file import operations that you have performed, in descending order of Submitted.

The screen refreshes automatically to update the display.
Imported files disappear from the Imported files screen three days after the date and time specified in the Submitted column. Also, when an app is deleted, files that were imported into the deleted app will no longer be displayed.

Overview of the "Imported files" screen

This section describes the items displayed on the Imported files screen.
Screenshot: The "Imported files" screen.

Submitted

Shows the date and time when the import file was registered.

Completed

Displays the date and time when the file import process was completed.

If the status is "Waiting" or "In progress", the field will remain blank until the loading process is complete.

App

Shows the name of the app to which you imported data from a file.
When you click the link of the app name, the View screen of the app is displayed.
However, if you do not have permission to view or add records for the app, (No permission) is displayed instead.

File

Shows the name of the file used to import data into the app.

Status

Indicates the status of the file import process. The following statuses are available:

  • [待機中]
  • In progress
  • Failed
  • Completed
  • Canceled

Details

Shows a message based on the current status.

If the status is "Waiting"

Indicates that the user is in an idle state.

To stop importing a file, click "Action" column's "Stop importing". The "Status" changes to "Canceled".

If the status is "In progress"

Displays the number of rows for which data import has been completed out of the total number of rows in the file to be imported.

To stop importing a file, click "Action" column's "Stop importing". The "Status" changes to "Completed".

If the status is "Failed"

An error code and an error message are displayed.

If multiple errors occur during a single file import, only one error message will be displayed.
For details on how to resolve errors, refer to the following page:
When Bulk Add/Update Records Fails

If the status is "Completed"

Indicates the number of rows for which data loading has been completed.

The number of rows that failed to be imported due to errors or cancellation is also displayed.
In addition, you can download the rows that failed to be imported and the causes in CSV format.

If the status is "Canceled"

A message indicates that the file import process was canceled.

"Action"

Depending on the situation, action links such as "Stop importing" appear.

Reloading the Updated File

If an error occurs during the file import process, you can resume the process with the settings from the previous import attempt retained.

Clicking the "Import from file again" button in the "Details" section opens the "Import from file" screen.
Screenshot: The "Import from file again" button

On the displayed "Import from file" screen, import the corrected file again.

Conditions for import settings to be carried over

If all of the following conditions are met, the settings from your previous import will be carried over.

  • On the "Imported files" screen, clicking the "Import from file again" button to open the "Import from file" screen
  • The user has previously checked "First row in the file contains column headers" and executed the file import process.
  • The column names and order of columns in the file to be re-imported are the same as those in the file that was previously imported.

Import settings that are carried over

The following import settings are carried over when you re-upload a file. For details, click on the links.