Hi, I always have problems importing CSV files in Heidi and often have to resort to going to my hosting's CPanel and importing from there. I have a tale with 3 fields: Nr (INT), Lied, Artiest (both VARCHAR) they contain the number, songtitle and artist of thsongs in my radio's repertoire. The latest CSV I tried to import looked like the one attached.
The semicolon at the beginning is there because I simply want the files in the CSV to be appended to the end of the already existing list. Also attached you will find an image of the import settings I use. After clicking "Import" I keep getting an error "Invalid integer in collumn 1 'Nr'", so there must be something wrong with my 1st field in my CSV field.
Could you please help me where I am going wrong?
Thank you so much in advance.