- This topic has 4 replies, 2 voices, and was last updated 3 years, 5 months ago by .
Viewing 5 posts - 1 through 5 (of 5 total)
Viewing 5 posts - 1 through 5 (of 5 total)
- You must be logged in to reply to this topic.
Support site for Tips and Tricks HQ premium products
by
Tips and Tricks HQ Support Portal › Forums › WP eMember › WP eMember General Questions › Bulk Membership Help needed
Tagged: wp emember. bulk import
Hi,
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 password
I am using WP emember 10.3.5 and wordpress 5.7.2
Thanks
It 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?
OK, 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
The 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-31
Thanks, I managed to sort the bulk import out and that is now working as expected.
Thanks for your help
Anni