Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    360 Services

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. 360 Services
    3. 360 Counter
    4. Knowledge Articles
    5. 360 Resource Manager and 360 Counter: Acquisitions Data Import for Voyager Clients

    360 Resource Manager and 360 Counter: Acquisitions Data Import for Voyager Clients

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. How does the 360 Resource Manager Acquisitions Data Import tool work for Voyager clients?
    • Product: 360 Counter

    How does the 360 Resource Manager Acquisitions Data Import tool work for Voyager clients?

    This document is intended to help Voyager libraries merge cost data to 360 Resource Manager and 360 Counter using the Cost Data Import tool and Microsoft Access 2007.
    NOTE: The suggested steps we provide here were written by a Voyager client; they were not created by -- nor are they supported by -- Serials Solutions. They serve as an example that we hope can help your library, but they may not work for all libraries.
    NOTE: It is helpful to add Serials Solutions identifiers to Voyager order records as part of your standard acquisitions workflow so that they will be present in the reports you export from Voyager. More explanation about this and other ways to prepare for this process can be found in the Cost Acquisitions Data Import documentation.
    1. In the Client Center, click Cost Data Upload under Management Tools in the Manage Your Data section:

      Client Center - Cost Data Upload

    2. On the Cost Data Upload page, select the appropriate template. For example, if you are uploading database costs, you would select the Databases in Profile with Template option from the File to Download drop-down menu.

    3. Click Download. Save the file to c:\voyager\access reports\reports.mdb.

    4. Open Microsoft Access and select Tables > External Data >Text Files, and then open the reports.mdb file. Follow the Access prompts. Create a table for the Cost Template file.

    5. To match the Serials Solutions data with the Voyager data, enter the Bib ID into the Local System Reference ID field. To simplify, you may try creating a form with the Access Form function using just the Database Name and Local System Reference ID:

      Image

    6. Create a query including all of the information you want from Voyager: funds, PO number, invoice number (or voucher number), vendor, etc.:

      Image

    7. Create a second query with the "Cost Template" table and Query 1 joined at Local System Reference ID. Select all fields from the Cost Template table and replace the field to upload with fields from Query 1 (see below):

      Image

    8. Run and export Query 2. Export as a text file and be sure to check the box to include headers. (In Access 2007, you can save your export profile.)

    9. Return to the Cost Data Upload page and upload the file you just saved.

    For further details on the Cost Data Upload process, see the following:
    Cost Data Upload Tool
    Cost Acquisitions Data Import

    • Date Created: 9-Feb-2014
    • Last Edited Date: 21-Feb-2014
    • Old Article Number: 7323
    View article in the Exlibris Knowledge Center
    1. Back to top
      • 360 Counter: ProQuest DB1 Fix
      • 360 Resource Manager and 360 Counter: Cost Data Upload for Innovative Interfaces (III) Millennium
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      360 Counter
    2. Tags
      1. Configuration
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved