Bug #791

[810] :Final picklist values -- decide and agree on them

Added by Michael Lee almost 20 years ago. Updated over 17 years ago.

Target version:
Start date:
Due date:
% Done:


Estimated time:


Check with NRIS db for applicable picklists

closedLists.xml (31.5 KB) closedLists.xml Michael Lee, 12/02/2002 02:13 PM
VegBank_closedLists.csv (22.8 KB) VegBank_closedLists.csv Michael Lee, 12/02/2002 02:14 PM
VegBank_closedLists.xml (86.4 KB) VegBank_closedLists.xml Michael Lee, 12/12/2002 11:42 AM
create-xml-closed-lists.vba (8.1 KB) create-xml-closed-lists.vba Michael Lee, 12/12/2002 11:57 AM
closedLists.html (32.5 KB) closedLists.html Michael Lee, 01/17/2003 03:52 PM
vegbank-closed-lists.html (105 KB) vegbank-closed-lists.html Michael Lee, 02/04/2003 07:01 PM

Related issues

Is duplicate of VegBank - Bug #790: [812] :Final picklist values?:Make final decision on picklistsClosed11/13/2002


#1 Updated by Michael Lee almost 20 years ago

This is the xml document created from MS Access that shows the current closed
list values. The values will change in the next few weeks, perhaps even
months, however.

#2 Updated by Michael Lee almost 20 years ago

this csv document is simply a translation of the xml, as per John's request.

#3 Updated by Michael Lee almost 20 years ago

This new document should be more useful in that it includes sort order, value
desctipion, table and field (explicitly) as well as the source table (in
VegBranch). VBA script that generates this will soon be posted.

#4 Updated by Michael Lee almost 20 years ago

This is the VBA code that generates the XML doc. It must be embedded in a
VegBranch database to work, OR:
Have tables named like: aux_table_field where table is the name of the table
and field is the name of the field that has a closed list
''There must also exist a Z_FieldDescription table in the database which
documents which fields have closed lists
''As well as a query Z_FieldDescriptionOrd, which includes a table:
misc_SQL_2AccTypes which translates "access" data types into "SQL" types

#5 Updated by Michael Lee over 19 years ago

  • Bug 790 has been marked as a duplicate of this bug. ***

#8 Updated by Michael Lee over 19 years ago


#9 Updated by Michael Lee over 17 years ago

changed from components that are to be deleted to "misc" so that bugs don't get
deleted with component. Sorry for all the email.

#10 Updated by Redmine Admin over 9 years ago

Original Bugzilla ID was 791

Also available in: Atom PDF