import-gpo with csvfile

All replies

• 

  

  0

  Sign in to vote

  Don't use -Header with your Import-Csv command. Your CSV file already contains a header.

  Because you are specifying a header, your Import-Gpo command is trying to import a GPO for the first line in the CSV file (because you are specifying a header).

  ---

  -- Bill Stewart [Bill_Stewart]

  Monday, April 23, 2018 5:19 PM
• 

  

  0

  Sign in to vote

  in really my csv is like this, no with {}:

  BackupGpoName,BackupId,GPOName,path
  "GPO1",11111111-2222-3333-444444444444,"GPO1","C:\BackupGPO"
  "GPO2",78888888-1222-4555-8777-123456789123,"GPO1","C:\BackupGPO"

  Without -Header i get this error:

  Foreach-Object : Cannot process argument because the value of argument "name" is not valid. Change the value of the "name"
  argument and run the operation again.
  At line:2 char:10
  +   $csv | Foreach-Object {
  +          ~~~~~~~~~~~~~~~~
      + CategoryInfo          : InvalidArgument: (:) [ForEach-Object], RuntimeException
      + FullyQualifiedErrorId : Argument,Microsoft.PowerShell.Commands.ForEachObjectCommand

  Monday, April 23, 2018 6:18 PM
• 

  

  0

  Sign in to vote

  Simplify your code first:

  import-csv C:\gpotest.csv |
      Foreach-Object {
         import-gpo -BackupGpoName $_.BackupGpoName -BackupId $_.backupid -Path $_.path
      }

  
  

  ---

  \_(ツ)_/

  
  

  • Edited by jrv Monday, April 23, 2018 6:48 PM

  Monday, April 23, 2018 6:26 PM
• 

  

  0

  Sign in to vote

  Foreach-Object : Parameter set cannot be resolved using the specified named parameters.
  At line:2 char:5
  +     Foreach-Object {
  +     ~~~~~~~~~~~~~~~~
      + CategoryInfo          : InvalidArgument: (:) [ForEach-Object], ParameterBindingException
      + FullyQualifiedErrorId : AmbiguousParameterSet,Microsoft.PowerShell.Commands.ForEachObjectCommand
   

  Monday, April 23, 2018 6:39 PM
• 

  

  0

  Sign in to vote

  It seems to me you are making changes without understanding.

  I would recommend going through some PowerShell tutorials and start actually learning how it works.

  ---

  -- Bill Stewart [Bill_Stewart]

  Monday, April 23, 2018 6:47 PM
• 

  

  0

  Sign in to vote

  Yes you're allright, i need to study more, english include. lol.

  But i find a solution for me problem with another approach. I used a function  like this below:

  Function importGPO() {
  
          [CmdletBinding()]
  
          Param(
              
              [Parameter(Mandatory=$True,ValueFromPipelineByPropertyName=$true)]
              [string]$BackupId,
              
              [Parameter(Mandatory=$True,ValueFromPipelineByPropertyName=$true)]
              [string]$GPOName,
                          
              [Parameter(Mandatory=$True,ValueFromPipelineByPropertyName=$true)]
              [string]$path
  
  
         )
  
  
   
      Process {
       
      import-gpo -BackupId $BackupId -TargetName $GPOName -path $path -CreateIfNeeded
      
      }
  }
  
  
  import-csv -Path "C:\gpotest.csv" | importGPO

  Thanks. If you can say me where i find the tutorial for my issues with foreach?

  Tuesday, April 24, 2018 11:54 AM