No subject
Fri Dec 14 15:48:43 EST 2012
screen to delete them using the Upload from File button. If all your
report has is the barcodes you can save the excel file and import it
straight into Item Status. (If the report has other fields, strip them
from the file) However, I'd recommend breaking them into smaller chunks
(100-200 or so) at a time. I just copy and paste groups from my report
into a notepad file. Then you click the Upload from File, select your file
and the items load. Highlight them and delete the whole group. It's a
pretty quick and easy process. But I bet there would be a better way from
the back end if it's a truly massive group. Somebody else will have to
direct you there.
---
Sarah Childs
Senior Cataloger
Hussey-Mayfield Memorial Public Library
250 North Fifth Street
Zionsville, IN 46077
317-873-3149 x13330 <tel:317-873-3149%20x13330>
sarahc at zionsville.lib.in.us
Message: 2
Date: Tue, 26 Mar 2013 14:52:46 -0400
From: Tony Bandy <tonyb at ohionet.org>
Subject: [OPEN-ILS-GENERAL] Best method of removing items from bibs?
To: Evergreen Discussion Group
<open-ils-general at list.georgialibraries.org>
Message-ID:
<CAEKwE4V7Wn1ddDkW1F87hCp6G+425sxpWEG7r2aW=kNRVHEJtA at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi all,
Was wondering if I could post this out to the group for ideas?
Working with a massive list of electronic resource bib records that are
needing some mistakenly added item records removed from them. I've been
able to create a list of item barcodes in the reports module. Is there a
way I can mass add these items via a copy bucket so that I can delete them
all at once from my list of bib records?
Or....is there a faster (better, cheaper, etc.) method of mass deleting
item records from the bibliographic records that I'm not aware of? This
involves electronic resource records, which don't need any attached item
records. PSQL operation maybe that you have used before?
Thanks for any links, thoughts, your experience on this as you have a
minute or two....
Tony
--
Tony Bandy
tonyb at ohionet.org
OHIONET
1500 West Lane Ave.
Columbus, OH 43221-3975
614-486-2966 x19 <tel:614-486-2966%20x19>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://libmail.georgialibraries.org/pipermail/open-ils-general/attachment
s/20130326/e77dc3f6/attachment-0001.htm>
--
Tony Bandy
tonyb at ohionet.org
OHIONET
1500 West Lane Ave.
Columbus, OH 43221-3975
614-486-2966 x19
------=_NextPart_000_03C8_01CE2BD5.794E8320
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40"><head><META =
HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii"><meta name=3DGenerator content=3D"Microsoft Word 14 =
(filtered medium)"><!--[if !mso]><style>v\:* =
{behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.hoenzb
{mso-style-name:hoenzb;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue =
vlink=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>Remember to uncheck the trim list box before you import your =
list.<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p> </o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>And as Sarah said, breaking the list into a few hundred makes it much =
more manageable.<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p> </o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>Once you delete the barcodes from the records, depending on your =
settings, the bib records will likely be deleted. In order to get them =
to display in the catalog, you will have to undelete them. It might be =
best to change your library setting not to delete records that have the =
last item/vol attached before you delete the items then change it back =
when you are finished.<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p> </o:p></span></p><div><div><div><div><div><p =
class=3DMsoNormal><i><span =
style=3D'font-size:18.0pt;font-family:"Garamond","serif";color:#1F497D'>E=
laine</span></i><span style=3D'color:#1F497D'><o:p></o:p></span></p><div =
class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span =
style=3D'color:#1F497D'><hr size=3D3 width=3D"100%" =
align=3Dcenter></span></div></div></div></div></div></div><p =
class=3DMsoNormal><span style=3D'color:#1F497D'><br>J. Elaine =
Hardy<br>PINES Bibliographic Projects & Metadata Manager<br>Georgia =
Public Library Service<br>1800 Century Place, Ste 150<br>Atlanta, Ga. =
30345-4304<br><br>404.235-7128<br>404.235-7201, =
fax<br>ehardy at georgialibraries.org<br>www.georgialibraries.org<br><a =
href=3D"http://www.georgialibraries.org/pines">www.georgialibraries.org/p=
ines</a><br><br><br></span><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p></o:p></span></p><p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span>=
</b><span style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> =
open-ils-general-bounces at list.georgialibraries.org =
[mailto:open-ils-general-bounces at list.georgialibraries.org] <b>On Behalf =
Of </b>Tony Bandy<br><b>Sent:</b> Tuesday, March 26, 2013 3:54 =
PM<br><b>To:</b> sarahc at zionsville.lib.in.us; Evergreen Discussion =
Group<br><b>Subject:</b> Re: [OPEN-ILS-GENERAL] Best method of removing =
items from bibs?<o:p></o:p></span></p><p =
class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal>Hi Sarah, =
folks,<o:p></o:p></p><div><p =
class=3DMsoNormal><o:p> </o:p></p></div><div><p =
class=3DMsoNormal>That's awesome...I was so focused on using the bucket =
approach, that I neglected to think of that part of the staff-client. =
<o:p></o:p></p></div><div><p =
class=3DMsoNormal><o:p> </o:p></p></div><div><p =
class=3DMsoNormal>Thank you so much! <o:p></o:p></p></div><div><p =
class=3DMsoNormal><o:p> </o:p></p></div><div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'>--Tony<o:p></o:p></p><div><p =
class=3DMsoNormal>On Tue, Mar 26, 2013 at 3:33 PM, Sarah Childs <<a =
href=3D"mailto:sarahc at zionsville.lib.in.us" =
target=3D"_blank">sarahc at zionsville.lib.in.us</a>> =
wrote:<o:p></o:p></p><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'>Hi, Tony.<br>From the staff client side =
you can import barcodes into the item status screen to delete them using =
the Upload from File button. If all your report has is the =
barcodes you can save the excel file and import it straight into Item =
Status. (If the report has other fields, strip them from the file) =
However, I'd recommend breaking them into smaller chunks (100-200 or so) =
at a time. I just copy and paste groups from my report into a notepad =
file. Then you click the Upload from File, select your file and the =
items load. Highlight them and delete the whole group. It's a pretty =
quick and easy process. But I bet there would be a better way from the =
back end if it's a truly massive group. Somebody else will have to =
direct you there.<br><br>---<br>Sarah Childs<br>Senior =
Cataloger<br>Hussey-Mayfield Memorial Public Library<br>250 North Fifth =
Street<br>Zionsville, IN 46077<br><a href=3D"tel:317-873-3149%20x13330" =
target=3D"_blank">317-873-3149 x13330</a><br><a =
href=3D"mailto:sarahc at zionsville.lib.in.us" =
target=3D"_blank">sarahc at zionsville.lib.in.us</a><br><br><o:p></o:p></p><=
p class=3DMsoNormal style=3D'margin-bottom:12.0pt'>Message: 2<br>Date: =
Tue, 26 Mar 2013 14:52:46 -0400<br>From: Tony Bandy <<a =
href=3D"mailto:tonyb at ohionet.org" =
target=3D"_blank">tonyb at ohionet.org</a>><br>Subject: =
[OPEN-ILS-GENERAL] Best method of removing items from bibs?<br>To: =
Evergreen Discussion Group<br> <<a =
href=3D"mailto:open-ils-general at list.georgialibraries.org" =
target=3D"_blank">open-ils-general at list.georgialibraries.org</a>><br>M=
essage-ID:<br> =
<CAEKwE4V7Wn1ddDkW1F87hCp6G+425sxpWEG7r2aW=3D<a =
href=3D"mailto:kNRVHEJtA at mail.gmail.com" =
target=3D"_blank">kNRVHEJtA at mail.gmail.com</a>><br>Content-Type: =
text/plain; charset=3D"iso-8859-1"<br>Hi all,<br>Was wondering =
if I could post this out to the group for ideas?<br>Working with a =
massive list of electronic resource bib records that are<br>needing some =
mistakenly added item records removed from them. I've =
been<br>able to create a list of item barcodes in the reports module. =
Is there a<br>way I can mass add these items via a copy bucket so =
that I can delete them<br>all at once from my list of bib =
records?<br>Or....is there a faster (better, cheaper, etc.) method of =
mass deleting<br>item records from the bibliographic records that I'm =
not aware of? This<br>involves electronic resource records, which =
don't need any attached item<br>records. PSQL operation maybe that =
you have used before?<br>Thanks for any links, thoughts, your experience =
on this as you have a<br>minute or two....<br>Tony<span =
style=3D'color:#888888'><br><span class=3Dhoenzb>--</span><br><span =
class=3Dhoenzb>Tony Bandy</span><br><span class=3Dhoenzb><a =
href=3D"mailto:tonyb at ohionet.org" =
target=3D"_blank">tonyb at ohionet.org</a></span><br><span =
class=3Dhoenzb>OHIONET</span><br><span class=3Dhoenzb>1500 West Lane =
Ave.</span><br><span class=3Dhoenzb>Columbus, OH =
43221-3975</span><br><span class=3Dhoenzb><a =
href=3D"tel:614-486-2966%20x19" target=3D"_blank">614-486-2966 =
x19</a></span><br><span class=3Dhoenzb>-------------- next part =
--------------</span><br><span class=3Dhoenzb>An HTML attachment was =
scrubbed...</span><br><span class=3Dhoenzb>URL:</span><br><span =
class=3Dhoenzb><<a =
href=3D"http://libmail.georgialibraries.org/pipermail/open-ils-general/at=
tachments/20130326/e77dc3f6/attachment-0001.htm" =
target=3D"_blank">http://libmail.georgialibraries.org/pipermail/open-ils-=
general/attachments/20130326/e77dc3f6/attachment-0001.htm</a>></span><=
/span><o:p></o:p></p><p class=3DMsoNormal><o:p> </o:p></p></div><p =
class=3DMsoNormal><br><br clear=3Dall><o:p></o:p></p><div><p =
class=3DMsoNormal><o:p> </o:p></p></div><p class=3DMsoNormal>-- =
<o:p></o:p></p><div><p class=3DMsoNormal><span =
style=3D'color:black'>Tony Bandy<br><a href=3D"mailto:tonyb at ohionet.org" =
target=3D"_blank">tonyb at ohionet.org</a><br>OHIONET<br>1500 West Lane =
Ave.<br>Columbus, OH 43221-3975<br>614-486-2966 =
x19</span><o:p></o:p></p></div></div></div></body></html>
------=_NextPart_000_03C8_01CE2BD5.794E8320--
More information about the Open-ils-general
mailing list