Appending.bat: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m (link fix)
 
(14 intermediate revisions by 4 users not shown)
Line 1: Line 1:
This is a batch file that '''automates''' two processes of '''moving''' "batch files:
This process has been superseded by [[Appending.vbs]].
#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
this article is now Legacy info only
#
 
This is a batch file that '''automates''' two processes.  Create August 25.09. (combines the following previously used batch files: A. [[DatatoIMP.bat]] and B. [[DataTwisterMDBtoSANS.bat]]
 
'''A'''
*moves batch files "sent" CSV files from the [[Regional Server]] to [[Data Processor]]s 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:  
FROM:  
*[[Regional Server]]/Output/<all locations' directories>
*Regional Server/Output/<all locations' directories>


TO:
TO:
Line 12: Line 16:
**Uses the program prefixes set out in [[Sent files naming conventions]] the batch file copies all data output files according to their '''prefix''':
**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 (database) files from the [[Regional Server]] (Twister) to the SAN (X:Drive)
#: data directory on twister
*the following mdb are copied:
set twister=\\twister\icu\output
 
: copy to SAN
set san_loc=\\Hsc1MSFP0001\MED_CCMED\CCMDB
 
 
#copy output mdb files from Twister to the SAN (X:Drive)
*greensheets.mdb  
*greensheets.mdb  
*PDA_Pending.mdb
*PDA_Pending.mdb
*TASKS.mdb   
*TASKS.mdb   
*TmpV2_1.mdb
*TmpV2_1.mdb
*Weekly processing.


[[Category: Batch Files]]
 
[[Category: Data Processing]]
 
[[Category: IT Instructions]]
[[Category: Legacy Data Processing]]

Latest revision as of 17:16, 2017 November 7

This process has been superseded by Appending.vbs.

this article is now Legacy info only

This is a batch file that automates two processes. Create August 25.09. (combines the following previously used 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:

B.

  • Copies output Access mdb (database) 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