Re: [OPEN-ILS-GENERAL] Report Generation

[Ellen Rainville]

I am attending the MLA Conference from Tuesday May 6 through Thursday May
8, and taking a vacation day on May 9. If you need assistance during this
period contact Asst. Director India Nolen at ino...@westfordma.gov or
Admin. Asst. Zoe Daniel at zdan...@westfordma.gov.



All email messages and attached content sent from and to this email
account are public records unless qualified as an exemption under the [
http://www.sec.state.ma.us/pre/preidx.htm ]Massachusetts Public Records
Law.

Re: [OPEN-ILS-GENERAL] Report Generation

[Jayaraj JR]

Hello,

The "minor" detail have made a major change in our library's attempt to
generate reports based on MARC fields. The idea suggested by Chauncy
Montgomery is highly useful, simple and perfect for generating reports
based on any MARC sub filed/ Tags. The individual normalized values can be
combined using more than one template or using any spreadsheet.

The output is really wonderful.

I use this opportunity to express sincere thanks to all who actively
participated in the discussion and share their valuable ideas.

-- 
Jayaraj J R
Central Library
IISER Thiruvananthapuram

Re: [OPEN-ILS-GENERAL] Report Generation

[Chauncey Montgomery]

Jayaraj,
"Minor" detail I missed in original post; add to the displayed fields:
Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC 
Fields - Normalized Value


This should show you what data is contained in that Subfield. Sorry 
about that.


CM
--
Chauncey G. Montgomery, MLIS
Director/Fiscal Officer | Community Library
44 Burrer Drive | Sunbury, OH 43074
740-965-3901 | http://community.lib.oh.us

On 05/07/2014 06:49 AM, Jayaraj JR wrote:

Hello Chauncey Montgomery,

I have entered the variables as follows

Filters:
Item :: Shelving Location - Location ID
Item :: Call Number/Volume - Owning Library
Item :: Call Number/Volume - Is Deleted
Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC
Fields - Tag
Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC
Fields - Subfield

Display:
Item -> Call Number/Volume -> Bibliographic Record :: Simple Record
Extracts - Title Proper (normalized)
Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC
Fields - Tag
Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC
Fields - Subfield

The output is attached. Here the values entered in the Tag and Sub field
area during report generation is displayed as it is in the report
output.Our requirement is if we enter 100 a , it would display the value
entered in the field ie author name in the output. My report displays
100 a in each row.

Please correct me where I go wrong in the above steps.

--
Jayaraj J R
Central Library
IISER Thiruvananthapuram

Re: [OPEN-ILS-GENERAL] Report Generation

[Ellen Rainville]

I am attending the MLA Conference from Tuesday May 6 through Thursday May
8, and taking a vacation day on May 9. If you need assistance during this
period contact Asst. Director India Nolen at ino...@westfordma.gov or
Admin. Asst. Zoe Daniel at zdan...@westfordma.gov.



All email messages and attached content sent from and to this email
account are public records unless qualified as an exemption under the [
http://www.sec.state.ma.us/pre/preidx.htm ]Massachusetts Public Records
Law.

Re: [OPEN-ILS-GENERAL] Report Generation

[Chauncey Montgomery]

Dan,
You're correct. I ran a test report on 651 and 901 tags with the 
subfields a and b.  The results display 651 a & b, as well as 901 a and 
b.  Perhaps there is a different way to filter than what I'm using. Or 
using Excel you could do further data manipulation.  Thanks for pointing 
that out.

CM

On 05/06/2014 09:35 AM, Dan Wells wrote:

One thing I'm not sure you can do in the reporter is group filters.  For 
example, I don't think you could pull 650a and 911b.  Instead, you effectively 
end up with the cross product of 650ab and 911ab.  Sometimes this limitation 
matters, sometimes it doesn't.

Also, if I'm mistaken, I'd love to know about it.

Thanks,
Dan


Daniel Wells
Library Programmer/Analyst
Hekman Library, Calvin College
616.526.7133

-Original Message-
From: open-ils-general-boun...@list.georgialibraries.org 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of 
Chauncey Montgomery
Sent: Tuesday, May 06, 2014 9:04 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Report Generation

   Jayaraj,
On your filters for tags and subfields, change the operator to "in list." When 
you build your report, you'll have empty text boxes to enter the information you want to 
filter on.  You can enter more than one element into that filter. For example, with the 
tag, I can enter 600 in the box and click add, then 650 and click add again, and now the 
report should filter on both.  See the attached screenshot for the example.  I hope that 
makes sense. Good luck and keep us posted on the outcome.
CM
--
Chauncey G. Montgomery, MLIS
Director/Fiscal Officer | Community Library
44 Burrer Drive | Sunbury, OH 43074
740-965-3901 | http://community.lib.oh.us


On 05/06/2014 12:31 AM, Jayaraj JR wrote:

Hello,

The recent developments discussed about Report Generation is very
interesting and useful. Special Thanks and Congrats to Chauncey
Montgomery !.

We have a requirement to generate a report which can display the
values contained in the sub fields and tags.ie <http://tags.ie>

Instead of displaying 650 a, we require the value entered in the field
650 a.

and 911 a b c. What modification need to be done below for such a report.

Filters:
Item :: Shelving Location - Location ID Item :: Call Number/Volume -
Owning Library Item :: Call Number/Volume - Is Deleted Item -> Call
Number/Volume -> Bibliographic Record :: Flattened MARC Fields - Tag
Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC
Fields - Subfield

Display:
Item -> Call Number/Volume -> Bibliographic Record :: Simple Record
Extracts - Title Proper (normalized) Item -> Call Number/Volume ->
Bibliographic Record :: Flattened MARC Fields - Tag Item -> Call
Number/Volume -> Bibliographic Record :: Flattened MARC Fields -
Subfield


--
Jayaraj J R
Central Library
IISER Thiruvananthapuram

http://www.iisertvm.ac.in

Re: [OPEN-ILS-GENERAL] Report Generation

[Dan Wells]

One thing I'm not sure you can do in the reporter is group filters.  For 
example, I don't think you could pull 650a and 911b.  Instead, you effectively 
end up with the cross product of 650ab and 911ab.  Sometimes this limitation 
matters, sometimes it doesn't.

Also, if I'm mistaken, I'd love to know about it.

Thanks,
Dan


Daniel Wells
Library Programmer/Analyst
Hekman Library, Calvin College
616.526.7133

-Original Message-
From: open-ils-general-boun...@list.georgialibraries.org 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of 
Chauncey Montgomery
Sent: Tuesday, May 06, 2014 9:04 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Report Generation

  Jayaraj,
On your filters for tags and subfields, change the operator to "in list." When 
you build your report, you'll have empty text boxes to enter the information 
you want to filter on.  You can enter more than one element into that filter. 
For example, with the tag, I can enter 600 in the box and click add, then 650 
and click add again, and now the report should filter on both.  See the 
attached screenshot for the example.  I hope that makes sense. Good luck and 
keep us posted on the outcome.
CM
--
Chauncey G. Montgomery, MLIS
Director/Fiscal Officer | Community Library
44 Burrer Drive | Sunbury, OH 43074
740-965-3901 | http://community.lib.oh.us


On 05/06/2014 12:31 AM, Jayaraj JR wrote:
> Hello,
>
> The recent developments discussed about Report Generation is very 
> interesting and useful. Special Thanks and Congrats to Chauncey 
> Montgomery !.
>
> We have a requirement to generate a report which can display the 
> values contained in the sub fields and tags.ie <http://tags.ie>
>
> Instead of displaying 650 a, we require the value entered in the field
> 650 a.
>
> and 911 a b c. What modification need to be done below for such a report.
>
> Filters:
> Item :: Shelving Location - Location ID Item :: Call Number/Volume - 
> Owning Library Item :: Call Number/Volume - Is Deleted Item -> Call 
> Number/Volume -> Bibliographic Record :: Flattened MARC Fields - Tag 
> Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC 
> Fields - Subfield
>
> Display:
> Item -> Call Number/Volume -> Bibliographic Record :: Simple Record 
> Extracts - Title Proper (normalized) Item -> Call Number/Volume -> 
> Bibliographic Record :: Flattened MARC Fields - Tag Item -> Call 
> Number/Volume -> Bibliographic Record :: Flattened MARC Fields - 
> Subfield
>
>
> --
> Jayaraj J R
> Central Library
> IISER Thiruvananthapuram
> 
> http://www.iisertvm.ac.in

Re: [OPEN-ILS-GENERAL] Report Generation

[Chauncey Montgomery]

 Jayaraj,
On your filters for tags and subfields, change the operator to "in 
list." When you build your report, you'll have empty text boxes to enter 
the information you want to filter on.  You can enter more than one 
element into that filter. For example, with the tag, I can enter 600 in 
the box and click add, then 650 and click add again, and now the report 
should filter on both.  See the attached screenshot for the example.  I 
hope that makes sense. Good luck and keep us posted on the outcome.

CM
--
Chauncey G. Montgomery, MLIS
Director/Fiscal Officer | Community Library
44 Burrer Drive | Sunbury, OH 43074
740-965-3901 | http://community.lib.oh.us


On 05/06/2014 12:31 AM, Jayaraj JR wrote:

Hello,

The recent developments discussed about Report Generation is very
interesting and useful. Special Thanks and Congrats to Chauncey
Montgomery !.

We have a requirement to generate a report which can display the values
contained in the sub fields and tags.ie 

Instead of displaying 650 a, we require the value entered in the field
650 a.

and 911 a b c. What modification need to be done below for such a report.

Filters:
Item :: Shelving Location - Location ID
Item :: Call Number/Volume - Owning Library
Item :: Call Number/Volume - Is Deleted
Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC
Fields - Tag
Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC
Fields - Subfield

Display:
Item -> Call Number/Volume -> Bibliographic Record :: Simple Record
Extracts - Title Proper (normalized)
Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC
Fields - Tag
Item -> Call Number/Volume -> Bibliographic Record :: Flattened MARC
Fields - Subfield


--
Jayaraj J R
Central Library
IISER Thiruvananthapuram

http://www.iisertvm.ac.in