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

123 Responses to Groups Import Export

  1. Teunis October 11, 2021 at 9:47 am #

    Hi, A pre-sales question here. To what format does the plugin export? CSV? My client needs to export the users of seperate groups to seperate Excel files. Is that possible with this plugin?

    And/or is there a trial version available for him to test?

    • Kento October 11, 2021 at 3:16 pm #

      Hi, thanks for asking!

      Please have a look at its documentation where you can find details on the extension and its formats. We don’t offer a trial but our terms allow for sufficient time to evaluate.

      Cheers

  2. Yaser May 6, 2021 at 10:22 am #

    My problem is solved, thank you

    • Kento May 6, 2021 at 2:03 pm #

      Great to hear, thanks!

  3. facearz January 6, 2021 at 2:14 pm #

    Hi
    It seems to be very useful but unfortunately I could not use it for my purposes.
    Can you guide me? Thanks for your reply

  4. عرضه و تقاضا چیست December 31, 2020 at 4:10 pm #

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

  5. Floutsch September 9, 2020 at 11:04 am #

    Bought and used Groups Import Export (commented before, too). The decision was made not to send out paper mail with the credentials but to fall back on the way it happens when a user is manually created in the backend: Sending them a mail in which there is a link that leads to a password creation prompt.

    For that I have made a plugin that overrides wp_new_user_notification so that I can customize its content. I expected Groups Import Export to use this as well. It doesn’t. You use a private function in class-groups-user-import.php of the same name. I understand that might ne neccessary to send the full credentials but an option to just use wp_new_user_notification as provided by the system would be nice. In that case my plugin would do the rest. This could be done as a dropdown instead of the checkbox that could contain “Send new users their password by email.” and “Send mails with activation link (WP default)” or something.

    If you’d like to discuss this you can also hit me up via email, although right now I’m frantically busy.

    Don’t get me wrong, I’m not angry or anything! Quite the opposite. I just want to share my user experience and make suggestions. Aside from the very fixable (not beautiful, though, modified your plugins source in said file) mail content issue this plugin was a life saver and very easy to use!

    Cheers
    Floutsch

    • Kento September 21, 2020 at 1:51 pm #

      Hi Floutsch,

      Thanks for sharing your approach to it, actually you have a couple of filters that you can use instead:

      groups_import_export_new_user_registration_subject
      groups_import_export_new_user_registration_message

      With those you can customize both the subject and content of the notifications that are sent out, so you don’t need to hack the extension itself. You will find those filters documented here: API

      Cheers

      • Floutsch September 23, 2020 at 7:09 am #

        Hi Kento,
        did this in a rush, but that’s certainly welcome! Thanks for pointing to it.

        I’d still like to suggest an option to just use the regular mail. Which, of course, wouldn’t make sense if a password were created.

        Cheers
        Floutsch

        • Kento September 28, 2020 at 4:44 pm #

          Hi,

          I hope that makes it easier for you 🙂 Also thanks for the suggestion, I can’t remember exactly right now but there must have been a good reason to do it the way we are, but I’m certainly taking note of your suggestion to review it.

          Cheers

          • Franz Josef January 11, 2021 at 4:17 pm #

            Hi Kento.
            Finally got around to approaching a cleaner soution using the filters 🙂 When I ran into problems I made sure that I use the most recent version 1.2.5 which is unchanged so that my earlier hack won’t interfere in any way.

            For normal user creation (manually, not using Groups Import Export), I overwrite the standard WordPress function wp_new_user_notification. To be able to just get the mail content for groups_import_export_new_user_registration_message I created a secondary function wp_new_user_notification_content that assembles the actual mail content. Because it provides some more user information it requires to be passed the user ID.

            Now, I may be misunderstanding “The filter receives the default subject, the user ID and the plaintext password” in the documentation – I expected to be able to use the ID of gthe created user. But only one parameter is passed and that is the message. The following example illustrates my expectation:

            function wp_new_user_notification_content_wrapper($message, $user_id, $plaintext_pass) {
            return ‘[message=’ . $message . ‘] [user_id=’ . $user_id . ‘] [plaintext_pass=’ . $plaintext_pass . ‘]’;
            }
            add_filter(‘groups_import_export_new_user_registration_message’, ‘wp_new_user_notification_content_wrapper’);

            This will produce: “Uncaught Error: Too few arguments to function wp_new_user_notification_content_wrapper(), 1 passed in … and exactly 3 expected”

            If neither the ID nor the password are passed, that seriously limits the usefulness of that filter. What to do now?

          • Floutsch January 12, 2021 at 12:02 pm #

            Hi Kento.
            Finally got around to approaching a cleaner soution using the filters 🙂 When I ran into problems I made sure that I use the most recent version 1.2.5 which is unchanged so that my earlier hack won’t interfere in any way.

            I had posted again but by accident as the user we bought the license with instead with the one I started the thread with.

            May I suggest additionally passing the filters you mention the user ID?
            At the moment I preg_match out the username from the message, resolve it to the user’s ID, pass it to my function, create the new message and return that. Ugly but it works for now.

            Just for the record, here’s the rest of my original comment, but that’s moot:
            ——————————————————————————–

            For normal user creation (manually, not using Groups Import Export), I overwrite the standard WordPress function wp_new_user_notification. To be able to just get the mail content for groups_import_export_new_user_registration_message I created a secondary function wp_new_user_notification_content that assembles the actual mail content. Because it provides some more user information it requires to be passed the user ID.

            Now, I may be misunderstanding “The filter receives the default subject, the user ID and the plaintext password” in the documentation – I expected to be able to use the ID of the created user. But only one parameter is passed. The following example illustrates my expectation:

            function wp_new_user_notification_content_wrapper($message, $user_id, $plaintext_pass) {
            return ‘[message=’ . $message . ‘] [user_id=’ . $user_id . ‘] [plaintext_pass=’ . $plaintext_pass . ‘]’;
            }
            add_filter(‘groups_import_export_new_user_registration_message’, ‘wp_new_user_notification_content_wrapper’);

            This will produce: “Uncaught Error: Too few arguments to function wp_new_user_notification_content_wrapper(), 1 passed in … and exactly 3 expected”

            If neither the ID nor the password are passed, that seriously limits the usefulness of that filter. What to do now?

            • Kento January 15, 2021 at 5:09 pm #

              FYI I just replied to the earlier comment you left, you’ll see the solution there.

              • Floutsch January 16, 2021 at 6:30 am #

                Hi Kento.
                Thank you. Very much! Indeed what I missed was the parameters for the filters. I’m kinda ashamed of that… So I wouldn’t mind if you deleted my comments about that 🙂

                All mails get filtered appropriately by now. No just the ones from Groups. This is working really well and in regards to Groups Import Export I have to say that I really love the plugin. All’s set to use that multiple times now, expect some sales in the future! 😀

                Highly appreciate your help!

                • Kento January 20, 2021 at 1:55 pm #

                  Hi Florian!

                  Awesome, great that everything is sorted out now! Everything has a process, making errors is just an essential part of doing and that’s a very good thing. Thank you so much for using our tools!

                  Cheers

  6. Set Farley September 2, 2020 at 10:12 pm #

    I’d like to import a list, and have those users removed from a group. Is it possible?
    Looking at the product screenshots, I didn’t see an option to do this. Thanks, really appreciate it!

    • Kento September 4, 2020 at 9:33 pm #

      Hi Set, good question! I guess you could achieve that by removing users from groups and then adding them back to those that they should belong to. Cheers!

  7. Chris August 24, 2020 at 4:55 am #

    Hi, I accidentally bought two licenses instead of 1, can you please refund the other one. Thanks!

    • Kento August 25, 2020 at 11:46 am #

      Hi Chris,

      Sure, done and many thanks for using our tools!

      Cheers

  8. Floutsch August 18, 2020 at 1:56 pm #

    Hey there,
    is it possible to import a list of users including passwords? Passwords would be individually created but we need to send them out in paper mail and not have mails sent while importing. And for the mail merge we obviously need to know the created passwords.

  9. کسب درآمد میلیونی October 24, 2019 at 5:53 pm #

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

    • کسب درآمد میلیونی October 24, 2019 at 5:56 pm #

      It was so good

    • Kento October 25, 2019 at 11:51 am #

      Hi,

      It allows to include metadata related to user profiles, among which there is also information on the duration of the membership. It doesn’t export termination jobs though, which is an internal way of processing the memberships and making sure that they are ended in due time, but Groups WooCommerce also checks “skipped” terminations so it should still work fine. You would have to make sure that group IDs match though, otherwise it wouldn’t be able to relate them properly.

      Maybe for your case, a full database export and import would be more appropriate if that is an option. I would recommend to try that first.

      Cheers

  10. mahdesarmaye October 21, 2019 at 9:47 am #

    It was so good
    I used this article
    thanks

    • Kento October 22, 2019 at 9:11 am #

      Great to hear it is useful, thanks!

  11. آموزش بورس August 20, 2019 at 4:03 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 August 21, 2019 at 10:52 am #

      Hi,

      Yes that would work as long as you make sure to include the appropriate meta fields in the export. In the Export section, there are several options that allow to include extended profile data and a field where metadata that should be included can be selected. There are several keys related to groups which would need to be included. You can find some more detail on that on http://docs.itthinx.com/document/groups-import-export/export-users/

      Cheers

  12. Martin April 1, 2019 at 1:06 pm #

    Hi, I am thinking about buying this. But is it possible to schedule imports with cronjobs?

    • Kento April 1, 2019 at 8:56 pm #

      Hi Martin,

      I think we had a similar request some time ago, but I’m not sure if this ended up in a solution. I’ll ping a team member to check …

      Cheers

      • Kento April 1, 2019 at 9:03 pm #

        The solution was related to exporting, so unfortunately not useful for what you want to achieve. How would you want to go about importing with a cron job, from a specific URL?

        • Martin April 2, 2019 at 6:30 am #

          Hi, yes excactly. Would make the import from a external URL.

          • Kento April 6, 2019 at 1:41 pm #

            Thanks Martin, I’ll take it into account as a suggestion for a possible future enhancement. At the current version I don’t see an easy way to accomplish this unfortunately.

    • Pascal Dubois July 2, 2020 at 2:48 pm #

      Hi,

      I’m considering purchasing the Groups Import & Export plugin, however, I need to import the file from a specific url for an daily update. Is it possible now ? Best regards

      • Kento July 10, 2020 at 12:09 pm #

        Hi Pascal,

        It hasn’t been added yet but we should look into the possibility again. Considering that the possibility to run a scheduled job that periodically runs imports can make sense in some cases, I think it should be an accepted feature request which we can schedule for addition. Done that, I can’t give an exact ETA to have it added yet but it shouldn’t take long.

        Cheers

  13. Gen March 19, 2018 at 2:24 pm #

    Hi,

    I’m considering purchasing the Groups Import & Export plugin, however, I need to know if it will handle my needs.

    I need the following functionality, please let me know if the plugin can support this:

    On a given input file:

    – Create new users ONLY if needed (ie: the file I’m uploading will have usernames, these names MAY already exist, if they exist then they should NOT be created, but if they don’t exist they should be created)
    – Create groups if needed (again, the group may already exist)

    The data I’m getting from my client will be a couple hundred rows, each looking like:

    user_name user_email group

    So I may have:

    user1@example.com user1@example.com GroupA
    user1@example.com user1@example.com GroupB
    user2@example.com user2@example.com GroupB
    user3@example.com user3@example.com GroupC

    In this example, it would need to create up to 3 users (the user might already exist), and then create & assign up to groups (again, might already exist).

    • antonio April 1, 2018 at 6:45 am #

      Hi Gen,
      You can do it, please have a look at the ‘update ecxisting users’ option, in the documentation page.
      You can use the ‘test’ option before, also we recommend make a full backup before.
      Kind Regards,
      Antonio B.

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

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

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

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

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

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

  20. 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!

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

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

  23. 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!

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

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

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

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

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

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

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

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

  32. 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’ …

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

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

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

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

Leave a Reply

We use cookies to optimize your experience on our site and assume you're OK with that if you stay.
OK, hide this message.

Affiliates · Contact · Jobs · Terms & Conditions · Privacy Policy · Documentation · Downloads · Useful Plugins · My Account

Share