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,
Please help me how we can do this.
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.
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.
Thank you so much Jon. I appreciate all your help.
thank you for replying. Please excuse my ignorance but can we run SQL scripts in an Adobe-hosted instance.
Thank you for replying. I really appreciate your help.