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
Questions
- mapping options
- what differentiates SP name, code, value, level, etc.
There has been some confusion on how Alex treats study programs, both in general and most recently regarding how they are treated when running imports. Questions about mapping options, like what differentiates a SP name, code, value, level, etc.
Create a support page within our import examples wiki that details how study programs import into Alex and how Alex will use and view that data. Link to this page at the top of this page: Add or Update Titles (2nd tab) AND from the notes column for the following fields in Field Mapping:
The initial goal is to get some additional information in place to help people understand how to create an import file and map it properly for import into Alexandria. This will need some work, but it's a start toward better illustrating this.
Once we have this information down it might be helpful to come back trough and also add some links and references to search documentation to better explain how this information can be used / searched inside of Alexandria.
Often it is necessary to import a file containing study program information for titles already in your collection. The information below is intended to assist users in properly field mapping the data for supported programs:
Updates to study program information can be imported
You can import a file to update study program information for titles already in your collection. The following examples
Update study program information for titles already in your collection with an import file. But before you get started, read these articles to understand how it all works:
The following examples are meant to help you understand how your tab-delimited import file should be formatted for each study program.
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
Accelerated Reader
MARC Field
526 - Study Program Information Note
Subfields
_a Program name
_b Interest level
_c Reading level
_d Title point value
_z Test number
_9 Have test
Tab-Delimited Example
ISBN<tab>title<tab>program name<tab>interest level<tab>reading level<tab>title point value<tab>test number<enter>
0439678137 Gregor the Overlander Accelerated Reader MG 4.8 8.0 71754
New MARC Tag
526_aAccelerated Reader_bMG_c3.2_d0.5_z71754^
Reading Counts
MARC Field
526 - Study Program Information Note
Subfields
_a Program name
_b Interest level
_c Reading level
_d Title point value
_z Test number
_9 Have test
Tab-Delimited Example
ISBN<tab>title<tab>program name<tab>interest level<tab>reading level<tab>title point value<enter>
9780142301937 Rapunzel Reading Counts K 3.8 2.0
New MARC Tag
526_aReading Counts_c3.2_d0.5^
Lexile
MARC Field
Subfields
_a Reading level code and value
_b Program name
Tab-Delimited Example
To update an existing record, format your import file as follows:
ISBN<tab>title<tab>reading level code<tab>reading level value<tab>program name<enter>
9780060835248 Scary Stories 3 BR 680 Lexile
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 level
_b Program name
Tab-Delimited Example
To update an existing record, format your import file as follows:
ISBN<tab>title<tab>reading level value<tab>study program name<enter>
0689500297 The Grey King 6.2 Fountas and Pinnell
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.
Guided Reading
MARC Field
Subfields
_a Reading level
_b Program name
Tab-Delimited Example
To update an existing record, format your import file as follows:
ISBN<tab>title<tab>reading level value<tab>study program name<enter>
0439531640 Inkheart 5.4 Guided Reading
New MARC Tag
521_a5.4_bGuidedReading^
The program name does not need to be in the import file. Alexandria automatically adds the program name to subfield _b when the Guided Reading import mapping option is set or it detects a field mapping header.