Joomla Import Export Users

Overview

Joomla Import Export Users plugin exports and downloads user details in the form of a CSV file. We can also import the users and their details using a CSV file as input. You must create a CSV file and upload it. For the plugin to work correctly, you must map the headers of all the columns correctly and you must ensure that all of the fields you enter are in the correct format. For example, the username field gets mapped to the Username.

Setup Joomla Import Export Users

Step 1: Install miniOrange Import Export Users plugin

• Download the zip file for the miniOrange Import Export Users plugin from the link here.
• Login into your Joomla site’s administrator console.
• From Menu, click on System, then under Install section click on Extensions.
• Upload the downloaded zip file to install the Import Export Users plugin.
• Installation of the plugin is successful. Now click on Get Started! button.

Step 2: Setup Export Users

• You can export the users and groups present on your Joomla instance in CSV format by using this feature. After that to export users click on the Export button and to export groups click on Export Groups button.

• Select the appropriate roles and then click on Export Users button to export the users of specific groups/roles which you want to export.

• This feature allows you to export specific information of users according to the columns written in the text box. You can use this field to set which columns must be exported and in which order. If you leave it empty, all columns will be exported. Use a list of fields separated by semicolon(;), for example: name;username;email.

Step 3: Import Users / Groups

• You can import groups present on different instances to the current Joomla instance using this feature. Upload the CSV file of groups and then click on Import Groups. Your CSV should contain id, parent_id, lft, rgt and title columns.

• This feature allows you to import the users from another instance to this Joomla instance. Upload the CSV file of users and then click on Import Users.

• If you want to allow only a specific role/group of users to import into Joomla, then enable the below checkbox and select appropriate Role.

Step 4: Cron Import

• This feature imports users from the google sheet you provided periodically. To use this feature you need to do following configuration:
• Enable Active periodical import
• There is also a much easier, but less clean solution, if you don't want to bother with the API or Google Authentication.

1. Go to your Spreadsheet in Google Drive.
2. Go to File -> Publish to the Web
3. In the Publish to the web dialog you can get a .csv Link to your spreadsheet.

• Select the appropriate period from dropdown.
• Enable the checkbox if you want to send email to users which are being updated.
• Then click the Save Cron Options button.

Step 5: Cron Export

• Go to the Google Cloud Dashboard. Then, click the Project Dropdown button.

• Click on the New Project button.

• Give the project a name and then, click on the Create button.

• You will see a notification about the project getting created. Click on the Select Project button.

• Now click on the Sidebar button and then go to Marketplace.

• In the marketplace search for Google Sheets API and enable it by clicking the Enable button.

• Now click on Credentials from the sidebar.

• Then click on the Create Credentials button and then click on Service Account.

• Enter the service account details and then click Create and Continue.

• Click on the service account you just created.

• Go to the Keys tab and under the Add Key dropdown click on Create New Key.

• Select JSON format under key type.

• You will see a confirmation that the JSON key file has been saved to your computer.

• Go to the CRON Operations tab of the plugin and under CRON Export section enable Allow Periodical Export and Allow User Profile Export. Also enter the Spreadsheet URL and Subsheet Name, and then upload the JSON Key file.

• Congratulations, you have successfully configured the Joomla Import/Export plugin.

Mail us on joomlasupport@xecurify.com for quick guidance(via email/meeting) on your requirement and our team will help you to select the best suitable solution/plan as per your requirement.