Global Excel Automation PowerShell Library 2.0.0.0 Published

Quick post to mention that version 2.0.0.0 of the GEM Automation library has been release. Here’s a list of notable changes:

Initial release available for version 2.0.0.0.

-Configuration data migrated to SQL Compact database
-Password protected, encrypted using AES256 using a password hashed with SHA512
– Modified Deploy-Build.ps1 and Set-ApplicationConfiguration.ps1 to get the configuration data from the database
– Modified function libApplicationRequestRouting.psm1 that sets web front end nodes Offline/Online for an application in the load balancers
– Several new functions to modify and query the configuration data:
Run-SQLCompactQuery
Remove-ApplicationConfiguration
New-WebSiteVirtualDirectoryConfiguration
New-WebSiteConfiguration
New-WebSiteBindingConfiguration
New-WebSiteApplicationPoolConfiguration
New-Environment
New-ConfigurationSetting
New-ConfigurationDatabase
New-ApplicationDeploymentTarget
New-ApplicationCredentialComponent
New-ApplicationCredential
New-ApplicationConfigurationFile
New-ApplicationConfiguration
Get-WebSiteVirtualDirectoryConfiguration
Get-WebSiteConfiguration
Get-WebSiteBindingConfiguration
Get-WebSiteApplicationPoolConfiguration
Get-NullIfEmpty
Get-Environment
Get-ConfigurationSetting
Get-ConfigurationDatabaseConnection
Get-ApplicationDeploymentTarget
Get-ApplicationCredentialComponents
Get-ApplicationCredential
Get-ApplicationConfigurationFile
Get-ApplicationConfiguration

You can download the latest release here

Enjoy!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s