[OPEN-ILS-GENERAL] Creating a report template with true/false values hardcoded

Wed Jan 26 13:55:44 EST 2011

Hi again fellow Evergreen users~ It occurs to me that I didn't give you
enough information in my email about the report I am trying to create. What
I need is a way to get the report to list all items that were not checked in
or out on or before a certain date. I can make a list of items that were; it
would be very long and useless. So I really need two things: How do I add
'false' to my checked in and checked out dates; and how can I put an 'or'
between the checked in date and the checked out date fields so the report
will count both of them as present in the library. Thanking you for you
help. ~Reba

I am trying to create a report template. I want to hardcode a true/false
value into the report and I can't seem to find instructions on how to do
that. Will someone please help me? Thanks ~ Reba

-----Original Message-----
From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
open-ils-general-request at list.georgialibraries.org
Sent: Tuesday, January 25, 2011 8:00 AM
To: open-ils-general at list.georgialibraries.org
Subject: Open-ils-general Digest, Vol 55, Issue 36

Send Open-ils-general mailing list submissions to
	open-ils-general at list.georgialibraries.org

To subscribe or unsubscribe via the World Wide Web, visit

http://libmail.georgialibraries.org/mailman/listinfo/open-ils-general
or, via email, send a message with subject or body 'help' to
	open-ils-general-request at list.georgialibraries.org

You can reach the person managing the list at
	open-ils-general-owner at list.georgialibraries.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Open-ils-general digest..."

Today's Topics:

   1. Re: OPAC start page (Dan Scott)
   2. Re: OPAC start page (Vicki Reeves)
   3. Re: OPAC start page (Sharp, Chris)

----------------------------------------------------------------------

Message: 1
Date: Mon, 24 Jan 2011 22:26:53 -0500
From: Dan Scott <dan at coffeecode.net>
Subject: Re: [OPEN-ILS-GENERAL] OPAC start page
To: vickir at beau.org,	Evergreen Discussion Group
	<open-ils-general at list.georgialibraries.org>
Message-ID: <20110125032653.GA4015 at dbs.denials>
Content-Type: text/plain; charset=us-ascii

On Mon, Jan 24, 2011 at 04:35:01PM -0600, Vicki Reeves wrote:
> We have gotten some bib and holdings records to load.  We celebrated by
> playing in the OPAC.  But that gave us a new issue ...

Yay!

<snip>

> Our problem is that we don't know how to 'point' the OPAC so that it
> starts searching at our library (2nd level) instead of the regional
> library (top level). 

<snip>

> If I pick Beauregard Parish Library, I see 'Now searching Beauregard
> Parish Library' which is where I want our patrons to start, but the URL
> is still this:
> http://evergreen.library.beau.org/opac/en-US/skin/craftsman/xml/index.xml

Once you've picked your library, run a search. The URL will change to
something like
http://evergreen.library.beau.org/opac/en-US/skin/lul/xml/rresult.xml?rt=key
word&tp=keyword&t=jazz&l=103&d=2&f=

The key GET param you're interested in is the "l" parameter - which
stands for "library". This specifies the ID of the library found in the
actor.org_unit table to which you want to scope your search. However,
you can see that value in the URL so you don't need to look in the
database for this one.

Assuming that the value in your case is "l=102", you can provide links
to
http://evergreen.library.beau.org/opac/en-US/skin/craftsman/xml/index.xml?l=
102
to start patrons at the right search scope. In our case, we redirect
patrons from various subdomains (like "laurentian.concat.ca" and
"windsor.concat.ca") to the full URL including the "l" parameter
appropriate for the scope of each library.

Hopefully this helps.

------------------------------

Message: 2
Date: Mon, 24 Jan 2011 21:57:17 -0600
From: Vicki Reeves <vickir at beau.org>
Subject: Re: [OPEN-ILS-GENERAL] OPAC start page
To: Dan Scott <dan at coffeecode.net>
Cc: Evergreen Discussion Group
	<open-ils-general at list.georgialibraries.org>
Message-ID: <1295927837.4643.3.camel at wountie.library.beau.org>
Content-Type: text/plain

Thank you.  This sounds like exactly what we needed.  

On Mon, 2011-01-24 at 22:26 -0500, Dan Scott wrote:
> On Mon, Jan 24, 2011 at 04:35:01PM -0600, Vicki Reeves wrote:
> > We have gotten some bib and holdings records to load.  We celebrated by
> > playing in the OPAC.  But that gave us a new issue ...
> 
> Yay!
>  
> <snip>
>  
> > Our problem is that we don't know how to 'point' the OPAC so that it
> > starts searching at our library (2nd level) instead of the regional
> > library (top level). 
> 
> <snip>
> 
> > If I pick Beauregard Parish Library, I see 'Now searching Beauregard
> > Parish Library' which is where I want our patrons to start, but the URL
> > is still this:
> >
http://evergreen.library.beau.org/opac/en-US/skin/craftsman/xml/index.xml
> 
> Once you've picked your library, run a search. The URL will change to
> something like
>
http://evergreen.library.beau.org/opac/en-US/skin/lul/xml/rresult.xml?rt=key
word&tp=keyword&t=jazz&l=103&d=2&f=
> 
> The key GET param you're interested in is the "l" parameter - which
> stands for "library". This specifies the ID of the library found in the
> actor.org_unit table to which you want to scope your search. However,
> you can see that value in the URL so you don't need to look in the
> database for this one.
> 
> Assuming that the value in your case is "l=102", you can provide links
> to
>
http://evergreen.library.beau.org/opac/en-US/skin/craftsman/xml/index.xml?l=
102
> to start patrons at the right search scope. In our case, we redirect
> patrons from various subdomains (like "laurentian.concat.ca" and
> "windsor.concat.ca") to the full URL including the "l" parameter
> appropriate for the scope of each library.
> 
> Hopefully this helps.

