Groups Import Export

Groups Import ExportGroups Import Export is an extension for Groups, providing import and export facilities.

  • Import Users : Users can be imported and assigned to groups in bulk from a text file.
  • Export Users : Users can be exported in bulk, including all users or users that belong to specific groups.

Groups Import Export works with plain text files to import and export users. An easy to use and spreadsheet-ready file format is assumed, where user data is provided on a line with information like username and email separated by tabs.

During a bulk import, new users can be notified by email, providing them with their username, password and login link to the site.

Documentation

Please visit the Documentation page.

Download

This extension is available in the Shop.

Import Users

Export Users

81 Responses to Groups Import Export

  1. Giampi July 24, 2014 at 4:36 pm #

    Hello.

    I bought the plugin “group imports and exports,” but it does not work.
    I need to export the group “registered”, edit it and then import the edited list in the group that I want.
    But when I export, I get a “time-out” error with the new BLANK page.
    How can I fix it?
    Should I change something?
    I need to change the settings on the mysql server?
    Please, help me!
    Thank you!

    • antonio July 28, 2014 at 8:44 am #

      Hi,
      if you have a lot of users maybe there is a connection timed out, you can try to increase the maximum execution time.
      cheers

  2. Rob September 26, 2014 at 10:46 pm #

    Does anyone know if this plugin will import and export all customer fields on My Account page, including custom ones I add?

    • kento September 30, 2014 at 11:06 am #

      It won’t in its current version but it would be a great addition, I’m having a look right now to see if we can add this.

      • Rob September 30, 2014 at 3:09 pm #

        Kento, Ok thanks. Please let me know. I need that function ASAP, but we’re already talking about this in another comment at http://www.itthinx.com/plugins/groups-woocommerce/#comment-433735

        So please feel free to end one comment thread and continue on the other. I really hope you can add that function soon.

        Thanks,
        Rob

  3. Rob October 6, 2014 at 7:41 pm #

    How do we edit the email that goes out when we import users. I don’t want my uses to go to the wp login page, and I’d like to add some basic instructional text to the page. I’m assuming there’s a php file somewhere we can edit that it.

    Please advise.

    Thanks,
    Rob

    • kento October 11, 2014 at 6:53 pm #

      There’s a plugin SB Welcome Email Editor which can be used to customize the welcome email.

      • Rob October 22, 2014 at 5:20 am #

        Kento,

        I tried that plugin, but it’s not working. I make the new email in the plugin, but your Groups Import/Export plugin keeps sending out the default password reminder email from WordPress, which uses the wp-admin url as the login url. Am I doing something wrong in the welcome email plugin? So your plugin doesn’t send out its own email? It uses wordpress’s default password email? Is that correct?

        • kento October 22, 2014 at 8:08 pm #

          Yes that is correct, it uses the default email. Hm … maybe a filter could be added later on but for now unfortunately there is only that option.

          • Rob October 22, 2014 at 10:26 pm #

            OK. I figured there would be a plugin to edit the default password email, but the few I found apparently don’t work with wp 4.0. I’m surprised there aren’t more options to change that.

            For this site, I’ll just not use the part of your plugin and send manual emails for everyone with the appropriate instructions. I’ll set their user and pw to be their email address. That way one email can be bcc’d to all imported members and that should take care of it.

          • Tammie June 30, 2016 at 5:41 pm #

            Hi, I just wanted to add to this conversation that the email SB Welcome Email Editor sends out is still not what is sent when using Groups Import/Export. It’s been almost 2 years since this was first pointed out. Is there any indication of when this might be added? Not being able to send custom welcome emails is a show stopper for us.

            • antonio December 12, 2016 at 3:04 pm #

              Hi Tammie,
              I have created a custom code that you could use.
              Kind Regards,
              Antonio B.

  4. Ali Saberian November 19, 2014 at 3:51 pm #

    Hi
    i use groups for woocommerce plugin
    is this plugin export the expiary date of user in a group ?
    thanks for your answer

    • kento November 19, 2014 at 7:28 pm #

      Hi, only in part as user meta data but to import it doesn’t support it fully yet because of termination schedules that would have to be added.

      • Ali Saberian November 19, 2014 at 7:53 pm #

        OK thanks
        but i don’t understand exactly that how is the exported file ?
        what is the column of exported file when we use group for woocommerce ?

        • kento November 25, 2014 at 8:44 am #

          Here is an example of exported data which includes complete extended user profile data.

  5. Royston December 30, 2014 at 3:36 am #

    I have grabbed my users from the AD & also grabbed the department field. Is there any ways to automatically add the users into the groups by their department?

    • kento January 7, 2015 at 7:50 pm #

      With this extension you can create a file where you indicate the group assignments per user. But I’m not sure what you mean with ‘grabbed my users from the AD’ …

  6. Andrei G January 7, 2015 at 11:24 pm #

    I have already imported about 2000 users via another method/plugin. Now, I just need a quick way to assign various users to their respective groups.

    What I would like to know, if the users exist already (so they don’t need to be created), will this extension allow to simply assign these existing users to the groups I indicate or do I necessarily have to create the users using this Groups extension?

    Thank you.

    • antonio January 14, 2015 at 9:43 am #

      Hi,
      you could use the users admin section (Users->All users) to assign various user to a group. In the “Screen options” you can change the table limit to increase the number of users shown. Then select the users and add to groups your need (above the table).
      cheers

    • kento January 16, 2015 at 2:01 pm #

      Hi Andrei,

      The new release now supports updates for existing users.

      Cheers

      • Andrei G. November 6, 2015 at 7:00 pm #

        Hi,

        Thanks for updating it, but I am still not sure I would be able to use it for my purposes.

        It looks like the user_email field is required for the import. In our case, many users don’t have an email added to their profile. So we were using Import Users from CSV plugin to create the users with a password but without an email, and then, at login time, we were forcing the users to add an email to their profile.

        I would really like to be able to use this extension because it makes adding users to groups really easy, but I can’t as long as the user email is a required column.

        Thanks.

        • Kento November 6, 2015 at 7:57 pm #

          Hi Andrei,

          Basically WordPress will require an email to create a new user which is consistent with the use cases we see implemented on the front and back end. The add_user() function will throw errors if no email address is provided but wp_create_user() will accept to create a user with an empty email address by default. It’s inconsistent and the decision to require the email is consistent with sensible uses cases we can execute with the facilities provided by WordPress on the front and back end. That said, why do you force users to provide an email at login? I’m trying to understand your use case.

          Cheers

  7. EGFS March 6, 2015 at 2:50 am #

    I had posted this in the ‘Groups’ comments and just noticed that it probably should have been posted here instead. Sorry for the multiple posts.

    I’m trying to Import users via a tab-separated TXT file using the ‘Groups Import Export’ extension. Upon clicking the button, the page displays the following error right away at the top of the page…

    Error on line 1, ajd@egbubs.net is not a valid email address.
    0 valid entries have been read.
    1 entry has been skipped.
    0 users have been imported.
    0 users have been updated.

    How is that not a valid email address? I’ve been using it for literally 7 years?! What’s going on here? Any help would be appreciated. Thanks.

    • EGFS March 6, 2015 at 3:08 am #

      I just tried again with a different user that had seven characters before the ‘@’ symbol, just in case there was a problem with only three characters before the ‘@’ (though I don’t know why that should be a problem?). It still did not work. What is going on here? What is the criteria it is using to check for a valid email address? How do I override it? This add-on is useless if it will not let me import users with email addresses.

      Please help. I am now sitting idle trying to get this to work.

      • antonio March 6, 2015 at 6:13 pm #

        Hi,
        the plugin uses the wordpress ‘is_email’ function available in wp-includes/formatting.php
        I honestly see no problem with that email, if you want you can send us the txt file to support at itthinx dot com and we’ll test the file.
        Regards

        • EGFS March 6, 2015 at 6:17 pm #

          Thank you. Thank you. Thank you Antonio for responding. My comments seemed like they were stuck in moderation permanently. Thank you for responding.

          I would be happy to send you the TXT file right away.

          BTW. Before yesterday I don’t remember ever having my comments ‘awaiting moderation’, is that something new or did I just not notice it before? It’s a LOT harder waiting when you don’t think anyone is even hearing you.

          • antonio March 7, 2015 at 10:34 am #

            Thanks,
            answered by email (It seems there is a hidden character at the beginning of the file)
            Regards

            • EGFS March 9, 2015 at 11:16 pm #

              Thanks for the clue Antonio. I discovered that the hidden character(s) is/are: Ôªø. I’m not sure what it is but I have an idea of how it came to be included.

              It is time-consuming to edit a tab-separated TXT file for hundreds of user accounts. So I create an ODS (OpenOffice spreadsheet) file to import/modify the user accounts. I save the file as a tab-separated CSV file and then change the extension to TXT. Somewhere in this process the ‘Ôªø’ character(s) get added.

              After doing some more research, it appears that the characters are a very hard to detect ‘UTF-8 byte order mark’, which appears to be an encoding error. These characters seem to be added by MacOS when I change the file extension from CSV (the format saved from OpenOffice) to TXT, the ‘Groups Import Export’ requirement.

              I’m working on a workaround solution now. First thing to try is to see if the Groups Bulk Import tool will allow a tab-separated CSV file. That would solve the problem right away.

              • EGFS March 9, 2015 at 11:52 pm #

                I found the solution and it turned out to be pretty simple. The tab-separated file does NOT need to be TXT, it can be a CSV file. This means that I can create/modify the user accounts in the OpenOffice spreadsheet and save it as a tab-separated CSV file and upload without issue.

                It seems that any open/save operation after the initial save of the CSV causes the file to be ‘spoiled’ and fail on upload.

                Issue solved. Thanks for your help.

                • antonio March 10, 2015 at 6:50 am #

                  Perfect 🙂
                  thanks for sharing your solution.

    • EGFS March 6, 2015 at 12:35 pm #

      Please review my comments and provide some assistance regarding this problem. Much of my project is on hold waiting for this to be resolved. I have a large number of users to setup and migrate.

  8. EGFS March 6, 2015 at 3:36 pm #

    What is going on? I have been leaving several comments but they all say ‘awaiting moderation’ and do not change. This is my only avenue to get my issue resolved. Someone please respond.

    • antonio March 6, 2015 at 6:18 pm #

      Hi, please have a look to support conditions.
      Regards

      • EGFS March 6, 2015 at 6:27 pm #

        I have. I’ve been living on that page, scouring it, trying to find any way to be able to contact someone about my comments in moderation. It talks about ‘preferential treatment’ in the forums, but there are NO forums for Groups or related extensions. It also mentions that emailing support will not be tolerated. Then it seems the ONLY method of contact is the plugin comments. I even posted on the ITthinkx Facebook page in the hopes of getting someone’s attention.

        As I mentioned in another comment, I don’t remember having my comments in moderation before, maybe I didn’t notice it. But when you see, “awaiting moderation” it’s like getting a busy signal on a phone call as opposed to leaving a voice mail. With a voice mail you have a reasonable expectation that your message will eventually be heard. If you only get a busy signal then you have no expectation of response because your message hasn’t even been delivered.

        • antonio March 7, 2015 at 10:43 am #

          We will consider to improve suporte.
          Thanks

  9. Aj March 6, 2015 at 3:40 pm #

    Hello. I’ve left several comments since early yesterday about a serious problem with the Group Import Export extension and every time I come back to check on the status it just says that my comments are ‘awaiting moderation’. Could somebody please look at the comments from ‘EGFStech’, release them from moderation, and respond? My project is on hold while I wait to get this issue resolved.

    Thanks.

  10. Andreas March 9, 2015 at 11:48 am #

    Hi! I just purchased your plugin in the hopes of solving this scenario:

    We’ll have a Group of around 100 members, which we’d like to export to a simple list, print, and bring to a music festival and be able to cross out people names as they turn up.

    However, I can’t seem to limit the plugin to only export first_name and last_name, that’s all we need. As it is now, all the information that gets exported makes it really hard for me to use.

    – Is it possible to only get a persons first and last name when exporting?

    • kento March 9, 2015 at 5:30 pm #

      Hi Andreas,

      This is a solution: go to Groups > Export Users, choose the desired Group and under Profile check the options Include extended user profile data and Include a column header, click in the field where the profile data fields are shown and press Cmd + A / Ctrl + A to select all and press Delete to remove all. The exported file will contain the data which you can easily edit as a spreadsheet to leave only the first and last name columns.

      Cheers

  11. EGFS March 10, 2015 at 12:01 am #

    I was able to successfully import users from a tab-separated CSV file I uploaded. However, I noticed that the import did not honor the roles listed in the CSV file? It set all of the imported users to ‘Subscriber’. Any ideas on why it would do that?

    • antonio March 10, 2015 at 6:51 am #

      In Groups->Import users you must select the groups.
      Remember that the import function add the users to groups, not roles (‘Subscriber’ is a role).
      cheers

  12. Osteomag June 23, 2015 at 8:47 am #

    I’ve just noticed we can ask questions here instead of the main page of Groups, so sorry if my question appears twice.

    So, I’m interested in purchasing Groups Import Export, but first I need some information.

    If I add multiple contacts in a group, does the plugin can automatically generate their logins and passwords ? It’s important for me to know, since I have about a thousand people in my database and doing it by hand would be really time consuming… Or maybe you have another solution to suggest me ?

    Thank you in advance for your answer !
    Osteomag

    • antonio June 29, 2015 at 9:24 am #

      Hi Osteomag,
      you can select to send the passwords to the user’s email (passwords will be generated by wordpress). Please have a look to the documentation page to view the import file format.
      Regards,
      Antonio B.

      • Osteomag June 30, 2015 at 10:47 am #

        Thank you for your reply.

        We made some tests with Groups Import, and I have another question… Is it possible to configure the mail with their password to users ? For now, it’s a bit empty and not really appealing…

        • antonio July 1, 2015 at 6:21 pm #

          Hi,
          Groups Import uses the wordpress email registration. Maybe you can find a plugin to customize the welcome email.
          Regards

  13. MC August 9, 2015 at 7:02 pm #

    I’ve got a tens of thousands of subscribers and have them segmented in an external database (as I implemented groups only during the past year). How can I bulk assign users to specific groups so I can synchronize everything back? I want to do more group-specific messaging etc. I was thinking about doing the following: export my user list, vlookup against the Excel file I have, then (somehow?) import back again. Can this import/export do that? Do you have any suggestions? Much appreciated!

    • kento August 11, 2015 at 12:08 pm #

      Hi,

      Yes you can do that with this extension. If you’d like to have a look at the documentation page where you will find details on the process.

      Cheers

      • kento August 11, 2015 at 12:10 pm #

        PS By “that” I mean export and import again, I can’t say if there are any particular requirements that aren’t covered, but basically if you can map them to groups outside and then re-import, that should be an option. Feel free to ask if you have any questions related to what you see in the documenation.

      • MC October 24, 2015 at 10:01 pm #

        So, after weeks of testing the import/export plugin, I cannot get around one show-stopper issue: how to STOP the plugin from updating the users’ passwords… I disabled the send password via email option but the password still got changed? I basically want to add users to a new group via the import, that’s all. How can I disable the password reset functionality completely? I want to quietly update a user and give them access to new groups but not touch their password. I tested this on a staging environment with only Woocommerce, Woocommerce Groups, Groups and the Import/Export plugin active. Everything else was switched off. Please let me know because without disabling the password change functionality I cannot use it in my live environment. Thanks!

        • Kento October 26, 2015 at 5:24 pm #

          Hi,

          If you want to add new users you need to indicate the password and it would be recommended to send them the email notification. For users whom you only want to update, you should omit the password field. You can simply do this with two different imports, one file you use for new users and another one for those you want to update.

          Please let me know if that helps or you need further help.

          Cheers

          • MC October 30, 2015 at 12:36 pm #

            Hi Kento,

            I have a feeling you may not have fully understood what I was trying to say. Fortunately, John Arcadian did explain it better than I could. It was exactly the same bug which you say has now been fixed, per: http://www.itthinx.com/plugins/groups-import-export/comment-page-1/#comment-691770

            So I’ll go and test the new version again now.

            Really concerning though that this bug has had such a business-destroying impact. I’m so grateful (to myself) for testing this out in a UAT environment and more importantly not with real users. Otherwise, it would have been a complete drama.

            Thanks. I’ll report back if it still doesn’t work.

  14. Eivind August 28, 2015 at 9:36 am #

    Hi! I’m having trouble with the import.

    First, it seems like files saved by Microsoft Excel (on Mac) won’t get accepted, for some reason. I haven’t been able to figure out why. Also, there might be a problem with special (norwegian) characters (æ,ø,å). Do you have any recommendation for this?

    Secondly, I can’t get the system to accept meta fields. Here’s my test import file:


    @user_email first_name last_name meta:user_adresse meta:user_telefon meta:user_postnr meta:user_poststed
    importtest1@domain.no Festus Hestus Gateveien 99999999 9122 Stedplassen
    importtest2@domain.no Bentson Flistus Veigata 88888888 9911 Plassestedet

    The email, first and last name are saved, but none of the meta fields. The meta names (e.g. “user_adresse”) corresponds to meta fields already created (and working fine in other parts of the system).

    Do you have any input on what might be wrong?

    Thanks!

  15. Kevin K October 27, 2015 at 12:40 am #

    I noticed there is no field (or discussion of) a Company field. All affiliates are companies, not individuals. I need to reflect a Company name on the landing page. I previously asked this question and it was answered, but with a user login. I need to import 6 fields: FName, LName, Company, Email, Website URL, and Telephone. This is the most basic info necessary to manage any program.
    1. Can I import these 6 fields and display them if I create these (custom) fields in the software to receive this data?
    2. Why does the software not mention landing pages .. it just assumes a home page landing .. and then gives that URL ID for affiliate. I have a custom landing page just for affiliates. What is the URL extension for an affiliate landing page called “www.domain.com/Apply”?

    • Kento October 28, 2015 at 7:58 pm #

      Hi,

      You can use the column order declaration and indicate meta fields – see this section in the documentation.

      Please use this premium support area for further help on this plugin. There’s also a space for the Affiliates Pro and Enterprise plugins. And for your question, you can use any of the shortcodes that produce an affiliate URL, see the related plugin’s section on the Documentation site please, for example affiliates_url.

      Cheers

  16. John Arcadian October 28, 2015 at 1:40 pm #

    I’m having a big issue with this plugin. Every time we try to upload and update users into a group, it generates a “Your Password Has Been Changed” notification and changes the user’s password. We’ve been importing with just an @user_email field and we only want to bulk add users to groups based on a list of emails we’ve got.

    How can we get the program to not update the user password, and if that is not possible, how do I get a refund as this plugin no longer supports the functionality we purchased it for.

    • Kento October 28, 2015 at 7:10 pm #

      Hi John,

      This sounds very similar to a question I have already responded to two days ago. See this reply. Also note that we have a premium support forum for this plugin which is here and where those questions should be posted. If you continue to have difficulties trying to import, please open a support topic there and we will help you further. In that case, please make sure to provide enough detail about the data you are trying to import and we might also ask you to provide admin access and an excerpt of the data file you need to import so we can run tests on it ourself and help you to successfully import it.

      Cheers

      • Kento October 28, 2015 at 7:36 pm #

        BTW if you import users and have the option to update existing ones enabled but have not indicated a password, then a new password *will* be generated. To avoid that, you can indicate the column order and omit the password field, expand the help tab on the Import Users screen, also refer to the File Format section in the documentation.

      • John Arcadian October 28, 2015 at 7:36 pm #

        Hi Kento,

        The link to that comment does not load anything. I searched the comment ids and could not find that comment number either.

        • Kento October 28, 2015 at 7:39 pm #

          Thanks John, the link works for me, anyhow, if you have a look at my replies from just a moment ago I think you should be able to complete the import successfully.

          • John Arcadian October 28, 2015 at 7:42 pm #

            We tried that option. So I should be able to set the column @user_email and add to group using just the user email without updating the password? Because that is how we tried it and that is what updated everyone’s password.

            • Kento October 28, 2015 at 7:46 pm #

              An example of an import file for that looks like this:

              @user_email groups
              bart@example.com Banana
              homer@example.com Apple

              It will simply add the users to the corresponding groups. You’ll need to check the appropriate import options when importing the file (update users, create groups, …).

              • Kento October 28, 2015 at 7:47 pm #

                PS : Note that there should be a tab between the email and group.

  17. John Arcadian October 28, 2015 at 7:52 pm #

    That is exactly the format I am using that doesn’t work.

    @user_email groups
    test1@testemail.com Groupname
    test2@testemail.com Groupname
    test3@testemail.com Groupname

    It still changes the password every time.

    This notice confirms that your password was changed on *******

    If you did not change your password, please contact the Site Administrator at
    *******

    This email has been sent to test1@testemail.com

    If you need me to open a full support therad, I’ll do that, because I am doing everything per the instructions on the page and per your instructions here and it updates the password every single time.

    • Kento October 28, 2015 at 8:09 pm #

      OK that shouldn’t happen, I’ll check and let you know. You don’t need to open a support topic for that right now, I’ll follow up here.

      • Kento October 28, 2015 at 9:00 pm #

        Hi John,

        There was a bug that was causing this which has been fixed in the version just released. Please update the plugin to this latest version. Many thanks for pointing out the issue!

        Cheers

    • MC October 30, 2015 at 12:37 pm #

      Just to say thanks John. This is exactly what I was struggling with!

  18. Golibe June 13, 2016 at 11:52 pm #

    I’m having a bit of difficulty with the import function. I tried to import a list of 407 people in a txt. file.

    Whenever I would try to import, even though I would edit import limit to accommodate the number of users I wanted to import, it would only import 75-100 users per attempt. I basically had create several txt. files and do multiple imports for something that should have been quick and pain free. Does anyone have insight on a fix for this since I plan on using the import function a lot in the the coming months.

    • Kento June 20, 2016 at 9:04 am #

      Hi,

      You can use the same file to import them in several rounds as the existing ones will be skipped. This is due to PHP memory and execution time constraints. Simply use the same file and it will create the ones that haven’t been added before.

      Cheers

  19. Marc Getter June 15, 2016 at 8:37 pm #

    I’m trying to determine the correct licensing level for our usage. We have one site, but it will live on 3 servers. Development, UAT, and Production. Do we need to purchase a single license or multi-install license? We ill be purchasing both the import export and the restrict categories extensions.

    • antonio June 17, 2016 at 10:05 am #

      Hi Marc,
      please have a look at the license page.
      Thanks,
      Antonio B.

  20. Tammie June 22, 2016 at 5:47 pm #

    If a plugin is purchased, are upgraded included for free, or will I have to pay again for new versions?

    • antonio June 23, 2016 at 4:50 am #

      Hi Tammie,
      You will have available a year of upgrades, please have a look at the Terms and Conditions page.
      Kind Regards,
      Antonio B.

  21. Andrei G November 4, 2016 at 12:24 am #

    Hi,

    Is there any reason why the export does not include the user ID?

    I need the user ID to tie users with data from other files based on other user meta.

    Any workarounds for getting the user ID in the export file?

    Thanks

    • antonio November 4, 2016 at 12:05 pm #

      Hi Andrei,
      really the user’s id is not exported because if you import this file, you could have these ids already stored.
      You could customize the plugin to add the user’s id in the groups-import-export/lib/core/class-groups-user-export.php around line 134. But remember that if you change this file, when you update the plugin, the changes will be lost.
      Kind Regards,
      Antonio B.

  22. Chris November 10, 2016 at 4:44 pm #

    Hi there plugin seems good but is there a way that instead of already generating a password on the email the user can just click the link to create a password? similar to the wordpress users when you create a new one. i.e click here to change password? Also i read alot if i update the users there password changes? does this still happen?

    • antonio November 10, 2016 at 8:37 pm #

      Hi Chris,
      the plugin uses the wordpress welcome email system. If you find a plugin to send the reset password on the welcome email, this should work. Sorry, I don’t know any plugin.
      Kind Regards,
      Antonio B.

  23. spravocnikpolekarstvam.ru February 6, 2017 at 7:40 am #

    On the Groups page, use the import and export functions to add new users and groups. However, you can’t remove users or groups. Also, you can’t add new users to your course during these processes.

    • antonio February 7, 2017 at 3:34 pm #

      Hi,
      You can use the bulk action available above the users table (Users->All Users) for remove users from groups.
      Remember that you have available a ‘test’ option in Groups->Import Users if you need to test the function.
      Kind Regards,
      Antonio B.

Leave a Reply