Centralized data Vetting Process: Difference between revisions

← Older edit Newer edit →

@@ Line 3: / Line 3: @@
 == Pull down data ==
 Before processing run [[Pull_down_centralized_data.vbs]] to do backups and move data from the regional server for local processing. This also prevents collectors from sending while data is being processed.
 The 'log' will show whether you are in 'push' or 'pull' mode.
@@ Line 40: / Line 41: @@
-'''OPTION TO VIEW DATA'''
+'''STEPS TO PULL'''
-Regional
+Go to ''Centralized_CCMDB''
-Output
+double click on ''Pull_down_centralized_data.vbs''
-Right click on ''centralized_data.mdb''
-Copy
-Pagasa's Centralized Manual Copy
-Paste
+'''STEPS TO SEE WHO SENT'''
-** This allows the data processor to VIEW these files.
+Pull --  ''Pull_down_centralized_data.vbs''
-Then go into
+Queries
-X
+P_Count_Of_Sent
-CCMDB
+Home
-PHI
+View
-right click on ''phi.mdb''
+Pivot Table
-Copy
+View
-Pagasa's Centralized Manual Copy
+Filter by 'Date Sent' -- then Right Click, then Field List, then drag 'sent Dt Time
-Paste
+Home
-** This allows the data processor to VIEW these files
+Design View
+Change to 'Wed' date
+Home
+View
+Pivot Table -- use + to expand, use - to collapse
+Click inside the column and scroll down to do a quick check of the location
+When done
+x (in top right) and DO NOT 'save'
+It will prompt you 'do you want to save'
+say NO
+When finished viewing, just close, DO NOT 'save'
-'''STEPS TO SEE WHO SENT'''
-Pull to Pagasa's Centralized Manual Copy
-Queries
+'''OPTION TO VIEW DATA'''
-P_Count_Of_Sent
+'''**'''You cannot edit any data.  The background will be red.
-Home
+Go to ''Regional''
-View
+Output
-Pivot Table
+Right click on ''centralized_data.mdb''
-View
+Copy
-Filter by 'Date Sent' -- then Right Click, then Field List, then drag 'sent Dt Time
+Then go to ''Pagasa's Centralized Manual Copy''
-Home
+Paste
-Design View
+'''**'''This only allows the data processor to VIEW these files.
-Change to 'Wed' date
-Home
-View
+Then go into '''X'''
-Pivot Table -- use + to expand, use - to collapse
+CCMDB
-Click inside the column and scroll down to do a quick check of the location
+PHI
-When done
+right click on ''phi.mdb''
-x (in top right) and DO NOT 'save'
+Copy
-It will prompt you 'do you want to save'
+Then go to ''Pagasa's Centralized Manual Copy''
-say NO
+Paste
-When finished viewing, just close, DO NOT 'save'
+'''**'''This only allows the data processor to VIEW these files.
 ==clean ups==