data import mapping template

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