Here you will find all the available fields that can be used in the Joomla Users import and export routines. Please see the relevant tutorials on how to use these fields in a specific scenario.
We are ROlandd
We make super nice software
Available Fields for Joomla Users
| Title | Description | Type | Example |
| activation | The activation code of Joomla user |
text | |
| block | If the Joomla user is blocked or not Possible options1:Yes |
numeric | 1 |
| combine | This is a special field to allow you to combine fields into a single field. |
text | |
| custom | This is a special field that allows you to set a custom value to be used during export. |
text | main |
Email id of the user |
text | user1@testsite.com | |
| fullname | Full name of the user |
text | Robert Gill |
| group_id | User group name id value |
numeric | 2 |
| id | Primary key value of Joomla users table |
numeric | 2 |
| lastResetTime | Date of last password reset |
text | 2017-06-20 09:23:07 |
| lastvisitDate | The date user last logged in the site |
text | 2017-06-20 09:23:07 |
| lft | Specifies the left position in the nested set. |
numeric | 45 |
| name | Name of the Joomla user |
text | Richard Wilson |
| ordering | Set the order in which the access levels are ordered. |
numeric | 3 |
| otep | One time emergency password |
text | |
| otpKey | Two factor authetication encrypted keys |
text | |
| params | Set the parameters of Joomla user |
text | |
| parent_id | Parent id of the user group name |
numeric | 1 |
| parent_name | Parent name of the user group name |
text | Registered |
| password | Set the password to login to site |
text | letmein |
| password_crypt | md5 hash password for site login |
text | $2y$10$OHmaKb6QtRJZRqlyOqiFIuCh/Qdu2BKNoV/7toAk3N0cVJ6J/c2.6 |
| registerDate | Date when user registered with the site |
text | 2017-05-17 09:58:38 |
| requireReset | Require user to reset password on next login Possible options1:Yes |
numeric | 0 |
| resetCount | Count of password resets since last reset time |
numeric | 2 |
| rgt | Specifies the right position in the nested set. |
numeric | 46 |
| rules | Set the rules for access control in assets table |
text | {"core.admin":{"7":1}} |
| sendEmail | If need to send email to the user Possible options1:Yes |
numeric | 1 |
| skip | This is a special field that allows you to skip a field during import. |
numeric | |
| title | Title of the Joomla user |
text | Mr. |
| usergroup_delete | Delete usergroup during import Possible optionsY:Yes |
text | Y |
| usergroup_name | Group name where the user belongs to |
text | Registered |
| username | Login name of the Joomla user |
text | user1 |
| usergroup_name_delete | Remove assigned user group of a user |
text | Registered|Administrator |
| usergroup_path | The usergroup path specifies in which group a user belongs |
text | Registered/Students/Girls|Registered/Students/Boys |
| title_path | This field specifies the path of user group name. |
text | Registered/Students/Girls|Registered/Students/Boys |