User Import Export

What It Does

Flexible Export - Export users to 5 different formats with complete control over which fields to include. Filter by user groups, status, or registration date range. Preview data before exporting.

Powerful Import - Bulk import users from CSV, Excel, JSON, or XML files. Intelligent auto-detection maps file columns to Joomla fields. Pre-import validation catches errors before they happen.

Reusable Templates - Save your export and import configurations for repeated use. One-click execution of saved templates for consistent operations.

Complete Audit Trail - Every operation is logged with full details. Re-download previous exports. Track who did what and when.

Dashboard Overview - Statistics at a glance. User counts, recent operations, template summaries, and quick action buttons.

Export Formats

CSV - Universal spreadsheet format with configurable delimiter (comma, semicolon, tab, pipe). Compatible with Excel, Google Sheets, LibreOffice.

Excel (XLSX) - Professional spreadsheet with styled headers, auto-column sizing, frozen header row, and auto-filter. Requires PhpSpreadsheet library.

JSON - Structured data format perfect for APIs, backups, and data interchange between applications.

XML - Standard markup format for enterprise systems and data interchange requirements.

SQL - Database migration scripts with INSERT statements. Ready for direct database import.

Exportable Data

• Core Fields - ID, username, name, email, registration date, last visit, block status, activation, send email flag
• User Groups - All assigned groups with names and IDs
• Profile Data - Address, city, region, country, postal code, phone, website, about me, date of birth, profile image
• User Notes - Administrator notes attached to users
• Custom Fields - All custom fields created for com_users automatically detected

Import Features

Auto Field Mapping - Intelligent detection matches file columns to Joomla fields based on common naming patterns.

Import Modes:
- Add New Only - Create new users, skip existing (matched by email or username)
- Update Existing Only - Update existing users, skip new entries
- Add and Update - Create new and update existing users

Password Handling:
- Generate Random - Create secure random passwords for new users
- Import from File - Use passwords from import file (will be hashed)
- Require Reset - Force password reset on first login

Validation - Pre-import validation checks for:
- Invalid email formats
- Invalid username formats
- Duplicate emails/usernames in file
- Existing users in database
- Missing required fields

Sample Template - Download a pre-formatted CSV template to see the expected format.

Key Features

? 5 Export Formats - CSV, Excel, JSON, XML, SQL
? Bulk Import - CSV, Excel, JSON, XML file support
? Auto Field Mapping - Intelligent column detection
? Pre-Import Validation - Catch errors before import
? Reusable Templates - Save and reuse configurations
? Operation Logs - Complete audit trail
? Re-Download Exports - Access previous export files
? Dashboard - Statistics and quick actions
? Filter by Groups - Export specific user groups
? Date Range Filter - Export by registration date
? Password Options - Secure password handling
? Profile Data - Export/import user profiles
? Custom Fields - Full custom field support
? User Notes - Export administrator notes
? Batch Processing - Handle large datasets
? Joomla 5 & 6 - Full compatibility

Perfect For

• Site Migration - Move users between Joomla sites
• User Backup - Regular backup of user data
• Bulk Registration - Add multiple users from HR or external systems
• Marketing Lists - Export email lists for campaigns
• User Sync - Synchronize with CRM or external databases
• Reporting - Generate user reports for management
• Database Migration - Move to different database systems
• User Cleanup - Identify inactive users for maintenance

Configuration Options

Export Settings
- Default export format
- CSV delimiter preference
- Password handling (exclude/hash/placeholder)

Import Settings
- Default password action (generate/import/reset)
- Default user group for new users
- Batch processing size

Log Settings
- Log retention period (days)
- Automatic cleanup of old logs

Permissions
- Configure access - Component options access
- Access Component - Basic component access
- Export Users - Permission to export
- Import Users - Permission to import
- Manage Templates - Create/edit/delete templates
- View Logs - Access operation logs

Technical Features

Modern Architecture
- Full Joomla 5 & 6 compatibility
- PHP 8.1+ with strict type declarations
- Proper namespace implementation
- MVC architecture following Joomla standards
- Service-based design for maintainability

Performance Optimized
- Batch processing for large datasets
- Efficient database queries
- Streaming file generation for memory efficiency
- Configurable batch sizes

Security Enhanced
- CSRF token validation on all operations
- Permission checks on every action
- Input validation and sanitization
- Secure file handling
- Password hashing for imported passwords

Database Support
- Full support for Joomla user tables
- User groups and mappings
- User profiles
- User notes
- Custom fields

Support

• Support Portal: https://support.joomlax.com
• Email Support: support@joomlax.com
• Website: https://www.joomlax.com
• Documentation: Comprehensive documentation included
• Update Server: Automatic updates via Joomla update system

Why Choose User Import Export?

Complete Solution - Export and import with full field support, not just basic user data

Multiple Formats - 5 export formats cover every use case from spreadsheets to database migration

Intelligent Mapping - Auto-detection makes importing fast and error-free

Validation First - Pre-import validation prevents errors and data issues

Reusable Templates - Save time with saved configurations for repeated operations

Full Audit Trail - Logs track every operation for accountability and recovery

Secure by Design - Password handling options, permission controls, and input validation

Enterprise Ready - Batch processing handles thousands of users efficiently

Well Documented - Clear documentation, sample templates, and intuitive interface

Joomla Native - Built specifically for Joomla, following all standards and best practices

Streamline your Joomla user management with comprehensive import and export capabilities. Perfect for site migrations, backups, bulk operations, and integration with external systems. Professional-grade user data management made simple.

Joomla 5 & 6 Compatible | 5 Export Formats | Intelligent Field Mapping | Pre-Import Validation