RIS PACS importer.accdb

From CCMDB Wiki
Revision as of 15:37, 2015 December 17 by Ttenbergen (talk | contribs) (→‎2015-08-24: m)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Work in progress

RIS PACS importer.accdb is used to import data provided as part of Direct Data Access for RIS/PACS into Centralized_data.mdb.

Beta

Currently just imports into a local table so we can compare.

Made some queries to do comparison, they start with "5_".

Instructions

  1. open any .xls file received and re-save as .xls. Breanee's output mechanism generates files that produce errors on import, re-saving fixes this.
  2. click the "Import" button and follow the wizard
  3. if it opens a query 1_z_unknown_imaging_type then copy the entries to querys_aggregate_types and make sure all have an appropriate Aggregate_type assigned to them, even if it is "<not coded>". Click "Import" again when done.

File Location

\\Hsc1msfp0001\med_ccmed\CCMDB\RIS_PACS_import\

Log

2015-12-17

There had been issues getting proper data; those are fixed now, importing new data.

2015-08-24

uploaded a beta version to start

Retrieved from "https://ccmdb.kuality.ca/index.php?title=RIS_PACS_importer.accdb&oldid=46522"