Appending.bat: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) m (→Freqency) |
TOstryzniuk (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
This is a batch file that '''automates''' two processes. Create August 25.09. (combines the following batch files: [[DatatoIMP.bat]] and [[DataTwisterMDBtoSANS.bat]] | This is a batch file that '''automates''' two processes. Create August 25.09. (combines the following batch files: A. [[DatatoIMP.bat]] and B. [[DataTwisterMDBtoSANS.bat]] | ||
'''A''' | '''A''' | ||
*moves batch files "sent" CSV files from the [[Regional Server]] to [[Data Processor]]s computers' local hard drive in preparation in preparation for [[Data Appending Process|appending]] or uploading files into the master Critical Care [[TMSX]] or Medicine [[MedTMS]] data repository. Create by Tina Tenbergen | |||
FROM: | FROM: | ||
| Line 12: | Line 13: | ||
'''B'''. Copies output Access mdb files from the [[Regional Server]] (Twister) to the SAN (X:Drive) | '''B'''. | ||
*Copies output Access mdb files from the [[Regional Server]] (Twister) to the SAN (X:Drive) | |||
*the following mdb are copied: | *the following mdb are copied: | ||
*greensheets.mdb | *greensheets.mdb | ||
Revision as of 14:30, 2009 August 25
This is a batch file that automates two processes. Create August 25.09. (combines the following batch files: A. DatatoIMP.bat and B. DataTwisterMDBtoSANS.bat
A
- moves batch files "sent" CSV files from the Regional Server to Data Processors computers' local hard drive in preparation in preparation for appending or uploading files into the master Critical Care TMSX or Medicine MedTMS data repository. Create by Tina Tenbergen
FROM:
- Regional Server/Output/<all locations' directories>
TO:
- "M" to: C:/ MedPDAdnld/Import Ready
- "C" to: C:/ CritPDAdnld/Import Ready
- Uses the program prefixes set out in Sent files naming conventions the batch file copies all data output files according to their prefix:
B.
- Copies output Access mdb files from the Regional Server (Twister) to the SAN (X:Drive)
- the following mdb are copied:
- greensheets.mdb
- PDA_Pending.mdb
- TASKS.mdb
- TmpV2_1.mdb
Frequency
- Done once a week by data processor.