This page explains how to view and read the error log when logs related to the  import of mobility activities fails and  as well as the most common error log messages.

When importing a file, the system first checks if the file type is right, then it checks if the field format and content are correct and finally it checks against the rules described in the   Erasmus+ Programme Guide.

If the file cannot be processed or the minimum information for creating a draft mobility activity is not present, the file will not be imported. In such cases, the ERROR status is displayed, and it includes a link to more details about the import error. If the import is successful, the status displayed is IMPORTED.Depending on the case, the import log will provide additional details about missing/incorrect information in the mobility activities.

Below are some examples of rules that must be respected. For full information about rules and restrictions please consult the Erasmus+ Programme guide and check the  Data dictionary  for specific field rules in the import files.

• it is not allowed to have multiple organisations (different Organisation ID) with the same OID
• the sending and receiving organisations cannot be the same
• the sending and receiving countries cannot be the same (depending on key action)
• the number of interruption or zero grant days cannot be greater than the duration
• the number of travel days must be   between 0 and 6 or between 0 and 2 respectively (no decimals), depending on whether the indicated means of transportation is sustainable or not (if applicable for the key action)
• the start date cannot be after the the end date
• the start date cannot be before the project start date
• the end date cannot be after the project end date
• the duration of Student mobility activities cannot be greater than 360 days
• the duration of Staff mobility activities cannot be less than 2 days and more than 60 days

Steps

Image Modified

The number of errors of each type is shown next to that category title (1). For each error found in the import file, you will see the column name (2), as well as the affected cells (3) in the file, which you need to correct. The error message will help you understand what to look for (4).

If you have more than 10 errors in a specific category, use the browsing options (number of items per page and navigation arrows) (5) to navigate through the list.

Image Modified

<div class="page-break-ruler"> </div> 

Examples of import errors

Failed import related to file processing

If an incorrect file type (other than CSV or XLS/XLSX is selected to import, an error message appears immediately. The file is not processed imported and the attempted import is not listed in the Import/Export status list, therefore there is no log for this type of error.

Image Modified

The import fails and the ERROR message is displayed in cases such as:

• The file configuration is different from the template configuration

Image Added

• System errors in processing the file

Image Added

Failed import due to validation rule for cell format and content

The import will fail due to validation rules for cell format and content, such as:

1. There are missing mandatory details for creating the draft record in the project:
   Image Added
   
2. Not using the allowed codes in field terms, as specified in the Data dictionary. Mandatory fields are left blank. If the missing value affects a field that is essential for creating the draft record in the project, the error message in the log indicates it - see the example below. :
   Image Added
3. Not respecting the accepted decimal separator or date format.

Image Removed

Failed import due to business rule that has not been respected

The import will fail if a business rule has not been respected. The ERROR message is displayed, and the error message in the import log provides details of the business rule that has not been observedrespected.

For example:

1. It is not allowed to have multiple mobility activities with the same ID.
   Image Added
2. It is not allowed to have multiple organisations (different OIDs from the Organisation Registration system) with the same Organisation ID.
   Image Added
3. The number of travel days must be between 0 and 6 or between 0 and 2 respectively (no decimals), depending on whether the indicated means of transportation is sustainable or not (if applicable for the key action).
4. The duration of Student mobility activities cannot be greater than 360 days.
5. The end date cannot be after the project end date.

Successful import with draft mobility activities

If the file import was successful, the import status is IMPORTED, the mobility activities are imported having the status DRAFT, and the import log shows the required fields or business rules to be respected for the draft mobility activities to become COMPLETE.

Image Removed

For example:

1. When mobility activities completed in the Mobility activities screen are exported and reimported, they are checked automatically against all rules, including business rules that may have been introduced or updated after the mobility activity was completed. In such cases, the reimported mobility activity becomes a draft if it no longer complies with such rules. 
   Image Added
   
2. The values for certain fields are out of range.
   Image Added
   
3. Values required for a complete mobility activity are missing. 

Image Added

<div class="page-break-ruler">&nbsp;</div> 

Related Articles