Reconnect CFE and initial error checks: Difference between revisions

Revision as of 09:25, 7 February 2019

Once you "Pull" Centralized data.mdb you need to initialise the program and make sure that you have consistent initial data.

	remove msgbox, this is now copied by script so should be right.

The program will now resetthe connections from CFE to Centralized data.mdb, PHI.mdb and TISS28 Data.mdb
the reconnector will confirm if L_Log table and L_PHI table have the same records in them. If they don't there will be an error; see Procedure when there are differences between L Log and L PHI for how to proceed
Run initial cross checks:
- PL_1orphans- see Orphans in Centralized data.mdb for what to do about these.
- PL missing L Tables content

	need to say what we do...

	re-name these so not PL any more

Continue what you were doing, likely the next step of Centralized data Vetting Process: Pre-linking checks

@@ Line 4: / Line 4: @@
 * Click the "Re-connect Data" button
 * Screen prompt 'do you have recent TISS', answer '''YES'''
+{{DT | remove msgbox, this is now copied by script so should be right. }}
 * The program will now resetthe connections from [[CFE]] to [[Centralized data.mdb]], [[PHI.mdb]] and [[TISS28 Data.mdb]]
 * the reconnector will confirm if [[L_Log table]] and [[L_PHI table]] have the same records in them. If they don't there will be an error; see [[Procedure when there are differences between L Log and L PHI]] for how to proceed