Forum Discussion
Help creating a script to import CSV to update Global Address List
Hi, I hope someone can help. I am trying to create a script that allows me to import and update a customer global address list with a CSV file that they have sent. This script when run would ...
There is a lot to it, even though it's a simple operation. Does the list (from the client) ONLY contain additions to the GAL, or is it also removing members from the GAL? These are the things that need all the consideration when writing a script for it.
Yeah you're 100% right. I do have a script that I have put together below however if I imported the csv and the imported csv had some users that had been removed, it wouldn't remove these would it? It would only add?
I am waiting to hear back from the customer.
I am waiting to hear back from the customer.
- in that case you need to clear the GAL before uploading the new csv. But clearing a GAL is a big thing. i would prefer a new addresslist which is not containing any system generated members like mailbox users or shared mailbox users.
- By the looks of the CSV. It is just external contacts. He sends this CSV every month and just adds a bunch of users on every time, I would assume that if I imported this it would import the additional users and just error on the users that are already there or am I wrong in saying that
- Indeed error on what exists but no removal of missing
