Normalizing denormalized content in Data Deploy

sgottlieb

I am trying to take a denormalized content structure and map it to a normalized data schema using DataDeploy.

My content structure looks like:

-Article

---- Cover Section

-------- Item replicant

---- Feature Section

-------- Item replicant

---- Special Section

-------- Item replicant



and my table structure looks like




- Article (master table)

---- Section (child table)

-------- Item (grandchild table)

Where Section is used to hold the all three types of sections and Item is used to hold all the items.

I have almost everything working (after a couple of hacks on my _dd.cfg) but I can seem to get the 3rd level replicant to write to the database.

Has anyone done anything similar to this? Any ideas?


--Seth

Migrateduser

I have almost everything working (after a couple of hacks on my _dd.cfg) but I can seem to get the 3rd level replicant to write to the database.

You can or cannot. If you can't its probably because the row generated by DD for the table has some columns which might be null and you probably created the table with certain columns which cannot be null.
You could set the attribute print-row-map-warnings=yes in the group element to detect this and make sure you remove this attribute once you verify.

<group name="Reviews" table="listtab" root-group="no" print-row-map-warnings="yes">