current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 2 down vote favorite
1

I have a CSV file with two different columns, one with PC names and one with MAC addresses like this:

PCxxxx 00-11-22-33-44-55  
...  
...

These values should be placed into the following CLI command:

wdsutil /Set-Device /Device:PCxxxx /ID:00-11-22-33-44-55

Now since there are about 200 of them, I want to automate this.

As a matter of interest, could one do this with batch? Would be quite complicated, right? I thought of arrays, but don't think one can do this in batch.

Maybe with powershell it'd be a bit easier.

share|improve this question
add comment

2 Answers

up vote 7 down vote accepted

In a batch file:

for /f "tokens=1,2 delims= " %%a in (foo.csv) do (
    wdsutil /Set-Device /Device:%%a /ID:%%b
)

Actually, you can do that as a one-liner from cmd directly:

for /f "tokens=1,2 delims= " %a in (foo.csv) do wdsutil /Set-Device /Device:%a /ID:%b

In PowerShell you can use a similar idea:

Get-Content foo.csv | ForEach-Object {
  $name,$mac = -split $_
  wdsutil /Set-Device /Device:$name /ID:$mac
}

Or use the CSV import cmdlet, but given your question you don't seem to have column headers, so you need to provide them manually:

Import-CSV -Delim ' ' -Path foo.csv -Header Name,Mac | ForEach-Object {
    wdsutil /Set-Device "/Device:$($_.Name)" "/ID:$($_.Mac)"
}
share|improve this answer
    
The FOR ... delims= " option is not necessary because the space is the default delimiter. You may use just for /f "tokens=1,2" %%a in ... –  Aacini Apr 26 '12 at 16:55
    
Yes, I just chose to be explicit here. Besides, the default delimiters are spaces and tabs. –  Јοеу Apr 26 '12 at 17:18
add comment
up vote 3 down vote 
# First column in csv file must be titled PCName, second column must be titled MacAddress.
Import-Csv myfile.csv | %{ wdsutil /Set-Device /Device:$_.PCName /ID:$_.MacAddress }

Warning: not tested.

share|improve this answer
2  
The file doesn't appear to have headers so you'd need to provide them manually. Also the default delimiter wouldn't work. –  Јοеу Apr 26 '12 at 9:00
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.