PowerShell parameters from file

Question

I am having some issue in calling a function using named parameters.

This is the declaration of the function in a separate file (Security.ps1):

function Add-SSRSItemSecurity
(
    [Parameter(Position=0,Mandatory=$false)]
    [Alias("SSRSrange")]
    [string]$range,[Parameter(Position=1,Mandatory=$false)]
    [Alias("path")]
    [string]$itemPath,

    [Parameter(Position=2,Mandatory=$false)]
    [Alias("grp")]
    [string]$groupUserName,

    [Parameter(Position=3,Mandatory=$false)]
    [Alias("SSRSrole")]
    [string]$role,

    [Parameter(Position=2)]
    [bool]$inherit=$true
)

I then call this function in another Host.ps1 script as:

    Set-Location 'C:\SSRSJobs'
    . .\SSRSsecurity.ps1

This call works in the Host file:

Add-SSRSItemSecurity -range "server1" -itemPath "/Test" -groupUserName "CN\Group" -role "Browser"

I tried to pass in multiple parameters to the function as a loop, but calling new variables each time:

$securityArray = @()
$securityArray = Get-Content -Path "C\ReleaseSecurity.txt"
    foreach($line in $securityArray)
    {
        Add-SSRSItemSecurity $line;
    }

The file having:

-range "server1" -itemPath "/Test" -groupUserName "CN\Group" -role "Browser"
-range "server2" -itemPath "/Test" -groupUserName "CN\Group" -role "Browser"
-range "server3" -itemPath "/Test" -groupUserName "CN\Group" -role "Browser"

The error I get is:

Add-SSRSItemSecurity : Cannot bind positional parameters because no names were given.
At line:229 char:27
+                         Add-SSRSItemSecurity <<<<  $line;
    + CategoryInfo          : InvalidArgument: (:) [Add-SSRSItemSecurity], ParameterBindingExcepti
   on
    + FullyQualifiedErrorId : AmbiguousPositionalParameterNoName,Add-SSRSItemSecurity

Inspecting the string, the $line variable does hold correct naming for parameters. I've tried all sorts of error trapping, but I'm unable to get a decent error message other than the above. I've also tried forms of quoting, but I cannot get the function to see the name binding.

Can multiple variables be called in a function that are bound to just a PowerShell variable name?

Ansgar Wiechers · Accepted Answer · 2015-01-22 12:28:39Z

1

You can use splatting for that. Save the parameters as a CSV like this:

"range","itemPath","groupUserName","role"
"server1","/Test","CN\Group","Browser"
"server2","/Test","CN\Group","Browser"
"server3","/Test","CN\Group","Browser"

and load it like this:

Import-Csv 'C:\ReleaseSecurity.txt' | % {
  Add-SSRSItemSecurity @_
}

answered Jan 22, 2015 at 12:28

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chris McGourty Over a year ago

Ansgar, you genius! I didn't use your code but I did use your method and it works perfectly! Thank you very much :)

Collectives™ on Stack Overflow

PowerShell parameters from file

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related