Forum Discussion
euanvjc97
Feb 01, 2023Copper Contributor
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 ...
euanvjc97
Feb 03, 2023Copper Contributor
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.
aterneuzen
Feb 03, 2023Brass Contributor
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.
- euanvjc97Feb 03, 2023Copper ContributorBy 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
- aterneuzenFeb 03, 2023Brass ContributorIndeed error on what exists but no removal of missing