Setting Up an Item Creation Column

When you set up a column for item creation, you specify where Horizon should look to find information such as call number, collection, item status, itype and location. This information becomes part of the new item record Horizon creates. You may also need to set up a priority for each subfield from which Horizon extracts information. Horizon checks the subfield with the lowest priority number first.

For example, suppose you had these tags and subfields containing call numbers:

050 a and b

090 a and b

092 a and b

099 a

You want Horizon to check tag 050 a first, so you enter the tag and subfield in the Item Map group entry and assign it priority 1:

Sometimes two or more fields of a tag contain part of the item information you want to extract. The Concatenation Order field tells Horizon which subfield to extract information from first so that the information will be entered in the correct order in the item table. (For example, if you want Horizon to extract call numbers and the classification number in subfield a with the cutter number in subfield b, enter a “0” in the Item Map setup for subfield a and a “1” in the Item Map setup for subfield b of the tag you are using. This assures that the call number will be entered in the correct order in the item table.)

Here are some examples that show how you might set up item import parameters to extract this information:

Item Information

View Setup


Collection (one collection stored in a single subfield)


Location
(two possible locations, each stored in a separate subfield)

For the second location, priority is different, but concatenation order is the same. Horizon will check n before it checks l. Only information from one subfield will be extracted.


Call Number
(one call number with two parts stored in two subfields)

For the second call number, priority is the same, but concatenation is different. Horizon will extract information from x before it extracts from y. Information in both fields will be extracted.

To set up item creation columns

View: import_item_column

In these fields, do the following:

Field

Action

Import Source

Enter or choose the code for the import source for which you are setting up item creation parameters.

Item Column

Enter the column in the item table where the item information is stored.

(For a list of columns for each table, see the Table Structures Guide.)

Preserve Existing Data

If you want to keep existing values (such as a call number) for an existing item record that Horizon wants to overlay, mark this box.

Default Value

If you want to, enter a default value that Horizon stores in the column.

This value should correspond to a defined code for the column. (For example, if the column is collection, enter the default value of the collection codes that is set up in the collection table.)

In the Item Map group fields, do the following:

Field

Action

Tag

Enter the tag number that contains the item information.

Subfield

Enter the subfield that contains the specific information to be stored in the column.

Priority

If the bib tag contains more than one subfield with information you want to extract, enter a priority level for each subfield that indicates the order in which you want Horizon to check each subfield.

Horizon checks the subfield with the lowest priority number first.

Important: If only one subfield contains the item information you are working with, enter “0” (zero).

Concatenation Order

If two or more subfields contain part of the item information, enter a concatenation order for each subfield that has part of the information.

Horizon extracts information from a subfield with the lowest concatenation order number first. (For example, Horizon would extract information from a subfield with the concatenation number 5 before a subfield with the concatenation number 8.)

Important: If only one subfield contains the item information you are working with, enter “0” (zero).

Concatenation Suffix

1 If you want to separate the concatenated values Horizon extracts from multiple fields with a suffix, specify one here. (For example, enter a dash [ - ] to have Horizon place a dash between a classification number found in subfield a and a cutter number found in subfield b.)
2 If more than one subfield contains information you want to store in the column you are working on, click New and complete the fields in this table for the subfield.
3 If you have another item table column for which you want to extract item information from imported bib records, complete the fields in all of the tables in this task for the new item table column.

You must set up parameters for each column you want filled for an item. (For example, you can set up parameters for the call number, the item status, the collection, and the item type.)

 


© 1998-2017 Sirsi Corporation