Export from database

Multi-sheet Microsoft Excel XLSX exports

This export has a summary sheet of all the requested and performed protocols and the series protocols. The next sheet has all studies on, one study per line, with the series stretching off to the right. The remaining sheets are specific to each series protocol, in alphabetical order, with one series per line. If one study has three series with the same protocol name, each one has a line of its own.

(task)remapp.exports.xlsx.ctxlsx(filterdict)

Export filtered CT database data to multi-sheet Microsoft XSLX files.

Parameters:filterdict (HTTP get) – Query parameters from the CT filtered page URL.
(task)remapp.exports.dx_export.dxxlsx(filterdict)

Export filtered DX and CR database data to multi-sheet Microsoft XSLX files.

Parameters:filterdict (HTTP get) – Query parameters from the DX and CR filtered page URL.

Single sheet CSV exports

(task)remapp.exports.exportcsv.exportFL2excel(filterdict)

Export filtered fluoro database data to a single-sheet CSV file.

Parameters:request (HTTP get) – Query parameters from the fluoro filtered page URL.
(task)remapp.exports.exportcsv.exportCT2excel(filterdict)

Export filtered CT database data to a single-sheet CSV file.

Parameters:request (HTTP get) – Query parameters from the CT filtered page URL.
(task)remapp.exports.exportcsv.exportMG2excel(filterdict)

Export filtered mammography database data to a single-sheet CSV file.

Parameters:request (HTTP get) – Query parameters from the mammo filtered page URL.
(task)remapp.exports.dx_export.exportDX2excel(filterdict)

Export filtered DX database data to a single-sheet CSV file.

Parameters:request (HTTP get) – Query parameters from the DX filtered page URL.

Specialised csv exports - NHSBSP formatted mammography export

(task)remapp.exports.mg_csv_nhsbsp.mg_csv_nhsbsp(filterdict)

Export filtered mammography database data to a NHSBSP formatted single-sheet CSV file.

Parameters:filterdict (dict) – Dictionary of query parameters from the mammo filtered page URL.
Returns:None - file is saved to disk and location is stored in database