Peter M. Groen / knowledgetree

"Optimize database datatypes for space"
Updated. Changed many types from char to varchar and fixed some minor irregularities.

Committed By: Conrad Vermeulen
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8972 c91229c3-7414-0410-bfa2-8a42b809f60b

"Upgrade does not work when upgrading to 3.5.3 with new DB config setup."
Fixed. Added upgrade function to copy config values from config.ini to the database table.

KTS-3405
"Auto group creation option has been removed from the config.ini file"
Fixed. Added the new config option.

Committed by: Megan Watson 
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8928 c91229c3-7414-0410-bfa2-8a42b809f60b

"Improve controls in the System Configuration section"
Fixed. Added radio buttons and dropdown lists, etc.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen




git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8914 c91229c3-7414-0410-bfa2-8a42b809f60b

"Allow indexing to not be dependant on open office"
Fixed.

Committed By: Conrad Vermeulen
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8871 c91229c3-7414-0410-bfa2-8a42b809f60b

"Uno module appears to require editing document conversion scripts"
Fixed. Updated config table to include Open Office programPath.

Committed By: Conrad Vermeulen
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8850 c91229c3-7414-0410-bfa2-8a42b809f60b

"After login you are taken to browse view by default instead of the dashboard"
Fixed. Updated default value.

Committed By: Kevin Fourie
Reviewed By: Conrad Vermeulen 


git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8788 c91229c3-7414-0410-bfa2-8a42b809f60b

"Link to document between folders"
Fixed. Added base code for symbolic links / shortcuts.

Committed by: Aart-Jan Boor
Reviewed by: Megan Watson



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8771 c91229c3-7414-0410-bfa2-8a42b809f60b

"On user login, some users would prefer to be redirected to the browse view, and not to the dashboard"
Fixed. Added Config settings to DB.

Committed By: Jonathan Byrne
Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8767 c91229c3-7414-0410-bfa2-8a42b809f60b

"Failed Upgrade 3.4.6 to 3.5.2 Stable (database problem)"
Fixed. text and blobs cannot have default values.

Committed By: Conrad Vermeulen
Reviewed By: Megan Waston

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8707 c91229c3-7414-0410-bfa2-8a42b809f60b

"Remove reliance on zseq_tables"
Fixed. Now can now deal with the auto inc on the tables. dbutil is bypassing peardb for the id, but will be rectified in 3.6.

Committed By: Conrad Vermeulen
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8704 c91229c3-7414-0410-bfa2-8a42b809f60b

"Background task can test Document Indexer diagnostics and cache results"
Fixed

Committed By: Conrad Vermeulen
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8669 c91229c3-7414-0410-bfa2-8a42b809f60b

"Indexing needs to be more resiliant when encountering errors with open office"
Fixed. Missing mime types added - msg, pps, db. Corrected ai, eps, msi

Committed By: Conrad Vermeulen
Reviewed By: Philip Arkoll

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8653 c91229c3-7414-0410-bfa2-8a42b809f60b

"Document Preview / Info Box - replace YUI control with an ExtJS control"
In progress. Changed the default setting to use an onclick instead of a mouse-over on the icon.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8640 c91229c3-7414-0410-bfa2-8a42b809f60b

"Background task should fetch latest version for Version Notifier and cache ."
Implemented.

Committed By: Conrad Vermeulen
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8603 c91229c3-7414-0410-bfa2-8a42b809f60b

"Disk Usage stats should be a background task and cached"
Implemented.

KTS-3432
"Storage Usage status should be retrieved in a background task and cached"
Implemented.

Committed By: Conrad Vermeulen
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8602 c91229c3-7414-0410-bfa2-8a42b809f60b

"The Config file data needs to be moved to the database and an admin page needs to be made to manage this data."
Fixed. Made changes to run config from DB.

KTS-3309
"Dmsdefaults has a lot of config functions in it, they need to be moved to the KTConfig class."
Fixed. Functions have been separated into the right classes.

KTS-3272
"Migration of configuration to database"
Fixed. Completed KTS-3276 and KTS-3278 associated with this issue.

Committed By: Jonathan Byrne
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8560 c91229c3-7414-0410-bfa2-8a42b809f60b

"When installing stack as root, OpenOffice stores files as root in the KT temp folder. The indexing scripts cannot clean these up."
Fixed.

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie


git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8448 c91229c3-7414-0410-bfa2-8a42b809f60b

"On the new search results page a number of our documents incorrectly state that the document is "Checked out by: Deleted User on"."
Fixed. The sql removes any incorrect references to the deleted user id of -10.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8379 c91229c3-7414-0410-bfa2-8a42b809f60b

"Add MD5 hash to assist with validation of repository storage"
Fixed.

Committed By: Conrad Vermeulen
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8366 c91229c3-7414-0410-bfa2-8a42b809f60b

"Allow the user to change the ordering of the fields in a fieldset"
Fixed. Added columns and logic for ordering the fields

Committed by: Megan Watson
Reviewed by: Jonathan Byrne



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8335 c91229c3-7414-0410-bfa2-8a42b809f60b

