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. For NM this is not true as protocol names do not exist, sheets are generated by study description instead.

remapp.exports.rf_export.rfxlsx(filterdict, pid=False, name=None, patid=None, user=None)

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

Parameters
  • filterdict – Queryset of studies to export

  • pid – does the user have patient identifiable data permission

  • name – has patient name been selected for export

  • patid – has patient ID been selected for export

  • user – User that has started the export

Returns

Saves xlsx file into Media directory for user to download

remapp.exports.ct_export.ctxlsx(filterdict, pid=False, name=None, patid=None, user=None)

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

Parameters
  • filterdict – Queryset of studies to export

  • pid – does the user have patient identifiable data permission

  • name – has patient name been selected for export

  • patid – has patient ID been selected for export

  • user – User that has started the export

Returns

Saves xlsx file into Media directory for user to download

remapp.exports.dx_export.dxxlsx(filterdict, pid=False, name=None, patid=None, user=None)

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

Parameters
  • filterdict – Queryset of studies to export

  • pid – does the user have patient identifiable data permission

  • name – has patient name been selected for export

  • patid – has patient ID been selected for export

  • user – User that has started the export

Returns

Saves xlsx file into Media directory for user to download

remapp.exports.mg_export.exportMG2excel(filterdict, pid=False, name=None, patid=None, user=None, xlsx=False)

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

Parameters
  • filterdict – Queryset of studies to export

  • pid – does the user have patient identifiable data permission

  • name – has patient name been selected for export

  • patid – has patient ID been selected for export

  • user – User that has started the export

  • xlsx – Whether to export a single sheet csv or a multi sheet xlsx

Returns

Saves csv file into Media directory for user to download

remapp.exports.nm_export.exportNM2excel(filterdict, pid=False, name=None, patid=None, user=None)
Parameters
  • filterdict – Queryset of studies to export

  • pid – does the user have patient identifiable data permission

  • name – has patient name been selected for export

  • patid – has patient ID been selected for export

  • user – User that has started the export

Returns

Saves xlsx file into Media directory for user to download

Single sheet CSV exports

remapp.exports.rf_export.exportFL2excel(filterdict, pid=False, name=None, patid=None, user=None)

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

Parameters
  • filterdict – Queryset of studies to export

  • pid – does the user have patient identifiable data permission

  • name – has patient name been selected for export

  • patid – has patient ID been selected for export

  • user – User that has started the export

Returns

Saves csv file into Media directory for user to download

remapp.exports.ct_export.ct_csv(filterdict, pid=False, name=None, patid=None, user=None)

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

Parameters
  • filterdict – Queryset of studies to export

  • pid – does the user have patient identifiable data permission

  • name – has patient name been selected for export

  • patid – has patient ID been selected for export

  • user – User that has started the export

Returns

Saves csv file into Media directory for user to download

remapp.exports.dx_export.exportDX2excel(filterdict, pid=False, name=None, patid=None, user=None)

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

Parameters
  • filterdict – Queryset of studies to export

  • pid – does the user have patient identifiable data permission

  • name – has patient name been selected for export

  • patid – has patient ID been selected for export

  • user – User that has started the export

Returns

Saves csv file into Media directory for user to download

remapp.exports.nm_export.exportNM2csv(filterdict, pid=False, name=None, patid=None, user=None)
Parameters
  • filterdict – Queryset of studies to export

  • pid – does the user have patient identifiable data permission

  • name – has patient name been selected for export

  • patid – has patient ID been selected for export

  • user – User that has started the export

Returns

Saves csv file Media directory for user to download

Specialised csv exports - NHSBSP formatted mammography export

remapp.exports.mg_csv_nhsbsp.mg_csv_nhsbsp(filterdict, user=None)

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