XSLT transformation using PowerShell

Question

I need to run a XSLT transformation using a PowerShell script that recursively for all the object *.xml:

Load the file
Transform it
Save the output with the same file name in the same path.

I thought something like this

FolderToCheck = "MyFolder"
Get-ChildItem $FolderToCheck -Filter *.xml | ForEach-Object {
    # declare Xslt script for transformation
    [Xml]$Xslt_script = Get-content 'MyScript.xslt'
    # read xml
    $File = [xml](Get-Content $_.FullName)
    # Run the transformation
    $xslt = New-Object System.Xml.Xsl.XslCompiledTransform
    $xslt.Load($Xslt_script)
    $xslt.Transform($File,$File)
    }

I'm always getting error

Exception calling "Transform" with "2" argument(s): "Could not find file 'C:\Users\gdiprima00\System.Xml.XmlDocument'." At line:9 char:1 + $xslt.Transform($File,$File) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : FileNotFoundException

What is it wrong? Can you suggest what to amend?

Martin Prikryl · Accepted Answer · 2024-10-07 06:17:10Z

1

Thanks to @Martin Honnen suggestion, I have amended a little bit my code as follows:

Get-ChildItem $FolderToCheck -Filter *.xml | ForEach-Object {
    # declare Xslt script for transformation
    [Xml]$Xslt_script = Get-content 'MyScript.xsl'
    # Create Output File Name
    $dir = $_.DirectoryName
    $BaseName = $_.Basename
    $OutputFileName = $_.DirectoryName + '\' + $_.Basename + '_v2.xml'
    # Run the transformation
    $xslt = New-Object System.Xml.Xsl.XslCompiledTransform
    $xslt.Load($Xslt_script)
    $xslt.Transform($_.FullName, $OutputFileName)
    rm $_.FullName
    }

With this I'm able to generate my *_v2.xml file and then delete the original file.

edited Oct 7, 2024 at 6:17

Martin Prikryl

205k64 gold badges560 silver badges1.1k bronze badges

answered Apr 7, 2022 at 20:08

Giuseppe Di Prima

211 silver badge3 bronze badges

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

Collectives™ on Stack Overflow

XSLT transformation 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