Using Powershell to update environment attributes lengths

Question

Can someone point out the correct syntax to use powershell to update attribute lengths. When I created the attribute the length was set as 20 and now i would like to change that length to 26. IS there a way to do that through power shell?

Mohammad Masud · Accepted Answer

# Install the latest and greatest
Uninstall-Module -Name pwps_dab
Install-Module -Name pwps_dab -Force

# Restart PS and log onto your datasource
Open-PWConnection -GUI -Admin

<#
 Update the attribute length. 
 Note that:
 Switch parameter EnvironmentName can have space, so quotes are used, double quotes are preferable as they can be used with variables as well as a value.
 A Column name cannot have space, so use of quote is not necessary.
 -NewWidth is an integer, so do not use quote. 
 -verbose switch just gives you more information about the command processing; it is optional but good to understand how each cmdlet is working.
#>


Update-PWEnvironmentColumnWidth -EnvironmentName "Environment Name" -ColumnName Column_Name -NewWidth 26 -Verbose

Paul Patterson · Answer

Here's an example 
 
 Update-PWEnvironmentColumnWidth -EnvironmentName 'Enviro' -ColumnName 'DOC_STATUS' -NewWidth '35'

Paul Patterson · Answer

You'll need to make sure you have the pwps_dab powershell extensions - that's listed elsewhere on this forum 
 once installed;

new-pwlogin 
 
 undo-pwlogin

Using Powershell to update environment attributes lengths

Top Replies