We require a script that can populate and periodically update multiple distribution lists. The script needs to read from a CSV file, create mail contacts, and populate these contacts into the DLs.
We also need to be able to schedule the script to run periodically to update the DLs from an updated CSV file.
It also needs to be able to clean up after itself (removing contacts that no longer exist in the updated CSV file), be schedulable, and when re-run, update the contents of the DLs.
Members are external contacts, not internal user mailboxes.
The script will:
read the source CSV file
removing contacts that no longer exist in the updated CSV file*
recreate new contacts
remove all contacts from the DLs
repopulate the DLs with new contacts
* We cannot remove all contacts as we do have some manually created contacts that must remain in the system. So we must remove only contacts that were imported in the previous import, not just a blanket delete of all contacts. Unless we can create imported contacts in a new OU or move keeper contacts to a different OU, then all of the contacts in the target OU could be deleted and recreated.
Platform is Exchange 2010 running on Windows Server 2008 R2 Enterprise.
Undetermined yet if contacts will be set to hidden or not.
2 freelancers are bidding on average $173 for this job
I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.