* Implement faster person import ** Install bespoke work (http://help.topdesk.com/en/5-2/enterprise/user/settings/manual/uploading-and-activating-bespoke-work-3#/en/5-2/enterprise/user/settings/manual/installing-or-updating-bespoke-work-3/ajax) *** TOPdesk Tool - SQLtransfer for TOPdesk 5.0-5.3 v2.4 2013-11-04.zip (could exist already as part of treewalk) *** fix for import subsetcondition for 5.1 SP1 2013-11-15 16.00.zip *** Connection_and_Import_Updater_TOPdesk5.1.1 v1.3.zip *** Link University of Edinburgh sqltransfer 2013-11-22 16.11.zip *** Link University of Edinburgh script Person Holding tables 2013-11-15 15.05.zip ** Restart TOPdesk ** Add import sqltransfer *** Click button Import from file *** Choose importsettings_sqltransfer.yaml from list *** Click button Import selected Import Definitions *** Place file sqltransfer.properties in directory import\sqltransfer in the TOPdesk root, next to existing sqltransfer.properties *** Enter correct values in sqltransfer.properties (plain text passwords will be hashed) ** Execute import sqltransfer ** Change import person *** Change database type to H2 database *** Change URL to jdbc:h2:../import/source/target;IFEXISTS=true ** Execute import person ** Schedule import sqltransfer 15 min before import persons *** check URL: jdbc:sqltransfer:./import/sqltransfer/sqltransfer.xml