Creating Sample Data for CSV Import and Data Update Tool
Creating Sample Data - Steps
Start with a properly formatted Data Dictionary.
Copy all cells including Header Row, and paste into second sheet called CSV Import Template.
Remove all blank columns, keep rows: UI Field Label, UI Field Type, UI Default Controlled List Contents, Schema Field ID, Schema Field Repeatable, Schema Group Repeatable, and Schema Option List Default Contents.
Add sample data, following the guidelines below.
Once you have +/- 25 rows of sample data, copy the sheet to a new file.
Delete all header rows except Schema Field ID. If the first column has headers (e.g. UI Field Label), delete it as well.
Save as .csv, following the naming convention procedurename_profile_all.csv or authorityname_profile_all.csv.
Unless you are providing sample data for Object Cataloging, please enter data for every single field in the schema.
Make a GitHub pull request: https://github.com/collectionspace/cspace-converter/tree/master/data
Creating Sample Data - Formatting Guidelines
For your first row, enter data in all fields, including multiple values in all multi-valued (repeatable) fields
Make sure that after your first row, all non-required fields include multiple empty cells in sample data
Values for multi-valued fields should be separated with a ;
Multi-valued fields with multi-valued sub-fields (e.g. Title) should be separated with a ; for each top-level instance and ^^ for each repeating value of the subfield (illustration below).
If a field points to more than one authority, create a column for each authority
Sample data for static lists should match the “schema option” list contents, new terms cannot be added via the tool
Sample data for dynamic lists should match the UI list contents, new terms can be added via the tool
To create synonyms for authorities, put the primary term in termDisplayName and synonyms in a new column called additionalTermDisplayName (can also add additionalTermStatus)
Use the values True or False for checkboxes
Examples
Multi-valued fields with multi-valued sub-fields, e.g.:
Model as:
title,titleLanguage,titleTranslation,titleTranslationLanguage
A Man; A Woman,English; English,Un Homme^^Hombre; Une Femme^^Fraulein,French^^Spanish; French^^German
or:
title | titleLanguage | titleTranslation | titleTranslationLanguage |
A Man; A Woman | English; English | Un Homme^^Un Hombre; Une Femme^^Fraulein | French^^Spanish; French^^German |