How helpful was this page?
Related Blog Posts
Blog Posts
-
Say cheese! All about patron pictures
created by
Aug 10, 2022
-
Assigning policies–the complete guide
created by
Mar 23, 2022
-
Update title records with exports & imports? Yes, you can!
created by
Jan 19, 2022
-
Getting equipped: Cataloging items for your library
created by
Jan 13, 2022
-
Saved field mapping—Easy peasy imports
created by
Feb 10, 2021
-
As you like it—Import Headings
created by
Nov 30, 2018
-
Importing MARC Records from a Vendor
created by
Oct 19, 2018
-
New Copies? In Processing
created by
Oct 06, 2014
They don't know how to map it correctly to update their records in a way that allows them to search on the individual programs and values correctly. They usually import it wrong and then wonder why it doesn't work in /search. With complete MARC or MicroLIF records provided by a vendor or data services company, they usually don't have problems - the problems are with the do it yourself types.
You can use an import to update study program information for titles already in your collection. But before you get started, read these articles to understand how it all works:
Alexandria will use the import header to match the imported data to the correct fields. If your import file does not have a header, however, you will need to map your fields. The following examples show how study program information is imported to update your MARC records.
You probably wont have any trouble importing MARC or MicroLIF records provided to you by a vendor or data services company, but importing your own files may be a bit more complicated.
Set Up the Import File
Set Up the Import
- In the imports module, select Items from the categories pane.
- In the Imports pane, click Choose File.
- Locate the import file on your computer and click Open.
- If your import file does not have a header, click Field Mapping.
- In the Settings tab, choose the following settings:
- Import Settings: Add or Update Titles
- Title Update Matching: ISBN or LCCN
- Vendor supplied records should contain accurate ISBNs, which make it a reliable identifier for title matching.
Skip First Record if Field Mapping: Check this option if your import file includes a header row, or leave unchecked if there is not.
- Barcode Handling: Select Reassign Only Duplicate Barcodes
- Go to the Options tab and the Title subtab. Then choose the following options:
- Title Policy: Choose a default policy for any new items.
- Use Call Number Policy Mapping: Leave unchecked.
- Replace MARC Records on Title Match. Leave unchecked so any title record being updated is not inadvertently replaced!
- Click Run.
Settings
Options
Accelerated Reader
MARC Field
Subfields
_a Program name
_b Interest code
_c Reading level
_d Point count
_z Test number
_9 Have test
Tab-Delimited Example
ISBN<tab>title<tab>program name<tab>interest level<tab>study program reading level<tab>study program point value<tab>test number<enter>
0439678137 Gregor the Overlander Accelerated Reader MG 4.8 8.0 71754
Field Mapping
New MARC Tag
526_aAccelerated Reader_bMG_c4.8_d8.0_z71754^
MARC Field
Subfields
_a Program name
_b Interest code
_c Reading level
_d Point count
_z Test number
_9 Have test
Tab-Delimited Example
ISBN<tab>title<tab>study program name<tab>study program interest code<tab>study program reading level<tab>study program point count<enter>
9780142301937 Rapunzel Reading Counts K 3.8 2.0
Field Mapping
New MARC Tag
526_aReading Counts_c3.8_d2.0^
Lexile
MARC Field
Subfields
_a Lexile code and value
_b Program name
Tab-Delimited Example
To update an existing record, format your import file as follows:
ISBN<tab>title<tab>Lexile code<tab>Lexile value<enter>
9780060835248 Scary Stories 3 BR 680
Field Mapping
New MARC Tag
521_aBR680_bLexile^
The program name does not need to be in the import file.
Alexandria automatically adds the program name to subfield _b when the Lexile import mapping option is set or it detects a field mapping header.
Fountas and Pinnell
MARC Field
Subfields
_a Reading program value
_b Program name
Tab-Delimited Example
To update an existing record, format your import file as follows:
ISBN<tab>title<tab>Fountas and Pinnell value<enter>
0689500297 The Grey King 6.2
Field Mapping
New MARC Tag
521_a6.2_bFountas and Pinnell^
The program name does not need to be in the import file.
Alexandria automatically adds the program name to subfield _b when the Fountas and Pinnell import mapping option is set or it detects a field mapping header.