Context -- I'm looking at OHC's skeletal data spreadsheet and wondering how it gets imported.
This question is specifically referring to Cataloging > Other Number field
We have (this is fake data – IRL it looks like only 2 columns at a time are filled in):
| Other Number - Previous Catalog Number | Other Number- SOD | Other Number: OAI |
|---|---|---|
| A 14/46.15385 | 150017 | 33 RO 22 |
First concern: The values for these numbers in the Other number > Type dropdown are:
- Previous Catalog Number
- SOD Number
- OAI Number
So I'm assuming we have to change the spreadsheet to at least match their established controlled values. But how, which leads to...
Second question: Does the converter tool know to change the value in the header row into the type value? If so, do we need to fix the header values to match what's in the controlled vocab for type in this field?
OR do we need to add new columns, like:
| Other number number 1 | Other number type 1 | Other number number 2 | Other number type 2 | Other number number 3 | Other nunmber type 3 |
|---|---|---|---|---|---|
| A 14/46.15385 | Previous Catalog Number | 150017 | SOD Number | 33 RO 22 | OAI Number |
In which case, it seems impossible to make a generic template that will work. OHC has 18 different number types, and this seems highly specific to different institutions.