Home Get data from elements within multiple XML files for output to another, single XML file using Powershell
Reply: 0

Get data from elements within multiple XML files for output to another, single XML file using Powershell

user2897
1#
user2897 Published in May 21, 2018, 2:58 am

I'll begin by confessing that I'm a Powershell (and coding) noob. I've stumbled my way through a few scripts, but I make no claims to anything even approaching competence. I'm hopeful that some more experienced folks can set me on the right track.

I'm trying to pull specific element-data from multiple XML files, which will be used to populate another XML file. The files from which I'm pulling the data are invoices, and I'd like to grab the invoice number and timestamp and drop those values into a manifest. The manifest structure is as follows

<?xml version="1.0" encoding="utf-8"?>
<Manifest>
    <Invoice>
        <InvoiceID></InvoiceID>
        <Timestamp></Timestamp>
    </Invoice>
</Manifest>

The XMLs from which I am pulling are in a sub-directory of the directory in which the manifest will be saved. For the sake of simplicity, the element names within the invoices are identical to the corresponding elements within the manifest. The folder structure for the manifest is "C:\Projects\Powershell\Manifest\Manifest.xml" and for the invoices it is "C:\Projects\Powershell\Manifest\Invoices\*.xml".

With the following code I am able to grab the data from the elements "InvoiceID" and "Timestamp" of only the first XML in the sub-directory "\Invoices". The code does, however, create one entry for each Invoice file; it just fills each element with the value taken from the first file. (So, for example, if I have three Invoice XML files in the "\Invoices" directory, I get results of: three instances of the <Invoice> complex element, each populated with the InvoiceID and Timestamp found in the first file. So it's counting the files and outputting a corresponding number of elements, it just isn't getting data from any but the first.)

Here is the code:

$files = Get-ChildItem "C:\Projects\Powershell\Manifest\Invoices\*.xml"

$xmlData = @"
    <Invoice>
        <InvoiceId>$InvID</InvoiceId>
        <Timestamp>$Timestamp</Timestamp>
    </Invoice>
"@
$Manifest = "C:\Projects\Powershell\Manifest\Manifest.xml"

ForEach ($file in $files) {
    $xmldoc = [xml](Get-Content $file)
    $InvID = $xmldoc.Manifest.Invoice.InvoiceID
    $Timestamp = $xmldoc.Manifest.Invoice.Timestamp
    ForEach ($xml in $xmldoc)
{
    Add-Content $Manifest $xmlData
}}

I can deal with properly formatting the closing tag of the output file once I have this piece figured out.

I know I must be looping incorrectly, but after reading up on this until my brain hurts, I've finally resorted to asking the question. What obvious thing am I missing/messing up?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.366209 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO