Quality Center

[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?

[frentmeister]

Need more Information about that!

[gmichaud]

Do you need more information to answer to my questions, or was it just to say that you're interested in this topic?

[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

[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

[gmichaud]

Thanks a lot for all this information!
(implementing my solution has been delayed, but I'll keep this topic updated)

[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)

[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

[gusmauro]

Did you find a solution about how to synchro QC with Mantis?
I'm interested to understand if it is possible..

[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).

[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

[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

[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.

[atrol]

Mail to MantisBT developer mailing list. This is the better place to reach the experts for API related questions.

[acognard]

Hello,
my solution was to write WebServices on Mantis server.

can give you some sample HPQC Workflow Code.

Sincerly.
Arnaud