Re-import of TmpV2 data from Julie's Export 2014-09-22
Original import of TmpV2 into the live Centralized_data.mdb went wrong. Julie provided a new export 2014-09-04. That import went wrong as well, so here instructions for new import with 2014-08-18 data. Some more corrections were done on 2014-09-19, so one more import. These are the instructions for the one-time import of her data into the live Centralized_data.mdb.
File location
The files for this process are stored in x:\CCMDB\z_archive\2014-09-22_Tmp_reimport
Steps
Followed Re-import of TmpV2 data from Julie's Export 2014-09-18 Ttenbergen 16:08, 2014 September 22 (CDT)
possible future steps
There are a number of orphans in the .mdb that have become disconnected from their parent record in L_Log, likely due to location changes; this was flagged during analysis and decided to just segregate the records for now and have Pagasa correct later if needed. The records would already be in the correct format to cut-and-paste them into L_TmpV2 once the D_ID gets corrected. If we need to reinstate any of the records that were orphaned:
- open #File location\tmp_to_centralized_importer.mdb
- open table 2014-09-22_orphans
- correct the D_ID for the relevant records
- cut-and-paste the records into an up-to-date copy of centralized_data.mdb