Re: [OPEN-ILS-GENERAL] Finding records in Evergreen that have no items attached?

2017-01-18 Thread Walz, Jennifer
Andrea,

Ooo…  that looks nice too.   That would probably have been my follow up 
question.  ☺

Thanks!

Jennifer

From: Open-ils-general 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Andrea 
Buntz Neiman
Sent: Wednesday, January 18, 2017 9:53 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Finding records in Evergreen that have no items 
attached?

Hi Jennifer,

An alternative that I used when I worked at KCPL will show bibs that have no 
copies but still have empty volumes attached (which can prevent a record from 
auto-deleting):

Source -- Last Copy Delete Time

Displayed Fields:
Record ID (transform: Raw Data)
Delete Date/Time (Transform: Date)

Filter Field:
[Bib] Deleted = False  (Last Copy Delete Time :: Record ID)

This will return a list of Bib IDs for undeleted bibs, and the date the last 
copy on the bib was deleted.  You can then go through and delete any "stuck" 
empty volumes.

Andrea

On Wed, Jan 18, 2017 at 9:30 AM, Walz, Jennifer 
> wrote:
Blake,

Thank you!   I will take a look at that.

Jennifer

From: Open-ils-general 
[mailto:open-ils-general-boun...@list.georgialibraries.org]
 On Behalf Of Blake Henderson
Sent: Wednesday, January 18, 2017 9:11 AM
To: 
open-ils-general@list.georgialibraries.org
Subject: Re: [OPEN-ILS-GENERAL] Finding records in Evergreen that have no items 
attached?

Jennifer,


This sounds familiar. We developed an additional reporting source to make this 
easier for us. In case your goal was to find bibs that "used" to have copies 
attached. Take a look at
https://bugs.launchpad.net/evergreen/+bug/1582354

-Blake-

Conducting Magic

MOBIUS

573-234-4513

877-312-3517
On 1/17/2017 6:16 PM, Walz, Jennifer wrote:
All –

We need to find out if we have ‘empty’ records.   IS there a report template 
that I can modify that will show me all our records  with no items attached?  
Maybe there is a source that is particularly helpful if I need to start from 
scratch?   Can someone advise me on how to find out this information.

Thanks!

Jennifer
--
Jennifer Walz, MLS - Head of ILS deletions
Kinlaw Library  - Asbury University
1 Macklem Drive, Wilmore, KY 40390
859-858-3511 ext. 2269
jlw...@asbury.edu






--
Andrea Buntz Neiman
Project Manager for Software Development
Equinox Open Library Initiative
abnei...@equinoxinitiative.org
1-877-OPEN-ILS (673-6457)
www.equinoxinitiative.org


Re: [OPEN-ILS-GENERAL] Finding records in Evergreen that have no items attached?

2017-01-18 Thread Andrea Buntz Neiman
Hi Jennifer,

An alternative that I used when I worked at KCPL will show bibs that have
no copies but still have empty volumes attached (which can prevent a record
from auto-deleting):

Source -- Last Copy Delete Time

Displayed Fields:
Record ID (transform: Raw Data)
Delete Date/Time (Transform: Date)

Filter Field:
[Bib] Deleted = False  (Last Copy Delete Time :: Record ID)

This will return a list of Bib IDs for undeleted bibs, and the date the
last copy on the bib was deleted.  You can then go through and delete any
"stuck" empty volumes.

Andrea

On Wed, Jan 18, 2017 at 9:30 AM, Walz, Jennifer  wrote:

