testcase id mapping between TestLink 1.7 vs TestLink 1.8

dalias · Post by **dalias** » Fri Mar 20, 2009 1:47 pm

Hi,
We are currently using TestLink 1.7 and are quite happy with it. I was checking out TestLink 1.8 and there are quite few features added on it that will definitely help but the only problem I have from upgrading is test case ids getting changed. Is it possible to somehow track what was old test case id i.e. from 1.7 to 1.8? We are using API for execution so if we upgrade we will not be able to use API until we map with new test case ids.

Any help is appreciated. I checked DB but was not able to find any table that will have this information

Sujal

Post by **fman** » Fri Mar 20, 2009 6:20 pm

Please check carefully because migration do not change internal id.

dalias · Post by **dalias** » Fri Mar 20, 2009 6:43 pm

It is changing because if I use search for test case id 4256 it shows up on TestLink 1.7.4 instance but if I try to search for same id on TestLink 1.8 nothing shows up after migration. I will try to migrate again and see if it changes it.

Sujal

Post by **fman** » Tue Mar 24, 2009 5:23 pm

You are wrong, what is happening now is :

search uses EXTERNAL ID not internal ID, that's why search fails

unixadmin007 · Post by **unixadmin007** » Tue Mar 24, 2009 9:26 pm

use this sql command to fix this issue

mysql> UPDATE tcversions a SET a.tc_external_id = (SELECT b.parent_id from nodes_hierarchy b where a.id = b.id);

dalias · Post by **dalias** » Tue Mar 31, 2009 7:20 pm

fman,
When I upgraded again from scratch, all IDs are coming back as '0' instead of actual test case id.

unixadmin007,
I was able to run the update so instead of seeing '0' I see testcase id that was in 1.7.4 so that fixed 1 issue. Search is still not working though for that particular test case id. Is there anything else that is needed to be updated for this to work?

Thanks for your help

unixadmin007 · Post by **unixadmin007** » Wed Apr 01, 2009 8:20 pm

in 1.8 RC search has been changed now you need to search like this,"TC-18772"

monsieur_jj · Post by **monsieur_jj** » Tue May 26, 2009 6:53 am

unixadmin007 wrote:in 1.8 RC search has been changed now you need to search like this,"TC-18772"

Has anyone made this work?

zmechz · Post by **zmechz** » Wed Jul 08, 2009 1:16 pm

It did not work here too.
The fields were updated and now Testlink shows the old Test case IDs, but the search option does not work.

malexs · Post by **malexs** » Tue Jul 14, 2009 10:42 am

we have the same problem.. using latest 1.8.3 after upgrading from testlink 1.7.4

if i create new test cases in an existing project where all test case id's are 0, it will come up with id's from 1, 2, 3, etc.

It seems that i cannot search for these test cases either by entering in either 2 or -2 ... However if i set the test case id prefix to be say "tc", then searching for "tc-2" will find the test case... So it appears that the test case id prefix is a required field for search to work.

Post by **fman** » Wed Jul 29, 2009 12:24 pm

external id is PREFIX-NNN, then you must indicate as searh criteria PREFIX-NNN