Add ability to import requested procedure name and study description data
Some of my fluoroscopy systems are missing study description or requested procedure name on initial import. The data is available on the radiology information system, and can be easily exported with the accession number of the study. I would like to be able to import a csv version of this data into OpenREM, much like the existing facility to import patient size information.
Comments (9)
-
reporter -
Go for it
-
reporter Removed word wrap in table cell in fluoro summary page. Added word wrap in plotly average chart. Needs further work. Refs issue #900
→ <<cset c1a880daf546>>
-
reporter Added character wrapping of plot labels for fluoroscopy charts. Added new chart option to set the character length of the wrap (defaults to 500, so unlikely to wrap). Refs issue #900
→ <<cset c1e1a1a8d952>>
-
reporter Added character wrapping of plot labels for scatter and binned statistic charts. Configured mammography charts to use the text wrapping. Refs issue #900
→ <<cset 54af736c1add>>
-
reporter Added character wrapping for radiographic charts. Refs issue #900
→ <<cset 12ada400eab0>>
-
reporter Investigating why mammo chart tests are failing - not fixed yet. Refs issue #900
→ <<cset c4a3ca74be83>>
-
reporter Fixing broken csv data preparation. Refs issue #900
→ <<cset 9bbc19b26d71>>
-
reporter Fixing sorting of frequency charts for CT. Need to clean up the other modalities too. Refs issue #900
→ <<cset 497085f46ead>>
- Log in to comment
Our Radiology Information System (CRIS) contains more detail on what took place during an examination than the “study description” that arrives in OpenREM. I would like to be able to easily update the OpenREM study description with this CRIS data.
In CRIS there is a field called "Exam details CSV" which contains the details of the exam, such as the line below:
IURRLS|Ureteric stent retrograde Lt|1|IURRRS|Ureteric stent retrograde Rt|1
I have written a Python script which can take a csv file containing the above data, extract the name components, sort them alphabetically and then concatenate them into a single string, separated by a semi-colon:
Ureteric stent retrograde Lt; Ureteric stent retrograde Rt
At the moment the Python script also creates an SQL statement for each entry in the CRIS csv export that I can use to update the study description by matching accession numbers present in the CRIS data with those in OpenREM, such as:
UPDATE remapp_generalstudymoduleattr SET study_description = 'Ureteric stent retrograde Lt; Ureteric stent retrograde Rt' WHERE accession_number = 'TheAccessionNumber';
There are two side effects to using these long concatenated study descriptions:
nowrap
to display the study description, which results in very wide cells, pushing some columns too far to the right, so that they are underneath the filters, and therefore invisible
For example, this is an entry in my test system once I’ve concatenated the CRIS study name components:
Nephrostogram Lt; Nephrostogram Rt; Nephrostomy Lt; Nephrostomy tube removal Rt; Ureteric stent antegrade Lt
Which, before I updated the study name, was simply
Ureteric stent antegrade Lt
I propose that:
nowrap
is removed in the rffiltered.html template