Search Results :

×

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

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


  • 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 .
  • Import Export for Joomla
  • Now under Upload Package File click on Or browse for file then select zip file of Import Export plugin.
  • Import Export for Joomla
  • Once zip file is uploaded then click on Components -> miniOrange Import Export -> Account Setup.
  • Import Export for Joomla
  • Now you can Setup with miniOrange.
  • Import Export for Joomla
  • 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
  • Joomla Import-Export-Users
  • Under Upload Package File tab. Drag the downloaded file OR upload file by click on browse for file
  • Joomla Import-Export-Users file
  • Go to Components miniorange Import Export Users
  • Joomla Import-Export-Users Plugin

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.
  • Joomla Import Export Users
  • Select the appropriate roles and then click on Export Users button to export the users of specific groups/roles which you want to export.
  • Joomla Import Export Users
  • 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.
  • Joomla Import Export Users

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.
  • Joomla Import Export Users
  • 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.
  • Joomla Import Export 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.
  • Joomla 2 Joomla Import Export Users

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.

    Publish to web Import Export Users
  • 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.
  • Joomla 2 Joomla Import Export Users

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.
  • Import-Export Users in Joomla using CRON Export
  • Give the project a name and then, click on the Create button.
  • Import-Export Users in Joomla using CRON Export
  • You will see a notification about the project getting created. Click on the Select Project button.
  • Import-Export Users in Joomla using CRON Export
  • Now click on the Sidebar button and then go to Marketplace.
  • Import-Export Users in Joomla using CRON Export
  • In the marketplace search for Google Sheets API and enable it by clicking the Enable button.
  • Import-Export Users in Joomla using CRON Export Import-Export Users in Joomla using CRON Export
  • Now click on Credentials from the sidebar.
  • Import-Export Users in Joomla using CRON Export
  • Then click on the Create Credentials button and then click on Service Account.
  • Import-Export Users in Joomla using CRON Export
  • Enter the service account details and then click Create and Continue.
  • Import-Export Users in Joomla using CRON Export
  • Click on the service account you just created.
  • Import-Export Users in Joomla using CRON Export
  • Go to the Keys tab and under the Add Key dropdown click on Create New Key.
  • Import-Export Users in Joomla using CRON Export
  • Select JSON format under key type.
  • Import-Export Users in Joomla using CRON Export
  • You will see a confirmation that the JSON key file has been saved to your computer.
  • Import-Export Users in Joomla using CRON Export
  • 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.
  • Import-Export Users in Joomla using CRON Export
  • 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.

Hello there!

Need Help? We are right here!

support
Contact miniOrange Support
success

Thanks for your inquiry.

If you dont hear from us within 24 hours, please feel free to send a follow up email to info@xecurify.com