Page 1 of 1
testcase id mapping between TestLink 1.7 vs TestLink 1.8
Posted: Fri Mar 20, 2009 1:47 pm
by dalias
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
Posted: Fri Mar 20, 2009 6:20 pm
by fman
Please check carefully because migration do not change internal id.
Posted: Fri Mar 20, 2009 6:43 pm
by dalias
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
Posted: Tue Mar 24, 2009 5:23 pm
by fman
You are wrong, what is happening now is :
search uses EXTERNAL ID not internal ID, that's why search fails
Posted: Tue Mar 24, 2009 9:26 pm
by unixadmin007
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);
Posted: Tue Mar 31, 2009 7:20 pm
by dalias
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
Posted: Wed Apr 01, 2009 8:20 pm
by unixadmin007
in 1.8 RC search has been changed now you need to search like this,"TC-18772"
Posted: Tue May 26, 2009 6:53 am
by monsieur_jj
unixadmin007 wrote:in 1.8 RC search has been changed now you need to search like this,"TC-18772"
Has anyone made this work?
Posted: Wed Jul 08, 2009 1:16 pm
by zmechz
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.
Posted: Tue Jul 14, 2009 10:42 am
by malexs
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.
Posted: Wed Jul 29, 2009 12:24 pm
by fman
external id is PREFIX-NNN, then you must indicate as searh criteria PREFIX-NNN