Execution Error when importing file

an empty line at the end of the csv file?

Afraid not! Did double check that first, even with just 7 lines on the CSV it returns with:

7 records updated successfully
1 rows were not imported due to error

header? can you show csv (with no PII of course)

Hi Daniel,

Yes it must be the header row which is throwing as an error as said by Dmytro Chupylka. You no need to worry much about that. 

hi Ramya Katram
i'm asking for a file (with PII cleared out)  to confirm the reason

Hi do you have a recommendation on how to host the file as the club doesn't seem to do direct uploads? The CSV copy/paste is simply:

HH ID Prefix,ID,Email Address,First Name,Last Name,Mobile,Primary Address Street,Primary Address Town/City,Primary Address County,Primary Address Postcode,Primary Address Country,Business Type,Primary Source,Secondary Source,Service Type,Description,Visitor ID
HH607,8428299c-7bfc-11eb-9dbb-00163e195c39,test@test.com,Test,MergeTest1337,54654654,123 strett,London,street,b97 3er,uk,Private,Outbound - Book an appointment,Branch Signage,Live In Ongoing,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fdgfdgd
HH609,99b881e0-7c28-11eb-a38f-00163e195c39,test@test.com,Test1,MergeTest2345,54654654,123 street,bolton,china,nn2 1hl,uk,CHC / NHS / CCG / Hospice,Outbound - Book an appointment,Bright Horizons,Hourly Respite,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fdgfdgd
HH610,15182174-7ff3-11eb-a541-00163e195c39,test@test.com,Test2,Test234,54654654,123 street,bolton,china,nn2 1hl,uk,Charity,Outbound - Call me back now,Branch Signage,Hourly Ongoing,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fgfdgd

Hi do you have a recommendation on how to host the file as the club doesn't seem to do direct uploads? The CSV copy/paste is simply:

HH ID Prefix,ID,Email Address,First Name,Last Name,Mobile,Primary Address Street,Primary Address Town/City,Primary Address County,Primary Address Postcode,Primary Address Country,Business Type,Primary Source,Secondary Source,Service Type,Description,Visitor ID
HH607,8428299c-7bfc-11eb-9dbb-00163e195c39,test@test.com,Test,MergeTest1337,54654654,123 strett,London,street,b97 3er,uk,Private,Outbound - Book an appointment,Branch Signage,Live In Ongoing,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fdgfdgd
HH609,99b881e0-7c28-11eb-a38f-00163e195c39,test@test.com,Test1,MergeTest2345,54654654,123 street,bolton,china,nn2 1hl,uk,CHC / NHS / CCG / Hospice,Outbound - Book an appointment,Bright Horizons,Hourly Respite,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fdgfdgd
HH610,15182174-7ff3-11eb-a541-00163e195c39,test@test.com,Test2,Test234,54654654,123 street,bolton,china,nn2 1hl,uk,Charity,Outbound - Call me back now,Branch Signage,Hourly Ongoing,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fgfdgd

Strangely enough, removing the 3rd record (4th row) the error disappears... 

No line feed at the end, try to add it

Apologises for the delay, same issue. That 3rd row just seems to break it...

as an option - you may try to switch 3rd row with e.g. the 2nd row.
If it won't help  - the problem could be in the data of the 3rd row -changing values column by column setting them equal to "good" row 2 - and you probably find the value that causes the issue.
I would also add quotes to the values

Daniel Hill said:

Hi do you have a recommendation on how to host the file as the club doesn't seem to do direct uploads? The CSV copy/paste is simply:

Daniel Hill - Just to let you know for future reference, you can upload files to Club in your replies in the Insert menu:

Please send me a message if you're having any issues using this!

Interesting nothing seems to be consistent with this error. It's very odd, removing line 3 still works but even when manually typing reinserting 3 causes the issue.