Write contents of all xml files into text file using Powershell

Question

Folder LogBackup contains 40K xml files. I want to read each xml file and copy its contents on different line of text file. For example, if I have 2 xml files:

xmlFile1.xml

<?xml version = "1.0" encoding = "ISO-8859-1" ?><Acknowledgement><HeaderData><Description>Estimate</Description> <SiteQueueName>QUEUE</SiteQueueName><LineItems>7</LineItems><TimeStamp>201408310925444111</TimeStamp></HeaderData><OrderDetail>

xmlFile2.xml

<?xml version = "1.0" encoding = "ISO-8859-1" ?><Acknowledgement><HeaderData><Description>Estimate</Description> <SiteQueueName>QUEUE2</SiteQueueName><LineItems>7</LineItems><TimeStamp>201408310925380810</TimeStamp></HeaderData><OrderDetail>

Both of these should be copied to output.log:

<?xml version = "1.0" encoding = "ISO-8859-1" ?><Acknowledgement><HeaderData><Description>Estimate</Description> <SiteQueueName>QUEUE</SiteQueueName><LineItems>7</LineItems><TimeStamp>201408310925444111</TimeStamp></HeaderData><OrderDetail>
<?xml version = "1.0" encoding = "ISO-8859-1" ?><Acknowledgement><HeaderData><Description>Estimate</Description> <SiteQueueName>QUEUE2</SiteQueueName><LineItems>7</LineItems><TimeStamp>201408310925380810</TimeStamp></HeaderData><OrderDetail>

This is what I got so far, but it is not working :(

Get-ChildItem "C:\LogBackup" -Filter *.xml | 
Foreach-Object 
{
    $content = Get-Content $_.FullName
    #save content to a new file 
    $content | Set-Content ('output.log')
}

Try using LogParser technet.microsoft.com/en-us/scriptcenter/dd919274.aspx — Ron Harlev
– Ron Harlev, Commented Mar 28, 2016 at 21:28
@RonHarlev I forgot to mention that nothing can be installed on the machine. I can't even get Notepad++ on it :( — Angelina
– Angelina, Commented Mar 28, 2016 at 21:31

gravity · Accepted Answer · 2016-03-28 21:57:04Z

Set-Content

Replaces the existing data in a file.

Add-Content

Appends data to a file.

Therefore, you are only writing the last XML you check to the output.log file, and the rest is discarded along the way.

Here's the Technet article, for reference.

... and the modified code snippet (note I dump the output.log at the top, now):

Clear-Content ('C:\LogBackup\Output.log')
Get-ChildItem "C:\LogBackup" -Filter *.xml |
Foreach-Object 
{
   $content = Get-Content $_.FullName
   $content | Add-Content ('C:\LogBackup\Output.log')
}

Yielded:

<?xml version = "1.0" encoding = "ISO-8859-1" ?><Acknowledgement><HeaderData><Description>Estimate</Description> <SiteQueueName>QUEUE</SiteQueueName><LineItems>7</LineItems><TimeStamp>201408310925444111</TimeStamp></HeaderData><OrderDetail>
<?xml version = "1.0" encoding = "ISO-8859-1" ?><Acknowledgement><HeaderData><Description>Estimate</Description> <SiteQueueName>QUEUE2</SiteQueueName><LineItems>7</LineItems><TimeStamp>201408310925380810</TimeStamp></HeaderData><OrderDetail>

Collectives™ on Stack Overflow

Write contents of all xml files into text file using Powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related