queXF 1.12.0 Released

queXF 1.12.0 has been released today on Sourceforge

ICR (Intelligent Character Recognition) is now implemented natively in queXF. OCR using Tesseract has been deprecated. It is possible to export and import the ICR knowledge bases - hopefully we will be able to share these among queXF users.

Also logging is now done on a line by line, date-stamped basis and corner edge detection area elements are exported when exporting a queXF banding XML file.

The ICR feature brings with it the need to update the database. Read on for the required database updates and for how to upgrade.

Upgrading from 1.11.2 or 1.11.3:

1. Backup config.inc.php (copy to config.inc.php.bak)
2. Extract the new package over your existing installation of queXF 1.11.2 or 1.11.3
3. Update the database by running the following SQL (please note the first two ALTER TABLE commands may take a while depending on the size of your database):


ALTER TABLE `formboxverifychar` CHANGE `val` `val` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;
ALTER TABLE `formboxverifychar` ADD INDEX ( `val` );
ALTER TABLE `ocrtrain` ADD `kb` INT( 11 ) NOT NULL DEFAULT '1' AFTER `ocrtid` ;
ALTER TABLE `process` ADD `type` INT( 11 ) NOT NULL DEFAULT '1' AFTER `process_id`;

CREATE TABLE IF NOT EXISTS `ocrkbboxgroup` (
`btid` int(11) NOT NULL,
`kb` int(11) NOT NULL,
`qid` int(11) NOT NULL,
PRIMARY KEY (`btid`,`kb`,`qid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `ocrprocess` (
`ocrprocessid` int(11) NOT NULL auto_increment,
`fid` int(11) NOT NULL,
`bid` int(11) NOT NULL,
`vid` int(11) NOT NULL,
`val` char(1) character set utf8 collate utf8_bin NOT NULL,
`kb` int(11) NOT NULL,
PRIMARY KEY (`ocrprocessid`),
KEY `kb` (`kb`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `process_log` (
`process_log_id` bigint(20) NOT NULL auto_increment,
`process_id` bigint(20) NOT NULL,
`datetime` datetime NOT NULL,
`data` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`process_log_id`),
KEY `process_id` (`process_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

4. Copy your config.inc.php.bak file over the extracted config file.