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


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

Compare with Current View Page History

« Previous Version 34 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.


Save as PDF

Import Study Program Field Mapping

Last Updated: $action.dateFormatter.formatDateTime($content.getLastModificationDate())

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:

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 data may be a bit more complicated. 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. This is crucial to ensuring that your data is imported correctly. 

These examples show how study program information is imported to update your MARC records.

Accelerated Reader

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

526 - Study Program Information Note

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


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

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

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.