Import New Users with Social Media Accounts - October 2024
Amrayu78
Please help import approved users (filter column K = Y) for users registered in October 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
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):
- Import users who applied in October 2024
-Timestamp
-Email Address
-Username
-Password
-Name
-Credential
-What's your favorite Jdrama
Amrayu78
Max Romanchenko: This is the highest priority right now. Whenever you have time, thanks!
Max Romanchenko
Amrayu78 Hi Duong, I apologize for not prioritizing this, didn't see your comment about it, and got caught up in other fixes on the site.
Done, I've imported the new users. Here are 3 users that were not imported because they already had accounts on the site.
WARNING Sorry, that email address
trzxhssy55@gmail.com
is already used!WARNING Sorry, that email address
gotons@gmail.com
is already used!WARNING Sorry, that email address
abdullah.auditore@gmail.com
is already used!Amrayu78
Max Romanchenko: Thanks Max! I'll let our users know. I will have another batch that will need importing later today. Thanks.
Amrayu78
Max Romanchenko: Hi Max, we have another set of users that need to be imported.
Please check the same google sheet and look for the "Approved Arduous" tab (after Google Responses tab) and import those users. Please run a dupe check to make sure there's no duplicate emails.
Please import the following:
-Timestamp (column A)
-Email Address (column B)
-Username (column L)
-Password (column M)
-What's your favorite Jdrama (column N)
Thank you
Max Romanchenko
Amrayu78 Hi Duong,
I've finished importing new users. A total of 143 new users.
14 were skipped:
-13 are duplicates, i.e. they are present several times on the “Approved Arduous” sheet (e.g. talia.sous01@gmail.com, galich.vasileva@gmail.com and so on).
- 1 user was created earlier.
WARNING Sorry, that email address
aozorahikari26@gmail.com
is already usedAmrayu78
Max Romanchenko: Thanks Max! Did you delete the duplicates from the Google sheet Approved Arduous tab?
Max Romanchenko
Amrayu78 You are welcome!
I saved the file locally and didn't touch the Google table
Amrayu78
Max Romanchenko: Can you email me the dupes so I can remove them from my list? Thanks.
Max Romanchenko
Amrayu78 Sure, replied to your email.