How to get variables from config file in powershell

Question

How can i get variables from a config file in XML ?

I am actualy doing this using a .txt config file.

There is my actual code :

Config.txt

[Repertoire de SPO (generalement C:\SPO)]
destinationn="C:\SPO"

[Nom du sous repertoire de SPO (generalement : SPO1)]
sous_destination="SPO1"

[Numero de la version de SPO vers laquelle vous souhaitez upgrade (par exemple : 1812.4)]
version="1812.4"

[Nom du pool dapplication lie a SPO (par defaut SPO_ADV)]
applicationPoolName="SPO_ADV"

[Chemin de livraison de la nouvelle version de SPO (par defaut \\path\to\somewhere)]
livraisonn="\\path\to\somewhere"

Powershell.ps1

Get-Content "$current_path\config.txt" | foreach-object -begin {$h=@{}} -process { $k = [regex]::split($_,'='); if(($k[0].CompareTo("") -ne 0) -and ($k[0].StartsWith("[") -ne $True)) { $h.Add($k[0], $k[1]) } }

$destinationn = $h.Get_Item("destinationn")

I would like to do a similar thing using an .xml config file.

You may want to have a look at the Script Get-IniContent from the TechNet Gallery which enables you to "parse" an ini-like file to return the values as a Hashtable — Razorfen
– Razorfen, Commented Jan 4, 2019 at 10:55
If you are open to reading JSON ot INI (i.e. TXT) files, consider github.com/alekdavis/ConfigFile — Alek Davis
– Alek Davis, Commented May 6, 2019 at 6:18
There is a much more convenient way to read settings using the ConvertFrom-Json Cmdlet in PowerShell to read a JSON formatted file: serverfault.com/a/1032517/293696 — Vladislav
– Vladislav, Commented Sep 3, 2020 at 7:21

Paweł Dyl · Accepted Answer · 2019-01-04 10:09:27Z

12

Xml is much easier to parse with PowerShell. See following example with comments:

#Translated XML config
@'
<root>
  <destinationn>C:\SPO</destinationn>
  <sous_destination>SPO1</sous_destination>
  <version>1812.4</version>
  <applicationPoolName>SPO_ADV</applicationPoolName>
  <livraisonn>\\path\to\somewhere</livraisonn>
</root>
'@ | Out-File YourSampleConfig.xml

#read xml file, skip root
$config = ([xml](Get-Content YourSampleConfig.xml)).root

#get <destinationn> value
$config.destinationn

answered Jan 4, 2019 at 10:09

Paweł Dyl

9,1831 gold badge13 silver badges28 bronze badges

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

2 Comments

xHypnosia Over a year ago

What is the "root" for here ?

Paweł Dyl Over a year ago

root is main, required node in xml: <root>...<root>. Name it whatever you want. If you name it <ABC>...</ABC>, you must chage it to ABC in script as well.

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

Getting connection string from App.Config

$appConfigFile = [IO.Path]::Combine($currentDirectory, '.\MyFile.config')

initialize the xml object

$appConfig = New-Object XML

load the config file as an xml object

$appConfig.Load($appConfigFile)

iterate over the settings which you want

foreach ($connectionString in $appConfig.configuration.connectionStrings.add) {
    # Get the connection string
    $dbconnectionstring = $connectionString.connectionString
}

Here's my config xml

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <add name="AtomicScopeConStr" connectionString="Server= localhost; Database= mydatabase; Integrated Security=True;" />
  </connectionStrings>
  <appSettings>
  </appSettings>
</configuration>

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jan 4, 2019 at 9:50

HariHaran

4,4592 gold badges26 silver badges39 bronze badges

1 Comment

Chris Patterson Over a year ago

This was a great help. See the working code in the answer below. (which is slightly different from above). My config file was essentially identical to the one above. Same elements.

Chris Patterson · Accepted Answer · 2020-03-27 03:10:42Z

1

This is a follow up to HariHaran's post. My connection.config file had the same elements and structure as his, but my working code is slightly different.

Use this to load the xml object

$appConfig = New-Object XML
$appConfig.Load($appConfigFile)

or use this

[xml]$appConfig = Get-Content $appConfigFile

and here is the working code to get the connection string

foreach ($xmlAddElement in $appConfig.connectionStrings.add) {
    $connectionString = $xmlAddElement.connectionString
    Write-Host "$connectionString"
}

answered Mar 27, 2020 at 3:10

Chris Patterson

5914 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to get variables from config file in powershell

3 Answers 3

2 Comments

Getting connection string from App.Config

initialize the xml object

load the config file as an xml object

iterate over the settings which you want

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Getting connection string from App.Config

initialize the xml object

load the config file as an xml object

iterate over the settings which you want

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related