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

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 7: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 Dotnetnuke System Integrator
From Module Development to Project Management, your one stop Dotnetnuke Shop
 
New Post
10/14/2008 9: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 6: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 Dotnetnuke System Integrator
From Module Development to Project Management, your one stop Dotnetnuke Shop
 
New Post
10/15/2008 9:16 PM
 

Thanks! That worked great!

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


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

Attend A Webinar
Try An Online Demo
Download DotNetNuke Professional Edition Trial
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

DotNetNuke Scoop!

Sponsors

DotNetNuke Corporation

DotNetNuke Corp. is the steward of the DotNetNuke open source project, the most widely adopted Web Content Management Platform for building web sites and web applications on Microsoft .NET. Organizations use DotNetNuke to quickly develop and deploy interactive and dynamic web sites, intranets, extranets and web applications. The DotNetNuke platform is available in a free Community and subscription-based Professional and Enterprise Editions with an Elite Support option. DotNetNuke Corp. also operates Snowcovered.com where users purchase third party apps for the platform.