import from QC: custom fields - lists

Wednesday, December 14, 2011

I imported my QC 10 project into spiratest and noticed the following:
my custom field in QC is a lookup list with 2 values (Yes/No). After import in Spiratest it a a normal text custom field. So you can enter whatever value.

How do I make a lookup list of this field in spiratest without loosing the values?

1 Replies
Wednesday, December 14, 2011
re: FilipBaert Wednesday, December 14, 2011
The problem is that QC stores all its data as text regardless of being a list or not. So you'd need to add new list fields in SpiraTest post-import. Then you'd need to write some SQL to populate the LIST_01 field from the values in TEXT_01 (in the TST_ARTIFACT_CUSTOM_PROPERTY) table in SpiraTest.

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885


  • Started: Wednesday, December 14, 2011
  • Last Reply: Wednesday, December 14, 2011
  • Replies: 1
  • Views: 2973