The Support Center has moved!! See the new website https://support.goalexandria.com/  

Alexandria

Space shortcuts

Page tree


You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Operations

Import

The root page ALEX:Import could not be found in space Alexandria.

How helpful was this page? 

Tell us what we can improve.

Related Blog Posts

Blog Posts


Save as PDF

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_5 Site Code (not yet used)
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^
Accelerated Reader

MARC tag 526

  • 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:

Format your tab-delimited import file as follows:

Template

ISBN<tab>Title<tab>Study Program Name<tab>Reading Level<tab>Points<return>

ISBN     Title     Study Program Name     Reading Level     Points

ISBN<tab>Title<tab>Accelerated Reader<tab>#.#<tab>#.#<return>

ISBN     Title     Accelerated Reader     #.#     #.#

Example

0385471637<tab>Draw 50 Birds<tab>Accelerated Reader<tab>3.2<tab>0.5<return>

New MARC Tag

  • 526_aAccelerated Reader_c3.2_d0.5^
  • 526_aAccelerated Reader_c3.2_d0.5^


MARC TagField
526_



Field

FieldHeaderMARC TagNotes





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^


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.

Fountas and Pinnell


This program uses MARC tag 521 and supports the following subfields:

  • 521_a Reading Level Value
  • 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^



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.

© 2023 COMPanion® Corporation | All Rights Reserved | Terms of Service & Privacy Policy