Creating Sample Data for CSV Import and Data Update Tool

Creating Sample Data - Steps

1. Start with a properly formatted Data Dictionary.

2. Copy all cells including Header Row, and paste into second sheet called CSV Import Template.

3. 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.

4. Add sample data, following the guidelines below.

5. Once you have +/- 25 rows of sample data, copy the sheet to a new file.

6. Delete all header rows except Schema Field ID. If the first column has headers (e.g. UI Field Label), delete it as well.

7. Save as .csv, following the naming convention procedurename_profile_all.csv or authorityname_profile_all.csv.

8. Unless you are providing sample data for Object Cataloging, please enter data for every single field in the schema.

9. 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:

or: