RIS PACS importer.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m |
Ttenbergen (talk | contribs) m →2015-08-24: m |
||
| Line 17: | Line 17: | ||
== Log == | == Log == | ||
=== 2015-12-17 === | |||
There had been issues getting proper data; those are fixed now, importing new data. | |||
=== 2015-08-24 === | === 2015-08-24 === | ||
uploaded a beta version to start | uploaded a beta version to start | ||
Latest revision as of 15:37, 2015 December 17
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
- 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.
- click the "Import" button and follow the wizard
- 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