Not able to create new groups when importing

—

by

Joel

Hi,
I just tried importing a group and the import seems to have worked fine except new groups were not created on import. Everyone just ended up in the “registerd” group. I think I followed the directions correctly, and the last column in my file is called “groups” and I have people belonging to several groups each with the names of the groups separated by commas. Can the group names have spaces in them? Maybe that is the problem? Thanks for any help.

Posted in

Comments

5 responses to “Not able to create new groups when importing”

  1. George Avatar
    George

    Hi Joel,

    Try this if you like.
    First, do an export for one user. Make sure to check the options Use separate columns and Include a column header (recommended if separate columns are used).
    Then modify this file, enter the values you like and be sure to press tab for seperating values. If you don’t want to enter a value for a column, press tab twice. Save the file and import it checking the options for Update existing users and Create new groups if they do not exist.. Yes group names can have a space.

    Kind regards,
    George

    1. Joel Avatar
      Joel

      Even basic importing from the exported file doesn’t work. It says user_email is “not a valid email. In other words, I can’t have header info. You can’t start a cell in excel with “@” symbol so I’m stuck trying to do this in notepad. I put in the @ and when testing import it gives me a notice that the order of the headers have been changed, but it always removes the last column. I have tried to get this simple thing working now for two days and I’m over it. It’s unusable for my needs. I’m putting in a refund request to paypal.

      1. kento Avatar
        kento

        Hi Joel,

        The tool works correctly if you provide a file using the correct input format.

        Example input file testgroup.csv:

        @user_email groups
groups.test@example.com	Testgroup
groups.test2@example.com	Testgroup

        Import settings

        testgroup-import-users

        Import results

        testgroup-results

        Users created

        testgroup-users

        As you can see in this example, you just need to use the appropriate input formats, probably that’s what’s been missing for you to complete the import successfully. In any case, we’ve refunded the order for you.

        Cheers

  2. Joel Avatar
    Joel

    Is there a template or specific instructions on how to do this in Excel or Open Office? This import seems totally buggy. I can manually type things into a text editor program, but when I do this in Excel and save as a .txt file-even when I open it in the text editor to check. Everything looks fine there but on import I have problems. Going on 8 hours over here trying to get this to work.

    A basic Excel template would be a great thing to have. The example code does not copy and paste correctly into Excel. Only by exporting a user into a text file and trying to recreate the file in a basic text editor am I having any luck.

  3. Joel Avatar
    Joel

    To update-the “groups” column is simply not importing-regardless of if I try and create a new group or if I try and add people to a group that already exists-they only get put in to the “registered” group. All other columns seem to be importing correctly.

Share