Members Management

The Members management page provides comprehensive tools for viewing, searching, editing, and managing all user accounts in the system. This interface allows administrators to perform bulk operations, view member statistics, manage member files, and handle both soft-delete and permanent delete operations.

Quick Start

To get started: Use the search bar to find specific members, click column headers to sort data, select checkboxes to perform bulk operations, or click "Add" to create new member accounts. The interface supports both active member management and deleted member recovery operations.


Toolbar Functions

The toolbar provides essential navigation and action buttons for member management:

Button Function Description
Add Create New Member Opens a popup window to create a new member account with all required fields
Back Browser Navigation Returns to the previous page in browser history
Close Close Interface Closes the current window or returns to Control Panel if embedded
â?» Refresh Page Reloads the current page to refresh data
Search Member Search Searches across ID, Name, and Email fields using the search input
Show All Clear Search Removes search filters and displays all active members
UnDelete View Deleted Members Switches to deleted members view for recovery operations

Data Table Columns

The members table displays comprehensive information about each user account:

Column Data Type Description
â?쳌 Checkbox Selection Select members for bulk operations (delete, undelete, or permanent delete)
Member Text Link Display name of the member, links to member profile page
Login / Email Email Link Member's login username and email address, clickable to send email
Alias Text Member's display alias or nickname
Kudos Number Link Count of kudos received, links to kudos calendar view
Followers Number Count of users following this member
Friends Number Count of members this user is following
Zip Text Member's postal/zip code for location reference
Actions Button Group Quick action buttons for individual member operations
Status Icon Visual Indicator Shows active (green check), deleted (red X), or inactive (gray dash) status
ID Number Unique member identification number

Individual Action Buttons

Each member row contains action buttons for specific operations:

Button Color Function
Delete Red Soft-deletes the member (sets Is_Active=2), requires confirmation
View Blue Opens member profile page in new tab (only for active members with View permissions)
Edit Gray Opens member record editing interface
Files Orange Opens file manager for member-specific files and uploads

Search Functionality

The search system provides multiple ways to locate specific members:

Search Methods

  1. Toolbar Search: Use the search input in the toolbar to search across ID, member name, and email fields
  2. DataTable Search: Use the built-in DataTable search box for real-time filtering
  3. Column Sorting: Click column headers to sort data ascending or descending
  4. Enter Key: Press Enter in the toolbar search box to execute the search

Search Scope

The search function looks for matches in:

  • Member ID numbers
  • Member display names (Sponsor_Name)
  • Email addresses and usernames
  • Partial matches using wildcard patterns

Bulk Operations

The interface supports bulk operations on multiple members simultaneously:

Selection Process

  1. Use individual checkboxes to select specific members
  2. Use the header checkbox to select/deselect all visible members
  3. Selections persist across DataTable pagination
  4. Selected items are collected from all pages when action is executed

Available Bulk Actions

Action Context Result
Delete Selected Active Members View Soft-deletes selected members (sets Is_Active=2)
Un-Delete Selected Deleted Members View Restores selected members to active status (sets Is_Active=1)
Permanently Delete Deleted Members View Permanently removes selected members from database (cannot be undone)

Member Status Management

Members can exist in different states with corresponding visual indicators:

Status States

Status Icon Is_Active Value Description
Active â?? Green Check 1 Member is active and can log in
Inactive â?? Gray Dash 0 or NULL Member is inactive but not deleted
Deleted â?? Red X 2 Member is soft-deleted (can be restored)

Status Transitions

  1. Activate: Click gray dash icon to set member to active status
  2. Deactivate: Click green check icon to set member to inactive status
  3. Delete: Use Delete button or bulk delete to soft-delete members
  4. Restore: Use UnDelete view to restore soft-deleted members
  5. Permanent Delete: Use hard delete option to permanently remove members

Deleted Members Workflow

The system provides a comprehensive workflow for managing deleted members:

Accessing Deleted Members

  1. Click the UnDelete button in the toolbar
  2. The interface switches to show only soft-deleted members (Is_Active=2)
  3. A red "Showing Deleted" badge appears in the record count area
  4. Bulk action buttons change to recovery options

Recovery Operations

Operation Method Result
Individual Recovery Click status icon Restores single member to active status
Bulk Recovery Select + Un-Delete Selected Restores multiple members simultaneously
Permanent Deletion Select + Permanently Delete Removes members from database permanently

Important Warning

Permanent deletion cannot be undone. Members are completely removed from the database along with all associated data. Use this feature with extreme caution and ensure you have proper backups.


Permissions and Security

The Members management interface implements several security measures:

Access Control

  • Admin Only: Only users with ID=1 (super admin) have full access
  • Users Permission: Other administrators need "Users" permission in their profile
  • View Permission: "View" button only appears for members with appropriate permissions
  • Protected Accounts: "Web Administrator" account cannot be deleted or modified

Data Filtering

  • Non-admin users only see members in their workgroup
  • Admin1 account is excluded from general user searches
  • Soft-deleted members are hidden by default
  • SQL injection protection through parameterized queries

DataTable Features

The members table includes advanced DataTable functionality:

Pagination and Sorting

  • Page Sizes: 25, 50, 100, or All records per page
  • Default Sort: By Member ID in descending order (newest first)
  • Column Sorting: Click any sortable column header
  • State Persistence: Table remembers your preferences

Search and Filtering

  • Global Search: Search across all visible columns
  • Real-time Filter: Results update as you type
  • Case Insensitive: Search works regardless of capitalization
  • Multi-word Search: Finds records matching any search term

Responsive Design

  • Table adapts to different screen sizes
  • Horizontal scrolling on narrow screens
  • Touch-friendly interface for mobile devices
  • Optimized button sizing for touch interaction

Integration Features

The Members interface integrates with other system components:

Link Destination Purpose
Member Name /members.cfm?action=details View public member profile
Email Address mailto: link Send email to member
Kudos Count Kudos calendar module View member's kudos history
View Button /members/push.cfm Member push notification interface
Files Button memberfilemanager.cfm Member-specific file management

Data Relationships

  • Kudos System: Displays count from global_kudos table
  • Social Network: Shows follower/friend counts from global_followers
  • Workgroups: Filters members based on workgroup assignments
  • Permissions: Integrates with role-based access control


Troubleshooting

Common Issues

Issue Cause Solution
No members visible Search filter or permission restriction Clear search, check permissions, or click "Show All"
Bulk actions not working No members selected Select members using checkboxes before clicking action buttons
Search not finding members Workgroup filtering Ensure member is in your workgroup or use admin account
Can't delete Web Administrator Protected account This is intentional - system account cannot be deleted

Summary

The Members management interface provides comprehensive tools for user account administration, including search capabilities, bulk operations, status management, and integration with other system modules. The interface supports both active member management and deleted member recovery workflows, with appropriate security controls and data protection measures. Use the search functionality to locate specific members, leverage bulk operations for efficient management, and utilize the soft-delete system for safe member removal with recovery options.