Data Schema

[prabhuk78522504]

Hi Everyone,

               In my production environment, i tried to create a new field using adobe campaign(extend the data in the table using an extension schema)  but at the end return an error message. After that, i came XML edit screen page but all the old XML are invisible.

Please, what should I do for getting all my old XML code?

I am New to Adobe campaign. Please help me and also please explain what purpose we use to edit tab. If i delete my old XML   code it affects database structure.

error When i create new field.png ‏42 KB

AC DataSchema.png ‏129 KB

[florentlb · Accepted solution]

Hello,

It is a best practice to test such modifications in a staging environment before attempting anything direclty in production.

When you extend an existing table with new fields, it is not supposed to change the original schema but to add a new schema with the same name with a different namespace (for example an extension to nms:recipient would be stored in a cus:recipient or kcm:recipient as in your screenshot).

But if you modify a schema I think there is no way to revert what you've done as it updates the database structure.

Have you checked the configuration guilde of the documentation?

Also, you can find an exemple of extension here.

Hope this helps,

Florent