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

HomeHomeGetting StartedGetting StartedNew to DNN Plat...New to DNN Plat...Member ListMember List
Previous
 
Next
New Post
10/18/2011 2:49 PM
 
I started with the standard DNN 6.2 UserProfile Display Template but found it is restricted to 2000 (max field is 4000) characters, so a decent html profile template using tokens (12k characters) can't be pasted into the table, and thus that failed

I tried H2O and found that too elaborate for a simple member directory since it was designed for teams and projects.

I then tried the Effority Membership directory and got through the install bugs on dnn 6.2 --- BUT then found that the link to open the directory template doesn't work and posted along a few people in Codeplex, but there's no response (dead end?)

Now I'm trying the UDT (Form List) and running into the thought that surely someone has created a template or something to make this simpler and less trial and error?

I've got Active Social running on 5-6 sites and know there's a release of DNN with that in it just around the corner (next month?) so I don't want to pay $200 per site (as I have so far) just to get a member list setup.

Anybody else?
 
New Post
10/18/2011 4:36 PM
 

Are you just looking for a report of the existing accounts?

If so try this:
Login with the Host account.
Add the Report module to a page.
Use this SQL after changing the portalID from 2 to the number of the portal you want to report:
Select
  U.UserID "UserID",
  U.Username "UserName",
  U.DisplayName "Name",
  P1.PropertyValue "Telephone",
  P2.PropertyValue "Cellphone",
  AM.Email "EMail",
  UP.Authorised "Authorized"
from
  aspnet_Membership as AM with (nolock)
  join aspnet_Users as AU with (nolock) on AM.UserID = AU.UserID
  join Users as U  with (nolock) on U.UserName = AU.Username
  join UserPortals  as UP with (nolock) on U.UserID = UP.UserID and UP.PortalID = 2
  left join UserProfile as P1 with (nolock) on U.UserID = P1.UserID and P1.PropertyDefinitionID = (select PropertyDefinitionID from ProfilePropertyDefinition where PortalID = UP.PortalID and PropertyName = 'Telephone')
  left join UserProfile as P2 with (nolock) on U.UserID = P3.UserID and P3.PropertyDefinitionID = (select PropertyDefinitionID from ProfilePropertyDefinition where PortalID = UP.PortalID and PropertyName = 'Cell')
where 
  AM.ApplicationID = (select ApplicationID from dbo.aspnet_Applications where ApplicationName = 'DotNetNuke')
  and UP.IsDeleted  = 'False'
  and U.IsSuperUser = 'False'
  and not exists (select UR.UserID from UserRoles as UR where UR.UserId = U.UserID and UR.RoleID in (select R.RoleID from Roles as R where R.PortalID = UP.PortalID and R.RoleName = 'Administrators'))
order by
  U.LastName,
  U.FirstName,
  U.Username

Thanks,
Greg

 
New Post
10/18/2011 8:37 PM
 
Thanks Greg, but no, I'm wanting to list Users with distinct role(s), which are linked to a profile page laid out in tables. We have the registration form and the userprofile page showing the data in an html module using TOKENS, but for the ADMIN, they need to view other user profiles and the TOKENS only show their OWN data, not the other users.

The real problem is that the DNN TabModuleSettings column where the UserProfile Template is stored is set for nvarchar(2000) and we have 2080 html characters in the template. Even upping the column to nvarchar(4000) or nvarchar(max) hasn't worked yet. Every time I save the template through the module settings form, it truncates the template by 70%.

I suspect I'm doing something wrong, but don't know what or why yet.
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedNew to DNN Plat...New to DNN Plat...Member ListMember List


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