Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Note
titleTry the default file first!
Please always check if you can upload our template file before contacting us. If that upload fails as well, remember to mention it when reporting the issue. You can find the template on the Creating OLA page

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.

Error 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. 

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.