TM1 Forum

Code: Select all

$headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
$headers.Add("Authorization", <Authentication Method - TM1/ CAM/ PA On Cloud/ AWS?>)

$csvfolder = <MyExportLocation>
$csvfile = $csvfolder + '<MyExportFileName>.csv'

$response = Invoke-RestMethod 'http://<ServerName>:<HttpPortNumber>/api/v1/Dimensions(''<DimName>'')/Hierarchies(''<DimName>'')?$select=Name&$expand=Elements' -Method 'GET' -Headers $headers
$response | ConvertTo-Json
$response.Elements | Export-Csv -Delimiter "," -Encoding "UTF8" -path $csvfile -NoTypeInformation

Write-Host $response

Code: Select all

#.\hot_promote_process.ps1 my_process_name DEV UAT PATCH

$processName  =$args[0]
$sourceEnv =$args[1]
$targetEnv = $args[2]
$method = $args[3]

function Set-Header {
    param (
        $EncodedText
    )
    
    $header = @{
        "Content-Type"="application/json; odata.metadata=none; odata.streaming=true; charset=utf-8"
        "Authorization"="Basic ${EncodedText}"
    }
    
    return $header
}

$sourceServer = switch ( $sourceEnv )
{
    "DEV" { "ip address/ host name"}
    "UAT" { "ip address/ host name"}
}

$targetServer = switch ( $targetEnv )
{
    "DEV" { "ip address/ host name"}
    "UAT" { "ip address/ host name"}
}

$sourcePort = switch ( $sourceEnv )
{
    "DEV" { "1234"}
    "UAT" { "5678"}
}

$targetPort = switch ( $targetEnv )
{
    "DEV" { "1234"}
    "UAT" { "5678"}
}

$Bytes = [System.Text.Encoding]::UTF8.GetBytes("user:pass")
$EncodedText =[Convert]::ToBase64String($Bytes)

$url = $url = "http://${sourceServer}:${sourcePort}/api/v1/Processes('$processName')"
$header = Set-Header $EncodedText
$response = Invoke-WebRequest -Uri $url -Method Get -Headers $header

$x = $response.content | ConvertFrom-Json
$x = $x | Select-Object * -ExcludeProperty Attributes
$body = $x | ConvertTo-Json

$url = $url = "http://${targetServer}:${TargetPort}/api/v1/Processes('$processName')"
$header = Set-Header $targetEncodedText
$response = Invoke-WebRequest -Uri $url -Method $method -Headers $header -Body $body

Code: Select all

#.\hot_promote_process.ps1 my_process_name DEV PRD PATCH

$processName = $args[0]
$sourceEnv = $args[1]
$targetEnv = $args[2]
$method = $args[3]

function Set-Header {
    param (
        $EncodedText
    )

    $header = @{
        "Content-Type"="application/json; odata.metadata=none; odata.streaming=true; charset=utf-8"
        "Authorization"="Basic ${EncodedText}"
    }

    return $header
}

$sourceServer = switch ( $sourceEnv )
{
    "DEV" { "20.123.178.99" }
    "PRD" { "ip address/host name" }
    "UAT" { "ip address/host name" }
}

$targetServer = switch ( $targetEnv )
{
    "DEV" { "ip address/host name" }
    "PRD" { "20.123.178.99" }
    "UAT" { "ip address/host name" }
}

$sourcePort = switch ( $sourceEnv )
{
    "DEV" { "8003" }
    "PRD" { "1234" }
    "UAT" { "1234" }
}

$targetPort = switch ( $targetEnv )
{
    "DEV" { "5678" }
    "PRD" { "6002" }
    "UAT" { "5678" }
}

$sourceUser = switch ( $sourceEnv )
{
    "DEV" { "admin" }
    "PRD" { "wim" }
    "UAT" { "wim" }
}

$targetUser = switch ( $targetEnv )
{
    "DEV" { "wim" }
    "PRD" { "admin" }
    "UAT" { "wim" }
}

$sourcePassword = switch ( $sourceEnv )
{
    "DEV" { "apple" }
    "PRD" { "apple" }
    "UAT" { "apple" }
}

$targetPassword = switch ( $targetEnv )
{
    "DEV" { "apple" }
    "PRD" { "apple" }
    "UAT" { "apple" }
}

