Page 1 of 2

Quality Center

Posted: 22 Dec 2006, 09:33
by gmichaud
I'd like to synchronize Mantis with data from Quality Center (defects module). Did someone already have this need? What would be the best way to design a solution?

Posted: 25 Dec 2006, 13:18
by frentmeister
Need more Information about that!

Posted: 26 Dec 2006, 08:38
by gmichaud
Do you need more information to answer to my questions, or was it just to say that you're interested in this topic?

I'll take a stab:

Posted: 16 Jan 2007, 21:52
by hmackiernan
Hi Gmichaud:

If you have data on defects from some other source that you want to add to mantis, there is an extension that allows import of tabular issue data (like from an Excel spreadsheet or other delimited format).
That extension is described here:
http://www.mantisbt.org/bugs/view.php?id=4220
I was able to get this running and (with a few adjustments to hide fields we won't be importing) it works fine for slurping up spreadsheets of bugs
submitted by our clients (who don't have direct access to our Mantis install).

But, I suspect you're looking for something a little more automated, and for that you may want to investigate MantisConnect, written (at least in part, if not in its entirety) by Victor Boctor (vboctor on these forums).

for that, take a look here:
http://www.futureware.biz/mantisconnect/

Getting the Web services part installed on Mantis wasn't that difficult -- there's a few PHP pages etc. But writing the interface code b/w your Quality Center system and MantisConnect will probably take some forethought and design before you implement it -- but hopefully that's a start in the right direction. MC uses SOAP for communication which is a fairly standard Web Services framework.

I'm sure Victor can speak with more clarity on the subject.

Hope that helps

-h MacKiernan
San Francisco, CA

Ooh, almost forgot...

Posted: 16 Jan 2007, 21:54
by hmackiernan
there's a nice implementation of a MantisConnect client called Anonymantis that you may want to look at for ideas/guidance about implementing your own solution.

You can find more info about that here:
http://trac.geekisp.com/bleep/wiki/Anonymantis

-h

Thank you!

Posted: 17 Jan 2007, 07:50
by gmichaud
Thanks a lot for all this information!
(implementing my solution has been delayed, but I'll keep this topic updated)

VBScript

Posted: 23 Jan 2007, 08:28
by gmichaud
Is it possible to work with MantisConnect easily using VBScript?
I ask this question, because Quality Center native language (for customization) is VBScript...
(and it seems that VBScript can't use SOAP webservices without special toolkits, that I can't install on the Quality Center server of my company)

GetObject

Posted: 23 Jan 2007, 17:01
by gmichaud
I've managed to find this VBScript source code line*, which seems to work:
Set SoapObj = GetObject("soap:wsdl=http://localhost/mantis/mc/mantisconnec ... nnect.wsdl")

Indeed, the object SoapObj is correctly initialized. But then, I don't know how to access the methods and so on...
I've tried things like that:
SoapObj.mc_issue_exists("username", "password", 12)

Without success :-(
Do you see an obvious solution?

In mantisconnect.wdsl file, I've only modified soapAction attributes to set a correct URL... that's all!
Perhaps more customization (in this file) is needed to make the things work?

Thank you!


* From: http://www.microsoft.com/france/msdn/we ... heckb.mspx

Progress?

Posted: 23 Aug 2007, 15:50
by gusmauro
Did you find a solution about how to synchro QC with Mantis?
I'm interested to understand if it is possible..

Bad news :-(

Posted: 24 Aug 2007, 13:09
by gmichaud
Yes, I've found a solution: develop an interface between Mantis and Quality Center but without VBScript... so outside from Quality Center :-(
(VBScript was too restrictive)

Then, you're free to implement with any programming language which will be able to communicate with Quality Center (OTA API) and Mantis. From my side, I've chosen Visual Basic .NET (because many examples are provided in Quality Center help).

partage :)

Posted: 03 Feb 2009, 10:31
by acognard
Hello gmichaud,
i am really interested with your solution. I have to propose a gateway solution between HPQC and Mantis to my company. Would you please send me some code or information about your solution. Does it work properly ? What was the dificulties ?
Tks in advance.
Arnaud

Re: Quality Center

Posted: 09 Sep 2009, 10:39
by acognard
Hi all,
I am trying to use WebService to get a defect from our bug tracking tool using Testdirector.

But I am facing an issue

Code: Select all

Function GetDefect(Byval sLoginName, ByVal sPassword, ByVal issue_id)
  'On Error Resume Next

  Dim    SoapServer
  Dim    SoapMessage
  Dim    xmlhttp

Logger " GetDefect ",  " BEGIN "

       SoapServer = "http://dmethode/mantis/api/soap/mantisconnect.php"
       SoapMessage ="<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'> <soap:Body> <GetDefect xmlns='http://dmethode/mantis/api/soap/mantisconnect.php/mc_issue_get'>           <username>" & sLoginName & "</username>          <password>" & sPassword & "</password>     <issue_id>" & issue_id & "</issue_id></GetDefect></soap:Body></soap:Envelope>"

       set xmlhttp = CreateObject("MSXML2.ServerXMLHTTP")

       xmlhttp.open "POST", SoapServer, False
       xmlhttp.setRequestHeader "Man", POST & " " & SoapServer & " HTTP/1.1"
       xmlhttp.setRequestHeader "MessageType", "CALL"
       xmlhttp.setRequestHeader "Content-Type", "text/xml"
       xmlhttp.send(SoapMessage)

       Logger " GetDefect status", xmlhttp.status
       Logger " GetDefect statusText", xmlhttp.statusText
       Logger " GetDefect responseText", xmlhttp.responseText

       set xmlhttp = nothing

Logger " GetDefect ",  " END "

End function
status is 200, statustest is Ok,
but response is =Fatal Error : cannot redeclare class soap_fault in /user/share/pear/SOAP/Fault.php on line 129.

Can someone help me ?

Tks In advance.
Arnaud

Re: Quality Center

Posted: 05 May 2010, 19:56
by flesky
some news for this topic ? I want to make an aplication to make a sincronisation between quality center and mantis and I wan't to know if someone had succes.

Re: Quality Center

Posted: 05 May 2010, 20:23
by atrol
Mail to MantisBT developer mailing list. This is the better place to reach the experts for API related questions.

Re: Quality Center

Posted: 05 May 2010, 20:54
by acognard
Hello,
my solution was to write WebServices on Mantis server.

can give you some sample HPQC Workflow Code.

Sincerly.
Arnaud