DataTwisterMDBtoSANS.bat: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(28 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Under Construction........[[User:TOstryzniuk|TOstryzniuk]] 16:08, 10 February 2009 (CST)
{{LegacyContent
| explanation=Was part of [[TISS28 Form Scanning]].
| successor=none, process changed
| content=
'''This is now a [[:Category: Legacy Data |Legacy]] batch file and will not be used.  See [[Appending.vbs]]  


This is a batch file that copies the numerous ACCESS MDB's from the Regional Server (Twister) to SANS (X)drive.
This batch file was written by the [[statistician]]. It copies the ACCESS "mdb's" from the [[Regional Server]]'s output folder into a directory called (CCMDB) which is located on SANS (X)drive.  


FROM:  
'''Copied FROM:'''
\\twister\ICU\output
{{Regionalserver|ICU\output}}


TO:  
'''Copied TO''':  
X:\MED_CCMED\CCMDB
{{S:\MED\MED_CCMED}}MED_CCMED\CCMDB


*Task completed once per week after data collectors have sent in their weekly data. It can be done more often if corrections are made to any of the mdb's.


**how often?
'''USE:'''
***once a week after data collectors have sent in their weekly data, or if correction are.
*Statistician pull these files from this share point into her [[SAS]] program for analsyis.  


*USE:
'''Files included''':
*back up for the Statistician who uses [[SAS]] to pull these files in for analsyis from this location.   


Files included:
::[[Tasks 1.mdb]]
::[[greensheets.mdb]]
::[[PDA_Pending.mdb]]
::[[TmpV2_1.mdb]]


* [[TASKS.mdb]]
* [[greensheets.mdb]]
* [[PDA_Pending.mdb]]
* [[TmpV2_1.mdb]]




{{Stub}}
*also see: [[Outputbackup.bat]]


[[Category: Backup]]
 
[[Category: Batch Files]]
*You can find copy of all batch files on:
[[Category: Data Processing]]
::{{S:\MED\MED_CCMED}}ccmis_backup\Copy_of_batch_files_on_Pagasa_C_drive.zip
::::::::::::[[User:TOstryzniuk|TOstryzniuk]] 11:04, 12 March 2009 (CDT)
 
 
 
[[Category:Legacy Data Processing]]
}}

Latest revision as of 10:32, 30 July 2025

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

This is now a Legacy batch file and will not be used. See Appending.vbs

This batch file was written by the statistician. It copies the ACCESS "mdb's" from the Regional Server's output folder into a directory called (CCMDB) which is located on SANS (X)drive.

Copied FROM: Regional Server\​ICU\output\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\ICU\output

Copied TO: S:\MED\Med_CCMED\S:\MED\Med_CCMED\MED_CCMED\CCMDB

  • Task completed once per week after data collectors have sent in their weekly data. It can be done more often if corrections are made to any of the mdb's.

USE:

  • Statistician pull these files from this share point into her SAS program for analsyis.

Files included:

Tasks 1.mdb
greensheets.mdb
PDA_Pending.mdb
TmpV2_1.mdb



  • You can find copy of all batch files on:
S:\MED\Med_CCMED\S:\MED\Med_CCMED\ccmis_backup\Copy_of_batch_files_on_Pagasa_C_drive.zip
TOstryzniuk 11:04, 12 March 2009 (CDT)