import users with table ‘usermeta’

Hi @raygrrr

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

Regards,

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!

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,

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!

Hi @raygrrr

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

Regards,

Many thanks again for your help!