User Name and Password in Table

[Salesman0Gil]

Hello,

I have a table in a database that contains, user name, passwrod, and priveledge set.

How can I have Filemaker use this, so I do not have to input all 400+ users manually?

[mr_vodka]

You should use the built in Accts and & Privs functionality of FM. Why would you want to store that kind of data in a table? It is not secure.

If the tediousness of manually entering all those 400 users is what is bothering you, then why not write a loop to do it for you? All you would have to do is create the priviledge sets that you need first. Then do a find for all users of each privilege set and run your loop script, referencing your user and password fields in conjunction with the Add Account script step.

[Salesman0Gil]

That worked flawlessly! I did not explore the account script steps before.

Is there a way to assign the privledge set through a script as well?

[mr_vodka]

No, but if you create the privilege sets first, and then do the find for each privilege set, all you really have to do is change the option in the Add Account step to whatever Privilege set that you want. So when it runs the loops to create all those accounts, it will assign all thuose found records with the privilege set.

This might take a few minutes, but its better than manually changing all 400 accounts' privilege set.

[Salesman0Gil]

I can not believe I missed the obvious. If I use an IF statement referenceing the privledge set field, I can essentially script the assignment of privledge sets.

[mr_vodka]

Oh that is right, you have a field in the table already that has a privilege set name. As long as the values match up then yes you technically can automate the entire thing. Good job.

[Steven H. Blackwell]

Be sure to trap for errors.

Steven

[Salesman0Gil]

I have a field set with Radio Buttons of the possible Privledge Sets, and if (IsEmpty) then it deletes the record and exits.

Can you give me other examples of errors I should trap for?

[Steven H. Blackwell]

You need to trap for duplicate Account Names and for failures of the script to execute.

Steven