Import members from csv

[Anonymous]

Hi,
I’m trying to import members from csv using the examples given on https://www.e-dynamics.be/wordpress/csv-import-members/, but somehow I get the error: “Not all required fields present.”. When I export a member I see differences in naming convention (lastname vs Last Name), but I also tried that and it was still refused.

This is what I have in my csv:
“lastname”,”firstname”,”email”,”membership”,“start_date”
“memberX”,”test”,”someone@mydomain.nl”,”Regular membership”,January 1, 2020″,”1″

According to the post I have all required fields and the error message is not telling me what it’s missing/expecting.

[Anonymous]

Oh it’s not the missing ” before January…already fixed that.

[Anonymous]

I also tried an expert to csv, edited with Notepad++ to remove the member ID and person Id and changed the name and email. Then trying import again it fails with the same error.

[Anonymous]

Okay i found that one ” was curly, so that fixed that, but now got the following issues. Members are now listed, but WordPress shows the following message:

WordPress database error: [Unknown column ‘user_url’ in ‘field list’]
INSERT INTO wpuf_uwp_usermeta (username, email, display_name, first_name, last_name, user_url, bio, user_id) VALUES (‘memberAtest’, ‘someuser@mydomain.nl’, ‘memberAtest’, ”, ”, ”, ”, 21)

[Anonymous]

I think that latest thing is related to the automatic creation of WordPress Users and bites with the UsersWP plugin.

[Franky]

Must be, because EME only calls wordpress functions for the user creation, see the function eme_create_wp_user in eme_functions.php

[Anonymous]

Yes I gues so. It doesn’t seem to be an issue for now. If it does become an issue I’ll let the maker of that plugin know, because I think it’s on that part. They’re probably missing the column user_url.

Sorry for spamming the forum for just a silly ” mistake.

[Anonymous]

I just noticed that when using the same csv twice I get duplicate persons. According to https://www.e-dynamics.be/wordpress/csv-import-members/ I’m assuming existing persons should be updated?

[Anonymous]

Actually to be more correct: the duplication not happens in people, but in members.

[Franky]

Confirmed, can you check if this fixes it:
https://plugins.trac.wordpress.org/changeset/2255066/

[Anonymous]

Seems to fix it, though the message says: “Import finished: 1 inserts, 0 updates, 0 errors”. I expected: “Import finished: 0 inserts, 1 updates, 0 errors”.

[Franky]

yes, I forgot to update the message too …

[Anonymous]

The database error mentioned earlier is also happening when registering a member using a form on the frontend. It must be related to the creation of a WordPress User. FYI: I created a topic on the UsersWP forum: https://userswp.io/support/topic/plugin-compatibility-issue/

[Anonymous]

About the fix: if I add the field “paid” and import once with 0 and once with 1 then I still get 2 entries in members.

[Franky]

Btw, the next version will be much more strict concerning WP user linking:

Linking an EME person with a WP user will not be allowed if there’s another EME person matching the WP user’s firstname/lastname/email.
Linking an EME person with a WP user will change the person firstname/lastname/email to the WP user’s firstname/lastname/email and those fields can then only be changed via the WP profile of that person.

[Anonymous]

Okay sounds like a good thing. Would that be on a match on all 3 parameters or on just a single? From a WordPress point of view a double entry on email would be not allowed. 2 persons with the same first and last name and a different email would be a valid real life use case.

[Anonymous]

To be honest: the existence of double data due to the WordPress User and the EME person/member is actually the only thing I don’t like / where I don’t understand the design choice. Exactly for the reason of synchronisation and also for easier integration with other plugins. I do know that other plugins create seperate user roles for this. I guess there would be downsides on that design choice to, but as far as I can see now it offers more profit then it does harm. Well anyway I gues that’s a past station at the level of where EME is now 🙂

[Franky]

EME is there for events and for memberships for people that are not part of your WP setup too. I have several clubs I maintain, and those people are certainly not interested in having a WP account, they just want to pay their yearly membership.
Also, for your other question: it is the combo of the 3 parameters that needs to be identical (I understand that people can have the same name and different emails 🙂 ).

[Author]

Posts