Bug 4392 - bulkmarcimport.pl leaves items.onloan set to '0000-00-00' instead of NULL
Summary: bulkmarcimport.pl leaves items.onloan set to '0000-00-00' instead of NULL
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: MARC Bibliographic data support (show other bugs)
Version: rel_3_0
Hardware: PC All
: P4 major (vote)
Assignee: Galen Charlton
QA Contact: Bugs List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-20 09:50 UTC by Chris Cormack
Modified: 2020-11-30 21:45 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Cormack 2010-05-21 01:26:38 UTC


---- Reported by chobbs@nhusd.k12.ca.us 2010-04-20 21:50:43 ----

On importing MARC records via bulkmarcimport.pl, I found that the items.onloan field is set to '0000-00-00' rather than null for unchecked out items. The workaround for now is to manually execute:

update items set onloan = NULL  WHERE onloan = '0000-00-00'

after the import is complete.



--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 01:26 UTC  ---

This bug was previously known as _bug_ 4392 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4392

Actual time not defined. Setting to 0.0
The original reporter of this bug does not have
   an account here. Reassigning to the person who moved
   it here: chris@bigballofwax.co.nz.
   Previous reporter was chobbs@nhusd.k12.ca.us.
Setting qa contact to the default for this product.
   This bug either had no qa contact or an invalid one.

Comment 1 Jonathan Druart 2015-03-24 15:02:06 UTC
Martin, do you know if this is still an issue?
Comment 2 Jonathan Druart 2019-11-28 11:20:25 UTC
Do not recreate.