Import approved users into database
complete
Amrayu78
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: Another task whenever you have time. Thank you!
Max Romanchenko
Amrayu78 Hi Duong, Thank you for the detailed description of the task. I have written a custom script for this task and already imported users. The task turned out to be a bit more complicated, because BuddyPress uses custom tables (as you pointed out). Hopefully soon users will be able to register in the usual way via frontend form to avoid this way of registration )
Amrayu78
Max Romanchenko: Thank you Max! I will try to avoid this method since it sounds so complicated, but I'm happy you managed to sort it out. Thank you!
Max Romanchenko
Amrayu78 Always happy to help.