Special note for this process: When manually reconciling and updating JSON instructions to add additional "known" subjects, retain those JSON instructions and update at the end of the process. Creating multiple pull requests branched from the same file will create multiple conflicts and prevent successful merging of JSON instructions.
- Load
DATE-named-subjects-INSTITUTION-DATATYPE.csv
ORDATE-subjects-INSTITUTION-DATATYPE.csv
into OpenRefine; renameDATE-named-subjects-INSTITUTION-DATATYPE-enriched.csv
ORDATE-subjects-INSTITUTION-DATATYPE-enriched.csv
- Add workflow columns: JSON
- Copy
subject_as_recorded
column and reconcile newrecon-subject
column against FAST terms: JSON - Apply list of previously reconciled or known FAST terms: Named Subjects JSON OR Subjects JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-1
andsubject-id-1
columns, reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Named Subjects JSON OR Subjects JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-2
andsubject-id-2
columns; consolidatesubject-label-1-2
andsubject-id-1-2
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Named Subjects JSON OR Subjects JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-3
andsubject-id-3
columns; consolidatesubject-label-1-2-3
andsubject-id-1-2-3
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Named Subjects JSON OR Subjects JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-4
andsubject-id-4
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Named Subjects JSON OR Subjects JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-5a
andsubject-id-5a
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Form Terms JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-5b
andsubject-id-5b
columns; consolidatesubject-label-4-5
andsubject-id-4-5
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Named Subjects JSON OR Subjects JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-6
andsubject-id-6
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Named Subjects JSON OR Subjects JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-7a
andsubject-id-7a
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Form Terms JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-7b
andsubject-id-7b
columns; consolidatesubject-label-6-7
andsubject-id-6-7
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Named Subjects JSON OR Subjects JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-8
andsubject-id-8
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Named Subjects JSON OR Subjects JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-9a
andsubject-id-9a
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Form Terms JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-9b
andsubject-id-9b
columns; consolidatesubject-label-8-9
andsubject-id-8-9
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Named Subjects JSON OR Subjects JSON
- Manually reconcile and extract known FAST terms, retain for update at the end of the process
- Add
subject-label-9a
andsubject-id-9a
columns; reconcile nextrecon-subject
column: JSON - Apply list of previously reconciled or known FAST terms: Form Terms JSON
- Manually reconcile and update known FAST terms: edit Named Subjects JSON OR Subjects JSON AND Form Terms JSON and submit pull requests
- Add
subject-label-10b
andsubject-id-10b
columns; consolidate all columns intoauthorized_label_add
andstructured_value_add
columns; finalize workflow: JSON - Remove any facets and filters
- Export full CSV from OpenRefine (retain file name)
json/subject/010-subject-workflow.json
json/subject/030-subject-recon-1.json
json/subject/040-subject-known.json
json/subject/040-named-subject-known.json
json/subject/060-subject-recon-2.json
json/subject/090-subject-recon-3.json
json/subject/120-subject-recon-4.json
json/subject/150-subject-recon-5a.json
json/subject/180-subject-recon-5b.json
json/subject/190-subject-form-known.json
json/subject/210-subject-recon-6.json
json/subject/240-subject-recon-7a.json
json/subject/270-subject-recon-7b.json
json/subject/300-subject-recon-8.json
json/subject/330-subject-recon-9a.json
json/subject/360-subject-recon-9b.json
json/subject/390-subject-recon-10a.json
json/subject/420-subject-recon-10b.json
json/subject/450-subject-finalize.json