Placeholder

Customer Forum

Import warning "Newlines are not allowed"

Jasmine Posted: 2017-04-26 11:34

Hello,

I am importing Person records and keep receiving this warning message:

Bad value ' first name.surname@test.org' for 'Email' on 'Person': Newlines are not allowed

I have done many imports in the past and cannot work out what the problem is. I am importing from a Mac, not sure if this is the issue... but it seems to be importing everything else apart from the persons email address.

Many thanks,

Jasmine

Sam (Workbooks Online) Posted: Fri, 28.04.2017 - 21:00

Hi Jasmine,

Sorry to hear that you are having issues with your import.

A bad value normally refers to a problem within the data.

Looking at the import it would appear that in the column for email there is a space before the email address, as a space isn't a valid character for an email Workbooks will not recognise it as a valid email address,which is preventing it from being imported.

Please let me know if this is the case, if so removing the space from the email address should hopefully resolve the issue.

I look forward to hearing from you.

Kind regards,

Sam