It's all about the answers!

Ask a question

I can import an enumeration list from excel file??


Nada Loutfallah (1512) | asked Sep 02 '15, 7:08 a.m.
 Dear Support,

I need your help to import an enumeration list from an excel file.
Note that the CLM version is 5.0.2

Thanks

One answer



permanent link
sam detweiler (12.5k6195201) | answered Sep 02 '15, 8:11 a.m.
there is no built in function to do this.

if you use Eclipse, and look at the process config XML for enums, you will see the text layout

then you can use Excel text and concatenate function to make the appropriate text for your new enums, then cut/paste that text into the process xml..

I did this for 100 enums for a project

use care not to change the IDs of each enum over time, as it will mess up your workitems

Comments
Nada Loutfallah commented Sep 02 '15, 9:15 a.m.

 Thanks sam


Solution worked properly


MK Skelton commented Dec 18 '17, 1:04 p.m. | edited Dec 18 '17, 11:41 p.m.

Thank you for this post and solution.  It worked perfectly! :)

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.