...
The CSV files for creating prefilled students’ OLAs have to follow a specific format that is illustrated in the Excel spreadsheet template. This template file can be used with most of the spreadsheet softwares, including Excel, LibreOffice and OpenOffice. The file template can be used both by entering new values by hand and by pasting them from other files in bulk, but in the latter case make sure you are only pasting values, to avoid carrying over special formatting.
Keep the headers from the template file in the final CSV, otherwise the data won’t be read correctly!
In the guide file, the headers clarify the validation rules the various fields have to follow in order to be correctly read. By clicking on the columns’ headers, you will see a text explaining the formatting rules that your data should follow. Conditional formatting across columns will help you navigate large files and fix errors, highlighting in red those cells that need adjustments.
...
4. If any changes should be introduced, adjustments need to be made in the CSV file, prior to re-uploading. After making sure that all is correct, click Upload.
5. Wait for the upload process to be completed.
6. Prefilled Online Learning Agreements! Students will receive an email notification to the indicated addresses inviting them to further edit and sign their OLA document on the platform. Erasmus Dashboard users can in the meantime see the OLAs under the status Unsigned.
Common errors and how to fix them
Please make sure to go through the material below to troubleshoot the process before reaching out.
Date
The date in the CSV file must be formatted like this: dd/mm/yyyy. This may cause issues when typing the date in Excel or while editing the CSV, because the software might recognise the input as a date and could format it using your national standard. In countries where this standard uses a different separator, for example, a period, the date may be formatted incorrectly.
To avoid this issue, change the format of the cell from Date to Text.
Please make sure there are no empty spaces in the email address’ cell checking whether there are no extra blank spaces before, in the middle or at the end of the address itself.
Receiving institution
Please make sure that the code is correct and is not missing some parts (for example the digits at the end or the country letters at the beginning). It is also possible that some extra spaces are making the code impossible to read.
Please check if your CSV file upload works using the Erasmus code appearing in our template file before contacting us.
On-Site Feedback Reporting Tool
If you are still having issues with the CSV upload and the support material here doesn’t offer help, please reach out via the on-site feedback tool. But when doing so - help us help you - please outline the steps you took and ideally also attaching screenshots of the error message and anonymised file that you used for the upload. To sum up:
- Describe the actions taken step-step-by step.
- Attach screenshots of the error messages you are seeing.
- Try the upload function with the template file available on this competence centre page.
- Respecting the privacy of the people involved, share the problematic CSV file for further troubleshooting.
...
Scenario 2: Student initiating OLA
...