queXF 1.13.0 - Changes since queXF 1.12.2
*New feature: Automatically update queXS Limesurvey database with queXF form when verified (allow for a single dataset of data collected via paper, the web and CATI)
*Fixed Bug: Scale and rotation did not correctly handle case where the scale was exactly 0 and rotation exactly 0
*Fixed bug: CSV output from text/numeric (not long text) elements were ignoring internal spacing
*Fixed bug: full text elements were not being removed when reverifying a form
*Fixed bug: Fixed width output updated to handle where code width is greater than the string length of the number of categories
*Fixed bug: PSPP output updated to fix where variables start with a number (append a V) and to handle where category variables are strings instead of numeric
Database changes:
ALTER TABLE `questionnaires` ADD `rpc_server_url` TEXT NULL COMMENT 'XML RPC server to send verified data to';
ALTER TABLE `questionnaires` ADD `rpc_username` TEXT NULL , ADD `rpc_password` TEXT NULL ;
ALTER TABLE `questionnaires` ADD `limesurvey_sid` INT( 11 ) NULL ;
ALTER TABLE `forms` ADD `rpc_id` INT NULL ;
DROP TABLE `differences` ;
queXF 1.12.2 - Changes since queXF 1.12.1
*Fixed Bug: Don't list box groups that have no boxes attached to them when verifying as it breaks it
*Fixed Bug: Removed <p> tag from messages as making log look too big
*Fixed Bug: divide by zero warning caused when formpages doesn't have a width set
*Fixed Bug: verification of text fields with apostrophe would not insert in to database
queXF 1.12.1 - Changes since queXF 1.12.0
*Fixed Bug: Global $n8 causing ICR thinzs_np function to fail when guessing characters
queXF 1.12.0 - Changes since queXF 1.11.3
*New feature: Enabled ICR (Intelligent Character Recognition) and added training features (config directive: ICR_ENABLED)
*New feature: Allow the import and export of ICR Knowledge Bases (KB) for sharing
*New feature: Process log is done on line by line datestamped basis instead of text update
*New feature: Added output of corner edge detection area elements to queXF banding XML
*Deprecated: Removed old OCR stuff with Tesseract
Database changes:
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;
queXF 1.11.3 - Changes since queXF 1.11.2
*Fixed Bug: testconfig failing where options are given to GS
*Fixed Bug: duplicate barcode data output if not first element
queXF 1.11.2 - Changes since queXF 1.11.1
*Fixed Bug: CSV output where barcode/longtext not outputting if first element in data
*Fixed Bug: testconfig script did not appear in index and failed as not referencing lang.inc.php
*New feature: testconfig now default default page and tests for directory based authentication and common settings
queXF 1.11.1 - Changes since queXF 1.11.0
*Fixed Bug: Verification boxes appear in wrong spot when original page form size differs to scan
queXF 1.11.0 - Changes since queXF 1.10.2
*Fixed Bug: Cannot verify when barcode selected on page
*Fixed Bug: Barcode tolerance is set to as close as possible
*Added new feature: Page setup now on a form by form basis - only requirement
is that the area of a page where a barcode belongs is specified
(see BARCODE_TLX_PORTION, BARCODE_TLY_PORTION..etc), and that the
barcode length (see BARCODE_LENGTH_PID) is specified.
Once queXF detects the barcode it uses the stored page location details to
determine the page edges.
Page setup is now part of the form importation process.
Here are the changes required to the database from the previous version:
ALTER TABLE `formpages` ADD `width` INT( 11 ) NOT NULL DEFAULT '0',
ADD `height` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `pages` ADD `width` INT( 11 ) NOT NULL DEFAULT '2480',
ADD `height` INT( 11 ) NOT NULL DEFAULT '3508',
ADD `TL_VERT_TLX` INT( 11 ) NOT NULL DEFAULT '54',
ADD `TL_VERT_TLY` INT( 11 ) NOT NULL DEFAULT '90',
ADD `TL_VERT_BRX` INT( 11 ) NOT NULL DEFAULT '390',
ADD `TL_VERT_BRY` INT( 11 ) NOT NULL DEFAULT '603',
ADD `TL_HORI_TLX` INT( 11 ) NOT NULL DEFAULT '54',
ADD `TL_HORI_TLY` INT( 11 ) NOT NULL DEFAULT '60',
ADD `TL_HORI_BRX` INT( 11 ) NOT NULL DEFAULT '669',
ADD `TL_HORI_BRY` INT( 11 ) NOT NULL DEFAULT '384',
ADD `TR_VERT_TLX` INT( 11 ) NOT NULL DEFAULT '2010',
ADD `TR_VERT_TLY` INT( 11 ) NOT NULL DEFAULT '81',
ADD `TR_VERT_BRX` INT( 11 ) NOT NULL DEFAULT '2433',
ADD `TR_VERT_BRY` INT( 11 ) NOT NULL DEFAULT '639',
ADD `TR_HORI_TLX` INT( 11 ) NOT NULL DEFAULT '1770',
ADD `TR_HORI_TLY` INT( 11 ) NOT NULL DEFAULT '66',
ADD `TR_HORI_BRX` INT( 11 ) NOT NULL DEFAULT '2433',
ADD `TR_HORI_BRY` INT( 11 ) NOT NULL DEFAULT '387',
ADD `BL_VERT_TLX` INT( 11 ) NOT NULL DEFAULT '54',
ADD `BL_VERT_TLY` INT( 11 ) NOT NULL DEFAULT '2922',
ADD `BL_VERT_BRX` INT( 11 ) NOT NULL DEFAULT '432',
ADD `BL_VERT_BRY` INT( 11 ) NOT NULL DEFAULT '3402',
ADD `BL_HORI_TLX` INT( 11 ) NOT NULL DEFAULT '54',
ADD `BL_HORI_TLY` INT( 11 ) NOT NULL DEFAULT '3105',
ADD `BL_HORI_BRX` INT( 11 ) NOT NULL DEFAULT '672',
ADD `BL_HORI_BRY` INT( 11 ) NOT NULL DEFAULT '3405',
ADD `BR_VERT_TLX` INT( 11 ) NOT NULL DEFAULT '2028',
ADD `BR_VERT_TLY` INT( 11 ) NOT NULL DEFAULT '2901',
ADD `BR_VERT_BRX` INT( 11 ) NOT NULL DEFAULT '2433',
ADD `BR_VERT_BRY` INT( 11 ) NOT NULL DEFAULT '3381',
ADD `BR_HORI_TLX` INT( 11 ) NOT NULL DEFAULT '1752',
ADD `BR_HORI_TLY` INT( 11 ) NOT NULL DEFAULT '3084',
ADD `BR_HORI_BRX` INT( 11 ) NOT NULL DEFAULT '2433',
ADD `BR_HORI_BRY` INT( 11 ) NOT NULL DEFAULT '3384',
ADD `VERT_WIDTH` INT( 11 ) NOT NULL DEFAULT '6',
ADD `HORI_WIDTH` INT( 11 ) NOT NULL DEFAULT '6';
queXF 1.10.2 - changes since 1.10.1
*Updated translations from Launchpad. Thank you for your translations!
*Fixed Bug: MISSING_PAGE_ASSIGN directive was being ignored
*Fixed Bug: Storing large sessions in the database caused performance issues so disabled
*Fixed bug: Remove unnecessary reference to boxgroups
*Fixed bug: Set default width for longtext to 1024
*Compatibility fix: Removed javascript links from admin index
*Updated to php-gettext 1.0.11
*Page setup feature: Added drawing of detected cornerlines in blue and barcode number in barcode box for validation
queXF 1.10.1 - Changes since 1.10.0
Fixed bug: Error when creating new questionnaire without banding XML
queXF 1.10.0 - Changes since 1.9.1:
queXF 1.10.0 and the simultaneous release of queXML 1.3.0 streamlines the paper questionnaire creation process by being able to produce a fully banded questionnaire from queXML. Once the PDF and associated banding XML file is imported to queXF, it is possible to begin scanning completed forms immediately, and export data with full question and value labelling from the original queXML file.
In addition, queXF 1.10.0 allows for the export of unverified data. This may be useful when your settings allow for very accurate OMR and also to view preliminary results before operator verification is complete.
In the backend - queXF 1.10.0 removes the need for using database views and some redundant tables.
Summary of SVN Log:
*Updated translation file and translations from Launchpad
*Added ability to download data that is not verified (just imported and OMR/OCR'ed)
*Updated database schema - removed use of views
*Added new test documents including banding XML document
*Updated default settings to allow for wider selections on A4 pages by default
*Updated default box colour to blue which assisted with colour blindness
*Added ability to import banding XML while importing a PDF file
*Removed references to boxgroups table which was redundant
*Data output now includes labels and sections/etc if banding XML is used
*BUG fix: Gave default value of 0 for 'sheets' column in questionnaires table
*BUG fix: Will not create a new questionnaire if cannot detect all page edges
*BUG fix: Will not apply transforms if not all edges detected
*BUG fix: Made sure boxes are processed in sortorder (javascript edit)
