Appending.vbs: Difference between revisions
Jump to navigation
Jump to search
Fschumacher (talk | contribs) |
TOstryzniuk (talk | contribs) mNo 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]] | ==What does it do== | ||
This is a batch file that '''automates''' the process of converting batch sent CSV files to TXT, while also '''moveing''' these "batch sent" CSV files from the [[Regional Server]] to [[Data Processor]]s computers' local hard drive. This is done in preparation in preparation for [[Data Appending Process]] or uploading files into the master Critical Care [[TMSX]] or Medicine [[MedTMS]] data repository. | |||
==Where exactly does it move if FROM and TO== | |||
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''': | |||
==How often is is done== | |||
*Once per week or more if required | |||
==Where is script for batch file stored== | |||
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'''. | ||
==Implementation/change log== | ==Implementation/change log== | ||
===2012- | ===2012-SEP-17=== | ||
* 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.--[[User:Fschumacher|Fschumacher]] ([[User talk:Fschumacher|talk]]) 13:52, 2012 September 17 (CDT) | * 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.--[[User:Fschumacher|Fschumacher]] ([[User talk:Fschumacher|talk]]) 13:52, 2012 September 17 (CDT) | ||
*-[[User:PTorres | Pagasa Torres]] & [[User:TOstryzniuk|Trish Ostryzniuk]] 14:57, 2012 December 14 (EST) | |||
[[Category:Data processing batch files]] | [[Category:Data processing batch files]] | ||
Revision as of 13:57, 14 December 2012
This script supersedes the previously used batch file Appending.bat
What does it do
This is a batch file that automates the process of converting batch sent CSV files to TXT, while also moveing these "batch sent" CSV files from the Regional Server to Data Processors computers' local hard drive. This is done in preparation in preparation for Data Appending Process or uploading files into the master Critical Care TMSX or Medicine MedTMS data repository.
Where exactly does it move if FROM and TO
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:
How often is is done
- Once per week or more if required
Where is script for batch file stored
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
2012-SEP-17
- 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)
- - Pagasa Torres & Trish Ostryzniuk 14:57, 2012 December 14 (EST)