PowerShell Task:
- Import CSV
- Read import-csv line by line
- Match Non AD group To a users folder
- Create an HTML page from powershell
- Create a hyper link in each folder from PowerShell
- base membership from a non AD source.
The task was to use a CSV file from an outside source that would create an HTML page with its HTML link based on the content of import-csv file.
The group member ships in the CSV file did not come from AD but based on a directory structure
#########################
#########################
# //===Name: .\easy_ImportCsv.ps1
# Description:www.BrilliantlyEasy.com import
# from CSV export to HTML File by
# a NoN AD group memberships
# ######## Create HTML URL Links
#By Group in user folders
#
#####################################</pre>
write-host $objItem.Name, $objItem.WorkingSetSize `
-foregroundcolor "magenta"
#var for date/time
$datetime = get-date -format G
#Var $OFS used for new lines when using write-host
$OFS = "`r`n`r`n"
$OFS1 = "`n"
#Source of users
#var used for team memberships in import-csv
$Red = "Marketing"
$Green = "Sales"
$Blue= "Development"
write-host $OFS $datetime $OFS1 `
"IMPORT FILE NAME: C:\scripts\powershell\portfoiloportStu.csv" `
-foregroundcolor "magenta" -backgroundcolor "yellow"
#import-csv "c:\import\accountsInfo.csv"
#Var for source of folder location
$source = "C:\users\folder"
#Var for CSV import of user files
$csv_info = Import-Csv C:\scripts\powershell\portStu.csv
foreach ($line in $csv_info)
{
#$destination = "C:\users\folder\" + $line.Username
#powershell create HTML file and HTML code content
# from a Variable with variables inside of HTML
#*look at the new-item -force -value $outFile
$outFile ='
<img alt="image" longdesc="image" width="846" height="62" />
<table style="width: 57%;">'$outFile = $outFile +
'$outFile = $outFile + $line.Username
$outFile = $outFile + '
#Var that holds the full path to user GROUP & their User name
# powershell destination use path in a variable with quotes
#by use of + syntax
$destination = "C:\users\folder\"+$line.Group_Role+"\"+ '
$line.Username
#write-host "1" $($line.Username) $($line.Link) `
$($line.Group_Role)
#if red grab the user in Red Groupif ($Red -eq $line.Group_Role)
{write-host "RED GROUP" $OFS1 $line.Username $line.Link
`$line.Group_Role#Powershell Create a new HTML survey.html file
# using Variable to spit out HTML
#code content based on CSV importnew-item -path $destination -name
survey.html -type file `-force -value $outFile}
#elseif red grab the user in
# Green Groupelseif ($Green -eq $line.Group_Role)
{Write-Host "Green Group" $OFS1 $line.Username $line.Link
`$line.Group_Rolenew-item -path $destination -name survey.html -type file
`-force -value $outFile}
#elseif red grab the user in Blue Groupelseif
($Blue -eq $line.Group_Role){Write-Host "Blue Group"
$OFS1 $line.Username $line.Link
`$line.Group_Role#Powershell Create a new HTML file survey.html
#using Variable to spit out HTML code content new-item -path
$destination -name survey.html -type
`file -force -value $outFile}else {"Users have been imported. "}}
#END
No comments yet.