"Pulling" Centralized data.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "[["Pushing" Centralized_data.accdb]]" to ""Pushing" Centralized_data.accdb" |
|||
| (22 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. | This article describes how 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]]''': {{:Designated sending times}}. | ||
'''ALWAYS'' make sure you finish [["Pushing" Centralized_data.accdb]] before you go home''' 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 - | * 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 | * 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 | ||
| Line 18: | Line 18: | ||
*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 | The [[Centralized_data.accdb]] & [[PHI.mdb]] get moved to the directory from which [[Pull_down_centralized_data.vbs] was run. | ||
== Background == | == Background == | ||
The data processor takes control of the data by [["Pulling" | 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 | At the beginning and end of the day, it should '''ALWAYS''' be in [["Pushing" [[Centralized_data.accdb]]|push]] mode. | ||
==="Back up" === | ==="Back up" === | ||
*The Centralized and Phi.mdb back up in Pull and Push state. | *The Centralized and Phi.mdb back up in Pull and Push state. | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:Centralized data push pull]] | [[Category:Centralized data push pull]] | ||
[[Category:Data Processing]] | |||
Latest revision as of 15:36, 23 July 2025
This article describes how 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: Because the Data Processor needs dedicated access to Centralized_data.accdb the time during which collectors are able to send is limited as follows:
- when working from hospital site: Monday to Friday 07:00-09:30 and 14:00-16:15
- sending should be done every day a collector is working on site
- Sending should only be done when on site and on the network. (no sending from home)
- Only 1 laptop can send at any given time, so sites need to coordinate this amongst themselves
- SBGH- will be assigned sending between 0700-0900
- HSC – will be assigned sending between 0900-0930 and 1400-1515
- GGH – will be assigned sending between 1515-1615
- If there is a special circumstance where you need to send outside of the assigned time, the collector is to email the site that is assigned that time slot to verify no one else is sending or negotiate a time to send.
.
ALWAYS make sure you finish "Pushing" Centralized_data.accdb before you go home 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 approx. 5 minutes
- 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 [["Pushing" Centralized_data.accdb|push]] mode.
"Back up"
- The Centralized and Phi.mdb back up in Pull and Push state.
Related articles
| Related articles: |