Appending.vbs: Difference between revisions

Fschumacher (talk | contribs)
Fschumacher (talk | contribs)
No edit summary
Line 1: Line 1:
''This script supersedes the previously used batch file [[Appending.bat]]
''This script supersedes the previously used batch file [[Appending.bat]]


[[Data Processor]] uses this script during the [[Data Appending Process]] to move and rename files sent by the Data Collectors from the Regional Server to the local import directory.
[[Data Processor]] uses this script during the [[Data Appending Process]] to move and rename files sent by the Data Collectors from the Regional Server to the local import directory. The script is run weekly.


The script is located in '''C:\ccmis_backup''' on the main data processing computer. A backup copy is located in '''X:\ccmis_backup\Copy of batch files on Pagasa C drive'''.
The script is located in '''C:\ccmis_backup''' on the main data processing computer. A backup copy is located in '''X:\ccmis_backup\Copy of batch files on Pagasa C drive'''.
Please refer to the script for details on functionality.
==For those who don't have access to script this is what it does==
''note that this information will not necessarily be updated if the script changes, so refer to the script for actual current content.
This is a batch file that '''automates''' two processes:
'''A'''
*moves batch files "sent" CSV files from the [[Regional Server]] to [[Data Processor]]s computers' local hard drive, renames extension to txt, 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:
*[[Regional Server]]/Output/<all locations' directories>
TO:
*"'''M'''" to: C:/[[MedPDAdnld/Import Ready | MedPDAdnld/Import Ready]]
*"'''C'''" to: C:/[[CritPDAAdnld/Import Ready | 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 (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
===Frequency===
*Done once a week by [[data processor]].


==Implementation/change log==
==Implementation/change log==