Alma requires bibliographic, holdings, and item records. Koha has only bibliographic records and items. On migration, a holding record is created based on information in the Koha item record. See the MARC Holding Records section for more information.
Customer Input
Questionnaire Tab
Institution Code, Customer Code, Institution Name, Customer Name, Time Zone
Codes: INST_CODE, CUST_CODE – these are filled in by Ex Libris
INST_NAME, CUST_NAME – these are mandatory and must be filled in.
Default: N/A
Options: This question is mandatory.
INST_NAME and CUST_NAME: Fill these fields in with your institution’s name and your customer name (this is only different from the institution name if you are part of a consortium).
List Prefix for bibs from SFX or other management system
Code: SFX_PREFIX
Default: ‘(SFX)’
Options: string. If not indicating a link resolver management system, leave blank.
Further Information: If your Koha catalog contains records imported from SFX or another electronic resources management system and you are also migrating bibliographic records directly from SFX or the other management system, this may result in duplicate bibliographic records in Alma. You can enter a prefix here so that the migration programs can identify these bibliographic records and not migrate them to Alma to avoid creating duplicate SFX records in Alma. The migration programs do not make any attempt to physically merge the two records into one.
The default response to this question is (SFX), but you can enter any prefix that represents the bibliographic records that you want to exclude from loading into Alma. The migration programs search for the string in the 035 $a field of the MARC record. If you do not want to exclude any such records, leave this field blank.
If the migration programs identify bibliographic records containing the prefix in the 035 $a and the records in Koha are connected to a purchase order line and/or physical items, these bibliographic records are still migrated so that the purchase order and/or items can be migrated, but they are automatically suppressed in Alma to avoid end-user discovery duplication.
MARC Organizational Code
Code: MARC_OC
Default: None; this is not mandatory
Options: Enter your MARC organizational code, which will be used to construct the former system number in Alma. Only one code is allowed.
Further Information: The migration moves the value in the exported record’s 001 field (Koha bibliographic system number) to the 035 $a field:
(MOC)<Koha record id>-<customer code>
<(moc)> is the MARC Organization code specified here. is the <customer code> specified in the CUSTOMER_CODE question above.
For example: (AbC)123456-01abc
Do you use internal system numbers in $w of Linked Entry fields?
Code: LINKED_ENTRY_W
Default: No
Options: If Yes, the internal system numbers are converted from the Koha system number to the Alma system number.
Internal record designation for Linked Entry fields $w
Code: LINKED_ENTRY_PREFIX
Default: blank
Options: If there are internal system numbers in $w, indicate if they have a prefix that is used to identify these numbers (for example, (abc)12345). If the system numbers in $w do not have a prefix (for example, 12345), leave this question blank. If No for the LINKED_ENTRY_W question, then leave blank.
Further information on LINKED_ENTRY_W and LINKED_ENTRY_PREFIX: When bibliographic records are related to each other, such as a journal title that is superseded by a second journal title, Koha may store the information in bibliographic fields 76x-78x. If the number in the $w of the linking tags is the internal Koha system number, these numbers must be changed to the Alma representation of the system number. If your library does not use the internal system number to link and rather relies on more general identifiers such as the ISBN, ISSN, or shared cataloging DB (OCLC or DLC), these numbers are not modified.
In Alma, the system numbers in the $w field (along with $z and $x) are used to link two related bibliographic records together using the related records process. Related records can be found by clicking the More Info link on the Alma Search Results page.
Indicate which 852 subfields to use to determine unique holding records
Code: 852_SUBFIELDS_FOR_HOL
Default: bc (library and location only, not call number)
Options: To group all items on a single bibliographic record by library/location only, indicate bc here. If you have many items on the same bibliographic record in the same library/location but different call numbers WITHIN that library/location, and you want each of them to have their own distinct holding record, specify additional call number subfields. Acceptable subfields: bchijklmp.
The library and location codes are matched after the Alma Location Mapping has been performed, meaning the match is done on the Alma version of the library/location codes.
See sections: Determining Groups for Holding Record Creation/Matching, Changing the Holding Record Grouping/Matching
Move 852$c to Another Subfield
Code: MOVE_852C_SUBF
Default: k
Options: optional
Further Information: If you have data in your Koha holdings record 852 $c, it must be moved to a different subfield to accommodate the two levels of location in Alma – Alma library and location, which are in 852 $b and $c. Decide to which subfield you want the $c information moved. If nothing is specified or the response is incorrect (such as Yes or No instead of specific subfield), the default subfield is $k. Subfield $c is only moved for the relevant 852 tag. This means that if there are multiple 852 tags in the same holding record, the $c is only moved for the first 852 tag to make room for the sublocation in $c in Alma.
Limit exported records by location
Code: LIMIT_BY_LOCATIONS
Default: No
Options: If your export contains all of the data from a shared database, and you want to only migrate a part of that export to Alma, the migration programs can filter the data according to locations listed on the Location tab. In this case, the ALMAME_VALUE_NOT_FOUND line on the Location tab is not used. Inventory and Acquisitions are filtered by locations on the Location tab, and Fulfillment is filtered based on campus codes in the Campus Code tab. Use this option only if agreed upon with your Ex Libris project manager.
Bib Key Prefix
Code: BIB_KEY_PREFIX
Default: empty
Options: If you are combining data from two or more separate databases into a single combined institution in Alma, indicate a prefix here that will be used to distinguish the former system numbers in Alma after migration. For example, the different systems likely had completely different bibliographic records for system number 12345 and you want to be able to search for the specific bibliographic record from your own institution after go-live. The prefix does not include a hyphen so if you want a hyphen in the number (for example, PQ-12345), include it in the string. If you are not merging institutions, leave this question blank.
See also the MERGE_PATRON_PREFIX in Fulfillment.
Move 001/003 to 035 or 035
Code: 001_035_935
Default: 035
Options: If your incoming bibliographic records have a number in the 001, then the migration programs move it elsewhere as (<003>)<001>. For example: (OCoLC)12345. To move to the 035, which is the default, then select 035 in the dropdown. If you are part of a consortium and are using OCLC numbers to determine matching records when linking to the NZ, you may wish to move this number to the 935 so that the moved number does not interfere with another matching key you may be using. If you are not linking to the NZ, then this question is likely not useful. Default: 035
Use subfield indicators in item call number (AltCallNo)
Code: ITEM_CALLNO_SUBFIELD
Default: Yes
Options: When generating an Item Call Number field (also known as AltCallNo), you can decide if the string contains subfield indicators. Default = Yes
Yes = $h PZ3.A93 Pr16 $i A975
No = PZ3.A93 Pr16 A975
For more information on when an Item Call Number is generated, see the section Changing the Holding Record Grouping, which depends on the question 852_SUBFIELDS_FOR_HOL.
Add $9 LOCAL to specified tags
Code: NZ_LOCAL_TAGS
Default: empty
Options: Add $9 LOCAL to specified bib tags, for use in consortia where an IZ environment links to an NZ. Tags marked as Local will be kept in the IZ, and not moved to the NZ.
Format for this input: tag + indicator. Use # for any/wildcard, and b for the space character. Separate with semicolon.
Example: 59###; 69###;960##;970##;090b#
Alma Library Tab
Use this tab to create a list of Libraries in Alma. At least one library is mandatory.
Alma Library Code: Maximum 10 characters. Mixed case is valid, but not recommended. Do not use special characters or spaces. Allowed: - and _ (hyphen and underscore). Not allowed: !@#$%^&*()+=/?><.,\|]}[{`~ or the space character.
The Alma Library Code may not be the same as the Alma Customer Code nor the Alma Institution Code .
Alma Library name: Maximum 255 characters. Visible to the public.
Address lines: Alma allows you to specify address, phone, and e-mail information about each library. It is mandatory for a library to have a shipping/billing address in order to place orders in Alma. The migration process sets the designated address provided with all possible types in Alma (shipping, billing, claiming, etc.). At least one address line is mandatory.
Email: An email address is mandatory. The migration process sets the email address provided with all possible email address types in Alma.
Phone: The phone number must contain dashes (nnn-nnn-nnnn). A phone number with no dashes is not accepted by the migration program. Not mandatory.
Default language: Indicate the language of patrons and/or staff members if it differs for each library. Use two-letter codes as defined in ISO 639-1. Consult the codes at
https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes.
Further Explanation: Both Koha and Alma have two levels of location. Koha uses holding library and collection code and Alma uses library and physical/shelving location. Locations in Koha are generally analogous to the physical/shelving locations in Alma. Libraries are higher level units that contain groups of locations. Alma libraries serve as higher-level repositories for physical records and also determine policy groupings for their management and fulfillment. The lower-level physical location does not determine policy for an item and is only the physical shelving location or collection. All physical resources in your institution must belong to a library.
During the migration process, group your Koha locations into library groupings. The first step is to determine the list of libraries, using this tab. Next, map locations into Alma libraries and locations using the Alma Location tab.
If you use an error library (for example “EMPTY”) in the ALMAME_VALUE_NOT_FOUND line of the Location Mapping tab, be sure to list that library here on the Library tab.
Alma Location Tab
Use this tab to map your Koha locations to Alma libraries and locations. Mandatory.
Include ALL locations of ALL types, including electronic types that may ultimately be deleted in Alma. They still need to be provided in the Location tab mapping.
Koha holding library code: Value from the Location field in the item extract, 952 $b, in the embedded item tag in the bibliographic record. The ALMAME_VAL_NOT_FOUND line is required to catch any location codes you may have missed.
Koha collection code: Value from the collection field in the item extract, 952 $8, in the embedded item tag in the bibliographic record. The ALMAME_VAL_NOT_FOUND line is required to catch any location codes that you may have missed.
Alma Library Code: The library that will contain this location in Alma. This code must be present on the Alma Library tab, column A. The match is case-sensitive.
Alma Location Code: The new location code for this location in Alma. It can be a maximum of 10 characters. You can use the same location codes in Alma that you used in Koha, but this is not required. You may also use this form to collapse locations if desired, for example, refa and refb in Koha both map to ref in Alma. Mixed case is valid, but not recommended. Do not use special characters or spaces. Allowed: - and _ (hyphen and underscore). Not allowed: !@#$%^&*()+=/?><.,\|]}[{`~ or the space character.
Call Number Type: List the call number type for any newly created holdings records, based on the values for the 852 first indicator. (
http://www.loc.gov/marc/holdings/hd852.html). If we cannot determine the call number type from the item record itself, we use this as a default for all items in the location.
Alma Location Name: A description for this location as seen/used by library staff members. The same location name cannot be used for different locations in the same library, but the same location name can be used for different locations in different libraries. See the examples in the Further Information section below for what is acceptable and not acceptable. Maximum 255 characters.
Alma External Location Name: A description for this location as seen/used by the public. The same name can be used for as many different locations as desired. For example, the location names may be Archives A and Archives B, but the external location names can both be Archives. Maximum 255 characters.
Electronic Location? (Yes or No): Used by the P2E migration process to determine if a holding/item/order should be converted to electronic. See the
Physical to Electronic (P2E) Processing section for more information.
Suppress from Externalization? (Yes or No): Indicate if the location should be suppressed from being visible to the public. The items are not marked as suppressed, but no holdings or items with this location code are exported to Primo.
Further Information: Do not leave the Alma Location and Library Code fields blank. If you want to stop using a location code after migration, map the Koha code to an easily identifiable code such as XXX or unused just in case any stray items are still in your Koha database.
ALMAME_VALUE_NOT_FOUND
The ALMAME_VALUE_NOT_FOUND line must be included at the top of the list of locations, in case any location codes were overlooked when completing this map. For example, you may think that you do not have any items left in a certain collection, so you leave it off the location map. However, there may be one or two items left, or a stray holding record, etc.
By default, the location code for the ALMAME_VALUE_NOT_FOUND line is UNASSIGNED, which is the default catch-all in Alma in production mode. We recommend that you select your primary/largest library as the library code for the line, for example MAIN as in the example line below. In this case, the items inherit the configurations for the MAIN library. You may also decide to use a completely new library, such as EMPTY. However, if you use a library that is new, like EMPTY, then be sure to also include it on the Library tab.
Koha Location code |
Koha Locn Desc |
Alma Library |
Alma Location Code |
Alma Location Desc |
Alma External Loc Desc |
ALMAME_ VALUE_NOT _FOUND |
|
MAIN |
UNASSIGNED |
Problem location from Migration |
Problem: See Library Staff |
Post-migration, search for items in the UNASSIGNED location and correct the records appropriately.
Alma Location Name and Alma External Location Name
The Alma Location Name column contains the names of the location codes that are displayed in the staff interface. The names cannot be repeated in the Location Name column when the location codes both belong to the same library, but you can use the same name for two different locations, if these locations belong to different libraries. The Alma External Location Name column contains the names of the location codes that are displayed to library patrons. These names can be repeated within the column without regard for libraries. For example:
The following is acceptable:
Library |
Alma Location Code |
Alma Location Name |
Alma External Location Name |
Library A |
stacks |
Main Stacks |
Main Stacks |
Library B |
stacks |
Main Stacks |
Main Stacks |
Library A |
archa |
Archives A |
Archives |
Library B |
archa |
Archives B |
Archives |
Library A |
archstk |
Archives Stacks |
Archives |
Library A |
archref |
Archives Reference |
Archives |
The following is not acceptable:
Library |
Alma Location Code |
Alma Location Name |
Alma External Location Name |
Library A |
archstk |
Archives |
Archives |
Library A |
archref |
Archives |
Archives |
The Alma library and Alma location are put in the following places in the migrated or newly created MARC holdings record:
- The Alma library is placed in the 852‡b field.
- The Alma location is placed in the 852‡c field.
Collapsing Locations
This mapping table can be used to collapse location codes – that is, two or more location codes in Koha can map to a single location code in Alma. The Alma location and library code fields may not be empty. If you want to stop using a location code on migration, map the Koha code to an easily identifiable code such as XXX if any stray items are still in your Koha database.
If you collapse location codes, you may have lines in the table such as the following:
Koha Location Code |
Alma Library |
Alma Location Code |
Alma Location Name |
Alma External Loc Name |
Suppress from Externalization |
Electronic Location |
reserves |
MAIN |
RESERVES |
Reserves |
Reserve |
Yes |
No |
reservesElec |
MAIN |
RESERVES |
Reserves |
ReserveElec |
Yes |
Yes |
reservesShort |
MAIN |
RESERVES |
Reserves |
Reserve |
Yes |
No |
reservesPerm |
MAIN |
RESERVES |
Reserves |
Reserve |
Yes |
No |
The two values in bold italic above (ReserveElec as the External Location name, and Yes for Electronic location) are not used in Alma. Since the locations are being collapsed, the first line for the RESERVES Alma location is used, and all subsequent lines below it use the values from the first line.
Item Type Tab
Use this tab to migrate the Koha Item Type ($y) to the Alma Item Type. This tab is optional. The item type in Alma is not required, so if you leave this tab blank, no item policies in Alma are created.
Koha Item Type ($y): The value in the item type field of the Koha item. The item type is used to differentiate between items when determining how something circulates.
Koha Description: The description of the Koha item type, for information only. This column is not used during the mapping process.
Alma itemPolicy: The Alma value for the item type. This sheet can be used to collapse item types if desired. Do not use special characters, for example, slashes (/) or spaces in the code.
Alma Description: This description is loaded into Alma as the display text for the item types. These values can be changed after migration. Maximum 255 characters.
You can optionally include an ALMAME_VAL_NOT_FOUND line at the top of the map. If this line is included, any value not found or any blank value is assigned the value in the ALMAME_VAL_NOT_FOUND line. If the ALMAME_VAL_NOT_FOUND line is not included, any value not found, including blanks, is left as blank in Alma.
Item Base Status Tab
Use this tab to map your item statuses to Alma. This tab is not mandatory if you do not want to migrate your item statuses to Alma. There are three different fields which indicate a status in Koha: $4 damaged, $0 withdrawn, and $1 lost. We will use all three fields to determine a base status in Alma.
STATUS (combination of fields $4-$0-$1): The value in the status fields from the Koha item extract. The status typically indicates what is happening to the item, such as in binding, in repair, lost, etc. In Koha we will use three fields as indicated. Separate the values by hyphens, and use * to indicate that any status will match. For example, *-*-1 means: $4 any value, $0 any value, and $1 = 1. This will map to the status “Lost”.
Description: The description of the STATUS code(s). The text in this column is written to the internal note 1 in the item in Alma. Maximum 255 characters.
baseStatus: In Alma, the base status indicates whether or not the item is on the shelf. Indicate whether or not an item with this status is on the shelf. For example, lib use only is on the shelf (1), but withdrawn is not (0).
Further information: Alma has a process type that indicates the status of an item depending on the Alma workflow (item is on loan, item is sent to the bindery, etc.), but the process type is dependent on the corresponding Alma workflow. For migration, all item statuses that are indicated as not on the shelf (0) from Koha are given the process type of TECHNICAL. Further, the item status description field is written to internal note 1 for all items where there was a status, regardless of the shelf/not on shelf designation.
Include any status that may indicate no status, for example Available, but leave column B blank. This migrates the item to Alma with no status at all, which is how Alma indicates that an item has no status. If any status is in your data but is NOT included in column A, it is given a note of Unknown status.
Post migration, you can search for and re-route items with values in the internal note 1 to the appropriate handling or department in Alma. This process can also be used as a configurable criterion for suppressing items from display in the Get It services screens from discovery systems. See
Appendix A - Post-Migration Process Statuses for more information.
Material Type Tab
Use this tab to migrate any incoming Material type to the Alma Material type. The material type is not mandatory; if no material type is indicated for an item, one will be generated based on information from the bib fixed fields.
Incoming Material Type: The value in the material type field of the incoming item.
Material type Description: The description of the material type, for information only. This column is not used during the mapping process.
Alma Material Type: The Alma value for the material type. Material types in Alma are fixed. You cannot add any new types to the list. Select the appropriate material type from the drop-down list.
If this field is not provided in the extract, Alma migration assigns the item material type based on the fixed fields in the bib as described in section Material Type from Bib Fixed Fields below.
Shelving Scheme Tab
Alma generates a first indicator for the 852 based on the Shelving Scheme tab.
Koha $2 classification: The values in the Shelving Scheme tab as delivered in the extract from Koha. The commonly used values are included in the tab, but you can make additions or changes as necessary.
852 1st Indicator: List the value that should be used in the 852 first indicator field when generating a holding record from the item. For a list of possible values and their description, see
http://www.loc.gov/marc/holdings/hd852.html. Note that 7 is not supported on migration. Mandatory.
Description: A description or note for this shelving scheme value, if you need to make a note while deciding the first indicator value. This column is not used in migration.
Do not use an ALMAME_VAL_NOT_FOUND line here, because if an item has a shelving scheme that is not listed or does not have a shelving scheme value, the shelving scheme is taken from the Call Number Type column on the Location tab of the
Koha Migration Form.