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:"
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This is now a [[:Category: Legacy Data | Legacy]] batch file.  See [[Appending.bat]]  
{{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 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.  
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:'''  
'''Copied FROM:'''  
twister\ICU\output
{{Regionalserver|ICU\output}}


'''Copied 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.
*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.
Line 16: Line 20:
'''Files included''':
'''Files included''':


::[[TASKS.mdb]]
::[[Tasks 1.mdb]]
::[[greensheets.mdb]]
::[[greensheets.mdb]]
::[[PDA_Pending.mdb]]
::[[PDA_Pending.mdb]]
Line 27: Line 31:


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






[[Category: Legacy Data]]
[[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)