Where is the user profile information stored in the Dotnetnuke database?

Question

Here is the situation I'm in:

I just implemented a DNN site. I already have a huge user database table. Now, when my users register on my DNN site, they are required to provide their first name, last name and DOB. I will then use this information to map their records to an existing user table using an SQL query. The only problem: I can’t find the “DOB” field anywhere, in any table or, for that matter, most of the rest of the profile information. Is it even stored in a database? or am i just blind?

The best answer I could find is a dnn forum which says

"Information about the user profile is stored in several tables in the database. The" Users "table is a place to start basic information. The name also has several tables with a" profile ".

I looked at almost every table in the database, but no luck ...

I am using DNN 6.0 with SQL Server 2008

I searched everywhere, but can't find it. Any help or guidance from someone would be greatly appreciated! Even a paid solution like a preliminary module will work.

thank

Answer 1

See the table ProfilePropertyDefinitionfor the PropertyDefinitionIddateOfBirth property. Then with this id and user id, you can query the table UserProfileto get the value.

http://erikvanballegoij.com/Home/itemid/28/Selecting-profile-properties-the-easy-way