Can anyone help me write a powershell script to set call immediate call forwarding on users from a .csv file?

Question

Can anyone help me write a powershell script to set call immediate call forwarding on users from a .csv file?

Dave 20

Hello, I'm looking to write a script to do the following:

Set an "immediately forward" on a user to another number. So for example:
Set-CsUserCallingSettings -Identity ******@domain.com -IsForwardingEnabled $true -ForwardingType Immediate -ForwardingTarget +3.......-ForwardingTargetType SingleTarget ^ Of course this works like this. But I want to do this in bulk from a .csv file. So it would look something like User Forwardnumber
UPN +3...... (With a script that uses the import function) I can't seem to get this part to work. Could you help me out? Thank you!

Accepted answer

0 additional answers

Your answer

Answer 1

Rich Matheisen 47,901

Try this:

Import-CSV <csv-path> |
    ForEach-Object{
        $u = $_.user    # for use in Catch block if update fails
        Try{
            Set-CsUserCallingSettings -Identity $_.user -IsForwardingEnabled $true -ForwardingType Immediate -ForwardingTarget $_.ForwardingTarget -ForwardingTargetType SingleTarget ^ -ErrorAction STOP
        }
        Catch{
            Write-Host "Could not make changes to '$_.u'"
            $_
        }
    }

The CSV file should look something like this:

User,ForwardingTarget
******@domain.com,+3.......
Another******@domain.com,+3.......

EDIT: corrected the "Write-Host" to use the variable "$u".

Dave 20

Hi Rich, I can see that it does read the correct information ( I have replaced the text for this example with testuser..) , but it gives an empty string error>

Should I add an allow empty string variable?

Could not make changes to 'Cannot bind argument to parameter 'Identity' because it is an empty string..user'
User                 ForwardingTarget
----                 ----------------
******@test.com    +3112121212
Set-CsUserCallingSettings : Cannot bind argument to parameter 'Identity' because it is an empty string.
At line:5 char:49
+             Set-CsUserCallingSettings -Identity $_.user -IsForwarding ...
+                                                 ~~~~~~~
    + CategoryInfo          : InvalidData: (:) [Set-CsUserCallingSettings], ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationErrorEmptyStringNotAllowed,Set-CsUserCallingSettings

Rich Matheisen 47,901 Reputation points

2023-04-24T15:45:23.1733333+00:00

Change the line FROM: Write-Host "Could not make changes to '$_.user'" T TO: Write-Host "Could not make changes to '$_.u'" However, that will only correct the error message. It looks to me as if the $_.user (which should contain only the user's identity) is the entire row of data from the CSV. Can you post the code you're using and the 1st two lines of the CSV (the header and one user)?

Dave 20

This is the code I use:

PS C:\Users\dave> Import-CSV C:\Users\dave\Downloads\test.csv
    ForEach-Object{
        $u = $_.user    # for use in Catch block if update fails
        Try{
            Set-CsUserCallingSettings -Identity $_.user -IsForwardingEnabled $true -ForwardingType Immediate -ForwardingTarget $_.ForwardingTarget -ForwardingTargetType SingleTarget ^ -ErrorAction STOP
        }
        Catch{
            Write-Host "Could not make changes to '$_.u'"
            $_
        }
    }


Could not make changes to 'Cannot bind argument to parameter 'Identity' because it is an empty string..u'
User;Forwardingtarget               
---------------------               
******@test.com;31613221123
******@test.com;3161134345    
Set-CsUserCallingSettings : Cannot bind argument to parameter 'Identity' because it is an empty string.
At line:5 char:49
+             Set-CsUserCallingSettings -Identity $_.user -IsForwarding ...
+                                                 ~~~~~~~
    + CategoryInfo          : InvalidData: (:) [Set-CsUserCallingSettings], ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationErrorEmptyStringNotAllowed,Set-CsUserCallingSettings

below is the csv file (excel saved as csv UT8) User's image

Rich Matheisen 47,901 Reputation points

2023-04-25T14:37:47.9233333+00:00
You're missing the pipe ("|") at the end of the 1st line. Typo?

A screenshot of an Excel spreadsheet isn't the equivalent of a CSV.

It looks like your CSV uses a semicolon (";") as a delimiter, but your Import-CSV uses the default comma (",")

Share via

Can anyone help me write a powershell script to set call immediate call forwarding on users from a .csv file?

0 additional answers

Your answer