Crosswalk selected object-level metadata from Solr/Fedora exports to LIBSAFE Go template spreadsheet

[katfish2]

• Get 1) template spreadsheet for LIBSAFE Go object metadata upload and 2) metadata mapping (see comment below)
• Transfer selected metadata fields from CSV export created in Rerun Solr export and Fedora query for Disk Image objects to create object-level metadata files #120 to template
• Split resulting spreadsheet into collection-based spreadsheets (one per collection with a row for each disk image object within it) and upload collection spreadsheets to project folder

[katfish2]

For Zo: I'm attaching an Excel template to put the metadata into and a key showing what goes in each field. Please let me know if any of this is unclear or not feasible.

Keep-LSG md migration.txt

libsafe-md-import-template.xlsx

[rotated8]

LibSafeGo Column	Keep Column	Notes
title	title_exact
local_call_number	collection_source_id
holding_repository	"Stuart A. Rose Manuscript, Archives, and Rare Book Library"	Always this value
content_type	"Mixed material"	Always this value
creator	""	Leave blank
date_created	coverage
primary_language	""	Leave blank
note	description, hardware_name, hardware_other_info, hasDerivation, isDerivationOf	Concatenate these columns with pipes
rights_statement	rights
rights_statement_controlled	""	Leave blank
restrictions	"Preservation copy; no researcher access without further review."	Always this value
ref_id	""	Leave blank
component_id	""	Leave blank
acc_number	""	Leave blank
pid	pid
md5	content_md5

[katfish2]

Thanks for turning my notes into a proper crosswalk, @rotated8!

[kmichaelis]

Alex is working on this next. Naming file with pid is preferable but not necessary.

[kmichaelis]

@rotated8 add md5 column to crosswalk

[AGCooper]

New sample files added. Object csvs now have headers with some of the column titles crosswalked, and have the new names KF wanted. All of this data is based on a smaller version of the disk_image csv I made for quicker testing. All should have the right identifier and container id for libsafe now, both Objects and Collections.