You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Try 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

Email format

Whenever you are typing an email address, particularly in the CSV to upload, please do not use any capital letters (i.e. use name.last@email.eu rather than Name.Last@email.eu or NAME.LAST@EMAIL.EU)

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.



Headers row

When uploading CSV files, you need to keep the first row of the template, the so called headers row, the one with "Name", "Last name" etc.

Do not remove this first row.

  • No labels