This spreadsheet can be used to test the CollectionSpace CSV Importer:
To use the spreadsheet:
Download to your local storage or cloud
In each sheet in the document, wherever the ID number column reads in RED and BOLD “Your Initials”, replace with your initials so that the system won’t see a duplicate ID number. Only change the numbers in bold red; the other numbers in the spreadsheet are copied from those columns. For example:
Media Handling: MF_SampleMH_001
In each sheet in the document, go to File > Save As and save the sheet as a CSV. Give the CSV the same name as the open sheet in the workbook.
Upload the sheets into the CollectionSpace CSV Importer, in the order they appear in the workbook and with the noted Mappers. If you do not have an account on the CSV Importer, follow the instructions in the user manual.
CollectionObject, use Mapper collectionobject
Media Handling, use Mapper media
Object Media Relationships, use Mapper nonhierarchicalrelationship
Storage Location Authority, use Mapper location-local
Storage Location Hierarchy, use Mapper authorityhierarchy
LMI, use Mapper movement
Object LMI Relationships, use Mapper nonhierarchicalrelationship