Datadeploy of non-replicant comma separated

Bubas_IWOV

Hi,

Can somebody help me to deploy non-replicant comma separated values to a db?

Scenario:

my item, returns as values - dk,se,nl and i need to deploy them in different rows and at the moment everything is coming on the same one.

Thanks for the help
Bruno

Michael

Hi Bruno

On page 127 of the DD 5.6 PDF manual it has the following which may be of assistance:

Deploying Comma Separated Lists of Values as Replicants
Multiple values entered into a field of a data capture form are often stored in the resulting DCR as a comma separated list of values rather than as separate item elements within a replicant item. The comma separated lists can be from a replicant or a non-replicant field and the values in such lists can be deployed as replicant values. That is, those values can be deployed into multiple rows in a table rather than into a single row. This is accomplished by using the list-field and list-to-replicant attributes of the column element in a database schema definition. When these two attributes are present, DataDeploy processes the data before the actual deployment takes place and expands the list of values.

hth

Cheers
Michael