| Content Layer |
|---|
|
| Content Column |
|---|
| tabbed-blocks | tabs |
|---|
| id | 1230590267 |
|---|
| | Content Block |
|---|
|
You can use an import to update study program information in MARC tags for titles already in your collection. 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 uses 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. 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 |
|---|
| |
|
|
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
...
...
code
_c Reading level
_d Point |
|
|
...
...
...
...
Tab-Delimited ExampleFormat your import file as follows: |
|
|
Format
ISBN<tab>title<tab>study program name |
|
|
...
<tab>study program interest code<tab>study program reading level<tab> |
|
|
...
...
...
Example
0385471637 Draw 50 Birds Accelerated Reader 3.2 0.5
New MARC Tag
526_aAccelerated Reader_c3.2_d0.5^
Reading Counts
MARC tag
526 - Study Program Information Note
Subfields
...
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 Added
|
|
New MARC TagAlexandria 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 |
|---|
| |
|
|
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^
Reading Counts
...
...
code
_c Reading level
_d Point |
|
|
...
...
...
...
Tab-Delimited ExampleFormat your import file as follows: |
|
|
...
ISBN<tab>title<tab>study program name |
|
|
...
<tab>study program interest code<tab>study program reading level<tab> |
|
|
...
0385471637 Draw 50 Birds Accelerated Reader 3.2 0.5
New MARC Tag
526_aReading Counts_c3.2_d0.5^
ORIGINAL 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
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 Added
|
|
New MARC TagAlexandria 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 |
|
|
...
...
...
Reading Counts
MARC tag
...
...
...
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
...
- 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:
Tab-Delimited ExampleISBN<tab>title<tab>Lexile code<tab>Lexile value<enter> 9780060835248 Scary Stories 3 BR 680 |
|
|
...
| 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. |
|
|
|
Reading Counts
MARC tag
526 - Study Program Information Note
Subfields
...
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
...
- 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
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 TagAlexandria 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_aBR680_bLexile^ |
| Content Block |
|---|
| name | Guided Reading |
|---|
| id | 1238907766 |
|---|
| |
|
|
...
...
program value
_b Program name
|
|
|
To update an existing record, format your tab-delimited import file as follows:
Format
Tab-Delimited ExampleISBN<tab>title<tab> |
|
|
...
Example
0385471637 Draw 50 Birds C Fountas and Pinnell
New MARC Tag
521_aC_bFountas and Pinnell^
Guided Reading value<enter> 0439531640 Inkheart 5.4 |
|
|
...
| The program name does not |
|---|
|
|
|
|
...
| need to be in the import file. |
| Alexandria automatically adds the program name to subfield _b when 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 Tag521_a5.4_bGuidedReading^ |
| Content Block |
|---|
| name | Fountas and Pinnell |
|---|
| id | 1230637820 |
|---|
| |
|
|
...
...
program value
_b Program name
Tab-Delimited ExampleFormat |
|
|
...
your import file as follows: ISBN<tab>title<tab> |
|
|
...
...
New MARC Tag
521_aC_bFountas and Pinnell^
value<enter>
0689500297 The Grey King 6.2 |
|
|
...
| 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
...
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.
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 TagAlexandria 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^ |
|
|
Guided Reading
MARC tag
521 - Target Audience Note
Subfields
...
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
...
