Item Types - Pick List Template

[Update: Some of the the techniques shown here have been superseded by Excel lookups, please refer to later posts coming soon from Nov 2023]

Pick Lists are useful when working with Items Types, they save repetitive input and aid data consistency.

When creating pick lists of any length or when you have existing lists in some text format, it is far quicker to use Excel to create sources from which Pick Lists can be imported than to enter via the Pick List Manager.

An existing list can be exported to Excel to create a template, this can be the simplest route:

The Excel file must contain a worksheet named PickLists, where column A follows the format shown below (this example file is attached to the post):

Subsequent columns must have the Pick List name in row 1, followed by list values in the row below. List can be of unequal length.

The example file contains 50 list rows, cell A:51 contains the value 'PickList.Value50', for a list longer than 50 items use Excel copy/fill to increment this value to add more active rows. (any list values that do not have a corresponding 'PickList.Valuenn' value in Column A will not be imported.

To import the Pick Lists open or create a relevant DGNLIB, run the Pick List Manager then click the Import button:

Resulting in:

Note that while Pick Lists can be imported into any DGN, they should be imported into a DGNLIB for sharing with your colleagues.