"Remove background task permissions problems by making web server user deal with background tasks"
Fixed.

Committed By: Conrad Vermeulen
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8261 c91229c3-7414-0410-bfa2-8a42b809f60b

"The Title of the RSS feed seems to be limited to 20 characters and names longer than that is cut-short."

Fixed. Changed RSS Title length to 100.

Committed By: Jonathan Byrne
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8200 c91229c3-7414-0410-bfa2-8a42b809f60b

"Create a script to check if Open Office is running (SUP-614)"
Fixed. Added the script to the scheduled tasks.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@8136 c91229c3-7414-0410-bfa2-8a42b809f60b

"Support for Office 2007 Documents"
Implemented.

Committed By: Conrad Vermeulen
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7992 c91229c3-7414-0410-bfa2-8a42b809f60b

"3.5.2 beta 2 upgrade error"
Updated. Fixed plugin_helper clean sql. Fixed root path in config.ini. 

Committed By: Kevin Fourie
Reviewed By: Jonathan Byrne

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7966 c91229c3-7414-0410-bfa2-8a42b809f60b

"3.5.2 beta 2 upgrade error"
Fixed. Updated paths in config.ini. Added plugins_helper cleanout during upgrade. Added CustomError section to config.ini.

Committed By: Kevin Fourie
Reviewed By: Jonathan Byrne

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7959 c91229c3-7414-0410-bfa2-8a42b809f60b

"Create indexer administration page"
Updated. Added a status column to the index_files table so that reporting can be done more easily.

Committed By: Conrad Vermeulen
Reviewed By: Jonathan Burne

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7939 c91229c3-7414-0410-bfa2-8a42b809f60b

"CLONE -Backslashes appear before every quote and double quote throughout our version of knowledgetree(SUP-532)"
Updated. Removed C-style comment block from upgrade SQL.

Committed by: Kevin Fourie
Reviewed by: Conrad Vermeulen


git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7922 c91229c3-7414-0410-bfa2-8a42b809f60b

"CLONE -End line characters in discussions and disclaimers being displayed as html tags (SUP-546)"
Fixed. Removed the calls to sanitiseForSQL before inserting into the database.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7909 c91229c3-7414-0410-bfa2-8a42b809f60b

"Number of characters allowed in a field is not 250 as is mostly specified"

Fixed. Changed version, filename and comment fields variable types.

Committed By: Jonathan Byrne
Reviewed By: Jalaloedien Abrahams

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7905 c91229c3-7414-0410-bfa2-8a42b809f60b

"CLONE -Backslashes appear before every quote and double quote throughout our version of knowledgetree(SUP-532)"
Fixed. Added an upgrade script to remove the backslashes.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7898 c91229c3-7414-0410-bfa2-8a42b809f60b

"Add integration/oem no so that integrators may associate a custom document reference"
Implemented.

Committed By: Conrad Vermeulen
Reviewed By: Megan Watson

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7874 c91229c3-7414-0410-bfa2-8a42b809f60b

"Top Download Dashlet takes a long time to load"
Fixed.

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7850 c91229c3-7414-0410-bfa2-8a42b809f60b

"Allow/enable multiple documents to be selected when attempting to link documents"
Fixed. Changed the collection to use the advanced selection. Removed the collection widget and added breadcrumbs. The collection widget wasn't using the mochikit correctly.

KEP-121
"Links to or from external world"
Fixed. Added a link to the Links action to add an external url as a link.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7848 c91229c3-7414-0410-bfa2-8a42b809f60b

"Add the plugin ordering variable to the plugins table"
Fixed. Added a column to the plugins table to set the ordering. Added a check on disabled when loading the plugins.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7819 c91229c3-7414-0410-bfa2-8a42b809f60b

"csv mime type does not have an icon"
Updated.

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7810 c91229c3-7414-0410-bfa2-8a42b809f60b

"CLONE -Performance has become tragically slow (SUP-443)"
Updated. Added the @ sign in front of id when inserting.

Committed by: Martin Kirsten
Reviewed by: Megan Watson



git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7794 c91229c3-7414-0410-bfa2-8a42b809f60b

"CLONE -Performance has become tragically slow (SUP-443)"
Fixed. Added the DB optimise script to the scheduler. Modified the script to log messages instead of printing them. Added a check on the id to the scheduler tasks in the upgrade script.

Committed by: Megan Watson
Reviewed by: Conrad Vermeulen




git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7779 c91229c3-7414-0410-bfa2-8a42b809f60b

"Refactor plugins registration and loading"
Updated. Added the upgrade sql.

Committed by: Kevin Fourie
Reviewed by: Conrad Vermeulen


git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7770 c91229c3-7414-0410-bfa2-8a42b809f60b

"Number of characters allowed in a field is not 250 as is mostly specified"
Updated. Changed filename and comment to be mediumtext compatible with other fields in other tables.

Committed By: Conrad Vermeulen
Reviewed By: Kevin Fourie

git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@7757 c91229c3-7414-0410-bfa2-8a42b809f60b