[Evergreen-acq] Sending only ISBN13 in EDI

Tue Mar 28 11:14:02 EDT 2023

Hi Tiffany,

I did some testing on this for the UPC and found the following.

- Adding a line item to a purchase order manually:  The identifier of UPC
was selected properly in the preview screen after clicking View/Place
Orders.  Once added to the purchase order, however, the identifier in the
line item switched to ISBN and the value in the box was blank.  The bib
record I tested with, after adding a UPC to it, was ID 13.

- Creating a PO from a file uploaded through the Load MARC Order Records
interface:  This is PO 10 on your test system. The file I uploaded had 1
record with a 13 digit ISBN, one record with both a 13 digit and a 10 digit
ISBN with the 10 digit listed first in the bib, and a record with a UPC.
The 13 digit ISBNs were correctly selected in the two line items that were
created. For the record with the UPC identifier the ISBN was selected and
the box for the value just had the "Order Identifier..." text.  I uploaded
this same file on a 3.9 test system and the UPC was correctly selected for
that line item.
The last line item in PO 10 (Double concerto in A minor, op. 102) was
manually added to the PO and shows that the UPC was not retained.

I am attaching the MARC file that I tested with in case anyone else wants
to give it a try.  I was logged in as BR1 and used the Ingram provider.
All 3 records had a 970 field of "=970  \\$lDisplay$fJUV$oBR1$q1$p14.98."

I'll add a comment to the bug.

I hope this is helpful,
Christine

On Mon, Mar 27, 2023 at 3:52 PM Tiffany Little via Evergreen-acq <
evergreen-acq at list.evergreen-ils.org> wrote:

> I threw together a patch that *seems* like it does it? I haven't tested
> extensively though--I just did one or two tests to see if it preferred the
> ISBN13 when both were present, and if it chose the ISBN10 if that was all
> that was available. It needs some more run-throughs and also testing to
> make sure other identifiers (like UPC) aren't negatively affected.
>
> It's loaded up on my test server now, if anyone has the time to take a
> look and put it through its paces.
>
> https://tiffany-master.gapines.org/eg/staff
>
> Thanks!
> Tiffany
>
> Tiffany Little, PINES Services Specialist: Acquisitions
>
> ------------------------------
>
> Georgia Public Library Service | University System of Georgia
>
> 2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341
>
> (404) 235-7161 | tlittle at georgialibraries.org
>
> Join our email list <http://georgialibraries.org/> for stories of Georgia
> libraries making an impact in our communities.
>
>
> On Mon, Mar 27, 2023 at 3:12 PM Tiffany Little <
> tlittle at georgialibraries.org> wrote:
>
>> Well drat. Found an existing bug:
>> https://bugs.launchpad.net/evergreen/+bug/1618199
>>
>> I was hoping there was somewhere in the EDI writer to make it choose
>> ISBN-13. :(
>>
>> Tiffany Little, PINES Services Specialist: Acquisitions
>>
>> ------------------------------
>>
>> Georgia Public Library Service | University System of Georgia
>>
>> 2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341
>>
>> (404) 235-7161 | tlittle at georgialibraries.org
>>
>> Join our email list <http://georgialibraries.org/> for stories of
>> Georgia libraries making an impact in our communities.
>>
>>
>> On Mon, Mar 27, 2023 at 2:20 PM Jennifer Pringle via Evergreen-acq <
>> evergreen-acq at list.evergreen-ils.org> wrote:
>>
>>> Hi Tiffany,
>>>
>>>
>>>
>>> The only way I can currently think to do this is by making sure the 13
>>> digit ISBN is the one selected as the order identifier on the line item
>>> (which I think you have to do manually).
>>>
>>>
>>>
>>> Sounds like we need a wishlist bug to prefer 13 digit ISBNs in the order
>>> identifier.
>>>
>>>
>>>
>>> Jennifer
>>>
>>>
>>>
>>> --
>>>
>>> Jennifer Pringle (she/her)
>>>
>>> Co-op Support - Training Lead
>>>
>>> BC Libraries Cooperative
>>>
>>> Toll-free: 1-888-848-9250
>>>
>>> Email:jennifer.pringle at bc.libraries.coop
>>>
>>> Website: http://bc.libraries.coop
>>>
>>>
>>>
>>> Gratefully acknowledging that I live and work in the unceded Traditional
>>> Territory of the St'at'yemc Nations.
>>>
>>>
>>>
>>> *From:* Evergreen-acq <evergreen-acq-bounces at list.evergreen-ils.org> *On
>>> Behalf Of *Tiffany Little via Evergreen-acq
>>> *Sent:* Monday, March 27, 2023 11:13 AM
>>> *To:* Evergreen ACQ Listserv <evergreen-acq at list.evergreen-ils.org>
>>> *Cc:* Tiffany Little <tlittle at georgialibraries.org>
>>> *Subject:* [Evergreen-acq] Sending only ISBN13 in EDI
>>>
>>>
>>>
>>> Good afternoon all,
>>>
>>>
>>>
>>> This is completely escaping me at the moment. One of our vendors is
>>> specifying that they can only receive ISBN13 values and not ISBN10. If a
>>> record for a lineitem has 2 ISBN values, the first one is the one that's
>>> encoded to send in EDI, and that's often the ISBN-10 that comes first.
>>>
>>>
>>>
>>> How can I specify that ISBN-13's should be sent when available? We're
>>> using EDI Attributes. Also, to introduce a restriction--I don't want to
>>> have to manually set the identifier for each line item.
>>>
>>>
>>>
>>> I feel like I'm missing something obvious.
>>>
>>>
>>>
>>> Tiffany
>>>
>>>
>>>
>>> *Tiffany Little, PINES Services Specialist: Acquisitions*
>>> ------------------------------
>>>
>>> *Georgia Public Library Service | University System of Georgia*
>>>
>>> 2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341
>>>
>>> (404) 235-7161 | tlittle at georgialibraries.org
>>>
>>>
>>>
>>> *Join our email list* <http://georgialibraries.org/> *for stories of
>>> Georgia libraries making an impact in our communities.*
>>>
>>> This message originated from outside the M365 organisation. Please be
>>> careful with links, and don't trust messages you don't recognise.
>>> _______________________________________________
>>> Evergreen-acq mailing list
>>> Evergreen-acq at list.evergreen-ils.org
>>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-acq
>>>
>> _______________________________________________
> Evergreen-acq mailing list
> Evergreen-acq at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-acq
>

-- 
Christine Morgan
Database Support Analyst
North of Boston Library Exchange, Inc.
Danvers, Massachusetts
cmorgan at noblenet.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-acq/attachments/20230328/317e265b/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: isbn_upc.mrc
Type: application/marc
Size: 963 bytes
Desc: not available
URL: <http://list.evergreen-ils.org/pipermail/evergreen-acq/attachments/20230328/317e265b/attachment-0001.bin>