"Pulling" Centralized data.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
Srusnak (talk | contribs)
CCMDB_legit
110 edits
m →Instructions / Steps to Pull: If L_Log & L_Phi do not match - steps to follow - needs Pagasa's input.
 
(25 intermediate revisions by 4 users not shown)
Line 1: Line 1:
This article describes how the [[Data Processor]] "pulls down" (ie moves to her local c:\ drive) [[Centralized_data.mdb]] and [[PHI.mdb]] for editing. The file gets moved to local because it's faster there and because it prevents collectors from sending in the middle of update actions.  
This article describes the part of [[PHI copy automation]] where the [[Data Processor]] "pulls down" (ie moves to her local c:\ drive) [[Centralized_data.accdb]] and [[PHI.mdb]] for editing. The file gets moved to local because it's faster there and because it prevents collectors from sending in the middle of update actions.  


Data should not be pulled during '''[[designated sending times]]'''.
Data should not be pulled during '''[[designated sending times]]'''.


'''**''' Before going home '''ALWAYS''' make sure you are in the 'push' mode
'''ALWAYS''' make sure you also complete [["Pushing" Centralized_data.accdb]] ''' or [[Data collector]]s will not be able to [[send]] during the next [[designated sending times]].'''


== Instructions / Steps to Pull ==
== Instructions / Steps to Pull ==
* double-click on ''Centralized_CCMDB'' (folder shortcut icon on Pagasa's desktop -star icon)
* double-click on ''Centralized_CCMDB'' (folder shortcut icon on Pagasa's desktop -yellow triangle)
* double click on [[Pull_down_centralized_data.vbs]]
* double click on [[Pull_down_centralized_data.vbs]]
* If you get the error msg "Phi files are locked", then re-boot both computers
* If you get the error msg "Phi files are locked", then re-boot the computer
Screen prompt will say 'attempting to update...', Click OK
Screen prompt will say 'attempting to update...', Click OK
Then 'finished updating...', Click OK
Then 'finished updating...', Click OK
* Prompts ''do you want to ...''
* Prompts ''do you want to ...''
* Answer Yes
* Answer Yes
* Wait for the program to ''pull'' which takes approx. 5 minutes
* Wait for the program to ''pull'' which takes {{Pull process time}}
* Prompts ''finished processing pull script''
* Prompts ''finished processing pull script''
* click OK
* click OK


*The [[Push/Pull log]] will show whether you are in 'push' or 'pull' mode.
*The [[Push/Pull log]] will show whether you are in 'push' or 'pull' mode.
The 'centralized)data.mdb & phi.mdb' get moved to 'C: Centralized_CCMDB'
The [[Centralized_data.accdb]] & [[PHI.mdb]]  get moved to the directory from which [[Pull_down_centralized_data.vbs]] was run.
 
Open 'Centralized data front end.mdb', need password
*Then ReConnect - makes sure LLog & LPhi are matched
* If '''NO''', then (few things to check):
***In Centralized, look at the table on the left and find the 2 queries you need ID which Hospital & ward that May have sent it.
***1_In_L_Phi_but_NOT_in_L_Log
***1_In_L_Log_but_NOT_in_L_PHI
 
*if in L_Log but not in L_PHI:
***check x:/CCMDB/PHI/PHI_CSV.  You want to make sure there is no CSV file sitting in this folder that was not uploaded to PHI.mdb
***this could mean the automated Task of Scanner computer is not working.
 
*If in L_PHI but not in L_Log
*** check x:/CCMDB/PH/PHI_CSV_Archive folder to check if the missing file was in the batch sent from the data collector.
 
*if not sure review with main office. 
*if after checking, file was a test, or error, you can delete it from L_Log and or L_PHI.
 
*Screen prompt 'do you have recent TISS', answer '''YES'''
*Then ready to Open Patient List to do PreLinking http://ccmdb.kuality.ca/index.php?title=Pre-linking_checks


== Background ==
== Background ==
The data processor takes control of the data by [["Pulling" Centralized data.mdb]], and releases it back for [[sending]] or for others to access by [["Pushing" Centralized data.mdb]].
The data processor takes control of the data by [["Pulling" Centralized_data.accdb]]
, and releases it back for [[sending]] or for others to access by [["Pushing" Centralized_data.accdb]].


The current state of pushing/pulling can be seen in the [[Push/Pull log]]
The current state of pushing/pulling can be seen in the [[Push/Pull log]]


At the beginning and end of the day, it should '''ALWAYS''' be in the 'push' mode.
At the beginning and end of the day, it should '''ALWAYS''' be in [["Pushing" Centralized_data.accdb|push]] mode.
 
 


==="Back up"  ===
==="Back up"  ===
When in the ''Pull'' mode, data processor can edit.
*The Centralized and Phi.mdb back up in Pull and Push state.
*The Centralized and Phi.mdb back up in Pull and Push state.
[[User:PTorres|PTorres]] 15:08, 2015 June 11 (CDT)


== Related articles ==
{{Related Articles}}


[[Category:Centralized data push pull]]
[[Category:Centralized data push pull]]
[[Category:Data Processing]]

Latest revision as of 13:51, 6 January 2026

This article describes the part of PHI copy automation where the Data Processor "pulls down" (ie moves to her local c:\ drive) Centralized_data.accdb and PHI.mdb for editing. The file gets moved to local because it's faster there and because it prevents collectors from sending in the middle of update actions.

Data should not be pulled during designated sending times.

ALWAYS make sure you also complete "Pushing" Centralized_data.accdb or Data collectors will not be able to send during the next designated sending times.

Instructions / Steps to Pull

  • double-click on Centralized_CCMDB (folder shortcut icon on Pagasa's desktop -yellow triangle)
  • double click on Pull_down_centralized_data.vbs
  • If you get the error msg "Phi files are locked", then re-boot the computer

Screen prompt will say 'attempting to update...', Click OK Then 'finished updating...', Click OK

  • Prompts do you want to ...
  • Answer Yes
  • Wait for the program to pull which takes about 5 minutes (see here)
  • Prompts finished processing pull script
  • click OK
  • The Push/Pull log will show whether you are in 'push' or 'pull' mode.

The Centralized_data.accdb & PHI.mdb get moved to the directory from which Pull_down_centralized_data.vbs was run.

Background

The data processor takes control of the data by "Pulling" Centralized_data.accdb , and releases it back for sending or for others to access by "Pushing" Centralized_data.accdb.

The current state of pushing/pulling can be seen in the Push/Pull log

At the beginning and end of the day, it should ALWAYS be in push mode.

"Back up"

  • The Centralized and Phi.mdb back up in Pull and Push state.

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=%22Pulling%22_Centralized_data.accdb&oldid=168354"