[johnE]

I found the solution, the member username had not been picked up from the bulk import so they all had the same username. Now fixed.

[johnE]

No;
the member bulk import is acccepting a status as active;

but when the status is “activation_required” its imported as “pending”.

If I then mark it as actvation required no email is sent;
However if the user then tries to log in they get an “activation required … click here to resend the activation email”
and on clicking an activation email is sent .

Following the link activates their account and they get an account active email – but on the email the password field is blank;

however they can at that point follow the forgot password link if necessary to get a new one.

So basically, the main issue is the incorrect import of an “activation required” status

here is the field from the csv file (using Libre Office as Excel corrupts the date fields)

account_state
active
activation_required

[johnE]

I can write an email to johnlerrington+test127@gmail.com and it is received – but no activation email from the wpforms system has been sent.

If I import with “notify” ticked they get a notification email.

test126 – showing as active – can log in without having received an activation email.

[johnE]

I’m using the bulk member import tool with this sample file based on your example

user_name,first_name,last_name,address_street,address_city,address_state,address_zipcode,country,email,phone,subscription_starts,member_since,membership_level,account_state,last_accessed,last_accessed_from_ip,gender,referrer,reg_code,txn_id,subscr_id,company_name
test126,ZAdam,Buckham,123 malibu street,California, ,12333, ,johnlerrington+test126@gmail.com,12345678,30/03/2020,30/03/2020,2,active,,,female, ,,,, 
test127,Zfred,Bloggs,,,,,,johnlerrington+test127@gmail.com,12345678,18/08/2020,30/03/2020,2,activation_required,,,,,,,,

Test126 is entered as “active” and test127 as “pending”

[johnE]

I found the answer; on our installation bulk member EXPORT shows the date in UK format;

example: 28/07/2020

HOWEVER bulk member IMPORT requires the date in ISO format https://www.w3.org/QA/Tips/iso-date

(formally YYYY-MM-DD, but bulk member import seems to accept YYYY/MM/DD )

when I put the date as 2020/08/18 the member list is imported correctly.

May I respectfully suggest this issue would likeley not have arisen if the template file included dates?

[Author]

Posts