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

Compare with Current View Page History

« Previous Version 2 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

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.

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. 

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.




  • No labels