Copy Phone field data to mobile field | Community
Skip to main content
I
ihm185
Level 3
April 30, 2019
Solved

Copy Phone field data to mobile field

  • April 30, 2019
  • 6 replies
  • 4641 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jonathon_wodnicki

    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

    6 replies

    Venu_Reddy
    Venu_Reddy
    Level 6
    April 30, 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

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    April 30, 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
      I
      ihm185Author
      Level 3
      May 1, 2019

      Thank you for replying. I really appreciate your help.

      I
      ihm185Author
      Level 3
      May 1, 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

      Jonathon_wodnicki
      Community Advisor
      Jonathon_wodnickiCommunity Advisor
      Community Advisor
      May 1, 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

        I
        ihm185Author
        Level 3
        May 3, 2019

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

        Kind regards,

        Imran

        Terms & ConditionsAccessibility statement

        Loading footer...