run powershell command using csv as input run powershell command using csv as input powershell powershell

run powershell command using csv as input


$csv = Import-Csv c:\path\to\your.csvforeach ($line in $csv) {    New-Mailbox -Name $line.Name -WindowsLiveID $line.Email -ImportLiveId}

First line of csv has to be something like Name,Email,Address

If you cannot have the header in the CSV, you can also have:

$csv = Import-Csv c:\path\to\your.csv -Header @("Name","Email","Address")

-Header doesn't modify the csv file in any way.


import-csv .\file.csv  -header ("first","second","third") | foreach{New-Mailbox -Name $_.first -WindowsLiveID $_.second -ImportLiveId}


This is some of the most useful information I have seen yet - it just made my job so much easier!!!

Combining Netapp commands:

get volumes from a controller, get snapshot schedule for said volumes, and export to a csv:

get-navol | Get-NaSnapshotSchedule | Export-Csv -path d:\something.csv

Import the csv reading in current values and assigning each column a label.

For each object, create a new schedule by RE-USING 4 of the 5 available columns/data fields

import-csv d:\something.csv -header ("label1","label2","label3","label4","label5") | foreach {Set-naSnapshotschedule $.label1 -Weeks $.label2 -Days $.label3 -Hours $.label4 -Whichhours "1,2,3,4,5"}

EXCELLENT STUFF!!!

Please note that the "Labels" should have an underscore - for whatever reason it isn't reflecting in the page so Dollar($)Underscore(_)Dot(.)Label