Imaging.mdb

The access file Regional Server\Output\imaging.mdb will be the data store for the import of RIS/PACS data.

Data to allow merging into TMSX will be written to the table Patients in the Imaging.mdb from CCMDB.mdb for all patient being sent by the query Send_Imaging.

Process to import data

1. receive monthly email from Breanne Batters with last month's imaging data
2. open Regional Server\Output\Imaging.mdb
   • import doesn't work with the data for some reason, so following steps:
   1. make copy of imp_blank table, name imp_<yyyy>-<mm>, e.g. imp_2012-01
   2. copy and paste data from Breanne's excel sheet into the table

Copy paste not working either, dates break ... need to figure out what to do with this... Ttenbergen 15:33, 2012 February 29 (CST)