Import Approved Users - August 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 (IMPORTANT: I do not think this table is being used by buddypress anymore? I tried to export from this table and there's no entries for august, I had to pull these fields from the table wp6y_signups instead)
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: Hi Max, hope you're doing okay! Above is a new task, please take a look as there's something different with the tables... I'm not sure if the table wp6y_bp_xprofile_data is in use anymore.
Thanks
Max Romanchenko
Amrayu78 Hi Duong, thank you, I'm fine. I have successfully imported new users from the table for August (31 new users).
I double checked and can confirm that the wp6y_bp_xprofile_data table is still used by the BuddyPress plugin. As far as I understand the logic this table contains data of already registered and signed up users (see screenshot). It looks like wp6y_signups is a separate table for those who have applied for registration, but have not yet been approved by the admin. I think you exported everything correctly. Thanks!
Amrayu78
Max Romanchenko: Thank you!