It's all about the answers!

Ask a question

Is there an API to update the db enumeration list

Subba Raju Datla (5147) | asked Aug 22 '12, 3:50 p.m.
We have custom attributes in our custom work item types. 
The custom attributes are using HTTP value set provider. The xml file they are pointing to gets its data from a third party tool. Whenever there are new values in the third party tool, the xml file is manually updated with the new values. In some instances these values are double byte characters (Chinese, Japanese.....)
Due to an issue we found with using double byte characters we are now looking to move to the new db enumeration option that has been introduced in 4.0. 
In 4.0 when a enumeration list is created we have the option to store the values in the database.
We would like to understand, what it would take to make this change. 

1. Will the new db enumeration list support double byte characters.
2. Is there an API to update values in a "db" enumeration list? We would like to use an API to directly update the values in the db by picking them up from the third party app or from a file
3. What is the impact of changing an attribute from http value set to enumeration? What will it take to move existing data from the xml files into the db?  Also, will this impact reporting and queries?

One answer

permanent link
Takehiko Amano (1.3k3741) | answered Aug 23 '12, 12:25 a.m.
Before looking into db enumeration, I'd suggest to fix Asian language issue. .xml is supposed to be UTF-8, but you said double byte characters. This is wrong (in UTF-8, they are 3-6 bytes). So I suspect there is a problem with encoding which is normally easy to fix.

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.