The Support Center has moved!! See the new website https://support.goalexandria.com/ 
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
Study Program Import Field Mapping Examples
Last Updated: $action.dateFormatter.formatDateTime($content.getLastModificationDate())
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:
- Lexile Value
- Lexile Code
- Fountas and Pinnell Value
- Guided Reading Value
- Study Program Name
- Study Program Interest Code
- Study Program Reading Level
- Study Program Point Count
- Study Program Test Number
- Study Program Have Test
- Study Program Holding Code
This gives plenty of relevant vectors to this information which will presumably be helpful when people are trying to import study program information. We can expand and modify as needed.
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:
Accelerated Reader
This program uses MARC tag 526 and supports the following subfields:
- 526_a Program Name
- 526_b Interest Level
- 526_c Reading Level
- 526_d Point Value
- 526_z Test Number
- 526_9 Have Test indicator
An example for updating Accelerated Reader for an existing title in the collection:
ISBN<tab>Title<tab>Accelerated Reader<tab>3.2<tab>0.5<return>
Mapped as:
- ISBN → ISBN
- Title → Title
- Accelerated Reader → Study Program Name
- 3.2 → Study Program Reading Level
- 0.5 → Study Program Point Count
Add's a new MARC 526 tag to the matching title, as follows:
- 526_aAccelerated Reader_c3.2_d0.5^
- 526_aAccelerated Reader_c3.2_d0.5^
Reading Counts
MARC tag
526 - Study Program Information Note
Subfields
_a Program name
_b Interest level
_c Reading level
_d Point value
_z Public note / Test Number
_9 Have Test indicator
To update an existing record, format your tab-delimited import file as follows:
Format
ISBN<tab>title<tab>study program name<tab>reading level<tab>title point value<tab>
Example
0385471637 Draw 50 Birds Accelerated Reader 3.2 0.5
New MARC Tag
526_aAccelerated Reader_c3.2_d0.5^
Field
MARC tags are formatted as follows:
Tag_
Reading Counts
This program uses MARC tag 526 and supports the following subfields:
- 526_a Program Name
- 526_b Interest Level
- 526_c Reading Level
- 526_d Point Value
- 526_z Test Number
- 526_5 Site Code (not yet used)
- 526_9 Have Test indicator
An example for updating Reading Counts for an existing title in the collection:
ISBN<tab>Title<tab>Accelerated Reader<tab>3.2<tab>0.5<return>
Mapped as:
- ISBN -> ISBN
- Title -> Title
- Reading Counts -> Study Program Name
- 3.2 -> Study Program Reading Level
- 0.5 Study Program Point Count
Add's a new MARC 526 tag to the matching title, as follows:
- 526_aReading Counts_c3.2_d0.5^
Reading Counts
MARC tag
526 - Study Program Information Note
Subfields
_a Program name
_b Interest level
_c Reading level
_d Point value
_z Public note / Test Number
_9 Have Test indicator
To update an existing record, format your tab-delimited import file as follows:
Format
ISBN<tab>title<tab>study program name<tab>reading level<tab>title point value<tab>
Example
0385471637 Draw 50 Birds Accelerated Reader 3.2 0.5
New MARC Tag
526_aReading Counts_c3.2_d0.5^
Lexile
This program uses MARC tag 521 and supports the following subfields:
- 521_a Reading Level Code and Reading Level Value
- 521_ b Program Name
An example for updating Lexile for an existing title in the collection:
ISBN<tab>Title<tab>AD<tab>100<return>
Mapped as:
- ISBN -> ISBN
- Title -> Title
- AD -> Lexile Code
- 100 -> Lexile Value
Add's a new MARC 521 tag to the matching title, as follows:
- 521_aAD100_bLexile^
The program name does not have to be in the import file. Alexandria automatically adds the program name to subfield _b when it detects a field mapping header or the Lexile import mapping option is set.
Reading Counts
MARC tag
526 - Study Program Information Note
Subfields
_a Program name
_b Interest level
_c Reading level
_d Point value
_z Public note / Test Number
_9 Have Test indicator
To update an existing record, format your tab-delimited import file as follows:
Format
ISBN<tab>title<tab>study program name<tab>reading level<tab>title point value<tab>
Example
0385471637 Draw 50 Birds Accelerated Reader 3.2 0.5
New MARC Tag
526_aReading Counts_c3.2_d0.5^
Fountas and Pinnell
This program uses MARC tag 521 and supports the following subfields:
- 521_a Reading level
- 521_ b Program name
An example for updating Fountas and Pinnell for an existing title in the collection:
ISBN<tab>Title<tab>C<return>
Mapped as:
- ISBN -> ISBN
- Title -> Title
- C -> Fountas and Pinnell Value
Add's a new MARC 521 tag to the matching title, as follows:
- 521_aC_bFountas and Pinnell^
Fountas and Pinnell
MARC tag
Subfields
_a Reading level
_b Program name
To update an existing record, format your tab-delimited import file as follows:
Format
ISBN<tab>title<tab>reading level<tab>program name<enter>
Example
0385471637 Draw 50 Birds C Fountas and Pinnell
New MARC Tag
521_aC_bFountas and Pinnell^
The program name does not have to be in the import file. Alexandria automatically adds the program name to subfield _b when it detects a field mapping header or the Fountas and Pinnell import mapping option is set.
Fountas and Pinnell
MARC tag
Subfields
_a Reading level
_b Program name
Tab-Delimited Format
Template: ISBN<tab>title<tab>reading level<tab>program name<enter>
Example: 0385471637 Draw 50 Birds C Fountas and Pinnell
New MARC Tag
521_aC_bFountas and Pinnell^
The program name does not have to be in the import file. Alexandria automatically adds the program name to subfield _b when it detects a field mapping header or the Fountas and Pinnell import mapping option is set.
Guided Reading
This program uses MARC tag 521 and supports the following subfields:
521_a Reading Level Value
521_ b Program Name
An example for updating Guided Reading for an existing title in the collection:
ISBN<tab>Title<tab>C<return>
Mapped as:
ISBN -> ISBN
Title -> Title
C -> Guided Reading Value
Add's a new MARC 521 tag to the matching title, as follows:
521_aC_bGuided Reading^
NOTE: It is not required to include the program name in the import file for this particular program. Alexandria automatically adds this to subfield _b when the Guided Reading import mapping option or field mapping header is used.
Guided Reading
MARC tag
Subfields
_a Program name
_b Interest level
_c Reading level
_d Point value
_z Public note / Test Number
_9 Have Test indicator
To update an existing record, format your tab-delimited import file as follows:
Format
ISBN<tab>title<tab>study program name<tab>reading level<tab>title point value<tab>
Example
0385471637 Draw 50 Birds Accelerated Reader 3.2 0.5
New MARC Tag
526_aReading Counts_c3.2_d0.5^
