Excel to ACL

[ShasRises]

Hello,

I have an excel file with a list of over 4000+ entries. I would like to export the file to the ACL list. Is this possible?

[Webdongle]

What's in the exel file and what ACL list ?

[ShasRises]

I have a list of over 4000+ entries in an excel file that would be Child User Groups. I have created a Parent Group- "Free user". I would like to import the excel file contents to Joomla user groups that would be listed under the parent group- "Free user".

[Webdongle]

Make a backup of your database and keep it safe !!!

The xml file would need to have the columns matching the fields in the #__users table

Code: Select all

`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`

Do not label the columns, leave blank columns for all except

• `name`, `username`, `email`,
• `password` (you can create the value for that field by creating a user manually and using that data then tell the users to change it)
• `block` (Value 0 )
• `sendEmail` (Value 1 )
• `registerDate` (value in the format of 2016-10-10 01:01:00 )
• `lastvisitDate` (value in the format of 2016-10-10 01:01:00 )
• `activation` (Value 1 )
• `lastResetTime` (value in the format of 0000-00-00 00:00:00 )
• `resetCount` (Value 0 )
• `requireReset` (Value 0 )

You can insert the columns in the excel file add the values in the first record then copy/paste each column. Export it as a csv file.

Then use phpMyAdmin to export the #__users table and edit it with the data from the csv file. Use phpMyAdmin to run the edited code as sql in the database.

Then you need the data for the #__usergroup_map
Create an excel sheet with two columns. First column with the newly created ID's, second column the value for your new group (found in 'Title' of #__usergroupmap). Export to a csv file

Use phpMyAdmin to export the #__usergroupmap and edit it with the data from the csv file and then run it as sql in phpMyAdmin.

It is complex and time consuming but quicker than manually adding all those. But you may need to do 50 records at a time because of database restrictions.