[Koha-bugs] [Bug 6113] enhancement to keep previous ids

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6113

Zeno Tajoli <tajoli at cilea.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |tajoli at cilea.it

--- Comment #9 from Zeno Tajoli <tajoli at cilea.it> 2011-04-16 11:13:21 UTC ---
(In reply to comment #7)

>What if the old system's internal number
>is alphanumeric, has leading zeros in the number, is too long ... ?

well this enhancement is to use in migration, not during production.
The idea is to create a perfect sync between old ILS ids and the values in:
biblio.biblionumber, 
biblioitems.biblionumber, 
biblioitems.biblioitemnumber,
items.biblionumber, 
items.biblioitemnumber
and also the marc fields connenct with them (in marc21 standard KohaToMarc
links
999$c and 999$d, for unimarc 001 and 090$a)

so
Q:What if the old system's internal number is alphanumeric ?
A:This enhancement will not work. It works only with  numbers.
The sql defintion of biblio.biblionumber is:
`biblionumber` int(11) NOT NULL auto_increment,

Q:..has leading zeros in the number ?
A: You need to delete leanding zeros before use bulkmarcimport.pl

Q: .. is too long ?
The max value in field biblio.biblionumber is 4294967295, if your numbers is
bigger, bulkmarcimport.pl will no works.
But we can plan to change biblio.biblionumber sql definition.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.