In This Article

Import courses and items from other E-Reserves systems

Required steps for importing e-reserves content

Coming to E-Reserves from another system? No problem! We can import E-Reserves from your previous system. :)

Here are the basic steps. More details around step 2 are below.

  1. Contact the Springy Sales team about the import, if you have not already discussed it when adding E-Reserves to your subscription.
  2. Download the CSV files & fill them out. See below for important details / to download the files.
  3. Once the templates are properly filled out*, email us:
    • Send to support@springshare.com.
    • Subject line: E-Reserves Import for {your institution name}
    • Attach the two properly filled out template files.
    • Provide us with access information for your files via FTP.
  4. We will process the data and let you know as soon as it's completed.
  5. Check your system to ensure everything was imported properly.

E-Reserves import templates and instructions

Step 1: Download the Templates

There are 2 files you will need to download, fill out, and return: one for courses and one for items. See the Links & Files section below for the latest versions.

Step 2: Fill in the Templates

Both the course and import files must be filled out in order to process your import.


Courses template

  • Fill in the relevant fields for your courses.
  • If you do not wish to use a field, simply leave it blank.
  • ID is required and each course listed must have a unique ID.
  • If you add a term that does not yet exist in your system, it will be created during the import.
    • You will want to go to that term (E-Reserves > Courses > Manage Terms) and set visibility dates after the import has run.

Example: You give a course the ID of 1234 in the import file.

You'd then add 1234 to the course_id field in the item import file for any items you want to associate with that course.

Course template fields

Field Description Field Type / Specific Options
id Unique course identifier.
This relates to the course_id field in the item import template.
If you want to relate an item to a course, use the same id you add for the course.
This is how we match up items to courses.
text
number The course number. This is different from the unique identifier.
It is the actual course number used at your institution, like MGT101 or EPS3501.
text
name The name of the course. text
instructor The instructor's name. This can follow whatever format you prefer, such as:
firstname lastname
lastname, firstname
lastname
text
term The name of the semester when the course is being held. text
password Optional password field for the course. text
description A description of the course. text

Items template

  • Required fields:
    • ID: Must be a unique identifier. If multiple items have the same ID, we will send the files back to you for correction.
    • Item Type
    • Name
    • True / False fields
  • Are you relating the item to a course?
    • Add the appropriate ID in the course_id field.
    • This is the unique ID you gave the course in the course import file, not the course number.
  • Fill in the other fields as appropriate. For example:
    • If there is a related URL, add that to the URL field.
    • If it's a book, fill out the book fields.
  • If a field does not relate to that particular item, simply leave it blank.
  • The Copyright Status field relates to the statuses entered into your system.
    • Leave this blank if you do not wish to assign a Copyright Status to the item.
    • If the Copyright Status you add does not yet exist in your system, running the import will add it.

Items template fields

Field Description Field Type / Specific Options
id Unique item identifier text
er_item_type The type of item you're adding book
article
website
media
name The item name as it should appear on the E-Reserves Course page text
description The item description as it should appear on the Course page text
course_id The related id (from the Course import file) for the course the item should be associated with text
folder If the item should be in a folder, add the folder name text
url If the item has a related URL, add it here text
enable_proxy Should your system's proxy prefix be added to the beginning of the URL? true
false
password Optional password field for the item text
attachment Add the path for an associated file (chapter / article pdf, etc.).
A path relative to the root of your FTP server is ideal. For example: /data/ereserves/12345/sample.pdf
text
copyright The copyright status for the item, if any.
If the status you enter does not yet exist in your system, it will be created during the import.
If the item does not have a copyright status, leave that field blank.
text
book_title The title of the book.
If the item is a book chapter, this should still be the book title, not the chapter title. That can be added later.
text
book_author The author or editor of the book.
If a chapter, there is a chapter author later in the file.
text
book_publisher The publisher of the book. text
book_volume The volume of the book, if applicable. text
book_isbn The ISBN for the book. text
book_pub_date The publication date of the book. text
book_call_number The call number of the book, if applicable. text
book_is_ebook Is this book an e-book? true
false
book_is_personal_copy Is this book a personal copy? true
false
book_is_chapter Is this item a book chapter vs. an entire book? true
false
book_chapter_title Title of the chapter, if applicable. text
book_chapter_author Author of the chapter, if applicable. text
book_chapter_pages Page range for the chapter, if applicable. text
article_title The title of the article. text
article_author The author of the article. text
article_journal The journal where the article appears. text
article_volume The volume of the journal where the article appears. text
article_issue The issue of the journal where the article appears. text
article_pages The page range for the article. text
article_pub_date The publication date of the article. text
website_name The name of the website.
(The related URL should be in the URL field earlier in the file.)
text
media_title The title of the movie, album, song, recording, etc. text
media_director The director, composer, performer, etc. text
media_call_number The call number of the media item, if applicable. text
media_is_personal_copy Is this a personal copy? true
false
media_database Can this item be found in a library database? If so, provide the database name. text

Related Articles