$sourceUseSSL = switch ( $sourceEnv )
{
    "DEV" { 0 }
    "PRD" { 0 }
    "UAT" { 0 }
}

$targetUseSSL = switch ( $targetEnv )
{
    "DEV" { 1 }
    "PRD" { 1 }
    "UAT" { 1 }
}

$sourceProtocol = if ("${sourceUseSSL}" -eq 1) { "s" } else { "" }
$targetProtocol = if ("${targetUseSSL}" -eq 1) { "s" } else { "" }

[System.Net.ServicePointManager]::ServerCertificateValidationCallback = {$true}


# The source side

$sourceBytes = [System.Text.Encoding]::UTF8.GetBytes("${sourceUser}:${sourcePassword}")
# $sourceBytes = [System.Text.Encoding]::UTF8.GetBytes("${sourceUser}:${sourceUser}:${sourceNamespace}")
$sourceEncodedText = [Convert]::ToBase64String($sourceBytes)

$sourceURL = "http${sourceProtocol}://${sourceServer}:${sourcePort}/api/v1/Processes('$processName')"
$header = Set-Header $sourceEncodedText
$sourceResponse = Invoke-WebRequest -Uri $sourceURL -Method Get -Headers $header


# The target side

$x = $sourceResponse.content | ConvertFrom-Json
$x = $x | Select-Object * -ExcludeProperty Attributes
$body = $x | ConvertTo-Json

$targetBytes = [System.Text.Encoding]::UTF8.GetBytes("${targetUser}:${targetPassword}")
# $targetBytes = [System.Text.Encoding]::UTF8.GetBytes("${targetUser}:${targetUser}:${targetNamespace}")
$targetEncodedText = [Convert]::ToBase64String($targetBytes)


$header = Set-Header $targetEncodedText

if ("${method}" -eq "POST") { 
$targetURL = "http${targetProtocol}://${targetServer}:${targetPort}/api/v1/Processes"
} else { 
$targetURL = "http${targetProtocol}://${targetServer}:${targetPort}/api/v1/Processes('$processName')"
}

$targetResponse = Invoke-WebRequest -Uri $targetURL -Method $method -Headers $header -Body $body

Code: Select all

$InputFolder = $args[0]
$srcEnv = $args[1]
$tgtEnv = $args[2]


$Directory = $InputFolder + "\pro\"

function Get-ConfigIni 
{  
    param(  
        [parameter(Mandatory = $true)] [string] $filePath  
    )  
    
    $anonymous = "NoSection"
  
    $ini = @{}  
    switch -regex -file $filePath  
    {  
        "^\[(.+)\]$" # Get Sections from Ini File 
        {  
            $section = $matches[1]  
            $ini[$section] = @{}  
            $CommentCount = 0  
        }  

        "^(;.*)$" # Comment  
        {  
            if (!($section))  
            {  
                $section = $anonymous  
                $ini[$section] = @{}  
            }  
            $value = $matches[1]  
            $CommentCount = $CommentCount + 1  
            $name = "Comment" + $CommentCount  
            $ini[$section][$name] = $value  
        }   

        "(.+?)\s*=\s*(.*)" # Key  
        {  
            if (!($section))  
            {  
                $section = $anonymous  
                $ini[$section] = @{}  
            }  
            $name,$value = $matches[1..2]  
            $ini[$section][$name] = $value  
        }  
    }  

    return $ini  
}  

$configIni = Get-ConfigIni .\config.ini

$srcServer = $configIni.$srcEnv.admin_host
$srcPort = $configIni.$srcEnv.port_number
$srcUser = $configIni.$srcEnv.user
$srcPassword = $configIni.$srcEnv.password
$srcUseSSL = $configIni.$srcEnv.useSSL

$tgtServer = $configIni.$tgtEnv.admin_host
$tgtPort = $configIni.$tgtEnv.port_number
$tgtUser = $configIni.$tgtEnv.user
$tgtPassword = $configIni.$tgtEnv.password
$tgtUseSSL = $configIni.$tgtEnv.useSSL

function Set-Header {
    param (
        $EncodedText
    )

    $header = @{
        "Content-Type"="application/json; odata.metadata=none; odata.streaming=true; charset=utf-8"
        "Authorization"="Basic ${EncodedText}"
    }

    return $header
}


