Recently Viewed...
DNN Modules
SnowCovered Top Sellers

The Catalyst skins are professionally designed, coded and packaged by a team of DotNetNuke experts. The skins are available in 12 great colours. This skin is easily customisable with our unique DrNuke EasyMod technology. Try our demo!

Version 5 of the perennial best-selling tool for creating data-based solutions in DNN without custom programming. This version focuses on greater flexibility, expandability, and ease-of-use.

Live Content uses Web 2.0 approach to provide a Rich User Interface and streamlines content presentation by overlaying content on current page. Overlay images, videos, audio, text/html content, flash, dotnetnuke modules, and external content. Experience the demo...

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

In this day and age, knowing as much detailed information as possible about your customer, prospect or web site user is essential. Thankfully, the new 'Dynamics Forms' module from Data Springs, makes it easier than ever to segment your data collection efforts.

Capture your users attention, enrich your site with multimedia flash, and create and opt in distribution list for your DNN site. These are just a few of the many features the Data Springs Module Collection can provide you.

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.

Edit documents directly on your server. The premier document management solution for DotNetNuke (DNN). Index contents of documents. Share documents across your portal and avoid duplicates. Revised and flexible UI. Extensible architecture.

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

    |   Register   |   Thursday, November 20, 2008   
Data Springs Product Forums...
Subject: DNN Core Integration
Prev Next
You are not authorized to post a reply.

Author Messages
Rut
Posts:22
going with the flow
going with the flow

03/26/2007 7:37 PM  

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.

Rut
Posts:22
going with the flow
going with the flow

04/01/2007 3:13 PM  
Could someone from DataSprings please provide an answer here.
Chad
Posts:2207
river guide
river guide

04/03/2007 8:18 AM  
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?





Rut
Posts:22
going with the flow
going with the flow

04/03/2007 8:42 AM  

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

 

 

Chad
Posts:2207
river guide
river guide

04/03/2007 10:12 AM  
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 peform 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 procdure:

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.


Chris
Posts:50
river guide
river guide

04/06/2007 7:02 AM  
We are researching this option as well, but it is for more than just dynamic users. I think this is a function that is best fit with sometype of backup/restore module or synchronization. We currently use a backup module and are researching a way for it to work utilizing that by automatically restoring it. If you need realtime synchronization and are running SQL 2005 Enterprise you can use web synch. within SQL.

I think this is a needed function, but not just for this module because there are groups that need more than just specific pieces of a module synchroinzed. If we find a solution, we will share it with you.

Glad to see that others have a similar need.
You are not authorized to post a reply.



ActiveForums 3.7

Copyright 2005 - 2008 by Data Springs, Inc.
Terms Of Use | Privacy Statement