I am setting up a system that will have synchonizing capabilities between the DNN database and a local office database. I need to be able to export to the local office database, data collected via a CheckBox Group. We can not integrate a Check Box Group to a Dynamic field. The module we are using for synchonizing the databases only works with core fields and the new dynamic fields.

How can we make this work. Can you add a capability to make this work. Such as adding the capability to link up each individual check box in a group to a dynamic field or combine all the checked check boxes into a single delimited string and link that to a dynamic field.

Hi, I might be confused on exactly what you are wanting to do. The information is stored in the database for checkbox groups as a comma delimited field (ie. option1, option2, option3, etc...). You can use Dynamic SQL Events to store the data in any table you wish though if that is an option. I would really have to know more about the "The module we are using for synchronizing the databases...". Which module is this?

You can link up individual checkbox's directly to a DotNetNuke Core Field but I don't believe the option exists for checkbox group because the core fields don't have an option of checkbox group?

I would like to store all data in the core fields or profile fields.

Many Other modules can work with these fields.

If you are storing the data as a comma delimited field then why can't you also provide the capability to link this to a Profile Field and store it there the same way?

The module I was planning on using is DNNMasters User Sync Manager.

If you have a better way please let me know.

Thanks

Hi. We will look at adding this option in the future, honestly though I think this is more than the average user would use or has requested and not sure its the best use for it. Since the option to link Checkbox Group fields to Core Fields is not yet a feature at all though I can't see the harm in storing it as a comma delimited text variable. Again, still a very custom enhancement though but we will review.

You can probably still do this now though with SQL Events. With a SQL Event you can pass the values to any stored procedure and have that stored procedure perform an insert/update (maybe to the extended fields?). You wouldn't have to use a stored procedure, you could perform the insert or update directly within the SQL event but I think passing the values to a stored procedure would be better for your testing etc... This would still take some development to setup the stored procedure etc... Basically within the SQL event you would pass the variables to the stored procedure:

Example, using a stored procedure:
exec sp_savemycheckboxgroup '$(CheckboxGroupFieldShortName)', $(UserID)

This would pass the results of the checkbox group and also the userID to a stored procedure to do any inserting/updating as you wish with the data.

Another example without a stored procedure:
Insert Into YourTable (results, UserID) Values('$(CheckBoxGroupFieldShortNAme)', $(UserID)

etc....

Hope this helps.