asked on

Need to create Multiple folders by importing CSV file using powershell.

Need to create Multiple folders by importing CSV file using powershell. Below script is giving error in last line of script can any one help whats working in this script , please assist
____________________________________________________________________

$rows=Import-Csv 'C:\Users\Narasimha.s\Desktop\foldertest\project.csv'
foreach ($row in $rows) {
$folderName = $row.DisplayName
md -Path C:\$folderName
}

Rajul Raj

Use this Script

Set-Location "c:\data\groups" 
 
$Folders = Import-Csv c:\scripts\GroupdOnTRG.csv 
 
ForEach ($Folder in $Folders) { 
 
New-Item $Folder.Name -type directory 
}

Open in new window

SAM IT

ASKER

I have initiated given error getting error. error message screen shot attached
errorfolder.jpg

Bill Prew

Try:

Set-Location "c:\data\groups" 
 
$Folders = Import-Csv c:\scripts\GroupdOnTRG.csv 
 
ForEach ($Folder in $Folders) { 
 
New-Item -path $Folder -type directory 
}

Open in new window

~bp

SAM IT

ASKER

Again getting same error. attached

Bill Prew

Unless you don't have the full path in the CSV, just the name of the new folder, in a column headed DisplayName, which I think would then be:

Set-Location "c:\data\groups" 
 
$Folders = Import-Csv c:\scripts\GroupdOnTRG.csv 
 
ForEach ($Folder in $Folders) { 
 
New-Item -name $Folder.DisplayName -type directory 
}

Open in new window

~bp

Bill Prew

Can you also show here what the CSV looks like.

~bp

SAM IT

ASKER

getting different error now . attached

CSV format also attached
csvformat.jpg
error1.jpg

Bill Prew

Please attach the actual CSV file, not a picture of it opened as a spreadsheet, need to see the text file.

~bp

SAM IT

ASKER

CSV attached
project.csv

ASKER CERTIFIED SOLUTION

Bill Prew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SAM IT

ASKER

Perfect......

I have one query on this ......

Post creating the folders in the path security group permission has to be apply to created folders

Security Group Name: shr-projectsmodify This Group is part of Active directory. This group permission has to apply on created folders

Bill Prew

Sounds like a new question, and be sure to include the "Active Directory" topic when you create it.

~bp

SAM IT

ASKER

quick response and resolution