Centralized import from Ed.mdb: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 45: | Line 45: | ||
** added field "active" , imported locations that are in orig_* records but no longer active. Ttenbergen 21:46, 2014 January 19 (CST) | ** added field "active" , imported locations that are in orig_* records but no longer active. Ttenbergen 21:46, 2014 January 19 (CST) | ||
** created column "old_code" to accomodate 3-letter code "oth", which imports as "ot" due to field length restrictions. Ttenbergen 21:46, 2014 January 19 (CST) | ** created column "old_code" to accomodate 3-letter code "oth", which imports as "ot" due to field length restrictions. Ttenbergen 21:46, 2014 January 19 (CST) | ||
* added queries ''1_check_no_tasks'' and ''1_check_tasks_orphans | * added queries ''1_check_no_tasks'' and ''1_check_tasks_orphans'' and ''1_check_task_dupes'' for pre-task import checks Ttenbergen 00:42, 2014 January 31 (CST) | ||
* added queries ''tasks_to_dx'', 'tasks_to_dx_u'', ''tasks_resolver'' and ''TASKS_d_id'' to process and import tasks Ttenbergen 00:42, 2014 January 31 (CST) | * added queries ''tasks_to_dx'', 'tasks_to_dx_u'', ''tasks_resolver'' and ''TASKS_d_id'' to process and import tasks Ttenbergen 00:42, 2014 January 31 (CST) | ||