load-tickets /

Y N 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 - 2010/12/17 19:43:20.254 redmine FROM 127.0.0.1 MYSQL Native redmine_dev 3306 redmine Encrypted 2be98afc86aa7f2e4cb0bab74d39ba1df EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER3306 QUOTE_ALL_FIELDSN STREAM_RESULTSY SUPPORTS_BOOLEAN_DATA_TYPEN USE_POOLINGN redmine MIGRATE 127.0.0.1 MYSQL Native redmine_migrate 3306 redmine Encrypted 2be98afc86aa7f2e4cb0bab74d39ba1df EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER3306 QUOTE_ALL_FIELDSN STREAM_RESULTSY SUPPORTS_BOOLEAN_DATA_TYPEN USE_POOLINGN redmine TO 127.0.0.1 MYSQL Native redmine_sup 3306 redmine Encrypted 2be98afc86aa7f2e4cb0bab74d39ba1df EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER3306 QUOTE_ALL_FIELDSN STREAM_RESULTSY SUPPORTS_BOOLEAN_DATA_TYPEN USE_POOLINGN input ticketsauthor lookupY author lookupassignee lookupY assignee lookupticket outputY ticket outputfrom_to table outputY from_to table outputExecute SQL scriptY Execute SQL script ExecSQL Y 1 none redmine TO Y Y update issues set root_id = id where id = ? id_to

422 586 Y assignee lookup DBLookup Y 1 none redmine MIGRATE N N 0 user_from_to N N assigned_to_id_from id_from = id_to assigned_to_id 5 Integer

422 318 Y author lookup DBLookup Y 1 none redmine MIGRATE N N 0 user_from_to N N author_id_from id_from = id_to author_id 5 Integer

419 224 Y from_to table output TableOutput Y 1 none redmine MIGRATE issue_from_to 1000 Y N Y Y N N Y N Y N id_from id_from id_to id_to

423 489 Y input tickets TableInput Y 1 none redmine FROM SELECT id as id_from , case tracker_id when 1 then 3 else 1 end as tracker_id , 4 as project_id , subject , description , due_date , null as category_id , case status_id when 8 then 7 else status_id end as status_id , assigned_to_id as assigned_to_id_from , priority_id , null as fixed_version_id , author_id as author_id_from , lock_version , created_on , updated_on , start_date , done_ratio , estimated_hours , parent_id , null as root_id , lft , rgt FROM issues where project_id = 3 0 N N N

417 127 Y ticket output TableOutput Y 1 none redmine TO issues 1000 N N N Y N N Y N Y Y id_to tracker_id tracker_id project_id project_id subject subject description description due_date due_date category_id category_id status_id status_id priority_id priority_id fixed_version_id fixed_version_id lock_version lock_version created_on created_on updated_on updated_on start_date start_date done_ratio done_ratio estimated_hours estimated_hours parent_id parent_id root_id root_id lft lft rgt rgt author_id author_id assigned_to_id assigned_to_id

423 408 Y N