Common errors when uploading a CSV OLA

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 (i.e. as dd.mm.yyyy).

To avoid this issue, change the format of the cell from Date to Text.

Email

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. As an example, "name.last@email.com " will raise an error, while "name.last@email.com" won't.

Errors with the institution

You may see this error referring to either the Sending or Receiving institution.

Please make sure that the Erasmus 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. 

Sending institution not using the Dashboard

If you see an error saying that the sending institution is not using the Dashboard to connect to the EWP, it means that you have yet to activate the OLA API in the EWP settings page. Here you can find a guide on how to set up the connection to the EWP connection for OLAs.

Receiving institution not using the EWP

If you see an error saying that the receiving institution is not connected to the EWP, it means that your partner has yet to activate the OLA API. This might be due to an array of factors, so we suggest waiting a bit to give them the time to connect, or alternatively reach out to them to understand when they plan to actually connect.

Invalid column name

This is most likely due to the fact that you tried adding a new column or removing an existing one from the base template. Alternatively, this could happen if the headers row (with the names of each column) has been removed altogether.