Update Distribution Group via CSV

Question

Is there a way to update a distribution group using a CSV file as the source through the web portal?

This script is an example of how I would do in manually through EMS.
import-csv C:\Distro1.csv | foreach {add-distributiongroupmember -id Distro1-member $_.Name }

Answer 1

Hello Michael,

Currently import of data from a CSV file is not supported in Adaxes Web Interface. This feature is in our TODO list and will be available in one of the nearest releases.

However, there is a way to do this using Custom Commands. You can create a Custom Command that will import users from a CSV file located on a network share. In this Custom Command you can use your PowerShell script via the Run a program or PowerShell script action. The name of the file can depend on the name of the user who is performing the operation. So, your users will need to open a CSV file (using, for example, Excel) located on a network share, enter all the data necessary, and execute a Custom Command via the Web Interface.

To create such a Custom Command:

1. Open Adaxes Administration Console.

2. Create a new Custom Command.

3. On the 2nd step of the Create Custom Command wizard, select Group.

4. On the 3rd step of the wizard, add the Run a program or PowerShell script action.
   To pass the name of the initiator to your Powershell script, use the $Context.Initiator.UserAdsObject.Get("<property_name>") method passing sAMAccountname as the name of the property. To pass the group, on which your Custom Command is executed, you can use the %sAMAccountName% value reference. For example:

    Add-PSSnapin Microsoft.Exchange.Management.PowerShell.E2010
    $initiator = $Context.Initiator.UserAdsObject.Get("sAMAccountname")
    import-csv \\server\share\$initiator.csv | foreach {add-distributiongroupmember -id %sAMAccountName% $_.Name }
   

5. Finish creation of the Custom Command.

On how to create a Home Page Action that will launch the Custom Command from the Web interface, see the Configure Home Page Actions tutorial (section Custom Command)