Recently Viewed...
To help you navigate to pages you most recently visited, select from the links below.
Product Forums
Sharepoint Forums
Newsletter
Dynamic Forms Demonstrations
Page Tags
DNN Modules
SnowCovered Top Sellers

Events Calendar and Registration 2.2.7

One stop solution for events calendar and events registration! Demo site available for free trial.

Opt In Email 4.0

'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

XMod 5.1

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.

Ultra Video Gallery 2.4

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.

Active Forums

The award winning discussion forum and community solution for DotNetNuke is now even better. When you need to build the best community site, you need the best module, Active Forums!

Open-DocumentLibrary v3.0

Powerful, Ajax Enabled, Easy to Use. Document Management has never been better. Open-DocumentLibrary allows DotNetNuke users to share and manage documents in a flexible, intelligent way, offering granular control over Folder and Document access.

Gloss // ALL COLORS! skin // XML Flash // W3C CSS XHTML1.0

Gloss is the first ALL COLORS! skin, featuring a powerful XML-based flash and being 100% W3C CSS XHMTL1.0 compliant. Tune it yourself on the fly, changing colors, backgrounds, containers, text color and size, width and more! Brilliant!Available for DNN4 and DNN5

Minimalist by Evan O'Neil - ALL NEW !

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 . . .

Ultra Flash Player 6.1(16-in-1)

A 16-in-1 dnn module.Powerful yet easy to use. Capable of producing a multitude of functions including:Image rotator/Numeric rotator/ Mp3 player/Wmv player/ Flash video player /YouTube video player/Multimedia player / Text-to-speech podcast / Flipping book player/Banner topic player/Silverlight albu

Ultra Media Gallery 5.4

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.
    |   Register   |   Friday, January 09, 2009   
Data Springs Product Forums...
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
Subject: Update DNN / Dynamic Field
Prev Next
You are not authorized to post a reply.

Author Messages
Eric
Posts:27
going with the flow
going with the flow
01/23/2008 1:16 PM  

Hi,
Just upgraded from v2.4 to v3, and have the reg form linked to some of the DNN profile fields.

There was a bug in v2.4 that prevented one of the DNN fields to be properly linked, so the entry in DNN profile is blank. But v2.4 also had an "Update DNN / Dynamic Field" function.

Now with v3, I can link the field properly to DNN, but can't find the "Update DNN / Dynamic Field" function.

What I want to do is update the DNN profile field with the value from the corresponding Dynamic Reg field.
Chad
Posts:2388
river guide
river guide
01/23/2008 2:10 PM  
This is now handled on the Dynamic Question level directly under each question in the 'Advanced Field Options' area.
Eric
Posts:27
going with the flow
going with the flow
01/23/2008 3:06 PM  
I can see how to link them - what I'm trying to do is update ALL of the existing site registrations with this newly linked field. There are thousands of users who have data missing for one of the DNN profile fields that needs to come from the Dynamic Reg module.

Is a mass-update like this possible?
Chad
Posts:2388
river guide
river guide
01/23/2008 5:49 PM  
Oh... Well there is no 'Mass' update from the previous way of linking to the new way of linking but... assuming they were linked before if you go in and reconnect the linking the users data will not be lost.

For example, before under DNN Core Integrationtion if you linked 'Postal Code' dynamic field to the 'PostalCode' core field and a user updated their information it was saved in the DynamicRegistration_QuestionResponse table and also in the core userprofile table. Therefore, when you go into the advanced field options in 3.0 (and beyond) and make that connection the users data should begin appearing correctly.

Does this make since? If you never did link the field you would have to run some mass update SQL Queries to pre-fill all of the DynamicQuestion_QuestionResponse into the UserProfile table.

-Chad
Eric
Posts:27
going with the flow
going with the flow
01/23/2008 5:59 PM  
Yeah, figured as much.

Was just hoping for a shortcut.

And also wishing I didn't upgrade a few dozen sites to DNN v4.8 .

Thanks Chad.
Chad
Posts:2388
river guide
river guide
01/30/2008 2:52 PM  

Eric,

 

I wanted to let you know that a customer has recently posted a solution that will handle this process with a single SQL Script instead of having to change those core integration settings manually.

 

You can view the solution here

 

Thanks,

 

Chad

 
Andrew
Posts:4
skipping stones
skipping stones
01/30/2008 3:27 PM  

Chad,

 

I saw this topic before I posted my SQL script. I didn't post it here because I think Eric had a slightly different issue. I just needed to re-create the mappings. It sounds like Eric added a new mapping and wants to copy existing question responses to that mapping after the fact.

 

Now that the ProfilePropertyDefinitionID is in the DynamicRegistration_Question.ProfPropId field, it's fairly straightfoward. You need to query the DynamicRegistration question responses and insert them into the UserProfile table. Here's the SQL:

 

insert into {databaseOwner}[{objectQualifier}UserProfile]
(UserID, PropertyDefinitionId, PropertyValue, Visibility, LastUpdatedDate)
select
 qr.UserId as UserId,
 cast(q.ProfPropId as int) as PropertyDefinitionID,
 qr.Response as PropertyValue,
 0 as Visibility,
 getdate() as LastUpdateDate
from {databaseOwner}[{objectQualifier}DynamicRegistration_Question] q
inner join {databaseOwner}[{objectQualifier}DynamicRegistration_QuestionResponse] qr on q.DynamicQuestionID = qr.DynamicQuestionID
inner join {databaseOwner}[{objectQualifier}ProfilePropertyDefinition] pd on cast(pd.PropertyDefinitionID as nvarchar(20)) = q.ProfPropId
left join {databaseOwner}[{objectQualifier}UserProfile] up on up.UserId = qr.UserId and up.PropertyDefinitionID = pd.PropertyDefinitionID
where up.UserId is null
and isnumeric(q.ProfPropId) = 1

 

Cheers!

-Drew
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration > Update DNN / Dynamic Field


ActiveForums 3.7

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