Many thanks for this list and the accompanying info you’ve offered here. Encouraging stuff – fair warning, I may hit you up off-list for those pointers you mentioned!

 

  damien

 

Damien McCaffery
Electronic Resources Librarian

Jefferson (Philadelphia University + Thomas Jefferson University)

4201 Henry Avenue

Philadelphia PA 19144
T 215-951-2674
mccafferyd@philau.edu

PhilaU.edu    

 

cid:image004.jpg@01D2F744.EB5F8BF0

 

From: Serials in Libraries Discussion Forum [mailto:SERIALST@LISTSERV.NASIG.ORG] On Behalf Of Steve Oberg
Sent: Monday, July 17, 2017 12:57 PM
To: SERIALST@LISTSERV.NASIG.ORG
Subject: Re: [SERIALST] connecting to Gale or ProQuest SUSHI services

 

Damien,

 

There is a list of working vendors on GitHub that is outdated (see https://github.com/Coral-erm/Coral/wiki/SUSHI-Documentation-for-Statistics-Module). I’ll work with others to provide more up-to-date info. within the documentation. Here is an updated list of vendors for whom I’ve successfully connected via SUSHI in CORAL:

 

American Chemical Society (ACS)

American Journal of Public Health

American Physical Society

Annual Reviews

BioOne

Brepols

Brill

Cambridge Core

DeGruyter

EBSCO

Edinburgh University Press

Elsevier

Endocrine Society

Gale

Guilford Press

Highwire Press

IOPScience

INFORMS

Ingenta Connect

JSTOR

Journal of Parasitology

Karger

Lieber

Liverpool University Press

Loeb Classics

MIT Press

MLA Journals

Nature

NewsBank

OCLC

Ovid

ProQuest

ProQuest Ebook Central

Project Euclid

Project Muse

Psychiatry Online

Royal Society of Chemistry

SAGE Journals

SAGE Knowledge

Scitation (AIP)

Springer

Taylor & Francis

The University of Chicago Press

University of Toronto Press

Vandenhoeck & Ruprecht

Web of Science

Wiley

 

I’d be glad to provide pointers to you or anyone else off list. Or you can send specific queries to the CORAL users discussion list (coral-user@lists.coral-erm.org).

 

One other thing: I’ve found a couple of other ERM vendors’ documentation on SUSHI to be a helpful guide even though we don’t use their systems:

 

OCLC WMS

EBSCO Usage Consolidation

 

Steve

 

On Jul 17, 2017, at 9:53 AM, McCaffery, Damien <mccafferyd@PHILAU.EDU> wrote:

 

Hi Steve,

 

I’ve had no success getting SUSHI to work with ProQuest or GALE (nor with several others via our Sirsi Dynix-hosted instance of CORAL), tho I was grateful for the GALE URL you provided. We got precisely the same error message you did when we tried it however.

 

Intrigued to hear that you have had success with so many vendors in setting up SUSHI; I have been very frustrated trying to get the connections set up and running correctly. Still stuck on Elsevier, Wiley, ITHAKA, McGraw-Hill,  plus ProQuest and GALE.

 

Even when I am able to set up a SUSHI connection and run successful tests with a vendor, those uploads do not appear to be running on schedule. So I must run them manually – on the SUSHI page in the Usage module, the date in the “Latest Run” column is always the date I managed to run a successful test of the SUSHI connection.

 

TBH, All this has left me skeptical of SUSHI’s capabilities, and CORAL’s. But its early days in my experience with both, so remaining hopoeful.

 

Ultimately, I’ve resorted to getting the Sirsi Dynix and GALE tech reps on a conf call to resolve this. This will occur this week; if anything useful results, I will update with that info. 

 

Cheers,

 

  damien

 

Damien McCaffery
Electronic Resources Librarian

Jefferson (Philadelphia University + Thomas Jefferson University)

4201 Henry Avenue

Philadelphia PA 19144
T 215-951-2674
mccafferyd@philau.edu

PhilaU.edu    

 

<image001.jpg>

 

From: Serials in Libraries Discussion Forum [mailto:SERIALST@LISTSERV.NASIG.ORG] On Behalf Of Steve Oberg
Sent: Wednesday, July 12, 2017 2:11 PM
To: SERIALST@LISTSERV.NASIG.ORG
Subject: [SERIALST] connecting to Gale or ProQuest SUSHI services

 

Sent to SERIALST and ERIL-L. 

 

I’m curious whether anyone has successfully connected to Gale’s or ProQuest’s SUSHI service.

 

ProQuest does not seem to provide instructions that are readily found or logically placed, e.g. I’ve looked everywhere I can think of in their admin module to no avail. They are listed as supporting SUSHI on the Project COUNTER site and I’ve reached out to the person listed there as their contact but haven’t heard a response yet.

 

Gale at least provides instructions that I was able to find (see https://support.gale.com/technical/sushi) but the SUSHI request I initiate (via CORAL, our open source ERM) generates the following error and their support staff’s response is that this is a problem on CORAL’s end. It may be, but I’ve successfully set up over 50 other vendors without encountering this issue, so I’m doubtful at this stage.

 

 

-- Soap Connection successfully completed --

 

Exception performing GetReport with connection to Gale (GOLD): org.xml.sax.SAXException: SimpleDeserializer encountered a child element, which is NOT expected, in something it was trying to deserialize.

DB1 successfully retrieved from Gale (GOLD) for start date: 2017-01-01, end date: 2017-06-30

 

-- Sushi Transfer completed --

Failed XML parsing or no data was found.

The following is the XML response:

<?xml version="1.0" encoding="utf-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Server.userException</faultcode><faultstring>org.xml.sax.SAXException: SimpleDeserializer encountered a child element, which is NOT expected, in something it was trying to deserialize.</faultstring><detail><ns1:hostname xmlns:ns1="http://xml.apache.org/axis/">tg-pxdym10</ns1:hostname></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>

 

When we test the connection with the following setup, the connection for Gale is successful. The error message above occurs, though, whenever we attempt to actually run a report. Here are our settings:

 

WSDL URL  

COUNTER Release

4

Report Layouts

DB1

Requestor ID  [our admin login]

Customer ID  loc=[our location id]

Password  [our admin password]

 

One more thing: we also happen to have access to ExLibris’s UStat service and although we don’t use it (preferring CORAL), sometimes I check that system to test a particular vendor setup using a different SUSHI client, which often helps me figure out particular wrinkles. However, Gale is not even listed as a valid vendor choice in that service, so this makes me wonder.

 

Steve


Steve Oberg
Assistant Professor of Library Science
Group Leader for Resource Description and Digital Initiatives
Wheaton College (IL)
+1 (630) 752-5852
 
NASIG President
<image004.png>

 

 


To unsubscribe from the SERIALST list, click the following link:
http://listserv.nasig.org/scripts/wa-NASIG.exe?SUBED1=SERIALST&A=1

 


To unsubscribe from the SERIALST list, click the following link:
http://listserv.nasig.org/scripts/wa-NASIG.exe?SUBED1=SERIALST&A=1

 

 


To unsubscribe from the SERIALST list, click the following link:
http://listserv.nasig.org/scripts/wa-NASIG.exe?SUBED1=SERIALST&A=1



To unsubscribe from the SERIALST list, click the following link:
http://listserv.nasig.org/scripts/wa-NASIG.exe?SUBED1=SERIALST&A=1