{"id":759,"date":"2018-07-13T09:50:38","date_gmt":"2018-07-13T07:50:38","guid":{"rendered":"https:\/\/www.tests-performance.fr\/?p=759"},"modified":"2018-07-25T13:52:13","modified_gmt":"2018-07-25T11:52:13","slug":"connexion-alm-qc-pc-avec-powershell","status":"publish","type":"post","link":"https:\/\/www.tests-performance.fr\/?p=759","title":{"rendered":"Connexion ALM QC-PC avec PowerShell"},"content":{"rendered":"
L’automatisation de t\u00e2ches de gestion dans\u00a0ALM<\/span>\u00a0QC-PC<\/span>\u00a0via\u00a0Powershell<\/span>\u00a0est possible, mais il est convient de respecter la proc\u00e9dure suivante. Pour\u00a0info<\/span>, cette proc\u00e9dure n’existe actuellement pas le net. Le programme ci-dessous active un projet\u00a0ALM<\/span>\u00a0si celui-ci n’est pas activ\u00e9.<\/div>\n
Pour autoriser\u00a0l’\u00e9x\u00e9cution<\/span>\u00a0des scripts sign\u00e9s ou pas dans\u00a0Powershell<\/span>, il est n\u00e9cessaire de lancer dans\u00a0Powershell<\/span>\u00a0:\u00a0set-executionpolicy<\/span>\u00a0remotesigned<\/span><\/div>\n
Lancer le script via invite de commande :\u00a0powershell<\/span>\u00a0-File “ActivateProjet<\/span>.ps1″<\/div>\n
<\/div>\n
# Chargement des\u00a0Assembly<\/span>\u00a0n\u00e9cessaires \u00e0 l’utilisation des classes de connexion<\/div>\n
[Reflection<\/span>.Assembly<\/span>]::LoadFile<\/span>(“D:\\Sources\\\\Interop<\/span>.TDAPIOLELib<\/span>.dll<\/span>“) |\u00a0out-null<\/span><\/div>\n
[Reflection<\/span>.Assembly<\/span>]::LoadFile<\/span>(“D:\\Sources\\\\Interop<\/span>.SACLIENTLib<\/span>.dll<\/span>“) |\u00a0out-null<\/span><\/div>\n
<\/div>\n
$td<\/span>\u00a0=\u00a0New-Object<\/span>\u00a0-ComObject<\/span>\u00a0TDApiOle80.TDConnection<\/span><\/div>\n
$almsa<\/span>\u00a0=\u00a0New-Object<\/span>\u00a0SACLIENTLib<\/span>.SAapiClass<\/span><\/div>\n
<\/div>\n
$qualityCenterLink = “http:\/\/<SERVER>:8080\/qcbin”<\/div>\n
$qualityCenterDomain = “DEFAULT”<\/div>\n
<\/div>\n
# Saisie Password et Nom Projet<\/div>\n
$qualityCenterProject=Read-Host “quality Center Project”<\/div>\n
$qualityCenterUsername = Read-Host “quality Center User”<\/div>\n
$qualityCenterPassword=Read-Host “quality Center Password”<\/div>\n
<\/div>\n
# Connexion\u00a0ALM<\/span>\u00a0PC<\/div>\n
$td.InitConnectionEx($qualityCenterLink)<\/div>\n
$td.Login($qualityCenterUsername, $qualityCenterPassword)<\/div>\n
$almsa.Login($qualityCenterLink, $qualityCenterUsername, $qualityCenterPassword)<\/div>\n
<\/div>\n
[System.XML.XMLDocument]$Doc = New-Object System.Xml.XmlDocument<\/div>\n
$Doc.LoadXml($almsa.GetDomain($qualityCenterDomain))<\/div>\n
#Write-Host “Doc : ” $Doc.OuterXml<\/div>\n
<\/div>\n
#[System.XML.XmlNode]$ProjectList = $Doc.DocumentElement.SelectSingleNode(“PROJECTS_LIST”)<\/div>\n
#Write-Host “ProjectList : ” $ProjectList.OuterXml<\/div>\n
<\/div>\n
$node1 = $Doc.SelectNodes(“GetDomain\/PROJECTS_LIST\/TDXItem”)<\/div>\n
#Write-Host $node1.Count<\/div>\n
<\/div>\n
ForEach ($Project in $node1) {<\/div>\n
\u00a0 \u00a0 $Projet = $Project.SelectSingleNode(“PROJECT_NAME”).InnerText<\/div>\n
\u00a0 \u00a0 Write-Host “Projet : ” $Projet<\/div>\n
\u00a0 \u00a0 $ProjetActive = $Project.SelectSingleNode(“PR_IS_ACTIVE”).InnerText<\/div>\n
\u00a0 \u00a0 Write-Host “ProjetActive : ” $ProjetActive<\/div>\n
\u00a0 \u00a0 if ($ProjetActive -eq “N”) {<\/div>\n
\u00a0 \u00a0 \u00a0$almsa.ActivateProject($qualityCenterDomain, $qualityCenterProject)<\/div>\n
\u00a0 \u00a0 \u00a0Write-Host “Projet” $qualityCenterProject “activ\u00e9 !”<\/div>\n
\u00a0 \u00a0 } else {<\/div>\n
\u00a0 \u00a0 \u00a0Write-Host “Projet d\u00e9j\u00e0 activ\u00e9”<\/div>\n
\u00a0 \u00a0 }<\/div>\n
}<\/div>\n
$td.Disconnect()<\/div>\n
$td.Logout()<\/div>\n
$almsa.Logout()<\/div>\n","protected":false},"excerpt":{"rendered":"

L’automatisation de t\u00e2ches de gestion dans\u00a0ALM\u00a0QC-PC\u00a0via\u00a0Powershell\u00a0est possible, mais il est convient de respecter la proc\u00e9dure suivante. Pour\u00a0info, cette proc\u00e9dure n’existe actuellement pas le net. Le programme ci-dessous active un projet\u00a0ALM\u00a0si celui-ci n’est pas activ\u00e9. Pour autoriser\u00a0l’\u00e9x\u00e9cution\u00a0des scripts sign\u00e9s ou pas dans\u00a0Powershell, il est n\u00e9cessaire de lancer dans\u00a0Powershell\u00a0:\u00a0set-executionpolicy\u00a0remotesigned Lancer le script via invite de commande :\u00a0powershell\u00a0-File […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[27],"class_list":["post-759","post","type-post","status-publish","format-standard","hentry","category-performance-center","tag-tests-de-performance"],"acf":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tests-performance.fr\/index.php?rest_route=\/wp\/v2\/posts\/759","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tests-performance.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tests-performance.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tests-performance.fr\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tests-performance.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=759"}],"version-history":[{"count":4,"href":"https:\/\/www.tests-performance.fr\/index.php?rest_route=\/wp\/v2\/posts\/759\/revisions"}],"predecessor-version":[{"id":1167,"href":"https:\/\/www.tests-performance.fr\/index.php?rest_route=\/wp\/v2\/posts\/759\/revisions\/1167"}],"wp:attachment":[{"href":"https:\/\/www.tests-performance.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tests-performance.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tests-performance.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}