Data standards at NPL
This document is intended to provide a structure for normalizing data. It is by no means an exhaustive treatise on the topic, nor is it an authority. It is simply this- if you want to get your data into a standard order, here's what NPL did, how we did it, and what I wish we had done. While it may not be the 'best' way, consider that it is at the very least a way to get everything standard so that tweaking procedures becomes easier.
One of the strongest tools in the data-nitpicking tool kit is Open Refine. This application is a way of taking a spreadsheet and massaging it into a database ready format.
See the 'Refine Help' page for instructions on how to apply the snippets of code.
Other standards:
File Naming Conventions:
Specimen Photographs: NPL_12345_1_a1.jpg
<Prefix>_<Catalog Number>_<Suffix>_<Qualifier>_<Component><index>.jpg
Accession Records 2014-004_AccessionRecord.pdf
template file name <donor or internal><"Accession Record">.pdf
SAVE AS and change the donor or internal to the accession number and an underscore.
Project Documentation
to be determined