RIS PACS importer.accdb

From CCMDB Wiki
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"