Imaging.mdb: Difference between revisions
Jump to navigation
Jump to search
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]] |
Revision as of 16:33, 2012 February 29
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
- 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... Ttenbergen 15:33, 2012 February 29 (CST)