Hey Tessi world,
I am looking temp user names and passwords to a list of constituents, I am aware that this is a process that I have to perform in SQL, however I do not have a script/SP to do this, anyone got anything that they can share?
regards
Claire
Claire,
I've uploaded the script ATTPAC uses to create temp logins to my profile page. File name is LP_CREATE_LOGINS_ATTPAC.sql. (Driect link: http://goo.gl/Qry0jU )
We create logins for all accounts with emails. The script uses a cursor to loop through them and add the correct records. I believe this will require some modification with the new web password functionality in V12, but this should work for V11 and earlier.
- Levi