Import Approved Users - September 2024
complete
Amrayu78
Hi Max,
Please help import approved users (filter column K = Y) for users registered in August 2024.
Users are still having issues with the webform, it's getting less and less frequent, but still it still occurs for some users.
Due to the registration page causing issues, I had to create a temporary Google form to collect registrations.
There's 2 tables used for user registrations, I think one is the default WP one and the other is from BuddyPress. Please check my note about wp6y_bp_xprofile_data below.
Default WP table: wp6y_signups
-user_login
-user_email
-registered
wp6y_bp_xprofile_data - is the BuddyPress table.
I'm pulling the following fields:
-last_updated
-display_name
-Credential
-FaveJdrama
This is the Google sheet, tab--Google Responses:
https://docs.google.com/spreadsheets/d/1UkruDyoqRd-Zp_ZbvvCV_dQsMDtn02g8PNXs158zRA8/edit?usp=sharing
We need to import from the Google sheet only APPROVED accounts (check column K, Approve? Where cells are Y):
-Timestamp
-Email Address
-Username
-Password
-Name
-Credential
-What's your favorite Jdrama
Amrayu78
complete
Amrayu78
Hi Max Romanchenko: Can you help import these? Also if this is too burdensome, lemme know if you have a script and if you can write instructions for it and I can start doing it. Thank you.
Also sent you something via PayPal.
Max Romanchenko
Amrayu78 Hi Duong,
I imported 50 new users. Unfortunately this requires several steps - working with the Excel table (removing unnecessary data, formatting the timestamp to the Wordpress date format, renaming the table fields), then I run the code (it's not active right now) and test one row from the table. If everything is ok, I proceed with importing the rest of the users. That's all ok, I can do it for less, don't worry about it.
I received the money, thank you for your kindness.
Thanks a lot!
Amrayu78
Max Romanchenko: Looks good! Thank you.