> Blake,
>
>
>
> Thank you!   I will take a look at that.
>
>
>
> Jennifer
>
>
>
> *From:* Open-ils-general [mailto:open-ils-general-
> boun...@list.georgialibraries.org] *On Behalf Of *Blake Henderson
> *Sent:* Wednesday, January 18, 2017 9:11 AM
> *To:* open-ils-general@list.georgialibraries.org
> *Subject:* Re: [OPEN-ILS-GENERAL] Finding records in Evergreen that have
> no items attached?
>
>
>
> Jennifer,
>
>
> This sounds familiar. We developed an additional reporting source to make
> this easier for us. In case your goal was to find bibs that "used" to have
> copies attached. Take a look at
> https://bugs.launchpad.net/evergreen/+bug/1582354
>
> -Blake-
>
> Conducting Magic
>
> MOBIUS
>
> 573-234-4513 <(573)%20234-4513>
>
> 877-312-3517 <(877)%20312-3517>
>
> On 1/17/2017 6:16 PM, Walz, Jennifer wrote:
>
> All –
>
>
>
> We need to find out if we have ‘empty’ records.   IS there a report
> template that I can modify that will show me all our records  with no items
> attached?  Maybe there is a source that is particularly helpful if I need
> to start from scratch?   Can someone advise me on how to find out this
> information.
>
>
>
> Thanks!
>
>
>
> Jennifer
>
> --
> Jennifer Walz, MLS - Head of ILS deletions
> Kinlaw Library  - Asbury University
> 1 Macklem Drive, Wilmore, KY 40390
> 859-858-3511 ext. 2269 <(859)%20858-3511>
> jlw...@asbury.edu
>
>
>
>
>
>
>



-- 
Andrea Buntz Neiman
Project Manager for Software Development
Equinox Open Library Initiative
abnei...@equinoxinitiative.org
1-877-OPEN-ILS (673-6457)
*www.equinoxinitiative.org *


Re: [OPEN-ILS-GENERAL] Finding records in Evergreen that have no items attached?

2017-01-18 Thread Walz, Jennifer
Blake,

Thank you!   I will take a look at that.

Jennifer

From: Open-ils-general 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Blake 
Henderson
Sent: Wednesday, January 18, 2017 9:11 AM
To: open-ils-general@list.georgialibraries.org
Subject: Re: [OPEN-ILS-GENERAL] Finding records in Evergreen that have no items 
attached?

Jennifer,

This sounds familiar. We developed an additional reporting source to make this 
easier for us. In case your goal was to find bibs that "used" to have copies 
attached. Take a look at
https://bugs.launchpad.net/evergreen/+bug/1582354


-Blake-

Conducting Magic

MOBIUS

573-234-4513

877-312-3517
On 1/17/2017 6:16 PM, Walz, Jennifer wrote:
All –

We need to find out if we have ‘empty’ records.   IS there a report template 
that I can modify that will show me all our records  with no items attached?  
Maybe there is a source that is particularly helpful if I need to start from 
scratch?   Can someone advise me on how to find out this information.

Thanks!

Jennifer
--
Jennifer Walz, MLS - Head of ILS deletions
Kinlaw Library  - Asbury University
1 Macklem Drive, Wilmore, KY 40390
859-858-3511 ext. 2269
jlw...@asbury.edu





Re: [OPEN-ILS-GENERAL] Finding records in Evergreen that have no items attached?

2017-01-18 Thread Blake Henderson

Jennifer,

This sounds familiar. We developed an additional reporting source to 
make this easier for us. In case your goal was to find bibs that "used" 
to have copies attached. Take a look at

https://bugs.launchpad.net/evergreen/+bug/1582354

-Blake-
Conducting Magic
MOBIUS
573-234-4513
877-312-3517

On 1/17/2017 6:16 PM, Walz, Jennifer wrote:


All –

We need to find out if we have ‘empty’ records.   IS there a report 
template that I can modify that will show me all our records  with no 
items attached?  Maybe there is a source that is particularly helpful 
if I need to start from scratch?   Can someone advise me on how to 
find out this information.


Thanks!

Jennifer

--
Jennifer Walz, MLS - Head of ILS deletions
Kinlaw Library  - Asbury University
1 Macklem Drive, Wilmore, KY 40390
859-858-3511 ext. 2269
jlw...@asbury.edu





[OPEN-ILS-GENERAL] Finding records in Evergreen that have no items attached?

2017-01-17 Thread Walz, Jennifer
All –

We need to find out if we have ‘empty’ records.   IS there a report template 
that I can modify that will show me all our records  with no items attached?  
Maybe there is a source that is particularly helpful if I need to start from 
scratch?   Can someone advise me on how to find out this information.

Thanks!

Jennifer
--
Jennifer Walz, MLS - Head of ILS deletions
Kinlaw Library  - Asbury University
1 Macklem Drive, Wilmore, KY 40390
859-858-3511 ext. 2269
jlw...@asbury.edu