Import Study Program Field Mapping

Content Layer

id	1230590257

Content Column

tabbed-blocks	tabs
id	1230590267

Content Block

name	Overview
id	1230590265

Info
this information — and all tabs — has been moved to https://support.goalexandria.com/operations/import/import-field-mapping/#program

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 in MARC tags for titles already in your collection.

But before

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

data 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.

Alexandria uses the import header to match the imported data to the correct fields. 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

however, you will need to map your fields. This is crucial to ensuring that your data is imported correctly.

Go through each tab above to see examples of how to format your tab-delimited file and map your fields to correctly import study program data.

Content Block

name	Accelerated Reader
id	1230590409

Accelerated Reader

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

Format your import file as follows:

ISBN<tab>title<tab>study program name<tab>study program interest levelcode<tab>study program reading level<tab>study program point valuecount<tab>study program test number<enter>

0439678137 Gregor the Overlander Accelerated Reader MG 4.8 8.0 71754

Field Mapping

Section

Column

If your import file does not have a header, click Field Mapping.

Data from the import file is shown on the left-hand of the window while Alexandria field names are shown on the right. Fields are matched and imported in order. Use the arrows to move the Alexandria fields up and down to match them with the fields in your import file.

Fields with a green checkmark will be imported and fields with a red X will not. Go through each field to make sure it's being set correctly—click the green checkmark to change it to an X, or click the X to change it to a checkmark.

When you've finished matching Alexandria fields to the information in your file, click Set.

Column
Image Modified

New MARC Tag

Alexandria will use the data in the import file to match each each record to an existing title and update the MARC tag. In this example, the new MARC tag will look like this:

526_aAccelerated Reader_bMG_c4.8_d8.0_z71754^

Content Block

name	Reading Counts
id	1230602771

Reading Counts

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

Format your import file as follows:

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

Section

Column

If your import file does not have a header, click Field Mapping.

Data from the import file is shown on the left-hand of the window while Alexandria field names are shown on the right. Fields are matched and imported in order. Use the arrows to move the Alexandria fields up and down to match them with the fields in your import file.

Fields with a green checkmark will be imported and fields with a red X will not. Go through each field to make sure it's being set correctly—click the green checkmark to change it to an X, or click the X to change it to a checkmark.

When you've finished matching Alexandria fields to the information in your file, click Set.

Column
Image Modified

New MARC Tag

Alexandria will use the data in the import file to match each each record to an existing title and update the MARC tag. In this example, the new MARC tag will look like this:

526_aReading Counts_c3.8_d2.0^

Content Block

name	Lexile
id	1230625846

Lexile

MARC Field

521 - Target Audience Note

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
Tip
title 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.

Field Mapping

Section

Column
If your import file does not have a header, click Field Mapping

Image Removed

.

Data from the import file is shown on the left-hand of the window while Alexandria field names are shown on the right. Fields are matched and imported in order. Use the arrows to move the Alexandria fields up and down to match them with the fields in your import file.

Fields with a green checkmark will be imported and fields with a red X will not. Go through each field to make sure it's being set correctly—click the green checkmark to change it to an X, or click the X to change it to a checkmark.

When you've finished matching Alexandria fields to the information in your file, click Set.

Column
Image Added

New MARC Tag

Alexandria will use the data in the import file to match each each record to an existing title and update the MARC tag. In this example, the new MARC tag will look like this:

New MARC Tag

521_aBR680_bLexile^

Content Block

name	Guided Reading
id	1238907766

Guided Reading

MARC Field

521 - Target Audience Note

Subfields

_a Reading program value
_b Program name

Tab-Delimited Example

ISBN<tab>title<tab>Guided Reading value<enter>

0439531640 Inkheart 5.4

Tip

title	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.it detects Guided Reading in the import header or the Guided Reading Value field is mapped.

Field Mapping

Section

Column

If your import file does not have a header, click Field Mapping.

Data from the import file is shown on the left-hand of the window while Alexandria field names are shown on the right. Fields are matched and imported in order. Use the arrows to move the Alexandria fields up and down to match them with the fields in your import file.

Fields with a green checkmark will be imported and fields with a red X will not. Go through each field to make sure it's being set correctly—click the green checkmark to change it to an X, or click the X to change it to a checkmark.

When you've finished matching Alexandria fields to the information in your file, click Set.

Column
Image Added

New MARC Tag

521_a5.4_bGuidedReading^

Content Block

name	Fountas and Pinnell
id	1230637820

Fountas and Pinnell

MARC Field

521 - Target Audience Note

Subfields

_a Reading program value
_b Program name

Tab-Delimited Example

To update an existing record, format Format your import file as follows:

ISBN<tab>title<tab>Fountas and Pinnell value<enter>

0689500297 The Grey King 6.2

Field Mapping

Image Removed

New MARC Tag

521_a6.2_bFountas and Pinnell^

Tip

title	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.

Field Mapping

Section

Column

If your import file does not have a header, click Field Mapping.

Data from the import file is shown on the left-hand of the window while Alexandria field names are shown on the right. Fields are matched and imported in order. Use the arrows to move the Alexandria fields up and down to match them with the fields in your import file.

Fields with a green checkmark will be imported and fields with a red X will not. Go through each field to make sure it's being set correctly—click the green checkmark to change it to an X, or click the X to change it to a checkmark.

When you've finished matching Alexandria fields to the information in your file, click Set.

Column
Image Added

New MARC Tag

Alexandria will use the data in the import file to match each each record to an existing title and update the MARC tag. In this example, the new MARC tag will look like this:

521_a6.2_bFountas and Pinnell^

Space shortcuts

Page tree

Versions Compared

Key

Set Up the Import File

Set Up the Import

Settings

Options

Accelerated Reader

MARC Field

Subfields

Tab-Delimited Example

Field Mapping

New MARC Tag

Reading Counts

MARC Field

Subfields

Tab-Delimited Example

Field Mapping

New MARC Tag

Lexile

MARC Field

Subfields

Tab-Delimited Example

ISBN<tab>title<tab>Lexile code<tab>Lexile value<enter>9780060835248 Scary Stories 3 BR 680 TiptitleThe 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.

Field Mapping

New MARC Tag

Guided Reading

MARC Field

Subfields

Tab-Delimited Example

Field Mapping

New MARC Tag

Fountas and Pinnell

MARC Field

Subfields

Tab-Delimited Example

Field Mapping

Field Mapping

New MARC Tag

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