Import approved users into database - July 2024
complete
Amrayu78
Hi Max,
Please help import approved users (filter column K = Y) for users registered in July 2024.
https://docs.google.com/spreadsheets/d/1UkruDyoqRd-Zp_ZbvvCV_dQsMDtn02g8PNXs158zRA8/edit?usp=sharing
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.
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
Max Romanchenko: New task whenever you're ready. Thanks!
Max Romanchenko
Amrayu78 Hi Duong,
I successfully imported 61 new users from the "Google Responses" sheet (July 2024). Please check it out.
Amrayu78
Max Romanchenko: Thank you! We'll check and let you know if any issues.
Amrayu78
Max Romanchenko: Everything looks good! Thank you.