Analysis of the progress of an import

Follow

To check the status of your import, select the "Monitoring" menu (at the top right), then choose the "Logs" tab (on the left), as shown below:

 

You will find the list of your most recent schedules:

 

 

2. If the status is:

Blue => it means that it is being processed

Green => it means that the action is finished

Red => it means that the action was not done, so there is an error.

 

Possible errors:

 

Mapping error: The * .FailedToMap files contain the lines of which one of the fields could not be interpreted. The possible reasons for mapping errors are a missing field in the source file, an extra field in the source file, a field separator present in a field.

Check error: The * .FailedToCheck files contain the lines one of the fields of which does not correspond to the format expected by Sunflow. Possible check errors are: 

- Wrong date format. 

- Wrong boolean format. 

- Numerical field outside the min / max limits. 

- Date field outside the min / max limits. 

- Bad decimal separator. 

- Character chain too long. 

- Non-unique primary key.

 

At the end of each line of a * .FailedToCheck file, we find 

- Or the column number causing the problem. 

- Either PK if it is a primary key issue

 

Import error: The * .FailedToImport files contain the lines that could not be copied into the database. Import errors relate to foreign key errors.

Each line in the * .FailedToImport file contains the reason for the failure at the end of the line.

 

Have more questions? Submit a request