Construct Three value Hashtable from CSV in Powershell

Question

Hi,

I am using this code to tag the Azure resources. But instead of hardcoding the key Values like this I want to pick the key values from a csv file. How can we achieve it

$tags = @{"key"="value"}
$csv = import-csv "C:\tags\tags.csv"

$csv | ForEach-Object {
Write-Host " $($.Name), $($.RESOURCE_GROUP), $($_.SUBSCRIPTION_ID ) "
Set-AzContext -Subscription $_.subscription_ID

$resource = Get-AzResource -Name $.Name -ResourceGroup $.RESOURCE_GROUP
Update-AzTag -ResourceId $resource.id -Tag $tags -Operation Merge
}

Regards
Rajaniesh

Answer 1

Hi,

Assuming the csv file has two columns with the headers "key" and "value", you write the key/value pairs to a hashtable like below

$file = "C:\temp\hashtable.csv"  
$tags = @{}  
Import-Csv -Path $file |ForEach-Object{  
    $tags.Add($_.key,$_.value)  
}  

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

This will never work you can try on your own. This will not add the =sign. I already tried it before posting it in this forum.

Answer 3

I tried running your code and it does not work here is the output. It keep on asking the parameters.

Answer 4

I did some more research and found this code to be working

# Constants.
$DELIM = ','
$CSV_F = 'C:\tags\tags.csv'

# Parse keys
$keys = (gc "${CSV_F}" -TotalCount 1).Split($DELIM)
$csv = Import-CSV "${CSV_F}"
 $TagsHashTable=@{}

# Iterate through CSV to build array of hashtables.
ForEach ($r in $csv) {
    $tmp_h = @{}

    # Create hash of key-value pairs.
    ForEach($k in $keys) {
        $tmp_h[$k] = $r.($k)
    }

    # Add hash to array of hashes.
    $TagsHashTable += $tmp_h
}

Answer 5

Even if you move it at the same line it won't work.