Products

Solutions

Resources

Partners

Community

Blog

About

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

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...export list of useridexport list of userid's with username
Previous
 
Next
New Post
10/13/2008 12:15 PM
 

I've exported survey results and need to see who is having problems. 

Basically I had a yes/no question. "are you having problems with X?"

I want to see which users responded yes.  The export data exports by userid, so I'd have to go lookup each user individually to see their username/e-mail address.

It'd be even better if I could generate a list with their userid, username, e-mail address, etc. -- that way I can contact the people having trouble.

Thanks

 
New Post
10/14/2008 9:07 AM
 

This query assumes you only have one survey module.  But it should get you going...

 

SELECT     SurveyResults.SurveyResultID, SurveyResults.SurveyOptionID, SurveyResults.UserID, Users.Username, Users.FirstName, Users.LastName,
                      aspnet_Membership.Email
FROM         SurveyResults LEFT OUTER JOIN
                      Users ON SurveyResults.UserID = Users.UserID INNER JOIN
                      aspnet_Users ON Users.Username = aspnet_Users.UserName INNER JOIN
                      aspnet_Membership ON aspnet_Users.UserId = aspnet_Membership.UserId

 

Stuart


Hilbert Solutions, LLC
Owner, Hilbert Solutions, LLC
http://www.HilbertSolutions.com
A DNN Service Provider
From Module Development to DNN Upgrades, your one stop DNN Shop
 
New Post
10/14/2008 11:02 PM
 

Thanks Stuart,

I understand the code but have no idea where to put it or implement it.  Sorry still sort of a beginner...

 

Anyone able to help with this? I don't mind if all surveys export userid, username, e-mail address, first name, last name

along with their responses. 

 

Thanks!

 
New Post
10/15/2008 8:32 AM
 

If you login with an account that has Host level access you can go to Host | SQL

Then you can put the code into the SQL box and click execute.

Stuart


Hilbert Solutions, LLC
Owner, Hilbert Solutions, LLC
http://www.HilbertSolutions.com
A DNN Service Provider
From Module Development to DNN Upgrades, your one stop DNN Shop
 
New Post
10/15/2008 11:16 PM
 

Thanks! That worked great!

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...export list of useridexport list of userid's with username


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