Eds and raw push to x manual.vbs

From CCMDB Wiki
Revision as of 14:46, 2014 April 29 by TOstryzniuk (talk | contribs)
Jump to navigation Jump to search

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