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

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

Live Content v1.6.1 :: Web 2.0

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

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.

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.

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.

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

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!

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

Document Exchange 5

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.

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   |   Thursday, January 08, 2009   
Data Springs Product Forums...
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
Subject: Can I control the profile visibility from a Dynamic Registration form?
Prev Next
You are not authorized to post a reply.

Author Messages
Gary
Posts:4
skipping stones
skipping stones
04/07/2008 5:16 PM  

I am using DNNFusion's MyProfile social networking module, and it has an option to display information from the DNN core profile.

In order for it to work, the visibility of the Profile Properties we want to show need to be "Public."

How can I control this visibility through Dynamic Registration (or work around it somehow)?
Chad
Posts:2385
river guide
river guide
04/09/2008 2:00 PM  
Hi. Well there is no direct built in functionality to allow the user to specify if their property is to be visible etc... There are work arounds or things you could do though.

First, if you want to have them choose if a field is visible you can create a checkbox or any other field type and create a SQL Completion Event. So for example lets say that there is a field called 'Company Name' which you have added under Admin, User Accounts, Manage Profile Properties. Lets assume this property definition ID is 500. Then you could setup a SQL Completion Event so that if they check the box it would make it visible such as using this query:

Update UserProfile
Set Visibility = 2 where UserID = $(UserID) and PropertyDefinitionID = 500

Similar examples could be setup for each checkbox they wanted to enable/disable with similar queries. I think setting the visibility to 2 though would do it. Another query/example might set ALL fields to visible for ALL users such as this:

Update UserProfile
Set Visibility = 2

Or... A 3rd example would just set all profile properties visible for that specific user:

Update UserProfile
Set Visibility = 2 where UserID = $(UserID)

So you can either set it visible for one specific field, one specific user... Or you could set it visible for all fields and all users, etc...

Does this help? You can have SQL events fire either for 'Any Field Response' or you can have them fired based on a fields condition (such as the user checking a box, or selecting a certain item from a dropdownlist field etc...)


Hope this helps!

-Chad


Chad
Posts:2385
river guide
river guide
04/09/2008 9:01 PM  
Hi. I wanted to follow up this since I was working on this earlier... I found that the visibility actually needs to be set to:

0 - Public
1 - Members Only
2 - Admin Only (default)

So, in the above queries where we are setting Visiblity = 2 it should actually be 0 or 1.

So....

Update UserProfile
Set Visibility = 0 where UserID = $(UserID)

Or to initially set all existing users to have all profile fields public:

Update UserProfile
Set Visibility = 0



-Chad


Chad
Posts:2385
river guide
river guide
04/09/2008 9:11 PM  
Ok... A few more notes on this....

1. This is only going to set the properties that you have 'linked' to the core profile fields. You link fields under each questions 'Advanced Fields Settings' for the 'DNN Core Field'. Additionally, if the field is blank or empty it will not get updated properly. So if you leave 'Zip Code' blank, if the user never enters a zip code then they will never have a row within the UserProfile table and therefore the update statement will not be able to update their visibility correctly.

2. You can easily test to see if a users visibility is set properly. To do this you need to temporarily change the 'User Page' back to none so that the standard DNN User Accounts / Manage Profile page is displayed and then pull up a user and click on 'Manage Profile'. This should then display the visibility flag for the user.


So.... This appears to be working on your site now. First I executed a query to simply affect existing users:

Update UserProfile
Set Visiblity =0

and now that this visibility should affect all existing users I am adding a SQL completion event below to just affect the current user when they register or update their profile:

Update UserProfile
Set Visibility = 0 where UserID = $(UserID)


This should do it!

-Chad
C
Posts:2
new to the springs
new to the springs
05/04/2008 5:42 PM  
Hi Chad,
Have you actually implemented this method successfully?

We cannot get it to work.
Running the SQL query from Host->SQL (with run as script checked) results in an error with this pasted in the box:

Update UserProfile
Set Visiblity =0

Adding the following as an SQL completion event (as mentioned) doesn't seem to do anything.

Update UserProfile
Set Visibility = 0 where UserID = $(UserID)

Please advise.
Thank you
Chad
Posts:2385
river guide
river guide
05/06/2008 9:22 AM  

This is probably because your site is using an object qualifier. If you go to Host, SQL and execute the following query what is returned?

Select top 10 * from sysobjects where name like '%UserProfile%'

If it returns table names such as dnn_userprofile then this means that your site uses object qualifier of dnn_ and that you need to reference it within any queries.

For example (if your object qualifier was dnn_):

Update dnn_UserProfile
Set Visiblity =0


-Chad
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration > Can I control the profile visibility from a Dynamic Registration form?


ActiveForums 3.7

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