"Pulling" Centralized data.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 3: Line 3:
Data should not be pulled during '''[[designated sending times]]''': {{:Designated sending times}}.
Data should not be pulled during '''[[designated sending times]]''': {{:Designated sending times}}.


'''**''' Before going home '''ALWAYS''' make sure you are in the 'push' mode
''' Before going home ''always'' make sure you are in the 'push' mode'''


== Instructions / Steps to Pull ==
== Instructions / Steps to Pull ==

Revision as of 00:42, 2017 November 12

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.

Data should not be pulled during designated sending times: Because the Data Processor needs dedicated access to Centralized_data.mdb the time during which collectors are able to send is limited as follows:

  • when working from hospital site: Monday to Friday 14:30-18:00
  • when working from home: Monday to Friday 07:00-09:00
.

Before going home always make sure you are in the 'push' mode

Instructions / Steps to Pull

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

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.mdb & phi.mdb' get moved to 'C: Centralized_CCMDB'

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

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


"Back up"

When in the Pull mode, data processor can edit.

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

PTorres 15:08, 2015 June 11 (CDT)