Record Import & Overlay Options

Summary: This procedure provides an overview on how to import bib records and overlay them on existing records using either Data Import or the single-record import command in Inventory.

Contact	Autumn Faulkner
Team	CMS
Updated	July 2024
Created	March 2024

Import & overlay options

	Data Import (preferred)	Single-record import in Inventory	Push from Connexion (not recommended)

	Data Import (preferred)	Single-record import in Inventory	Push from Connexion (not recommended)
Carries over local Connexion edits?		Only imports the OCLC master record.
Allows overlay?
Auto-generates holdings/items?	Can be fully customized for different types of cataloging.	Yes, but generic; must be edited after. Use macros, copy/paste text strings, etc., instead of typing in values to reduce errors.
Multiple records at once?
Process	Prepare the MARC file Perform usual cataloging in Connexion, including Local edits to records Addition of 949 string Update holdings Save to save file Select records from save file that you wish to export Select export command Locate your export file on your desktop; change the file extension from .dat to .mrc The first time you export in your Connexion session, you'll be asked to choose a file location; subsequent exports continue to use this same location instead of asking you. Additionally, if you do not change the file extension after each export, Connexion will add records to that same .dat file instead of creating a new one. For best results, just delete your .mrc file after each import! Import into FOLIO Open Data Import app Drag and drop or upload your .mrc file Choose desired job profile from the menu Actions → Run → Run	In Connexion For any edits appropriate for the master record, replace and update Remember that local edits can also be made later in QuickMarc Copy the OCLC number In Inventory To create a new instance, with or without generic holdings/item records Actions → Import Choose your unit, and then your desired "target" from the dropdown menu Paste OCLC record number Click "Import" To overlay on an existing instance Open the instance record you intend to overlay Click the blue Actions button in the top right of the instance record pane Choose Overlay on source bibliographic record Choose your unit, and then your desired "target" from the dropdown menu Paste OCLC number Click "Import"	In Connexion Ensure this export option is the default (Tools→ Options → Export) Create/edit your record as usual Update holdings and export In Inventory Locate new instance Create new holdings record with appropriate values Create new item record with appropriate values
Notes	This method can be used both to import new or overlay on existing instance records, regardless of whether they are source MARC or FOLIO. Set up on your desktop and in Connexion Open Windows File Explorer and check View tab; make sure "File name extension" is checked Set up export to file in OCLC Connexion Tools → Options → Export tab Select "File: (Prompt for filename)" and click "Apply Create 949 constant data in Connexion, using template below	The list of target job profiles you can select from accommodate the following scenarios: Overlaying on an uncataloged instance and keeping it uncataloged Overlaying on an uncataloged source MARC or FOLIO instance, and generating a generic holdings/item Overlaying on a cataloged instance only, with no updates to existing holdings/item	Set up in Connexion Tools → Options → Export Create → OCLC Gateway Export Host name = https://michstate-lm.folio.ebsco.com/ Port = 8443 Timeout = 90 Retries = 3 Delay = 10 Logon ID = can be shared upon request – contact Joshua Barton or other CMTF members Send Local System Log On ... → make sure this is checked After you click OK, name it something useful for you Double click your new FOLIO export option in the list and click Apply