DataTwisterMDBtoSANS.bat

Legacy Content

This page contains Legacy Content.

• Explanation: Was part of TISS28 Form Scanning.
• Successor: none, process changed

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\CCMED\​S:\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

• also see: Outputbackup.bat

• You can find copy of all batch files on:

S:\MED\CCMED\​S:\MED\CCMED\ccmis_backup\Copy_of_batch_files_on_Pagasa_C_drive.zip

TOstryzniuk 11:04, 12 March 2009 (CDT)