CA-PostersMetadataMapping.xls

	A	B	C	D	E	F	G	H	I	J	K
1	Rule type	Source	CA table.element	Group	Options	Refinery	Refinery parameters	Original values	Replacement values	Source description	Omeka Column

2	MAPPING	1	ca_objects.idno							Titles	dcterms:identifier
3	SKIP	2									FS ID Number (skip)
4	SKIP	3									Sideload Image File
5	SKIP	4									Google Drive image File name
6	SKIP	5									FS File Name (useless)
7	MAPPING	6	ca_objects.material_type
8	SKIP	7
9	MAPPING	8	ca_objects.physical_description
10	MAPPING	9	ca_objects.processinfo							Accession no.	These numbers merged into new object lot records
11	SKIP	10						orig repro dontknow	original reproduction unknown
12	MAPPING	11	ca_entities		{"skipIfEmpty": 1}	entitySplitter	{ "relationshipType": "creator", "entityType": "ind" }
13	MAPPING	12	ca_objects.date
14	SKIP	13
15	SKIP	14
16	SKIP	15
17	MAPPING	16	ca_objects.title
18	MAPPING	17	ca_objects.description
19	MAPPING	18	ca_objects.abstract
20	MAPPING	19	ca_objects.general_notes
21	CONSTANT	HSSM_Artifacts.Posters	ca_collections			collectionSplitter	{ "relationshipType":"part_of", "collectionType":"record_group", "matchOn": ["idno"] }
22
23
24
25		Setting name	Setting value	Description	Notes
26	Setting	name	Posters Mapping	Human readable name of the mapping	Arbitrary text
27	Setting	code	PosterMapping	Alphanumeric code of the mapping	Arbitrary, no special characters or spaces
28	Setting	inputFormats	XLSX	Sets types of source (input) data that can be handled by this import mapping. Values are format codes defined by the various DataReader plugins. You can specify multiple formats by specifying their format codes in a semicolon delimited list.	file type
29	Setting	table	ca_objects	Sets the table for the imported data	Corresponds to CollectiveAccess Basic Tables
30	Setting	existingRecordPolicy	none	Determines how existing records are checked for and handled for the mapping
31	Setting	errorPolicy	ignore	Determines how errors are handled for the import. "Stop" will halt the entire import on any error.
32	Setting	type	item	Set the target record's type_id
33	Setting	numInitialRowsToSkip	1	The number of rows at the top of the data set to skip. Use this setting to skip over column headers in spreadsheets and similar data.	If this is not set, the first row of your data set (the headers) will be imported as a record.
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100