Appending.vbs: Difference between revisions

(9 intermediate revisions by 4 users not shown)

Line 1:

Legacy, no longer used

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

==What does it do==

This is a batch file that '''automates''' the process of converting batch sent CSV files to TXT, while also '''moving''' 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.

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

==Where exactly does it move if FROM and TO==

FROM:

*[[Regional Server]]/Output/<all locations' directories>

Line 23:

Line 15:

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

'''B'''.

==Where is script for batch file stored==

*Copies output Access mdb (database) files ~~from the [[Regional Server]] (Twister) to the SAN (X:Drive)~~

The script is located in '''C:\ccmis_backup''' on the main data processing computer. A backup copy is located in '''{{S:\MED\MED_CCMED}}ccmis_backup\Copy of batch files on Pagasa C 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==

===2014-Apr-24===

Pagasa ID that there was an error message for the last month when running this program but she did not let anyone know because it is minor. She noted that any of the MD sent csv files that are move from Output folder on Regional Server to MedTms\Import Ready folder are not changed from CSV to TXT. The CC one are okay. Tina had a look and made some minor edits and ran test and things seemed to work. [[User:TOstryzniuk|Trish Ostryzniuk]] 18:46, 2014 April 24 (CDT)

*Plan: Pagasa to write down the error message with the LINE number so we can look at which line in the vbs script things may be getting hung up in.[[User:TOstryzniuk|Trish Ostryzniuk]] 18:46, 2014 April 24 (CDT)

===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)

*-[[User:PTorres | Pagasa Torres]] & [[User:TOstryzniuk|Trish Ostryzniuk]] 14:57, 2012 December 14 (EST)

[[Category:~~Data processing batch files]]~~

[[Category:Legacy_Data_Processing]]

~~[[Category:Batch Files]]~~

~~[[Category:Data Processing]]~~

~~[[Category:IT Instructions~~]]

@@ Line 1: / Line 1: @@
+ Legacy, no longer used
 ''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.
+==What does it do==
+This is a batch file that '''automates''' the process of converting batch sent CSV files to TXT, while also '''moving''' 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.
-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
+==Where exactly does it move if FROM and TO==
 FROM:
 *[[Regional Server]]/Output/<all locations' directories>
@@ Line 23: / Line 15: @@
 **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
-'''B'''.
+==Where is script for batch file stored==
-*Copies output Access mdb (database) files from the [[Regional Server]] (Twister) to the SAN (X:Drive)
+The script is located in '''C:\ccmis_backup''' on the main data processing computer. A backup copy is located in '''{{S:\MED\MED_CCMED}}ccmis_backup\Copy of batch files on Pagasa C 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==
+===2014-Apr-24===
+Pagasa ID that there was an error message for the last month when running this program but she did not let anyone know because it is minor.  She noted that any of the MD sent csv files that are move from Output folder on Regional Server to MedTms\Import Ready folder are not changed from CSV to TXT.  The CC one are okay.   Tina had a look and made some minor edits and ran test and things seemed to work. [[User:TOstryzniuk|Trish Ostryzniuk]] 18:46, 2014 April 24 (CDT)
+*Plan: Pagasa to write down the error message with the LINE number so we can look at which line in the vbs script things may be getting hung up in.[[User:TOstryzniuk|Trish Ostryzniuk]] 18:46, 2014 April 24 (CDT)
+===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)
+*-[[User:PTorres | Pagasa Torres]] & [[User:TOstryzniuk|Trish Ostryzniuk]] 14:57, 2012 December 14 (EST)
-[[Category:Data processing batch files]]
+[[Category:Legacy_Data_Processing]]
-[[Category:Batch Files]]
-[[Category:Data Processing]]
-[[Category:IT Instructions]]