• Resolved raygrrr

    (@raygrrr)


    Hi I am planning to imports users by inserting data directly into table ‘users’ and ‘usermeta’, I can see table ‘usermeta’ is for storing user profiles, it all looks fine to me except for below 3 meta keys:

    synced_gravatar_hashed_id
    use_gdpr_agreement
    _wpnonce

    Please kindly suggest the general rules to setting those keys, many thanks!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor Champ Camba

    (@champsupertramp)

    Hi @raygrrr

    Could you please clarify what “General rules settings” means? Do you want to exclude those from being exported?

    Regards,

    Thread Starter raygrrr

    (@raygrrr)

    Hi @champsupertramp ,

    Thanks for your prompt reply! I want to import some existing users from a website to use ultimate member, what I was trying to do are:

    1) I have created some forms accordingly based on existing users’ data

    2) I created some testing user accounts via web pages

    3) I then go to checked on the database tables ‘users’ and ‘usermeta’ to see what data have been created so that I can prepare sql statments to insert those users directly into database.

    I found those rows have been created for all the testing accounts so I think I need to assign those properties for each user right? if so how do I decide what value I should put for each user? I guess property ‘use_gdpr_agreement’ is a mandatory field?

    I hope above description make sense and many thanks again!

    Plugin Contributor Champ Camba

    (@champsupertramp)

    Hi @raygrrr

    synced_gravatar_hashed_id – the value contains the hashed email to retrieve a gravatar. please see: https://en.gravatar.com/site/implement/hash/

    use_gdpr_agreement – the value is either 1 or 0.

    _wpnonce – I’m not sure how this being added by UM. Maybe it’s part of the WP core.

    Regards,

    Thread Starter raygrrr

    (@raygrrr)

    Hi @champsupertramp ,

    Thanks again for your help, that was very helpful, one more question about the field ‘use_gdpr_agreement’, I created two users and their ‘use_gdpr_agreement’ fields have values ‘1585041100’ and ‘1585041921’, which looks like a timestamp value, as their ‘timestamp’ field values are ‘1585041043’ and ‘1585041902’.

    Many thanks!

    Plugin Contributor Champ Camba

    (@champsupertramp)

    Hi @raygrrr

    Sorry, I just checked the value and it’s coming from the time() function:
    $submitted['use_gdpr_agreement'] = time();

    Regards,

    Thread Starter raygrrr

    (@raygrrr)

    Many thanks again for your help!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘import users with table ‘usermeta’’ is closed to new replies.