Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Profile Info - Where is it?Profile Info - Where is it?
Previous
 
Next
New Post
7/19/2006 10:26 AM
 
Jeremy Fine

Joined: 6/20/2006
Posts: 17
I need to grab data from user profiles such as telephone # and IM. It seems from reading the forums that there isn't any straightforward way of doing this. Am I missing something? Any help at all would be appreciated.
 
New Post
7/19/2006 12:03 PM
 
Jeremy Fine

Joined: 6/20/2006
Posts: 17
Ok I can get to this point:

http://img113.imageshack.us/img113/9281/sqltableca1.jpg

By using the this:

SELECT PropertyName, PropertyValue, UserID FROM ProfilePropertyDefinition INNER JOIN UserProfile ON ProfilePropertyDefinition.PropertyDefinitionID = UserProfile.PropertyDefinitionID

Now I guess its just a matter of using SQL to group the items by UserID and turn those groups on their side, stacking one on top of the other. I hope this isn't too hard. I've never used SQL before today and I'm knee deep in online tutorials. Still any help would be very much appreciated - especially a link to a particularly good SQL tutorial.

Wish me luck!
 
New Post
7/19/2006 2:49 PM
 
Johannes Dolberg

Joined: 2/26/2006
Posts: 19
I am looking into this stuff as well. More specifically I'm trying to log on a user programmatically. Anyways...
Try something like:
DotNetNuke.Entities.Users.UserController userCont = new DotNetNuke.Entities.Users.UserController();
DotNetNuke.Entities.Users.UserInfo userInfo = userCont.FillUserInfo(PortalId, "admin");          
the fiddle around with the userInfo.Profile e.g userInfo.Profile.Telephone.
I don't know (yet) how to save e.g the telephone number after updating it but let me know if you find out.
 
New Post
7/19/2006 8:39 PM
 
ps30


Joined: 6/14/2006
Posts: 14

We are having the same problems here.  Is anyone interested in creating a new Profile that works with true SQL tables?  The only drawback would be that it is not custom for a bunch of hosted sites that need different tables. But.. it does work with standard SQL and can be extended with whatever field you want.

Has anyone done this yet for DNN?
 
New Post
7/19/2006 8:51 PM
 
cathal connolly


cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676

The latest release works with true sql tables (i.e. not serialized BLOB fields). The post earlier in this thread referencing ProfilePropertyDefinition is an example of this. I created a few DNN 4.x modules to teach a class recently demoing some of this, they're available here , they should help you get an idea. Now that we've gone live with the gold release, expect some blog posts to describe the new profile area in better detail.

Cathal

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
 Page 1 of 3
123Next 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Profile Info - Where is it?Profile Info - Where is it?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out