How to bulk import my users into Radicore? [message #4826] |
Fri, 10 July 2015 18:21 ![Go to next message Go to next message](/theme/default/images/down.png) |
rafs
Messages: 69 Registered: May 2015
|
Member |
|
|
In my old schema I have a 'users' table which was linked to the 'created_at', and 'updated_at' fields of almost every table in the database.
(1) In my RADICORE implementation, will I need to rename my table fields to 'created_date', 'revised_date', 'created_user', 'revised_user', in order to work seemlessly with the RADICORE auto-insert methods?
(2) If I want to do a bulk import of my user records directly in mnu_user table, what is the hashing algorithm used before storing, and after loading?
Thanks.
|
|
|
|
|
|
|
Re: How to bulk import my users into Radicore? [message #4832 is a reply to message #4826] |
Sat, 11 July 2015 04:39 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
AJM
Messages: 2361 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
rafs wrote on Fri, 10 July 2015 23:21In my old schema I have a 'users' table which was linked to the 'created_at', and 'updated_at' fields of almost every table in the database.
(1) In my RADICORE implementation, will I need to rename my table fields to 'created_date', 'revised_date', 'created_user', 'revised_user', in order to work seemlessly with the RADICORE auto-insert methods?
(2) If I want to do a bulk import of my user records directly in mnu_user table, what is the hashing algorithm used before storing, and after loading?
Thanks.
(1) Surely you mean that the 'user_id' column is linked to the 'created_user' and 'revised_user' columns? You cannot link a user_id column to columns containing dates.
Although I have a 'created_user' and 'revised_user' column on each table in my database I never relate them bac to the MNU_USER table as this would be overkill.
(2) You could always turn password encryption OFF during the bulk import and import plain text passwords, then turn encryption ON again afterwards. You can do this on the 'Menu Controls' screen.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Re: How to bulk import my users into Radicore? [message #4834 is a reply to message #4829] |
Sat, 11 July 2015 04:43 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
AJM
Messages: 2361 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
rafs wrote on Sat, 11 July 2015 00:53After importing all of my user records directly into mysql mnu_user table, I am unable to login with one of the new users. I have set the user to have "GLOBAL ACCESS" and set is_disabled to N. The user_password is Nz-3jN6+lK@Ii^DE. When I try to logon I get 'Security violation.'
This is because the encryption algorithm uses a slightly different key for each user, so you cannot use the same encrypted value for different users.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|