Reconnect CFE and initial error checks: Difference between revisions

(28 intermediate revisions by 2 users not shown)

Line 1:

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

Once you [["Pull" Centralized_data.accdb]] you need to initialise the program and make sure that you have consistent initial data.

== Instructions ==

* ~~Open 'Centralized data front end.mdb', need password~~

* click the [["Re-connect Data" button]]

* Click the "Re-connect Data" button

* the reconnector will do the following

* ~~Screen prompt '~~do ~~you have recent TISS~~'~~, answer~~ ''~~'YES~~'''

** '''no need to run them manually'''

* ~~The program will now resetthe connections from [[CFE]] to [[Centralized data.mdb]], [[PHI.mdb]] and [[TISS28 Data.mdb]]~~

** 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

* ~~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

** runs the initial [[cross check]]s, but only shows them if errors are found. If there are errors, correct them before proceeding to the next step,

*** [[Reconnect_check_Completes query]] - Generally, errors in missing are the result of a failed send, so follow [[Re-sending data]] to fix

*** [[Reconnect_check_orphans query ]] - see [[Orphans in Centralized_data.accdb]]for what to do about these

*** [[Reconnect_check_missing_L Tables_content query]] - Generally, errors in missing are the result of a failed send, so follow [[Re-sending data]] to fix

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

* If there were no errors, continue what you were doing, likely the next step of [[Centralized data Vetting Process]]: [[Pre-linking checks]]

== Related articles ==

@@ Line 1: / Line 1: @@
-Once you [["Pull" Centralized data.mdb]] you need to initialise the program and make sure that you have consistent initial data.
+Once you [["Pull" Centralized_data.accdb]] you need to initialise the program and make sure that you have consistent initial data.
 == Instructions ==
-* Open 'Centralized data front end.mdb', need password
+* click the [["Re-connect Data" button]]
-* Click the "Re-connect Data" button
+* the reconnector will do the following
-* Screen prompt 'do you have recent TISS', answer '''YES'''
+** '''no need to run them manually'''
-* The program will now resetthe connections from [[CFE]] to [[Centralized data.mdb]], [[PHI.mdb]] and [[TISS28 Data.mdb]]
+** 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
-* 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
+** runs the initial [[cross check]]s, but only shows them if errors are found. If there are errors, correct them before proceeding to the next step,
+*** [[Reconnect_check_Completes query]] - Generally, errors in missing are the result of a failed send, so follow [[Re-sending data]] to fix
+*** [[Reconnect_check_orphans query ]] - see [[Orphans in Centralized_data.accdb]]for what to do about these
+*** [[Reconnect_check_missing_L Tables_content query]] - Generally, errors in missing are the result of a failed send, so follow [[Re-sending data]] to fix
-* Continue what you were doing, likely the next step of [[Centralized data Vetting Process]]:  [[Pre-linking checks]]
+* If there were no errors, continue what you were doing, likely the next step of [[Centralized data Vetting Process]]:  [[Pre-linking checks]]
 == Related articles ==