[Koha-bugs] [Bug 6199] Allow bulkmarcimport to blank duplicate barcodes rather than skipping items
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue May 31 01:48:44 CEST 2011
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6199
--- Comment #9 from Robin Sheat <robin at catalyst.net.nz> 2011-05-30 23:48:44 UTC ---
You don't say if you got any errors when you ran it. Also, can you put the
output of:
show create table items;
here. Mine is:
CREATE TABLE `items` (
`itemnumber` int(11) NOT NULL AUTO_INCREMENT,
`biblionumber` int(11) NOT NULL DEFAULT '0',
`biblioitemnumber` int(11) NOT NULL DEFAULT '0',
`barcode` varchar(20) DEFAULT NULL,
`dateaccessioned` date DEFAULT NULL,
`booksellerid` mediumtext,
`homebranch` varchar(10) DEFAULT NULL,
`price` decimal(8,2) DEFAULT NULL,
`replacementprice` decimal(8,2) DEFAULT NULL,
`replacementpricedate` date DEFAULT NULL,
`datelastborrowed` date DEFAULT NULL,
`datelastseen` date DEFAULT NULL,
`stack` tinyint(1) DEFAULT NULL,
`notforloan` tinyint(1) NOT NULL DEFAULT '0',
`damaged` tinyint(1) NOT NULL DEFAULT '0',
`itemlost` tinyint(1) NOT NULL DEFAULT '0',
`wthdrawn` tinyint(1) NOT NULL DEFAULT '0',
`itemcallnumber` varchar(255) DEFAULT NULL,
`issues` smallint(6) DEFAULT NULL,
`renewals` smallint(6) DEFAULT NULL,
`reserves` smallint(6) DEFAULT NULL,
`restricted` tinyint(1) DEFAULT NULL,
`itemnotes` mediumtext,
`holdingbranch` varchar(10) DEFAULT NULL,
`paidfor` mediumtext,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
`location` varchar(80) DEFAULT NULL,
`permanent_location` varchar(80) DEFAULT NULL,
`onloan` date DEFAULT NULL,
`cn_source` varchar(10) DEFAULT NULL,
`cn_sort` varchar(30) DEFAULT NULL,
`ccode` varchar(10) DEFAULT NULL,
`materials` varchar(10) DEFAULT NULL,
`uri` varchar(255) DEFAULT NULL,
`itype` varchar(10) DEFAULT NULL,
`more_subfields_xml` longtext,
`enumchron` text,
`copynumber` varchar(32) DEFAULT NULL,
`stocknumber` varchar(32) DEFAULT NULL COMMENT 'stores the inventory number',
PRIMARY KEY (`itemnumber`),
UNIQUE KEY `itembarcodeidx` (`barcode`),
KEY `itembinoidx` (`biblioitemnumber`),
KEY `itembibnoidx` (`biblionumber`),
KEY `homebranch` (`homebranch`),
KEY `holdingbranch` (`holdingbranch`),
KEY `itemstocknumberidx` (`stocknumber`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8
--
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.
More information about the Koha-bugs
mailing list