Eds and raw push to x manual.vbs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
TOstryzniuk (talk | contribs)
mNo edit summary
Line 21: Line 21:
#**Pharmacy.dat
#**Pharmacy.dat
#**REGISTRYX.dat
#**REGISTRYX.dat
#**SAPII.dat
#**SAPSII.dat
#**SapXtra.dat
#**SapXtra.dat
#*Special note: [[iTISS]] is not longer being collected in Medicine but master is still in [[MedTMS]]
#*Special note: [[iTISS]] is not longer being collected in Medicine but master is still in [[MedTMS]]

Revision as of 13:51, 29 April 2014

X:\Eds_Master_data\Eds_push_to_x.vbs is a VBS script that copies specific DAT files and EXPORTED raw files from local PC (usually the data processor's) to X:

ICU files from Data Processor's local C:

  1. C:\TMSX\data - TO X:\Eds_Master_data\ICU
    • Specific files copied from this folder:
      • Apache.dat
      • Lab.dat
      • pharmacy.dat
      • Registryx.dat
      • TISS.dat
    • special note: TISS.data is no longer updated to TMSX. Only edits of older data may be done there. TISS for ICU is now stored on X:\TISS28\Database\TISS28_Data.mdb. The elements of TISS on X are different than the elements of TISS in TMSX.
  2. C:\CCData\rawdata - TO X:\PAGASA\CCData\rawdata

MED files from Data Processor's local C:

  1. C:\MEDTMS\data TO: X:\Eds_Master_data\MED
    • Specific files copied from this folder:
      • MedTMS\data\ADL.dat
      • apache.dat
      • iTISS.dat
      • lab.dat
      • Pharmacy.dat
      • REGISTRYX.dat
      • SAPSII.dat
      • SapXtra.dat
    • Special note: iTISS is not longer being collected in Medicine but master is still in MedTMS
  2. C:\MedData\rawdata TO: X:\PAGASA\MedData\rawdata

Location of vbs script

X:\Eds_Master_data


Also see: Eds pull from x.vbs


Future Plan

Set up a automated Scheduled Task to do this. This task will be stopped when we finally move to centralized database to stop Ed. Target date end possible end May or June 2014


Template:Discussion pls link to whichever processes use this...