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...Searching by name in admin user accountsSearching by name in admin user accounts
Previous
 
Next
New Post
1/14/2009 11:35 AM
 

Thanks in advance for any and all help.

I have very little experience with asp code and dotnetnuke so please be easy on me.

I would like to be able to search by FirstName or LastName when in admin/useraccounts.  Currently I can only search by username and email.

I thought I could duplicate a line in users.ascx and then make a change to call for LastName.  But when implemented I get no search results.

Thanks once again.

 
New Post
1/14/2009 1:55 PM
 

dspeak-
Under ADMIN->USER ACCOUNTS you should have a dropdown box to select the name of the field you are searching.  This dropdown should contain over 20 user-account-related fields, not just two.  If you are only seeing two fields then something is wrong with your DNN installation (I've never run across that particular issue).

A bit more info might be helpful:

  • What version of DNN is it? 
  • Is this a local copy or a hosted copy of DNN? 
  • Do you have HOST access or only ADMIN access? 
  • What third-party modules have you installed?
  • Did you install the SOURCE CODE version of DNN?
  • Have you previously altered any DNN code or was your change to USERS.ASCX the only modification?

-mamlin


esmamlin atxgeek.me
 
New Post
1/16/2009 8:44 AM
 

Thanks for your reply, I hope with your help I can resolve this.

Version   3.1.0

Hosted copy

Both Host and Admin access

None

I am not sure on the source code, it was installed by someone else who is no longer available.

No other code has been changed.

 

Thanks for the help

 
New Post
1/16/2009 11:55 AM
 

3.1 is a bit old... (june 2005) so that's why you have limited functionality compared to the current (4.9.1 / 5.0.0) version.

You might consider upgrading, but that's not an easy one from such an old version.

 
New Post
1/16/2009 12:45 PM
 

Well, I'm not well-versed in DNN 3.x, but in 4.x the code you're looking for is in USERS.ASCX.VB in the Page_Load setion -- see highlighted portion of DNN 4.x code below.  Note:  Do NOT use this code in your DNN 3.x instance!  I'm posting it for illustration purposes only.

  Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    Try
      'Add an Action Event Handler to the Skin
      AddActionHandler(AddressOf ModuleAction_Click)
      If Not Page.IsPostBack Then
        'Load the Search Combo
        ddlSearchType.Items.Add(AddSearchItem("Username"))
        ddlSearchType.Items.Add(AddSearchItem("Email"))

        Dim profileProperties As ProfilePropertyDefinitionCollection = ProfileController.GetPropertyDefinitionsByPortal(PortalId, False)
        For Each definition As ProfilePropertyDefinition In profileProperties
          ddlSearchType.Items.Add(AddSearchItem(definition.PropertyName))
        Next

        'Localize the Headers
        Localization.LocalizeDataGrid(grdUsers, Me.LocalResourceFile)
        BindData(Filter, ddlSearchType.SelectedItem.Value)
      End If
    Catch exc As Exception    'Module failed to load
      ProcessModuleLoadException(Me, exc)
    End Try
  End Sub

 
Note that the "Username" and "email" items are added individually while the other searchable profile field names are loaded from the database.  Unless the previous person managing your DNN instance edited the USERS.ASCX.VB file, I doubt your problem is with the USERS code. 
 

VERIFY PROFILE PROPERTIES HAVE NOT BEEN DELETED
At this point I'd recommend making sure your site still HAS profile properties.

Method 1: Log in as ADMIN or HOST, going to ADMIN->USER ACCOUNTS and then select "MANAGE PROFILE PROPERTIES".  Verify that all the expected profile fields are still there.  You SHOULD see the default user profile fields for name info (prefix, firstname, middlename, lastname, suffix), address info (unit, street, city, region, country, postalcode), contact info (telephone, cell, fax, website, IM) and preferences (timezone, biography, preferredlocale).  It's possible that someone deleted all the fields (I've seen it happen more than once) not realizing that deleting them really is deleting them and not just hiding them from the user.

Method 2 (SQL):  If you know your portal ID number (it will be '0' if you only have one portal), go to HOST->SQL, copy-and-paste the following query into the box and click "Execute":

   exec GetPropertyDefinitionsByPortal {your portal ID number here}

Look in the column "DELETED" and make sure all values are set to "FALSE".

 

Also -- if you have not already done so, undo you previous edit(s) to the USERS.ASCX file to avoid having your changes introduce new issues.

Check into whether your profile properties have been deleted and post what you find-
-mamlin


esmamlin atxgeek.me
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Searching by name in admin user accountsSearching by name in admin user accounts


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