1 / 17

Using Serials Solutions Overlap Analysis to Identify Print Redundancies

Using Serials Solutions Overlap Analysis to Identify Print Redundancies. LACUNY Serials Roundtable Prof. Monica Berger New York City College of Technology Oct. 26, 2012. How to Start. Request your renewal from Ebsco as a spreadsheet

ferris
Download Presentation

Using Serials Solutions Overlap Analysis to Identify Print Redundancies

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using Serials Solutions Overlap Analysis to Identify Print Redundancies LACUNY Serials RoundtableProf. Monica BergerNew York City College of TechnologyOct. 26, 2012

  2. How to Start Request your renewal from Ebsco as a spreadsheet Does not require renewing as spreadsheet: No issue with using Ebsconet for renewals Do not try to get data from Ebsconet via my orders: confusing and time-consuming Probably fine to use My Renewals in Ebsconet to export to Excel

  3. Prepare Data for Uploading • Copy the file (good to save original) • Filter the spreadsheet to remove the online titles • Cleanup membership titles (swap in title and ISSN as needed) • Leave only the TITLE and ISSN fields • Change the headers to TITLE and ISSN respectively • Save the file as .txt (required for uploading into Serials Sol’n)

  4. Getting the data into Serials Solutions After logging in • DATA MANAGEMENT • CREATE NEW DATABASE • Name your database, e.g. Print periodicals renewal 2012 • Save your database

  5. Getting the data into Serials Solutions • Download template for local holdings • Template is in .txt file, so save to your computer and open up in Excel • Drop in your title & issn data • Save file to your computer as tab delimited .txt file • Close the file • Upload file (UPLOAD TITLES) • Wait for overnight load for titles to index

  6. Running the Overlap Analysis On start page, go to Business Intelligence Tools Select OVERLAP ANALYSIS Remove any print holdings if you have already loaded these Run analysis Go to your renewals data and click on number in column “Title Overlap” Report is generated of what is available in databases and ejournal packages incl. OA Export summary; file is .txt; open in Excel

  7. Adding print holdings to Serials Sol’n For documentation, see in the Support Center, Library-Specific (Library-Managed)Holdings Database – Overview (Answer ID 1000) If you want your print holdings to link to the CUNY Catalog, follow instructions for library-specific holdings but use permalinks in the catalog for your URLs, e.g. http://apps.appl.cuny.edu:83/F/?func=item-global&doc_library=CUN01&doc_number=000608435&year=&volume=&sub_library=GC001 Don’t forget to add ISSN!

More Related