data import mapping template
TRANSCRIPT
7/27/2019 Data Import Mapping Template
http://slidepdf.com/reader/full/data-import-mapping-template 1/9
Rule type Source
Mapping #Enter source column from dataset as number (column A =1, B = 2)
Mapping #Enter source column from dataset as number (column A =1, B = 2)
Constant #Enter value to be applied for constant data#
Mapping #Enter source column from dataset as number (column A =1, B = 2)
Mapping #Enter source column from dataset as number (column A =1, B = 2)
SKIP #Enter source column from dataset as number (column A =1, B = 2)
Setting name
Setting name
Setting code
Setting inputFormats
Setting table
Setting type
Setting numInitialRowsToSkip
Setting existingRecordPolicy
Setting errorPolicySetting archiveMapping
Setting archiveDataSets
7/27/2019 Data Import Mapping Template
http://slidepdf.com/reader/full/data-import-mapping-template 2/9
CA table.element
#ca_table.element_code#
#ca_table.element_code#
#ca_table.element_code#
#ca_entities.example_splitter#
#ca_table.element_code#
Setting value
#Assign_unique_name_for_mapping#
#Assign_unique_name_for_code#
#file_type#
#ca_table#
#assign_record_type#
#number#
#select_policy#
# ignore or stop##yes or no#
#yes or no#
7/27/2019 Data Import Mapping Template
http://slidepdf.com/reader/full/data-import-mapping-template 3/9
Group
#Name_Group (to map multiple lines into single container)#
#Name_Group (to map multiple lines into single container)#
Description
Human readable name of the mapping
Alphanumeric code of the mapping
Sets types of source (input) data that can be handled by this impor
Sets the table for the imported data
Type to set all imported records to. If import includes a mapping to
The number of rows at the top of the data set to skip. Use this setti
Determines how existing records are checked for and handled for t
Determines how errors are handled for the import. "Stop" will haltSet to yes to save the mapping spreadsheet; no to delete it from th
Set to yes to save the data spreadsheet or no to delete it from the
7/27/2019 Data Import Mapping Template
http://slidepdf.com/reader/full/data-import-mapping-template 4/9
Options Refinery
entitySplitter
Notes
Arbitrary text
Arbitrary, no special characters or spaces
file type
Corresponds to CollectiveAccess Basic Tables
CollectiveAccess list item idno
Numeric value
e mapping
the entire import on any error.e server after import
erver after import
7/27/2019 Data Import Mapping Template
http://slidepdf.com/reader/full/data-import-mapping-template 5/9
Refinery parameters Original values Replacement values
{ "relationshipType":
"#relationship_type#",
"entityType":
"#entity_type#",
"skipIfValue":
["unknown"]}
original_value replacement_value
7/27/2019 Data Import Mapping Template
http://slidepdf.com/reader/full/data-import-mapping-template 6/9
Source description
7/27/2019 Data Import Mapping Template
http://slidepdf.com/reader/full/data-import-mapping-template 7/9
Notes
7/27/2019 Data Import Mapping Template
http://slidepdf.com/reader/full/data-import-mapping-template 8/9
Mapping ignore none yes XLSX
Constant stop skip_on_idno no XLS
Setting merge_on_idno MYSQL
SKIP overwrite_on_idno FMPDSO
skip_on_preferred_labels Inmagic
merge_on_preferred_labels MARC
overwrite_on_preferred_labels CollectiveAcc
skip_on_idno_and_preferred_labels
merge_on_idno_and_preferred_labels
overwrite_on_idno_and_preferred_labels
7/27/2019 Data Import Mapping Template
http://slidepdf.com/reader/full/data-import-mapping-template 9/9
ca_object_lots
ca_objects
ca_entities
ca_collections
ca_occurrences
ca_loans
ca_places
ca_movements
ca_object_events
ca_object_lot_events
ca_sets
ca_set_items
ca_object_representations
ca_storage_locations
ca_lists
ca_list_items