Appending.vbs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
Fschumacher (talk | contribs)
approved
142 edits
Fschumacher (talk | contribs)
approved
142 edits
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==

Revision as of 08:34, 19 September 2012

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. 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.

Implementation/change log

  • Implemented script on Data Processor's PC. Explained functionality and ran through a test to demonstrate how the script works. No problems in the production environment.--Fschumacher (talk) 13:52, 2012 September 17 (CDT)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Appending.vbs&oldid=28366"