Imaging.mdb: Difference between revisions
Ttenbergen (talk | contribs) m Created page with "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 '''tab..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 2: | Line 2: | ||
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'''. | 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 == | |||
# receive monthly email from Breanne Batters with last month's imaging data | |||
# open [[Regional Server]]\Output\[[Imaging.mdb]] | |||
#* import doesn't work with the data for some reason, so following steps: | |||
## make copy of imp_blank table, name imp_<yyyy>-<mm>, e.g. imp_2012-01 | |||
## 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... [[User:Ttenbergen|Ttenbergen]] 15:33, 2012 February 29 (CST) | |||
[[Category:Data Repository]] | [[Category:Data Repository]] | ||
[[Category:RIS/PACS Import]] | [[Category:RIS/PACS Import]] | ||