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

Last import included incompletes, leading to duplicates when those were sent. Re-doing without incompletes.

File location

The files for this process are stored in x:\CCMDB\z_archive\2014-09-25_Tmp_reimport

Steps

1. Update queries to exclude incompletes
2. Follow Re-import of TmpV2 data from Julie's Export 2014-09-18

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:

1. open #File location\tmp_to_centralized_importer.mdb
2. open table 2014-09-25_orphans
3. correct the D_ID for the relevant records
4. cut-and-paste the records into an up-to-date copy of centralized_data.mdb