Copy Phone field data to mobile field

Avatar

Avatar
Validate 10
Level 3
ihm185
Level 3

Likes

24 likes

Total Posts

52 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
ihm185
Level 3

Likes

24 likes

Total Posts

52 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
ihm185
Level 3

30-04-2019

Hello everyone,

we have Adobe campaign v7 classic instance where we have existing recipient records. Till now contact number was added to phone field. We have recently introduced SMS and it is not considering phone field to target SMS deliveries. It requires mobile number field to be populated for the SMS delivery to be sent.

In order to make it work either,

  1. We need all the contact numbers from phone field copied to mobile field
  2. or change SMS delivery targeting from mobile number to phone number.

Please help me how we can do this.

Kind regards,

Imran

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

30-04-2019

Hi,

Update activity will alter the audit fields, @lastmodified, etc, and may miss data if executing concurrent to a data load.

To do a straight atomic copy, use sql script: update nmsrecipient set smobilephone = sphone;

Make sure to update existing ETL's, etc accordingly.

Changing the address mapping also works, though you'd be stealing phone channel's field, making it awkward if that gets installed in the future.

Thanks,
-Jon

Answers (5)

Answers (5)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

01-05-2019

Hi,

Yes, under admin/config/sql scripts. Run button's in the top right.

You can also do it using sql script workflow activity, which will give you error logs.

Thanks,

-Jon

Avatar

Avatar
Validate 10
Level 3
ihm185
Level 3

Likes

24 likes

Total Posts

52 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
ihm185
Level 3

Likes

24 likes

Total Posts

52 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
ihm185
Level 3

02-05-2019

Thank you so much Jon.  I appreciate all your help.

Kind regards,

Imran

Avatar

Avatar
Validate 10
Level 3
ihm185
Level 3

Likes

24 likes

Total Posts

52 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
ihm185
Level 3

Likes

24 likes

Total Posts

52 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
ihm185
Level 3

01-05-2019

Hi Jon,

thank you for replying. Please excuse my ignorance but can we run SQL scripts in an Adobe-hosted instance.

kind regards,

Imran

Avatar

Avatar
Validate 10
Level 3
ihm185
Level 3

Likes

24 likes

Total Posts

52 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
ihm185
Level 3

Likes

24 likes

Total Posts

52 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
ihm185
Level 3

30-04-2019

Thank you for replying. I really appreciate your help.

Avatar

Avatar
Springboard
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct reply

53 solutions
Top badges earned
Springboard
Establish
Give Back 25
Give Back 10
Give Back 5
View profile

Avatar
Springboard
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct reply

53 solutions
Top badges earned
Springboard
Establish
Give Back 25
Give Back 10
Give Back 5
View profile
Venu_Reddy
MVP

30-04-2019

Hello ihm185​,

You can copy the phone field data to mobile field using update activity and make sure both fields are of same data type.

Regards,

Venu