Search Results :

×

Joomla 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.

  • 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.
Get Started with Import Export User
  • 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.
Joomla Import Export user
  • 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 user
  • 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 user
  • 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
    Metadata
  • 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 user
  • 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 Import Export
        Metadata
  • 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.

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

ADFS_sso ×
Hello there!

Need Help? We are right here!

support