Tips and Tricks HQ Support Portal › Forums › WP eMember › eMember – do not require member to click email link when creating members from
Tagged: bulk import, import
- This topic has 7 replies, 4 voices, and was last updated 7 years, 4 months ago by admin.
-
AuthorPosts
-
June 1, 2017 at 2:11 pm #14283exults_danMember
We were attempting to upload a CSV of additional members into our site, but it seems to be unsuccessful. We are getting an error message that the customer needs to click a link emailed to them complete the account.
Is there a way to skip this step and have all the new records just set to “active” instead of “pending”?
June 1, 2017 at 11:43 pm #75765wzpModeratorHow are you importing the additional members? Are you using this addon?
https://www.tipsandtricks-hq.com/wordpress-membership/bulk-member-data-importer-addon-853
If you need help with the addon, please read this:
June 2, 2017 at 4:52 am #75766exults_danMemberYes, we did use that add-on.
The error states:
“This account registration is not complete yet. It is waiting for the user to click on the unique registration completion link and complete the registration by choosing a username and password.”
The field ‘Account State’ is set to ‘active’.
June 3, 2017 at 12:08 am #75767adminKeymasterIf the username field value is empty then it will say that. Do you see a username value when you edit that user record? If it is empty then why is the username empty? Did you not import usernames?
June 5, 2017 at 7:10 am #75768exults_danMemberIt seems that it’s because we tried to use:
this:
WP eMember->Member Bulk Import
which I think comes with WP eMember.
We SHOULD HAVE used this:
WP eMember->Member Import & Update
I’m wondering if we can easily hide the first link in the sidebar?
June 5, 2017 at 12:11 pm #75769wzpModeratorHonestly, there probably is, but because we are talking about Admin menu functions; the “best solution” would be train the Admin(s), to use the correct menu choice. Otherwise, you’d be having to redo the menu change; every time the plugin is updated.
July 16, 2017 at 9:01 pm #75770MagicTHSpectatorMy real question is in the final paragraph if you just want to skip to that!
I can find no other import for members as mentioned above. That’s fine because I WANT the behavior that “exults_dan” doesn’t like (original post). HOWEVER, when I try to import the .csv file with no user_name it fails saying ‘duplicate user_name’ (I am using the demo file that comes with the plugin, but with two test members using my member IDs, etc.) The duplicate is duplicate null values.
Stranger than that it says it processed 3 records, but there are only 2 plus the header. If it’s counting the header and just ignoring it, fine. But it will not import blank user_name.
Then I tried giving it user_test1 and user_test2. It still says 3 records. It now says it has 1 fail on duplicate user-name. Looking at members afterwards, it imported user_test1 fine and failed on user_test2. I thought there might be a limit on number of characters in user_name, but user_test1 shows up in it’s entirety.
I am more than happy to just use phpMyAdmin, but when I use that everything is fine EXCEPT it needs a reg_code field to be filled out. I have another user pending and it has the value 59581e644ab67 in this field. Does it matter what’s here? Can I just make up my own (probably sequential) numbers? Is there a length requirement? If I can do this, I’m good to go because it happily accepts blank usernames.
July 17, 2017 at 2:41 am #75771adminKeymasterThe following page has a video tutorial that shows how to use emember bulk importer:
https://www.tipsandtricks-hq.com/wordpress-membership/bulk-member-data-importer-addon-853
That needs to be used for importing a full member profile so there has to be a username for every entry.
If you want to import records without any username then use PHPMyAdmin. You can use a sequential number for the rego code field.
-
AuthorPosts
- You must be logged in to reply to this topic.