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