Exporting study information¶
Exporting to csv and xlsx sheets¶
If you are logged in as a user in the
exportgroup or the
the export links will be available near the top of the modality filter pages
in the OpenREM interface. The following exports are currently available (version 0.5.0)
- CT basic, single sheet csv
- CT advanced, XLSX muliple-sheets
- Fluoroscopy basic, single sheet csv
- Mammography, single sheet csv
- Mammography NHSBSP, single sheet csv designed to satisfy NHSPSB reporting
- Radiographic, single sheet csv
- Radiographic, XLSX multiple sheets
For CT and radiographic, the XLSX export has multiple sheets. The first sheet contains a summary of all the study descriptions, requested procedures and series protocol names contained in the export:
This information is useful for seeing what data is in the spreadsheet, and can also be used to prioritise which studies or protocols to analyse based on frequency.
The second sheet of the exported file lists all the studies, with each study taking one line and each series in the study displayed in the columns to the right.
The remainder of the file has one sheet per series protocol name. Each series is listed one per line. If a single study has more than one series with the same protocol name, then the same study will appear on more than one line.
Clicking the link for an export redirects you to the Exports page, which you can also get to using the link at the top right of the navigation bar:
Whilst an export is being processed, it will be listed in the first table at the top. The current status is displayed to indicate export progress. If an export gets stuck for whatever reason, you may be able to abort the process by clicking the ‘Abort’ button. However this does not always cause an active export to terminate - you may find it completes anyway!
Completed exports are then listed in the second table, with a link to download the csv or xlsx file.
When the export is no longer needed, it can be deleted from the server by ticking the delete checkbox and clicking the delete button at the bottom:
Specific modality export information¶
This export is specific to the UK NHS Breast Screening Programme and generates the source data in the format required for the dose audit database developed by the National Co-ordinating Centre for the Physics of Mammography.
It has been modified to clean up the data to remove exposures that are unlikely to be wanted in the submitted data, such as exposures with any of the following in the protocol name:
scout, postclip, prefire, biopsy, postfire, stereo, specimin, artefact
The view codes have been modified to match the NCCPM convention, i.e. medio-lateral oblique is recorded as
MLO. The other codes are mapped to the ACR MQCM 1999 Equivalent code.
Each patient is numbered from starting from 1. Each view for any one patient has a unique view code, so if a second cranio-caudal exposure is made to the left breast the view codes will be LCC and LCC2.
The survey number is left as 1. This needs to be modified as appropriate. The easiest way to do this in Excel is to change the first two or three rows, select those cells that have been changed, then double click on the bottom-right corner of the selection box to copy-down the value to all the remaining cells below.
The data can then be copied and pasted into the NCCPM database.
If there are a mixture of 2D and tomography exposures, providing you can separate them by virtue of the filter used, then you should further prepare the data as follows:
- Copy the sheet to a new sheet
- In the first sheet, filter for the target and filter combination used for used for the tomographic exposures and delete those rows.
- In the second sheet, filter for the target and filter combinations used for 2D exposures and delete those rows.
- Change the survey number on the 2D sheet and the the survey number on the tomographic sheet as appropriate, with the tomographic survey number bing one more than the 2D survey number.
Where patients have had both 2D and tomographic exposures in the same study, NCCPM will be able to match them up as they will have the same patient number in both surveys.
Opening csv exports in Excel¶
If the export contains non-ASCII characters, then Microsoft Excel is unlikely to display them correctly by default. This issue does not occur with Libre Office which defaults to UTF-8 – behaviour with other applications will vary.
To correctly render characters in csv files with Excel, you will need to follow the following procedure:
- Open Excel.
- On the
Datatab of the ribbon interface, select
From Textin the
Get External Datasection.
- Select your exported csv file and click
- Ensure that Data Type
Fixed widthis selected.
- Change the
65001 : Unicode (UTF-8)– the easiest way to find it is to scroll right to the bottom of the list, then move up one.
- Change the delimiter to just
- Either click
Next >if you want to further customise the import.