Skip to main content

Name and character set validation fixes

Fix name and company field problems caused by unsupported characters or incorrect use of uppercase and lowercase letters.

Written by Gemma Langley

These occur when first names, company names or related text fields include unsupported characters, incorrect casing or symbols outside the allowed character set, which may happen when data is copied from external systems or entered manually.


Customer upload fix: First name

Error message - Firstname must contain only: upper case letters (A‑Z), numbers (0‑9), full stop (.), comma (,), forward slash (/), dash (-), ampersand (&) and space.

The Firstname field can only include the following characters:

  • Uppercase letters A–Z

  • Numbers 0–9

  • Full stop .

  • Comma ,

  • Forward slash /

  • Dash -

  • Ampersand &

  • Space

All rows before this one were imported successfully, so check the Customer.FirstName field in column B and remove any characters that aren’t on the allowed list.

📌Note: Although the ampersand (&) is listed as an acceptable character, it is not currently supported for this field. Please delete any ampersands.


Customer upload fix: Company name

Error message - Company name must contain only: upper case letters (A‑Z), numbers (0‑9), full stop (.), apostrophe ('), comma (,), forward slash (/), dash (-), round brackets ( ), question mark (?), quotation mark ("), ampersand (&) and space.

Company name must contain only: upper case letters (A-Z), numbers (0-9), full stop (.), apostrophe ('), comma (,), forward slash (/), dash (-), round brackets ( () ), question mark (?), quotation mark ("), Ampersand (&) and space . All previous rows were imported successfully. Please clear the previous rows in the file, fix the error and try again.

Remove any punctuation not listed from the Customer.CompanyName field column D.

Did this answer your question?