I need to bulk import phone numbers into a E164 phone field

frankh_ · ‎06-16-2016

I am attempting to upload phone numbers in bulk to an E-164 formatted phone number. All of them are North America phone numbers and they are stored in two text cells - the first one is the area code with just 3 digits: ZZZ the second field is the number XXX-YYYY. I don't know how to work with E164 phone number fields - how can I force it to North America and load all of these in to the phone number fields correctly for the US (all are US numbers)?

I have a transform script already built for other data that I need to operate on - but the E164 phone field is a mystery to me.

frankh_ · ‎06-16-2016

Pradeep - thank you, the answer was ridiculously simple once I saw it - all I needed to do was add '+1' to the front of the phone number and it came straight in as a US phone number (I have strict checking turned off). Essentially the code worked like this:

target.phone = '+1' + source.u_area_code + ' ' + source.u_7digitNumber;

View solution in original post

Pradeep Sharma · ‎06-16-2016

Awesome

Glad you got it resolved.