Using Powershell to add attributes inside an XML

Question

I'm trying to make a script to add connexions to SAPWIN GUI by software distribution, but I have some difficulties with XML. I have this XML from initial installation of SAP : SAPUILandscape.xml in user profile.

Adding a connexion will add these lines in XML file.

Workspaces
-- Workspace : uuid name
--- Item : uuid serviceid
Messageservers
-- Messageserver : uuid name host port

Services
-- Service : type uuid name systemid msid server sncop dcpg

Adding another entry would change the file like this

I'll take it one step at a time. Here is what I've created so far

    # function to generate a GUID
    function UID {
    [System.GUID]::NewGuid().ToString()
    }
    # This is my date on the specific format
    $dateXML = Get-Date -Format "yyyy-MM-ddTHH:mm:ssZ"
    # This is my SAP Version
    $VER = [System.Diagnostics.FileVersionInfo]::GetVersionInfo("C:\Program Files (x86)\SAP\FrontEnd\SAPgui\saplgmgr2.dll").FileVersion
    # This is the user connected executing the script
    $GetLoggeduser = $env:USERNAME
    
    # This is the path where I save my result
    $path = "C:	emp\SAPUILandscape.xml"
    
    # Initial XML (created on the first launch of SAP)
    $XMLinit = @'
    
    
        
            
        
    
    '@ -f $dateXML,$ver,$GetLoggeduser
    
    # XML Format
    [xml]$xml = $XMLinit
    
    # Workspaces node creation
    $newNodeWorkspaces = $xml.CreateElement('Workspaces')
    $xml.Landscape.AppendChild($newNodeWorkspaces)
    
    
    # Workspace node creation
    $newNodeWorkspace = $xml.CreateElement('Workspace')
    $uuidWorkspace = UID
    $newNodeWorkspace.SetAttribute("uuid",$uuidWorkspace)
    $newNodeWorkspace.SetAttribute("name","Local")
    $xml.Landscape.AppendChild($newNodeWorkspace)
    
    
    # Saving XML
    $xml.Save($path)

And this is my result

This is what I wanted

Better, but. The result should be like this

name="Local"> **not** name="Local"**/**>

**not**

user97xF · Answer

You create the new nodes allright, but append the inner Workspace node to the wrong parent node.

Try

# Workspaces node creation
$newNodeWorkspaces = $xml.CreateElement('Workspaces')
# Workspace node creation
$newNodeWorkspace = $xml.CreateElement('Workspace')
$uuidWorkspace = [System.GUID]::NewGuid().Guid
$newNodeWorkspace.SetAttribute("uuid",$uuidWorkspace)
$newNodeWorkspace.SetAttribute("name","Local")

# append the Workspace node to the new Workspaces node
[void]$newNodeWorkspaces.AppendChild($newNodeWorkspace)

# then append that to the $xml.Landscape node
[void]$xml.Landscape.AppendChild($newNodeWorkspaces)

# Saving XML
$xml.Save($path)

Result:

Using Powershell to add attributes inside an XML

1 Answers