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
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...How do I Retrieve/download content in my databaseHow do I Retrieve/download content in my database
Previous
 
Next
New Post
10/17/2007 10:14 AM
 
darius M

downtimeonline.net
Joined: 5/28/2005
Posts: 12

I need to retrieve the data from my database associated with my dotnetnuke site - specifically all the people who joined my site.  I have no idea where to start in order to retrieve this information.  Can someone point me in the right direction?

 
New Post
10/17/2007 11:22 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212

can you be more specific about your use case - in which format do you need the data, once, frequently or constantly (live access), user profile only?, ...

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
10/23/2007 1:31 PM
 
darius M

downtimeonline.net
Joined: 5/28/2005
Posts: 12

I would love to retrieve the data in a format that would allow me to open it using excel - so tab delimited would be great; also as a .txt file would be manageable.  I am looking for the user profiles - with names, addresses, email addresses, etc.  i don't needt the content, images, etc. that make up my site.
 
New Post
10/23/2007 4:47 PM
 
chrisv91301

Joined: 9/26/2007
Posts: 13

you can browse the database with sql server.  Its just an sql database.

Table "Users" has all the basic user info.

UserPrifle - this table has UserProfile information  you can join that information by userID key in both tables.

UserAuthentication - not sure this is probably the table for users to be authenticated.  check it out yourself see what this one does.

Once you know what data you need all you do is simple select queries to the db.  "select * from Users where ......." 

hope that helps
 
New Post
10/23/2007 5:05 PM
 
chrisv91301

Joined: 9/26/2007
Posts: 13

Here is a step by step if how to get your data then.

1) Connect to the databse using SQL Server Management Studio (express version free from microsoft.com downloads section)

2) Query DotNetNuke database with following

select * from Users inner join UserProfile on Users.UserID = UserProfile.UserID

' add your own where clause if you need to restrict certain profile properties.  this is one to many relationship.

' After that once query is ran you will see a grid on the bottom with the results of the query.  Right click the grid and choose Save As.... it will give you plenty of options of file formats to save to.

That should do it. :)
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...How do I Retrieve/download content in my databaseHow do I Retrieve/download content in my database


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