updating lists

[knaya]

Hello Everyone,
I have a problem that i beleive i know the answer too but want to verify. Problem - I have a list of members on my sharepoint site but this list changes as new employees are been hired, terminated etc. To make sure the information on the sharepoint site is correct, I receive an extration file from the mainframe showing all current employees. My question is - Is there a way to automatically compare this list with the list in my sharepoint database and then add the new employees or remove old employees. Is this possible or is the only way to do this is manually compare this extration file with the list on the sharepoint site and then make changes via sharepoint as opposed to through the sql database...Thank you

 

[Beowulf005]

You would have to check the list manaually. But have you considered using security groups? I am assuming that the memebers are users on the network and you need to change the permissions everytime someone is hired and fired. If you use security groups on the server sharepoint can use those groupd for permission on the site. So when you remove or add a member to the group it will update it to all sites/list that you have given permission too.

Brian

 

[ChaserNL]

Brain's idea is IMO the best i use AD groups for this, the only thing to note is that alerts keep getting sent even when the user is no longer a member of the security group, this must be deleted seperatly.

Greetings


Paul

 

[Beowulf005]

IMO?

 

[ChaserNL]

In My Opinion

Greetings