RIS PACS importer.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →2015-08-24: m |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Work in progress | 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. | [[RIS PACS importer.accdb]] is used to import data provided as part of [[Direct Data Access for RIS/PACS]] into [[Centralized_data.accdb]]. | ||
== Beta == | == Beta == | ||
| Line 23: | Line 23: | ||
uploaded a beta version to start | uploaded a beta version to start | ||
[[Category: IT Instructions]] | [[Category:IT Instructions]] | ||
[[Category: RIS/PACS]] | [[Category:RIS/PACS]] | ||
[[Category: Labs]] | [[Category:Labs]] | ||
Latest revision as of 10:55, 30 July 2025
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.accdb.
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