Contents

Joomla Setup Guide Import Export Users

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.

Click here to know more about other features we provide in Joomla Import Export Users plugin

Pre-requisites : Download And Installation

Download

Free Trial

What is Import Export Users ?

You can Import / Export your users from .csv file regardless of the size or number of columns. It also allows you to import or export user's profile data..

1. Install miniOrange Import Export Users plugin

Joomla 4 Configuration
Joomla 3 Configuration

Download the zip file for the miniOrange Import Export Users plugin for Joomla from the link here.
Now go to the System -> under Install section -> click on Extensions .

Now under Upload Package File click on Or browse for file then select zip file of Import Export plugin.

Once zip file is uploaded then click on Components -> miniOrange Import Export -> Account Setup.

Now you can Setup with miniOrange.

Download the zip file for the miniOrange Import Export Users plugin for Joomla from the link here.
On your Joomla admin console go to Extensions Manage Install

Under Upload Package File tab. Drag the downloaded file OR upload file by click on browse for file

Go to Components miniorange Import Export Users

2. Export Users

You can export the users and groups present on your Joomla instance in CSV format by using this feature. To use this feature check the checkbox. 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.

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.

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.

File -> Publish

Publish to the web

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.

5. Cron Export

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

Import-Export Users in Joomla using CRON Export

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.