Hey Guys, Doing an import for Customers and Contacts, but am getting an error on the phone numbers with Extentions. Anyone familiar with what the format should be for CSV imports?

can you give an example? I've never had much problem unless the extension info was too long.

It may be because of the length, due to personal info I replaced the numbers with x's. xxx-xxx-xxxx ext xxxx. error message was The field phone contained more than the maximum number ( 22 ) of characters allowed. Should I just take the spaces out?

youre example is less than 22 characters...

This is why I am confused as to why it failed. I don't see any additional spaces at the end of the string.

maybe try using

clean (cell reference you want cleaned)

to see if it removes hidden characters

interesting, when I used the len function it returned 21 on the cell in question, when I used the clean function and used the len function on that new cell it also returned 21.

I've seen NetSuite do character limit checks both before and after they put their formatting on phone numbers, depending on the context - my guess is they're doing the check after in this case, so your

xxx-xxx-xxxx ext xxxx

turns into

(xxx) xxx-xxxx ext xxxx

which is indeed over the limit. When I've run into this error in the past, I usually swap

ext

(or variations on that) with a simple

x

immediately before the extension's digits, that should be enough to get you up to a 6 digit extension before hitting the character limit.

@MTNathan Thank you, I believe that is the case! I also checked, my preference for phone number format is set to have the (xxx) xxx-xxxx formatting, so it must be adding those characters during load. I changed 'ext' to an 'x' and it loaded fine! Thank you!