AbsysNET to Alma Data Delivery Specification
Migration Overview
- Indicate which local fields correspond to Ex Libris' expected fields using the AbsysNET Field Mapping Form prior to data delivery (customer responsibility).
Validate the flat files using Ex Libris’ Validation Tool Excel. It is recommended that this step be done against a small sub-set of data to ensure that the header of each of your flat files and the filled in field mapping form match each other. Note that the validation only works for CSV files. It is not possible to validate the AbsysNET flat files. If you do not modify the AbsysNET flat files after exporting them from AbsysNET, there is no need to validate them before sending them to Ex Libris.
- Extract the relevant data elements from AbsysNET into standard files (customer responsibility). Refer to the following data extract instructions from other AbsysNET customers who migrated to Alma on how to extract data using native AbsysNET functions that yield formats Ex Libris will accept for migration: https://developers.exlibrisgroup.com/blog/AbsysNET-to-Alma-Migration-Extract-tools
- Upload the files to Ex Libris’ secure file server along with the AbsysNET Delivered Files form and the executed/validated Non-ExLibris to Alma Validation Tool (customer responsibility).
- Transform the data elements, based on the Field Mapping form, into an intermediate conversion XML format (Ex Libris responsibility).
- Load the transformed data into Alma (Ex Libris responsibility).
AbsysNET Field Mapping Form
AbsysNET Delivered Files Form
AbsysNET Migration Form
Expected File Formats
Inventory
Bibliographic Records
Suppressed Bibliographic Records
Holding Records
- From Bib – Summary statement embedded in a bib tag.
- None – no holdings records are delivered. In this case, holdings records are generated from item information.
Holdings From a Bib Tag
Expected Field Name | Value | Notes |
---|---|---|
SUMM_TAG | Five characters; tag+2 indicators. May use # as wildcard, for example, 866## | |
SUMM_SUBFIELDS | Multiple subfields allowed, e.g. abz. May use # to indicate all subfields. | |
SUMM_CALLNO | Textual call number to be used in all newly generated holdings records if desired. | |
SUMM_LIB_SUBF | A single subfield code (like 'a') which contains a library code in local ILS format. Do NOT enter a different bib tag. The migration program searches for a subfield within the SUMM_TAG bib tag. | |
SUMM_LOC_SUBF | A single subfield code (like 'a') which contains a location code in local ILS format. Do NOT enter a different bib tag. The migration program searches for a subfield within the SUMM_TAG bib tag. | |
SUMM_LIB_CODE | If SUMM_LIB_SUBF is not provided or the subfield is not found, this is used for all records as a default. Provide a library code in local ILS format. | |
SUMM_LOC_CODE | If SUMM_LOC_SUBF is not provided or the subfield is not found, this is used for all records as a default. Provide a location code in local ILS format. | |
SUMM_PUBLIC_NOTE_SUBF | Public note, will be placed in 852 $z of the generated holding record | |
SUMM_NON_PUBLIC_NOTE_SUBF | Non-public note, will be placed in 852 $x of the generated holding record |
Items
Expected Field Name | Description | Note |
---|---|---|
COBARC | Code-barres | |
COFSAD | createDate | |
COUSAD | createdBy | |
COFSMD | updateDate | |
COUSMD | updateBy | |
CONTIT | No de titre | links to bib record field 002 |
COCOCL | Localisation | use in Alma Location map in migration form |
COFREC | Date de réception | |
COCOCP | Type exemplaire | use in Item Type map in migration form |
COCOSU | Succursale | use in Alma Location map in migration form |
COSIGN | Cote | data will be placed in 852 $h |
COSIGS-Call_Number_2 | Cote supplémentaire | place field COSIGS here to have the data be placed in 852 $i (second part of regular call number) |
COSIGS-Item_Call_Number | Cote supplémentaire |
place field COSIGS here to have the data be placed in Item Call Number. If customer uses this option, they MUST use 'bch' in the 852_subfield_for_hol question; if they use 'bc', then differing call number information may be lost - we can't put both into the same field Item_call_number. |
COSTAT | Situation exemplaire | use in item status map in migration form |
CONREG | No de registre | is placed in INVENTORY_NO in Alma |
COFINV | Date de Récolement | is placed in INVENTORY_DATE in Alma |
COCOPR | Provenance | |
CONPRE | Nbr de prêts | To see this value in Alma, search for the item under 'Physical Items' and on the results list click 'Other details'. |
COFULT | Date de retour | |
COCOCS | Support | use in Material Type map in migration form |
COIDVO | Identifiant de volume | is placed in item DESCRIPTION field |
Price | COVALU | Inventory Price |
REPLACEMENT_COST | COVALU | Use only if this is an actual replacement cost. If not, put only in the Inventory price field above. |
P2E_LINK | P2E_LINK | URL access to this material. This value is transferred to the holding record 856 subfield u, and then is used during the p2e process. |
P2E_NOTE | P2E_NOTE | This value is transferred to the holding record 856 subfield z, and then is used during the p2e process. |
TEMP_LIBRARY | Temporary Library | |
TEMP_LOCATION | Temporary Location | |
TEMP_ITEM_TYPE | Temporary item type | |
TEMP_CALL_NUMBER | temporary call number | |
TEMP_CALL_NO_TYPE | temporary call number type | |
PAGES | pages |
Item Notes
Note Name | Default Local Subfield | Note Label |
---|---|---|
PUBLIC_NOTE | ||
FULFILLMENT_NOTE | ||
NON_PUBLIC_NOTE_1 | ||
NON_PUBLIC_NOTE_1 | ||
NON_PUBLIC_NOTE_2 | ||
NON_PUBLIC_NOTE_2 | ||
NON_PUBLIC_NOTE_3 | ||
NON_PUBLIC_NOTE_3 | ||
STAT_NOTE_1 | ||
STAT_NOTE_2 | ||
STAT_NOTE_3 |
Secondary Item File
Expected Field Name | Notes |
---|---|
itemKey |
Provide either itemKey or itemBarcode, but not both. If both are provided, itemKey is preferred Always provide both fields, even when one is empty. E.g. itemKey,ItemBarcode,etc 12345,,etc ,bar123455,etc |
itemBarcode | |
itemDescription | Provide in a format such as: Vol. 12, No. 6 (February 2015) |
EnumA | For example, “12”. |
EnumB | For example, "6". |
EnumC | |
EnumD | |
EnumE | |
EnumF | |
EnumG | |
EnumH | |
ChronI | For example, "2015" |
ChronJ | For example, "2". |
ChronK | |
ChronL | |
ChronM |
Electronic Identification (P2E)
Fulfillment (Patrons and Circulation)
Patrons
Field Name | Description | Notes |
---|---|---|
LENLEC | No lecteur | use to link patron to loans, fines, requests |
LEFSAD | createDate | |
LEUSAD | createdBy | |
LEFSMD | updateDate | |
LEUSMD | updatedBy | |
LECOBI | Bibliothèque | campus code |
LEAPEL | Nom | |
LETI | Titre | |
LEIN | Middle Name | |
LENOMB | Lecteur | |
LECOLP | Type | |
LEFCAD | Date de fin de droit | |
LEFNAC | Date de naissance | |
LEFSUS | Date de suspension | if present, a block will be created with type 'CONV' |
GENDER | must contain 'Male' or 'Female' or leave blank | |
LANG | language | must contain two-letter ISO code https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes |
BLOCK_TYPE | block |
Use these fields only if providing a single block per patron. If multiple blocks are provided for a single patron, provide the blocks in a separate file. See User Block section below. |
BLOCK_NOTE | block | |
BLOCK_CREATE | block | |
BLOCK_EXPIRY | block |
User Addresses
Alma Address Field | AbsysNET Field Name |
---|---|
ADDRESS_LINE_1 | LEDI11 |
ADDRESS_LINE_2 | LEDI12 |
ADDRESS_LINE_3 | LEDI13 |
ADDRESS_LINE_4 | |
ADDRESS_LINE_5 | |
ADDRESS_CITY | |
ADDRESS_STATE | |
ADDRESS_CODE | LEDIZ1 |
ADDRESS_COUNTRY | If country is provided, it must be a three-letter ISO country code, which can be found here https://en.wikipedia.org/wiki/ISO_3166-1_alpha-3 |
ADDRESS_NOTE | |
ADDRESS_START | |
ADDRESS_END | |
Address Type (Select): | ALL |
SEC_ADDRESS_LINE_1 | LEDI21 |
SEC_ADDRESS_LINE_2 | LEDI22 |
SEC_ADDRESS_LINE_3 | LEDI23 |
SEC_ADDRESS_LINE_4 | |
SEC_ADDRESS_LINE_5 | |
SEC_ADDRESS_CITY | |
SEC_ADDRESS_STATE | |
SEC_ADDRESS_CODE | LEDIZ2 |
SEC_ADDRESS_COUNTRY | If country is provided, it must be a three-letter ISO country code, which can be found here https://en.wikipedia.org/wiki/ISO_3166-1_alpha-3 |
SEC_ADDRESS_NOTE | |
SEC_ADDRESS_START | |
SEC_ADDRESS_END | |
Secondary Address Type (Select): | ALL |
PHONE | The preferred phone should go in PHONE_PREFERRED, other phones in PHONE_x |
The preferred email should go in EMAIL_PREFERRED, other emails in EMAIL_x |
User Identifiers
Alma Identifier Type | AbsysNET Field Name | AbsysNET Field Name for Note |
---|---|---|
UNIV_ID | LEDDNI | |
BAR | LENLEC | |
ADDL_ID_1 | LEDDNN | |
ADDL_ID_2 | ||
ADDL_ID_3 | ||
ADDL_ID_4 |
User Statistical Categories
User Statistical Category | Local Field Name | Field Label |
---|---|---|
USER_STAT_CATEGORY | HOME INST | INST |
USER_STAT_CATEGORY | DEPT | DEPT |
USER_STAT_CATEGORY | SCHOOL | SCHOOL |
Notes
Note Name | Information |
---|---|
LIBRARY_NOTE | |
BARCODE_NOTE | |
ADDRESS_NOTE | |
OTHER_NOTE | The 'OTHER_NOTE' is marked by the migration programs as viewable by the user. |
User Blocks (if multiple blocks per patron)
If a single block is provided per patron, the blocks can be provided within the patron record. Otherwise, if there can be multiple blocks for a single patron, provide the blocks in this separate file.
Address Field | Instructions |
---|---|
PATRON_ID | There may be multiple lines in the file for a single patron ID - meaning that the patron has multiple blocks. |
BLOCK_TYPE | Use the User Block tab in the migration form. |
BLOCK_NOTE | |
BLOCK_CREATE | If this is not present, migration will use use patron create date, then patron migration date. |
BLOCK_EXPIRY |
Active Loans
Field Name | Description | Notes |
---|---|---|
PRBARC | Code-barres | links to item ID in item file |
PRFSAD | create date | |
PRUSAD | create_user | |
PRFSMD | update date | |
PRUSMD | update_user | |
PRPRSU | Succursale du prêt | |
PRCOCL | Localisation | |
PRNLEC | Lecteur | links to ORIGINAL_ID in patron file |
PRFPRE | Date de prêt | |
PRFDEV | Date de retour | |
PRRECL | Nbr de réclamations | checks if the loan was recalled; to keep actual number of recalls, also put this field in notes |
PRNREN | Nbr de renouvellements | checks if the loan was renewed; to keep actual number of renewals, also put this field in notes |
PRCORN | Origine renouvellement | |
PRRERE | Date de réclamation de réservation |
Note Name | Default Local Fields |
---|---|
NON_PUBLIC_NOTE |
Active Requests on the Hold Shelf
Field Name | Notes |
---|---|
REFSAD | |
REUSAD | |
REFSMD | |
REUSMD | |
RERESU | |
REBARC | item barcode |
RENLEC | links to User ID in patron file |
RECOSU | |
REFCRE | |
REFCOM | |
REFFIN |
Note Name | Default Local Fields |
---|---|
NON_PUBLIC_NOTE |