Converting bulk xml to separate csv using powershell

Question

I have a Power Shell script that queries an xml document and outputs the results to a csv file. The script works, but I need to apply it to multiple xml files in a folder, then output the results as a separate csv for each XML with the same XML name. How can this script be modified to do this?

PROCESS 
{ 
$xml = [xml](Get-Content .\sample.xml) #Sample XML

$xml.log.event | Select-object @(
@{l="times";e={$_.time}},
@{l="type";e={$_.type}},
@{l="user";e={$_.user}},
@{l="place";e={$_.place}},
@{l="message";e={$_.message}}) |
Export-Csv test.csv -NoTypeInformation
}

Do you have a directory of xml files or something?

Maximilian Burszley
– Maximilian Burszley

2017-10-30 23:25:36 +00:00
Commented Oct 30, 2017 at 23:25 — Maximilian Burszley
– Maximilian Burszley, Commented Oct 30, 2017 at 23:25
Hi.. Yes I've got a directory with multiple xml files in it

user8859187
– user8859187

2017-10-30 23:39:19 +00:00
Commented Oct 30, 2017 at 23:39 — user8859187
– user8859187, Commented Oct 30, 2017 at 23:39

Maximilian Burszley · Accepted Answer · 2017-10-30 23:44:22Z

2

Assuming a directory:

$ToProcess = Get-ChildItem -Path 'C:\Temp' -Filter '*.xml'

ForEach ($File in $ToProcess)
{
    [Xml]$Xml = Get-Content -Path $File.FullName

    $Xml.log.event | Select-Object -Property @(
        @{Name='Times';Expression={$_.Time}},
        @{Name='Type'; Expression={$_.Type}},
        @{Name='User'; Expression={$_.User}},
        @{Name='Place';Expression={$_.Place}},
        @{Name='Message';Expression={$_.Message}}
    ) | Export-Csv -Path "C:\Temp\$($File.BaseName).csv" -NoTypeInformation
}

answered Oct 30, 2017 at 23:44

Maximilian Burszley

19.9k7 gold badges39 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting bulk xml to separate csv 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