-
- 834 Posts
I’ve imported a list of users from another database into the web_users _attributes db table, but they don’t show up in the web users section of the modx manager.
I’m guessing they still need to be associated with the basic web_users table, but how is that done?
Is it even possible to do this?
Content Creator and Copywriter
The web_users table has to have the username and password, and its ID has to match the InternalKey of the attributes table. Usually an import would insert into the web_users table first, get the ID, then insert into the attributes table. Only the email is really necessary; you can even use the email as the username in the web_users table.
-
- 834 Posts
Thank Susan,
I figured it would be something like that, but I was trying to avoid stuffing around trying to match ids in two separate lists, and imports.
So it seems like I have to do this:
1: Export the base web_user data table
2: Extract just the user name and password from my external non-modx user list.
3: Paste that into the exported web_users file.
4: Import that back into the web_users table.
5: Export that back out again as a csv/ data file.
6: Export the base web_users_attributes file.
7: Copy and paste the relevant columns from the external list into exported web_user_attributes file.
8: Grab the id numbers from the exported web_users file and paste them into the web_users_attributes data file making sure everything matches up with the rest of the data I previously pasted.
9: Then import that back into the web_users_attributes table.
ke sera
Content Creator and Copywriter