To consolidate lists:
- Prepare Lists for Consolidation – Decide which list you want to use going forward. For example, if you have two subject lists, Campus Museum: Local Subjects (List B) and Visual Resources Collection: Local Subjects (List A), decide which to use. For this example, we will keep List A and consolidate List B terms into List A.
- Optional Step: Export terms from List B to Excel. If the terms between Lists A and B differ, you can bulk import the unique List B terms to List A.
- Clear values from project fields using List B. Follow the same steps detailed in Change a Field Type For a Field with Existing Data Using Excel, but do not re-import your preserved data (step 4). You will complete this step after changing the list connected to this field.
- Reconfigure Project Fields Connected to Lists – In the Administrative Tools, select your project then select the fields tab. Select the field that uses List B, then click Edit field.
- In the popup window, use the List Selection dropdown to select the list you want to use. In this example, replace List B with List A.
- Save your changes.
- If List B is connected to multiple fields, you will need to repeat these steps for each field you wish to disconnect from List B and connect to List A.
- Import Values to the Reconfigured List Field – As long as the terms exist in the newly connected List A (detailed above in the optional step 1.a.), then you can proceed with the steps detailed in Change a Field Type For a Field with Existing Data Using Excel to re-import your preserved data (step 4).
- Clean Up Unused Lists – Optional Step: If you wish to delete the lists you are no longer using, you can delete them following the instructions detailed in Delete List. If you do not want to delete the lists, you might consider removing permissions to the list so that your catalogers do not continue to add terms to this list. See Permission Users to List for more information about managing list permissions. You can also optionally rename any of the lists you consolidated.