Import not working because of Seperation Symbol


I just bought the very promising plugin Groups Import/Export that i want to use for a clients customer portal. The problem i run into is that i am working on a Dutch Windows PC. Here in the Netherlands we use ; as a symbol in our CSV’s. I am able to import into Excel the exported file from the website with the users, because than i can choose what the seperation symbol is.

When i want to save the xls file to a csv, i am not able to choose and i get the ; which is not recognized by the import/export plugin. I get the message “Error on line 8,;test;test;;test;;test;test is not a valid email address.” that’s because of the ; i believe.

Now i think i partly found a solution, but exporting the xls to a txt file with tab-seperation. But when i import this i only get 1 user added and i get a 500 error. When i refresh the users i see one user is added, but the group i want to create with this user is –. While i checked the “Create new groups if they do not exist.”

I really hope you can help me, because this plugin could help me a lot by creating the user lists for this company.

The files i used to try it out are:

CSV-file with ; as seperation
TXT-file with tab as seperation

One Response to Import not working because of Seperation Symbol

  1. George April 19, 2017 at 3:54 pm #

    Hi Dennis,

    The accepted file format is a txt file with tab separated values, so your second option is the correct one.
    The thing that worries me is the 500 error which probably means you run out of php memory. Try to increase it by adding a constant like this in your wp-config.php file:
    define('WP_MEMORY_LIMIT', '128M');
    Try this and let me know if the issue persists.

    Kind regards,

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