in testlink 1.9.7 integrated with jira with soap interface

[Nehru Saini]

in testlink 1.9.7 integrated with jira with soap interface. When clicked in testlink on failed test cased and then click on export to spreadsheet, it gives junk number in excel.

[Nic Brough -Adaptavist-]

It's not clear whether the export to Excel is in from Jira or Testlink. You haven't said which column is giving a "junk number" or where the data for it is coming from.

Could you explain in more detail?

[Nic Brough -Adaptavist-]

Again, where are you exporting this from?

[Nehru Saini]

Thanks Nic for response,

There is a column:

Bugs (ID : Summary)

In this column, I am getting junk value in excel which I get after clicking on export data as spreadsheet .

[Nehru Saini]

I am exporting this from testlink.

Regards,

~Nehru

[Nehru Saini]

Please let me know

This is the setting I have done for jira integration in testlink.

Jira Soap interface

<issuetracker>

<username>nehru</username>

<password>xxxxxxxx</password>

<uriview>https://jira.test.com/browse/</uriview>

<uriwsdl>https://jira.test.com/rpc/soap/jirasoapservice-v2?wsdl</uriwsdl>

<uribase>https://jira.test.com</uribase>

<uricreate>https://jira.test.com/secure/CreateIssue!default.jspa</uricreate>

<projectkey>TEST</projectkey>

</issuetracker>

[Nic Brough -Adaptavist-]

Give us a chance - there are things like sleep, family and paid work to do!

The integration you've given is to enable Testlink to create Jira issues, but the data you are extracting is from Testlink, so it's irrelevant. You need to work out what Testlink is doing - where the junk number comes from, how Testlink generates it and why.

Jira may well be the source of the number, but until you know where Testlink is getting the number from (which is something you've configured in Testlink), it's not really worth asking about Jira.

What is the actual field that Testlink is showing a random number in?

[Nehru Saini]

Can I you response on it please.

Regards,

~Nehru

[Nehru Saini]

in Bugs (ID: Summary)

I am getting following:

129584:QA - Store Locator maps and Direction - Error message for invalid start address is displaying as pop-up and wording of error message are not correct.

whereas it should be:

TEST-1751:[Indefinite Hold]:QA - Store Locator maps and Direction - Error message for invalid start address is displaying as pop-up and wording of error message are not correct.

[Nic Brough -Adaptavist-]

Right, so where is Testlink getting that 129584 from? How have you configured it ot acquire that field from Jira?

I can see it's supposed to be for getting the ID field and I suspect I know what it's actually doing, but what it's doing is done in Testlink. The "integration" you've given is for creating issues, nothing to do with getting data back from Jira.

[Nehru Saini]

no idea where it is getting it from. But when I create test cases and I just add bug from there, and even when I click on link it opens that jira link correctly.

[Nic Brough -Adaptavist-]

So it's linking correctly somehow, but Testlink is configured to output a number instead of a useful string.

(For what it's worth, I *suspect* the number you're seeing is the Jira issue ID in the database, rather than the issue Key/status combination you want)

This is stuff configured in Testlink, which I don't know well enough to help you. It really does feel like the integration is correct and working ok, but Testlink is not giving you the right data.