Manually creating profiles on DataBase
I've got a spreadsheet of contacts with all details needed to create profiles on my UNA platform. I've written sql script to insert rows into the 'bx_persons_data' table. my questions is how to link these profiles to the 'sys_accounts' so that I can create accounts using their email address and full name, then link these email accounts to their profiles.
LeonidS can you help me with a sample sql script that will insert a new row in the sys_account table using an email address and full name, then linking this to the corresponding row on the bx_persons_data for the rest of the profile information?
-
Hello Scholar !
The bounds between accounts and profiles were described here https://github.com/unaio/una/wiki/User-Profiles
so you need to insert the record to sys_accounts, then to sys_profiles, and then only to bx_persons_data table.