R2i DotNetNuke® Forum

R2i wants you to have the opportunity to ask questions, post reviews, help others or just rant and rave about DotNetNuke® or any of the R2i Modules and Skins. Our team spends hour upon hour, day after day, working on custom DotNetNuke® modules and services; please feel free to ask us anything.
 
Where is User Profile Information?
Last Post 01 Jan 1900 05:00 AM by . 3 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
mrwebslingerUser is Offline
Basic Member
Basic Member
Posts:357

--
06 Jun 2006 09:43 PM  
Ok, I thought I knew the answer to this but apparently I don't.  What table is the following User Profile information stored:  Phone Number, Country, etc...  

I know that First, Last and Email is stored in users but I can't find the rest of the registration fields.

Thanks!
kevinmschreinerUser is Offline
Advanced Member
Advanced Member
Posts:729

--
12 Jun 2006 01:06 PM  
Sure, this information (atleast up through DNN 3.2.2 and 4.0.3) is stored in the aspnet_profile table, in a compound column aggregation. You can fetch information out of this table by using a set of procedures that I have defined in a previous forum tip:

http://dnn.bi4ce.com/Forums/tabid/106/forumid/2/postid/42/view/topic/Default.aspx
blenherrUser is Offline
New Member
New Member
Posts:9

--
14 Aug 2006 12:52 PM  
This has changed a lot in 4.3.4. It now allows more information to be stored in the user profile but it is definitely a lot harder to get out.
blenherrUser is Offline
New Member
New Member
Posts:9

--
16 Aug 2006 12:56 AM  
I am still struggling to create a simple user list with the current profile info. I imported the XML from your sample but if a user updates their profile I don't seem to be getting the latest info. I have tried flushing the caches. I think it has something to do with versioning within the structure.

I also need to only pull users from a specific portal.

You have a great module but DNN structure is getting to be a lot more complex.

I need to get this working asap since it is for a class reunion site....

Thanks in advance
You are not authorized to post a reply.

Active Forums 4.1
 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seatle, WA • 410.327.0007 • info@R2Integrated.com

Bookmark & Share Bookmark and Share