For Message Center can I extend nms:eventHisto table in campaign classic

Question

On Adobe campaign Classic , can i extend the nms:eventHisto table and save additional columns that might be passed by the source system. There is an XML column , but I still want to extract out and place this as a regular column that i could use. Please note that this i want to do on the campaign side and not sure how or will it impact anything with message center.

Thanks

Chez

Marcel_Szimonisz · Accepted Answer

Hello @chez.elamvazhudi,yes you can extend the schema as any other schema. But then you will need to amend the synch workflow to add data to your new column.The change has to be done on execution instance as well as on the control instance. Marcel

Jyoti_Yadav · Answer

Hi @chez.elamvazhudi ,

Yes you can extend the schema.

Or

You can fetch the xml element value from the 'data' field column. Let's assume the xml element you want to fetch is 'phoneNo'. Use query activity on 'nms:eventHisto' table and in 'Add Additional Data' add a column name 'phoneNo1' and use below syntax to define it:

Substring(data, Charindex(data, '<phoneNo =" '), 10);

Thanks,

Jyoti

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded