Here’s a sample script which shows how to work with XML files in Powershell and much more.<\/p>\n
Logic of this script:<\/p>\n
Check if folder has more than 2 files
\nIf it finds more than 2 files send email via function SendMail()
\nNext read first XML file
\nif it finds multiple fields under Envelope.Body.repairorders, use array for each object. Next it replaces characters in this XML object using regex and save it.
\nif it finds single field under Envelope.Body.repairorders, do not use array as Powershell fails to recognize XML array object 0 in such cases, thus i had to make this extra step. It does the same magic.<\/p>\n
Script<\/p>\n
# Created: Naz Snidanko\r\n# Date: Aug 22, 2012\r\n# Description: This script checks wheeltime folder and if it sees more than 2 XML files it run's error correction\r\n# error correction removes special characters from complaint and complain fields and replaces them with space.\r\n# It also send email notification to specified email.\r\n\r\n#function for an email notification\r\n function sendMail{\r\n\r\n Write-Host \"Sending Email\"\r\n\r\n #SMTP server name\r\n $smtpServer = \"server\"\r\n\r\n #Creating a Mail object\r\n $msg = new-object Net.Mail.MailMessage\r\n\r\n #Creating SMTP server object\r\n $smtp = new-object Net.Mail.SmtpClient($smtpServer)\r\n\r\n #Email structure \r\n $msg.From = \"noreply@aa.com\"\r\n $msg.ReplyTo = \"noreply@aa.com\"\r\n $msg.To.Add(\"nsnidanko@aa.com\")\r\n $msg.subject = \"Invalid characters\"\r\n $msg.body = \"This is automatic email generated by a script. Thank you, Magic Script.\"\r\n\r\n #Sending email \r\n $smtp.Send($msg)\r\n }\r\n\r\n# Working folder\r\n$path = \"C:\\out\"\r\n\r\n# count number of files inside the folder\r\n[int]$intFileNumber = [IO.Directory]::GetFiles($path).Count\r\n\r\n# execute script only if there is more than 2 files inside the folder = stuck\r\nif ($intFileNumber -gt 2){\r\n\r\n#Sending email notification\r\nsendMail\r\n\r\ncd $path\r\n# variables\r\n\r\n Get-ChildItem -path $path| ForEach-Object {\r\n\r\n $file = Get-ChildItem ($_.FullName)\r\n\r\n $xmlInpt = Get-Content $file\r\n\r\n # count orders in XML file\r\n [int]$intTotal = $xmlInpt.Envelope.Body.repairorders.\"repair-order\".Count\r\n [int]$intCnt = 0\r\n echo $intTotal\r\n\r\n # Note: Powershell doesn't read XML field as an array if only 1 present. If statement to verify if array should be used \r\n if ($intTotal -ge 2) {\r\n do\r\n {\r\n\r\n # data input\r\n [string]$strCompl = $xmlInpt.Envelope.Body.repairorders.\"repair-order\"[$intCnt].\"detail-records\".\"detail-record\".complaint\r\n [string]$strCause = $xmlInpt.Envelope.Body.repairorders.\"repair-order\"[$intCnt].\"detail-records\".\"detail-record\".cause\r\n\r\n # Validate for special character and replace with blank space\r\n\r\n [string]$strComplFix = [System.Text.RegularExpressions.Regex]::Replace($strCompl,\"[^1-9a-zA-Z_]\",\" \");\r\n [string]$strCauseFix = [System.Text.RegularExpressions.Regex]::Replace($strCause,\"[^1-9a-zA-Z_]\",\" \");\r\n\r\n # replace values in file\r\n $xmlInpt.Envelope.Body.repairorders.\"repair-order\"[$intCnt].\"detail-records\".\"detail-record\".complaint = $strComplFix\r\n $xmlInpt.Envelope.Body.repairorders.\"repair-order\"[$intCnt].\"detail-records\".\"detail-record\".cause = $strCauseFix\r\n\r\n # increase counter (number of work orders inside file)\r\n #echo $intCnt\r\n $intCnt++\r\n #echo \"Inside loop:\" $file.FullName\r\n } while ($intCnt -lt $intTotal)\r\n\r\n #save validated file\r\n $xmlInpt.Save(\"$file\") \r\n }\r\n else {\r\n # data input\r\n [string]$strCompl = $xmlInpt.Envelope.Body.repairorders.\"repair-order\".\"detail-records\".\"detail-record\".complaint\r\n [string]$strCause = $xmlInpt.Envelope.Body.repairorders.\"repair-order\".\"detail-records\".\"detail-record\".cause\r\n\r\n # Validate for special character and replace with blank space\r\n\r\n [string]$strComplFix = [System.Text.RegularExpressions.Regex]::Replace($strCompl,\"[^1-9a-zA-Z_]\",\" \");\r\n [string]$strCauseFix = [System.Text.RegularExpressions.Regex]::Replace($strCause,\"[^1-9a-zA-Z_]\",\" \");\r\n\r\n # replace values in file\r\n $xmlInpt.Envelope.Body.repairorders.\"repair-order\".\"detail-records\".\"detail-record\".complaint = $strComplFix\r\n $xmlInpt.Envelope.Body.repairorders.\"repair-order\".\"detail-records\".\"detail-record\".cause = $strCauseFix\r\n #save validated file\r\n $xmlInpt.Save(\"$file\")\r\n }\r\n } \r\n\r\n}\r\n\r\n#else for test\r\n# {\r\n# echo \"No backlog, yay!\"\r\n# }<\/pre>\n","protected":false},"excerpt":{"rendered":"Here’s a sample script which shows how to work with XML files in Powershell and much more. Logic of this script: Check if folder has more than 2 files If it finds more than 2 files send email via function … Continue reading