$srcHttp = if ("${srcUseSSL}" -eq 1) { "https" } else { "http" }
$tgtHttp = if ("${tgtUseSSL}" -eq 1) { "https" } else { "http" }

[System.Net.ServicePointManager]::ServerCertificateValidationCallback = {$true}


# The source side

$srcBytes = [System.Text.Encoding]::UTF8.GetBytes("${srcUser}:${srcPassword}")
# $srcBytes = [System.Text.Encoding]::UTF8.GetBytes("${srcUser}:${srcUser}:${srcNamespace}")
$srcEncodedText = [Convert]::ToBase64String($srcBytes)

foreach ($FileName in Get-ChildItem $Directory) {
	$FileType = $FileName.Extension
	if ("${FileType}" -eq ".pro") { 
		$processName = $FileName.Basename
		##
		$srcURL = "${srcHttp}://${srcServer}:${srcPort}/api/v1/Processes('$processName')"
		$header = Set-Header $srcEncodedText

		#$srcResponse = Invoke-WebRequest -Uri $srcURL -Method Get -Headers $header

		$srcErrorCode = 0
		try {
			$srcResponse = Invoke-WebRequest -Uri $srcURL -Method Get -Headers $header
		} catch {
			$StatusCode = [int]$_.Exception.Response.StatusCode
			$srcErrorCode = $StatusCode

		}
		if ("${srcErrorCode}" -eq 0) 
		{ 
			$srcErrorCode = $(Invoke-WebRequest -Uri $srcURL -Method Get -Headers $header).statuscode
		}

		# The target side
		if ("${srcErrorCode}" -eq 200) 
		{
			$x = $srcResponse.content | ConvertFrom-Json
			$x = $x | Select-Object * -ExcludeProperty Attributes
			$body = $x | ConvertTo-Json

			$tgtBytes = [System.Text.Encoding]::UTF8.GetBytes("${tgtUser}:${tgtPassword}")
			# $tgtBytes = [System.Text.Encoding]::UTF8.GetBytes("${tgtUser}:${tgtUser}:${tgtNamespace}")
			$tgtEncodedText = [Convert]::ToBase64String($tgtBytes)


			$header = Set-Header $tgtEncodedText

			#== Check if Process Exists in Target Server. If it Exists, use PATCH, otherwise, use POST

			$tgtErrorCode = 0
			$tgtURLCheck = "${tgtHttp}://${tgtServer}:${tgtPort}/api/v1/Processes('$processName')"
			try {
				$tgtResponse = Invoke-WebRequest -Uri $tgtURLCheck -Method Get -Headers $header
			} catch {
				$StatusCode = [int]$_.Exception.Response.StatusCode
				$tgtErrorCode = $StatusCode

			}

			if ("${tgtErrorCode}" -eq 0) 
			{ 
				$tgtErrorCode = $(Invoke-WebRequest -Uri $tgtURLCheck -Method Get -Headers $header).statuscode
			}	
			if ("${tgtErrorCode}" -eq 200 ) 
			{ 
				$method = "PATCH"
				Write-Output "Process $processName exists, therefore, using $method method"
			}
			else
			{
				$method = "POST"
				Write-Output "Process $processName does not exist, therefore, using $method method"
			}

			if ("${method}" -eq "POST") { 
				$tgtURL = "${tgtHttp}://${tgtServer}:${tgtPort}/api/v1/Processes"
			} else { 
				$tgtURL = "${tgtHttp}://${tgtServer}:${tgtPort}/api/v1/Processes('$processName')"
			}
			if ("${method}" -eq "POST") { 
				$tgtResponse = Invoke-WebRequest -Uri $tgtURL -Method $method -Headers $header -Body $body
			} else { 
				$tgtResponse = Invoke-WebRequest -Uri $tgtURL -Method $method -Headers $header -Body $body
			}
		}
		else
		{
			Write-Output "Unable to Hot promote process $processName"
		}
##
		
	}
    
}

Code: Select all

foreach ($FileName in Get-ChildItem $Directory -Filter "*.pro") {
	$processName = $FileName.Basename

Code: Select all

[DEV]
admin_host=localhost
port_number=8881
user=admin
password=apple
useSSL=0

[UAT]
admin_host=localhost
port_number=8882
user=admin
password=apple
useSSL=0