Tips and Tricks HQ Support Portal › Forums › WP eMember › WP eMember General Questions › Bulk Membership Help needed
Tagged: wp emember. bulk import
- This topic has 4 replies, 2 voices, and was last updated 4 years, 4 months ago by
annib.
-
AuthorPosts
-
June 17, 2021 at 3:57 am #83178
annib
SpectatorHi,
I am struggling to fully understand the bulk importer. It sort of works, only that:
– the bulk importer seems to just ignore the membership level in the csv file (I tried both with level number and name), it is just left blank
– the bulk importer sets all newly imported member accounts as pending (the manually approve membership tick box is unticked)
– the reset password email is sent out and I have adjusted this to make sense to newly added members. However, they cannot sign in, as their account status is ‘pending’ and not ‘active’, therefore they cannot change their passwordI am using WP emember 10.3.5 and wordpress 5.7.2
Thanks
June 17, 2021 at 8:00 pm #83190admin
KeymasterIt usually happens if the CSV file has information that isn’t lining up correctly (in terms of what the importer is expecting). Better to do a test run with the importer with only 2 or entries first. It’s a very simple importer so it can fail if columns has been changed in any way or they are not lined up perfectly:
Can you post the URL of your CSV file so I can take a look to see if I can spot anything?
June 18, 2021 at 2:56 am #83193annib
SpectatorOK, thanks. I have sorted nearly everything now, but am struggling with the dates. It won’t take subscription starts or expiry dates at all, just reverts to the 70s. However, if I open each members individually and just click save, the correct dates are saved.
Is there a trick to this? Ideally I would either input the subs start date and the membership level determines the expiry, or I input the expiry itself
June 20, 2021 at 7:30 pm #83205admin
KeymasterThe format of the date is most likely causing the issue. The date needs to be entered in the following PHP Format (as shown in the CSV file example):
YYYY-MM-DD
So for example: a valid date value is the following:
2021-01-31June 21, 2021 at 2:18 am #83208annib
SpectatorThanks, I managed to sort the bulk import out and that is now working as expected.
Thanks for your help
Anni -
AuthorPosts
- You must be logged in to reply to this topic.