Ok, I tried the multiple user upload tool from Rudster, but had no luck. I've got two user tables I need to copy into my tblAuthor table. I've created a rudimentary SQL statement, but I know it won't work because of the usercode and encryption. Could someone help me find a way to get these ~550 users into WWF? I would greatly appreciate it and am also willing to compensate for one's investment of time into this.
INSERT INTO FRMtblAuthor (Real_name, Username, Password)
SELECT (First_Name + Last_Name, UserName and Password) from users
INSERT INTO FRMtblAuthor (Real_name, Username, Password, Author_email)
SELECT (First_Name + Last_Name, UserName, Password, E-mail_Address) from entity_empoyee
I don't know how to add a space between the First_Name and Last_Name. I know I also need to supply a default time for the time_offset fields, I'm just not well-versed enough in SQL to know how to do it.
Thanks,
Patrick
Topic Options
Post Options
Thanks(0)
