How to map multiple values in a dcr field to different rows in table?

Hi All,

I am using Standalone method to deploy my dcr content to table.

Some fields of my dct are multiple select (more than one value can be selected) so when it updates table then it sends comma seperated values under one row.

Though my requirement is that there should be multiple rows in the table each representing one value out of the total values selected for one field in the dct.

Please suggest me the way to accomplish this.

________________
Thanks,
Retesh
OD 6.1 @ UNIX

Find more posts tagged with

Comments

retesh

Hi All,

I am using Standalone method to deploy my dcr content to table.

Some fields of my dct are multiple select (more than one value can be selected) so when it updates table then it sends comma seperated values under one row.

Though my requirement is that there should be multiple rows in the table each representing one value out of the total values selected for one field in the dct.

Please suggest me the way to accomplish this.

________________
Thanks,
Retesh
OD 6.1 @ UNIX

Hi All,

I have read Database Deployment admin pdf but couldn't figure out a way to pass multiple values selected for one dct field to multiple rows in the table.

What happens is that in case of multiple selected values, comma seperated values are passed in single row of the table. Which shouldn't be the case.

If feel there has to be some provision with OD 6.1 to tackle multiple select values in dct. But currently I dont know how??

If somebody has gone thru the similar situation or know how to implement this then please help me.

-Thanks,
Retesh

Adam Stoller

Hi All,

I have read Database Deployment admin pdf but couldn't figure out a way to pass multiple values selected for one dct field to multiple rows in the table.

What happens is that in case of multiple selected values, comma seperated values are passed in single row of the table. Which shouldn't be the case.

If feel there has to be some provision with OD 6.1 to tackle multiple select values in dct. But currently I dont know how??

If somebody has gone thru the similar situation or know how to implement this then please help me.

-Thanks,
Retesh

I think you would need to develop your own tuple preprocessor to do what you desire - either that, or write the entire data deployment process yourself (Perl DBI or Java equivalent) so that you have full control (and full responsibility) for making everything work.

kajjubee

Look at page 140 of the ddadmin guide. It has been clearly explained with an example.

K

retesh

Look at page 140 of the ddadmin guide. It has been clearly explained with an example.

K

Hi,
I had already gone thru Deploying Replicants section of Advanced Features chapter of ddadmin guide (page: 136 - 140)

I had executed the entire example end to end. But it didn't work. It is making another table (reviewers) but in that table also multiple values are going into a single row (R1,R2,R3,R4)

I have tried giving value in dct thru select field and text field respectively but it did not change the output.

In logs I get this => DBD: TUPLE={IWOV_PROC_FLAG=true, state=Original, Polls/0/ISBN/0=select1, Polls/0/Author/0=select1, Polls/0=, Polls/0/Price/0=25.63, Polls/0/Title/0=select1, path=./select1, Polls/0/Reviewers/0=R1, R2, R3, R4}

Which means that it is not using Reviewer[0-4], perhaps it is writing values into the first cell, which is denoted by 0. Correct me if I am wrong!!

If anybody has implemented this successfully then please guide me the way to achieve this.

-Thanks,
Retesh

kajjubee

Post your dd config file and I can take a look.

K

retesh

Multiple values are now going to different rows as I intended.

I have debugged the log file and then came to know that path of list-field attribute was not correct. I have to give it like this: list-field="Polls/0/Reviewers/0"

-Thanks,
Retesh