[Workflowtoolkit-l] Workflowtoolkit-l Digest, Vol 27, Issue 26
Howard, Annette E.
ahoward at mst.edu
Wed Feb 15 10:56:40 EST 2012
UMR problem is a little different. The problem we are having is that
the copyright titles are not showing up in our Web reports under
Administration> Copyright> and Finished Requests with Copyright Fees.
Titles with CCC info saved beyond August 2011 will not appear. I am not
sure if they were appearing in the list from the client, because I was
not the one clearing copyright and did not get to check it prior to the
end of the 2011 year.
OCLC support is trying to figure out what the problem is.
Also, for some reason when I submitted my copyright usage from the
client, all titles that ccc info was saved for was there. And once I
submitted our usage to copyright clearance center, the titles showed in
the web reports under Completed copyright orders.
Is anyone else having this problem?
Thanks
Annette
Missouri S&T
573 341-4006
ahoward at mst.edu
-----Original Message-----
From: workflowtoolkit-l-bounces at geneseo.edu
[mailto:workflowtoolkit-l-bounces at geneseo.edu] On Behalf Of
workflowtoolkit-l-request at geneseo.edu
Sent: Wednesday, February 15, 2012 9:10 AM
To: workflowtoolkit-l at geneseo.edu
Subject: Workflowtoolkit-l Digest, Vol 27, Issue 26
Send Workflowtoolkit-l mailing list submissions to
workflowtoolkit-l at geneseo.edu
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.geneseo.edu/mailman/listinfo/workflowtoolkit-l
or, via email, send a message with subject or body 'help' to
workflowtoolkit-l-request at geneseo.edu
You can reach the person managing the list at
workflowtoolkit-l-owner at geneseo.edu
When replying, please edit your Subject line so it is more specific than
"Re: Contents of Workflowtoolkit-l digest..."
Today's Topics:
1. Re: Titles not showing up on Copyright List in ILLiad
(Kathryn Leigh)
2. Re: Titles not showing up on Copyright List in
ILLiad
(Judy Greenwood)
3. Re: match string for pre-1923 items (Schwartz, Andrea)
4. Re: Titles not showing up on Copyright List in
ILLiad
(Joyce Melvin)
----------------------------------------------------------------------
Message: 1
Date: Wed, 15 Feb 2012 08:44:29 -0500
From: "Kathryn Leigh" <kathrynr at library.umass.edu>
To: "'ILLiad Best Practices Workflow Toolkit'"
<workflowtoolkit-l at geneseo.edu>
Subject: Re: [Workflowtoolkit-l] Titles not showing up on Copyright
List in ILLiad
Message-ID: <008e01ccebe7$f1407d90$d3c178b0$@library.umass.edu>
Content-Type: text/plain; charset="iso-8859-1"
This happened to us too! - And we had to have Atlas tweak the query for
us.
I asked why this might have happened and never received a response to
that question.....wonder if it is a wide spread thing.
Kathryn? Leigh
Head, Access Services
W.E.B. Du Bois Library
154 Hicks Way
University of Massachusetts
Amherst, MA 01003
413-577-0175
-----Original Message-----
From: workflowtoolkit-l-bounces at geneseo.edu
[mailto:workflowtoolkit-l-bounces at geneseo.edu] On Behalf Of Kathy Tower
Sent: Tuesday, February 14, 2012 5:56 PM
To: ILLiad Best Practices Workflow Toolkit
Subject: Re: [Workflowtoolkit-l] Titles not showing up on Copyright List
in ILLiad
I was wondering why I haven't had at least one title appear in the
copyright list yet.
Is this related to updating the client to a certain version or does
everyone need to do this? And where is the copyright.txt file located?
I checked the ILLiad documentation and don't see the location of the
file.
Thanks for letting us all know about this.
Kathy
***************************************
Kathy Tower
Document Delivery/Interlibrary Loan
Arizona Health Sciences Library
University of Arizona
OCLC: AZA DOCLINE: AZUARI
520-626-6840 tower at ahsl.arizona.edu
-----Original Message-----
From: workflowtoolkit-l-bounces at geneseo.edu
[mailto:workflowtoolkit-l-bounces at geneseo.edu] On Behalf Of Leigh A
Dorsey
Sent: Tuesday, February 14, 2012 3:36 PM
To: workflowtoolkit-l at geneseo.edu
Subject: [Workflowtoolkit-l] Titles not showing up on Copyright List in
ILLiad
Hello everyone--I thought I'd pass some info on in case others missed
this, also.
We usually start getting titles on our copyright list right away in
January but this year nothing was showing up. It turns out that there is
a line that needed to be changed in the copyright.txt file. Some other
libraries in Wisconsin had not made the change, either.
I checked with Atlas and found out that the line that needs to be
changed is the line that says:
and t.CopyrightAlreadyPaid != 'Yes'
It can be replaced with
AND ISNULL(CopyrightAlreadyPaid, 'No') != 'Yes'
or
and (t.CopyrightAlreadyPaid != 'Yes' or t.CopyrightAlreadyPaid is Null)
Both should work. Just a heads up for everyone.
Regards,
Leigh Dorsey
UW-Milwaukee
_______________________________________________
Workflowtoolkit-l mailing list
Workflowtoolkit-l at geneseo.edu
http://mail.geneseo.edu/mailman/listinfo/workflowtoolkit-l
_______________________________________________
Workflowtoolkit-l mailing list
Workflowtoolkit-l at geneseo.edu
http://mail.geneseo.edu/mailman/listinfo/workflowtoolkit-l
------------------------------
Message: 2
Date: Wed, 15 Feb 2012 14:22:39 +0000
From: Judy Greenwood <jgrnwood at olemiss.edu>
To: ILLiad Best Practices Workflow Toolkit
<workflowtoolkit-l at geneseo.edu>
Subject: Re: [Workflowtoolkit-l] Titles not showing up on
Copyright
List in ILLiad
Message-ID:
<C34598B169C0A343971F448A194C5395060B8C0B at exchange.ad.olemiss.edu>
Content-Type: text/plain; charset="iso-8859-1"
Our copyright list has been populating. We are using version 8.1.4.
I am actually surprised at the number of titles we have already!
Judy Greenwood
MUM
-----Original Message-----
From: workflowtoolkit-l-bounces at geneseo.edu
[mailto:workflowtoolkit-l-bounces at geneseo.edu] On Behalf Of Kathryn
Leigh
Sent: Wednesday, February 15, 2012 7:44 AM
To: 'ILLiad Best Practices Workflow Toolkit'
Subject: Re: [Workflowtoolkit-l] Titles not showing up on Copyright List
in ILLiad
This happened to us too! - And we had to have Atlas tweak the query for
us.
I asked why this might have happened and never received a response to
that question.....wonder if it is a wide spread thing.
Kathryn? Leigh
Head, Access Services
W.E.B. Du Bois Library
154 Hicks Way
University of Massachusetts
Amherst, MA 01003
413-577-0175
-----Original Message-----
From: workflowtoolkit-l-bounces at geneseo.edu
[mailto:workflowtoolkit-l-bounces at geneseo.edu] On Behalf Of Kathy Tower
Sent: Tuesday, February 14, 2012 5:56 PM
To: ILLiad Best Practices Workflow Toolkit
Subject: Re: [Workflowtoolkit-l] Titles not showing up on Copyright List
in ILLiad
I was wondering why I haven't had at least one title appear in the
copyright list yet.
Is this related to updating the client to a certain version or does
everyone need to do this? And where is the copyright.txt file located?
I checked the ILLiad documentation and don't see the location of the
file.
Thanks for letting us all know about this.
Kathy
***************************************
Kathy Tower
Document Delivery/Interlibrary Loan
Arizona Health Sciences Library
University of Arizona
OCLC: AZA DOCLINE: AZUARI
520-626-6840 tower at ahsl.arizona.edu
-----Original Message-----
From: workflowtoolkit-l-bounces at geneseo.edu
[mailto:workflowtoolkit-l-bounces at geneseo.edu] On Behalf Of Leigh A
Dorsey
Sent: Tuesday, February 14, 2012 3:36 PM
To: workflowtoolkit-l at geneseo.edu
Subject: [Workflowtoolkit-l] Titles not showing up on Copyright List in
ILLiad
Hello everyone--I thought I'd pass some info on in case others missed
this, also.
We usually start getting titles on our copyright list right away in
January but this year nothing was showing up. It turns out that there is
a line that needed to be changed in the copyright.txt file. Some other
libraries in Wisconsin had not made the change, either.
I checked with Atlas and found out that the line that needs to be
changed is the line that says:
and t.CopyrightAlreadyPaid != 'Yes'
It can be replaced with
AND ISNULL(CopyrightAlreadyPaid, 'No') != 'Yes'
or
and (t.CopyrightAlreadyPaid != 'Yes' or t.CopyrightAlreadyPaid is Null)
Both should work. Just a heads up for everyone.
Regards,
Leigh Dorsey
UW-Milwaukee
_______________________________________________
Workflowtoolkit-l mailing list
Workflowtoolkit-l at geneseo.edu
http://mail.geneseo.edu/mailman/listinfo/workflowtoolkit-l
_______________________________________________
Workflowtoolkit-l mailing list
Workflowtoolkit-l at geneseo.edu
http://mail.geneseo.edu/mailman/listinfo/workflowtoolkit-l
_______________________________________________
Workflowtoolkit-l mailing list
Workflowtoolkit-l at geneseo.edu
http://mail.geneseo.edu/mailman/listinfo/workflowtoolkit-l
------------------------------
Message: 3
Date: Wed, 15 Feb 2012 15:05:05 +0000
From: "Schwartz, Andrea" <aschwart at bloomu.edu>
To: ILLiad Best Practices Workflow Toolkit
<workflowtoolkit-l at geneseo.edu>
Subject: Re: [Workflowtoolkit-l] match string for pre-1923 items
Message-ID:
<ACB1886202847649941B3A6086A446B1DE7C at EXCHMB1.buad.bloomu.edu>
Content-Type: text/plain; charset="iso-8859-1"
Nathan-
Thanks for the help.
In case anyone else is curious, I also had another off-list reply to
try:
(t.LoanDate < '1923') or (t.PhotoJournalYear < '1923') - note that if
you're a shared server site, this would require additional info. But
since I'm a single-site I think this will work for my purposes.
Andrea @ PBB
From: workflowtoolkit-l-bounces at geneseo.edu
[mailto:workflowtoolkit-l-bounces at geneseo.edu] On Behalf Of Nathan
Hosburgh
Sent: Tuesday, February 14, 2012 5:14 PM
To: ILLiad Best Practices Workflow Toolkit
Subject: Re: [Workflowtoolkit-l] match string for pre-1923 items
Andrea, I would create a separate rule:
t.RequestType = 'Article' and t.PhotoJournalYear < '1923'
Nate
Nathan Hosburgh
Document Delivery Librarian
Evans Library
Florida Institute of Technology
150 W. University Blvd.
Melbourne, FL 32901
(321) 674-7540
nhosburg at fit.edu<mailto:nhosburg at fit.edu>
From:
workflowtoolkit-l-bounces at geneseo.edu<mailto:workflowtoolkit-l-bounces at g
eneseo.edu>
[mailto:workflowtoolkit-l-bounces at geneseo.edu]<mailto:[mailto:workflowto
olkit-l-bounces at geneseo.edu]> On Behalf Of Schwartz, Andrea
Sent: Tuesday, February 14, 2012 4:45 PM
To: 'ILLiad Best Practices Workflow Toolkit
(workflowtoolkit-l at geneseo.edu<mailto:workflowtoolkit-l at geneseo.edu>)'
Subject: [Workflowtoolkit-l] match string for pre-1923 items
OK, you've all been so helpful over the past few weeks, I've got one
more.
How can I modify this match string in my routing rules to make it
incorporate pre-1923 article requests?
My existing rule is --> t.RequestType = 'Loan' and t.LoanDate < '1923'
I'm assuming I'd add an "or" in there for t.PhotoJournalYear < '1923'
but constructing these always scares me a bit.
Any guidance?
Thanks,
Andrea Schwartz
Andruss Library/Interlibrary Loan
Bloomsburg University of Pennsylvania
570.389.4218 (ph)
570.389.3895 (fax)
aschwart at bloomu.edu<mailto:aschwart at bloomu.edu>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://mail.geneseo.edu/pipermail/workflowtoolkit-l/attachments/2012021
5/7250c979/attachment-0001.html>
------------------------------
Message: 4
Date: Wed, 15 Feb 2012 15:09:34 +0000
From: Joyce Melvin <jmelvin at unl.edu>
To: ILLiad Best Practices Workflow Toolkit
<workflowtoolkit-l at geneseo.edu>
Subject: Re: [Workflowtoolkit-l] Titles not showing up on
Copyright
List in ILLiad
Message-ID:
<212DA53B0BE3B7498F7FFC7B666439F8079DA0D2 at CH1PRD0802MB120.namprd08.prod.
outlook.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi Leigh, Kathy, Kathryn & others experiencing this problem, I'm
wondering if this is a problem related to the most recent version of
ILLiad. What version are you using?
Like Judy, we're still on 8.1.4 and our copyright list is populating
Thanks!
Joyce Melvin
U of Nebraska Lincoln
ILL
-----Original Message-----
From: workflowtoolkit-l-bounces at geneseo.edu
[mailto:workflowtoolkit-l-bounces at geneseo.edu] On Behalf Of Kathryn
Leigh
Sent: Wednesday, February 15, 2012 7:44 AM
To: 'ILLiad Best Practices Workflow Toolkit'
Subject: Re: [Workflowtoolkit-l] Titles not showing up on Copyright List
in ILLiad
This happened to us too! - And we had to have Atlas tweak the query for
us.
I asked why this might have happened and never received a response to
that question.....wonder if it is a wide spread thing.
Kathryn? Leigh
Head, Access Services
W.E.B. Du Bois Library
154 Hicks Way
University of Massachusetts
Amherst, MA 01003
413-577-0175
-----Original Message-----
From: workflowtoolkit-l-bounces at geneseo.edu
[mailto:workflowtoolkit-l-bounces at geneseo.edu] On Behalf Of Kathy Tower
Sent: Tuesday, February 14, 2012 5:56 PM
To: ILLiad Best Practices Workflow Toolkit
Subject: Re: [Workflowtoolkit-l] Titles not showing up on Copyright List
in ILLiad
I was wondering why I haven't had at least one title appear in the
copyright list yet.
Is this related to updating the client to a certain version or does
everyone need to do this? And where is the copyright.txt file located?
I checked the ILLiad documentation and don't see the location of the
file.
Thanks for letting us all know about this.
Kathy
***************************************
Kathy Tower
Document Delivery/Interlibrary Loan
Arizona Health Sciences Library
University of Arizona
OCLC: AZA DOCLINE: AZUARI
520-626-6840 tower at ahsl.arizona.edu
-----Original Message-----
From: workflowtoolkit-l-bounces at geneseo.edu
[mailto:workflowtoolkit-l-bounces at geneseo.edu] On Behalf Of Leigh A
Dorsey
Sent: Tuesday, February 14, 2012 3:36 PM
To: workflowtoolkit-l at geneseo.edu
Subject: [Workflowtoolkit-l] Titles not showing up on Copyright List in
ILLiad
Hello everyone--I thought I'd pass some info on in case others missed
this, also.
We usually start getting titles on our copyright list right away in
January but this year nothing was showing up. It turns out that there is
a line that needed to be changed in the copyright.txt file. Some other
libraries in Wisconsin had not made the change, either.
I checked with Atlas and found out that the line that needs to be
changed is the line that says:
and t.CopyrightAlreadyPaid != 'Yes'
It can be replaced with
AND ISNULL(CopyrightAlreadyPaid, 'No') != 'Yes'
or
and (t.CopyrightAlreadyPaid != 'Yes' or t.CopyrightAlreadyPaid is Null)
Both should work. Just a heads up for everyone.
Regards,
Leigh Dorsey
UW-Milwaukee
_______________________________________________
Workflowtoolkit-l mailing list
Workflowtoolkit-l at geneseo.edu
http://mail.geneseo.edu/mailman/listinfo/workflowtoolkit-l
_______________________________________________
Workflowtoolkit-l mailing list
Workflowtoolkit-l at geneseo.edu
http://mail.geneseo.edu/mailman/listinfo/workflowtoolkit-l
_______________________________________________
Workflowtoolkit-l mailing list
Workflowtoolkit-l at geneseo.edu
http://mail.geneseo.edu/mailman/listinfo/workflowtoolkit-l
------------------------------
_______________________________________________
Workflowtoolkit-l mailing list
Workflowtoolkit-l at geneseo.edu
http://mail.geneseo.edu/mailman/listinfo/workflowtoolkit-l
End of Workflowtoolkit-l Digest, Vol 27, Issue 26
*************************************************
More information about the Workflowtoolkit-l
mailing list