member badge
Amrayu78
Hi Max,
Please help import approved users (filter column K = Y) for users registered in November 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
Import from the Google sheet only APPROVED tab accounts (check column K, Approve? Where cells are Y. Ignore orange highlighted lines as those are dupes. Use timestamps for November 2024):
  • Timestamp
  • Email Address
  • Username
  • Password
  • Name
  • Credential
  • What's your favorite Jdrama
Import from the Google sheet APPROVED ARDUOUS tab for timestamps for November 2024. Use the following fields:
  • Timestamp (column A)
  • Email Address (column B)
  • Username (column L)
  • Password (column M)
  • Name (is name needed? You can reuse Username)
  • Fave Jdrama (column N)