Welcome

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Include PageRoot Watch wiki buttonRoot Watch wiki button

Anchor
TOP
TOP

Include Page

CP

Root Script

CP

Root Script
Include Page
Pop up Limitations for Mobility Activity Import and Export for KA151, KA152, KA153 and KA154
Pop up Limitations for Mobility Activity Import and Export for KA151, KA152, KA153 and KA154

Include Page
Root Watch wiki button
Root Watch wiki button

Table of Contents
styledisc

Include Page
Illustrations provided for consultation only...
Illustrations provided for consultation only...

What is the topic about?

This page gives an overview of the process for importing and exporting mobility activities in beneficiary projects.  The Import-Export functionality is available for:

  • Erasmus+, Call year 2021 onward
    • KA121 - Accredited projects for mobility of learners and staff in school education, vocational education and training, and adult education
    • KA122 - Mobility for learners and staff in school education, vocational education and training, and adult education
    • KA131-HED - Mobility of higher education students and staff
    Erasmus+, Call year 2022
    • supported by internal policy funds
    • KA151-YOU
    • KA121 - Accredited projects for mobility of learners and staff in school education, vocational education and training, and adult educationyouth mobility 
    • KA152-YOU - Mobility of young people 
    • KA153-YOU - Mobility of youth workers 
    • KA154-YOU - Youth participation activities 
  • Erasmus+, Call year 2022 onward
    • KA122 - Mobility for learners and staff in school education, vocational education and training, and adult education
    • KA131-HED - Mobility of higher education students and staff
    • KA171-HED - Mobility of higher education students and staff supported by external policy funds funds


Excerpt

For a quick overview of import and export of the mobility activity export and import activities in Beneficiary module, please view the eLearning videos "Introduction to export and import of mobility activities" and "How to export a list of mobility activities using an XLS file".

Excerpt IncludeActivities in KA1 Youth mobility projectsActivities in KA1 Youth mobility projectsnopaneltrue

the eLearning video. 

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

Import and Export of mobility activities


The bulk import and export of mobility activity data is done in the Import-export mobility activity

 section

section of the mobility project.

When importing or exporting the

bulk

list of mobility activities for a project, the file extension options available for download are CSV and

XLS/

XLSX. Both draft and/or complete mobility details can be used when importing or exporting. If there are no mobility activities in the project, the empty

file   to  XLS

Image Added

Info
titleInformation
typegeneric

It is advisable to  export the latest file after each IT release  to ensure that any changes (e.g. added or removed fields) are also reflected in the file you intend to import.

Image Removed

After the export it is possible

to  

in the specific fields and columns in the file. See Edit the mobility activity import file for details. Use

the  for guidance on how to update the file

and Mobility Import-Export templates for details on the data relevant for your project including formatting specifics.

To avoid errors when importing, please adhere to the layout of the CSV or

XLS

XLSX templates. If the import does not succeed, an ERROR status is displayed and an import error log is available to view

in certain cases

.

 The

The error log allows the user to understand the fields that need to be corrected in the import file for the import to be successful.

The import error log allows the beneficiary user to locate the lines or cells with incorrect values in the imported file. These need to be corrected before the file can be re-imported successfully. See View mobility activity import error logs for details. 

Image Modified

The Unique Mobility Activity ID

Each mobility

 

activity in the project must have a unique identification code, the

 

Mobility Activity ID.

Excerpt Include
Mobility Activity ID
Mobility Activity ID
nopaneltrue

This is an alphanumeric field in the import file and must be filled

in

by the beneficiary when using the import-export functionality.


Image Modified

Note

When importing a file with duplicated Mobility Activity IDs, the import will fail.

Be careful when importing mobility activities: using

the same

an existing Mobility Activity ID for a different mobility activity will result in overwriting the original mobility activity data in your project.

Image Modified

Updating

Mobility activity

Mobility activity details

If there is a need to update mobility details, for example the contact details, this can be done using the import functionality. First update the details in the spreadsheet and then import it into the project

in the Erasmus+ and European Solidarity Corps platform

.

Image Modified

The organisation and its associated Organisation ID, OID and ECHE code

Excerpt Include
OID
OID
nopaneltrue

Excerpt Include
Organisation ID and OID in projects
Organisation ID and OID in projects
nopaneltrue

Each organisation in the project has an assigned Organisation ID, an associated OID and, if applicable, an Erasmus  ECHE  code for Higher Education.   Each of the these identifiers must be associated correctly, can be updated in the spreadsheet, and imported back into the beneficiary project.  Excerpt IncludeOIDOIDnopaneltrue

The  Organisation ID  is alphanumeric, if auto-generated (for example 123456-ORG-00001), but can be overwritten via the imported file.

Warninginfo
titleOrganisation ID and OID:
typegeneric

Do not confuse the Organisation ID in the import-export file with the Organisation ID retrieved from the Organisation Registration system. In beneficiary projects only, the Organisation ID refers to the organisation identifier auto-generated within a given project and can differ from one project to another for the same organisation. The Organisation ID retrieved from the Organisation Registration system (i.e. the unique organisation identifier) is referred to as OID and is unique for the same organisation across all projects.

It is not possible to have multiple organisations with different Organisation IDs associated to the same OID. It is also not possible to have the same Organisation ID associated with different OIDs. Both scenarios will result in an error.

When adding a new mobility activity, the Organisation ID for the sending and receiving organisations as well as the Mobility Activity ID are checked. A new Mobility Activity ID creates a new mobility activity in the project and similarly a new Organisation ID creates a new organisation in the project as long as the associated OID is also unique for that project.

The ECHE accreditation is required for all higher education institutions from Programme Countries acting as sending organisations, as well as for those from Programme Countries acting as receiving organisations for activities of type HE-SMS (Student mobility for studies) and HE-STA (Staff mobility for teaching).

For higher education institutions holding an ECHE code, it is suggested to use the ECHE Code as the identifier in the Sending Organisation ID and Receiving Organisation ID fields.

You can download the latest list of higher education institutions holding an ECHE.

Image Modified

View the mobility activity list in the project

Beneficiaries can consult the list of imported mobility activities in the

 

Mobility activities

 

section of their project. Key details are provided in the list view for each entry. 

Beneficiaries can delete a mobility activity from the list, but cannot view nor edit the full details in the Erasmus+ and European Solidarity Corps platform. Any update to a mobility activity must be done by updating and re-importing the relevant XLS or CSV file.

Image Modified

Check imported data

After importing the file, export it again to consult and verify the complete mobility activity information, in particular the calculation of partial grants and unit costs for each mobility activity based on the imported information.

    
Include Page
Top of page include
Top of page include
HTML
<div class="page-break-ruler">&nbsp;</div> 

How to do this in the tools?

Children Display
depth2