Re-import of TmpV2 data from Julie's Export 2014-09-08

From CCMDB Wiki
Revision as of 17:32, 2014 September 4 by Ttenbergen (talk | contribs) (Created page with "Original import of TmpV2 went wrong. Julie provided a new export 2014-09-04. Files are in X:\CCMDB\TmpV2_final === steps === # copied backup of centralized_data.mdb to file...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Original import of TmpV2 went wrong. Julie provided a new export 2014-09-04.

Files are in X:\CCMDB\TmpV2_final

steps

  1. copied backup of centralized_data.mdb to files as centralized_data_pre_tmpv2_import.mdb
  2. copied centralized_data.mdb to desktop
  3. ran
    • SELECT L_TmpV2.D_ID FROM L_Log INNER JOIN L_TmpV2 ON L_Log.D_ID = L_TmpV2.D_ID WHERE (((L_Log.RecordStatus)<>"incomplete"));
    • deleted the 120274 records in that query
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Re-import_of_TmpV2_data_from_Julie%27s_Export_2014-09-08&oldid=40309"