------------------------------

Message: 3
Date: Tue, 25 Jan 2011 06:19:41 -0500 (EST)
From: "Sharp, Chris" <csharp at georgialibraries.org>
Subject: Re: [OPEN-ILS-GENERAL] OPAC start page
To: vickir at beau.org, 	Evergreen Discussion Group
	<open-ils-general at list.georgialibraries.org>
Message-ID:

<718063742.30698.1295954381664.JavaMail.root at hagrid.georgialibraries.org>

Content-Type: text/plain; charset=utf-8

Vicki,

You can also add the IP range of each library to a file on the server in
/openils/conf (assuming you added the "--sysconfdir=/openils/conf" parameter
in the "./configure" step during installation) called "lib_ips.txt".  There
is a "lib_ips.txt.example" file in a default installation that you can
rename to "lib_ips.txt" and add your libraries' IP ranges in the format
<shortname> <start IP> <end IP>.  The example setting in
"lib_ips.txt.example" is

MY-LIB 127.0.0.1 127.0.0.254

Where MY-LIB is the value in actor.org_unit.shortname for the library with
that IP range.

Then, in /etc/apache2/startup.pl, you'll see this:

# - Uncoment the following 2 lines to make use of the IP redirection code
# - The IP file should to contain a map with the following format:
# - actor.org_unit.shortname <start_ip> <end_ip>
# - e.g.  LIB123 10.0.0.1 10.0.0.254

#use OpenILS::WWW::Redirect qw(/openils/conf/opensrf_core.xml);
#OpenILS::WWW::Redirect->parse_ips_file('/openils/conf/lib_ips.txt');

If you uncomment the two lines and restart apache, your OPACs should
automagically redirect to their default location.  Hope that helps too!

Chris Sharp
PINES Program Manager
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csharp at georgialibraries.org
http://pines.georgialibraries.org/

----- Original Message -----
> From: "Vicki Reeves" <vickir at beau.org>
> To: "Dan Scott" <dan at coffeecode.net>
> Cc: "Evergreen Discussion Group"
<open-ils-general at list.georgialibraries.org>
> Sent: Monday, January 24, 2011 10:57:17 PM
> Subject: Re: [OPEN-ILS-GENERAL] OPAC start page
> Thank you. This sounds like exactly what we needed.
> 
> On Mon, 2011-01-24 at 22:26 -0500, Dan Scott wrote:
> > On Mon, Jan 24, 2011 at 04:35:01PM -0600, Vicki Reeves wrote:
> > > We have gotten some bib and holdings records to load. We
> > > celebrated by
> > > playing in the OPAC. But that gave us a new issue ...
> >
> > Yay!
> >
> > <snip>
> >
> > > Our problem is that we don't know how to 'point' the OPAC so that
> > > it
> > > starts searching at our library (2nd level) instead of the
> > > regional
> > > library (top level).
> >
> > <snip>
> >
> > > If I pick Beauregard Parish Library, I see 'Now searching
> > > Beauregard
> > > Parish Library' which is where I want our patrons to start, but
> > > the URL
> > > is still this:
> > >
http://evergreen.library.beau.org/opac/en-US/skin/craftsman/xml/index.xml
> >
> > Once you've picked your library, run a search. The URL will change
> > to
> > something like
> >
http://evergreen.library.beau.org/opac/en-US/skin/lul/xml/rresult.xml?rt=key
word&tp=keyword&t=jazz&l=103&d=2&f=
> >
> > The key GET param you're interested in is the "l" parameter - which
> > stands for "library". This specifies the ID of the library found in
> > the
> > actor.org_unit table to which you want to scope your search.
> > However,
> > you can see that value in the URL so you don't need to look in the
> > database for this one.
> >
> > Assuming that the value in your case is "l=102", you can provide
> > links
> > to
> >
http://evergreen.library.beau.org/opac/en-US/skin/craftsman/xml/index.xml?l=
102
> > to start patrons at the right search scope. In our case, we redirect
> > patrons from various subdomains (like "laurentian.concat.ca" and
> > "windsor.concat.ca") to the full URL including the "l" parameter
> > appropriate for the scope of each library.
> >
> > Hopefully this helps.

End of Open-ils-general Digest, Vol 55, Issue 36
************************************************