17. Things to do

17.1. Tasks


To be prioritized

  • Test Your Memory (TYM) task (Jerry M. Brown).
  • Continuous performance task, as per RNC’s similar previous task (Linda P and team). A/w ETB.


  • Lewy body dementia checklist – need details from JO’B, as per 14 Jan 2018 meeting.

Not a priority

  • Cardinal_ExpDet* tasks: generate noise on the fly?
  • PDSQ screener (see Clark talk 2018-09-20, MQ Data Science)
  • Perinatal: an infant/mother relationship indicator (Zeyn, TBC); NOT the Parent–Infant Interaction Observation Scale (PIIOS); clinician-rated and needs training; https://dx.doi.org/10.1080/02646838.2012.751586; INSTEAD the Care Index (a/w details from JM/NK). Currently deferred.
  • Better SNOMED coding, with text values (for which: framework already in place) for clinical clerking tasks. See CRG minutes of 2019-02-26 for a draft map.


  • review Guo 2015 “measurement-based care”: - HADS/HDRS already - QIDS – permissible? - Maudsley Treatment Inventory? - see notes on Cleare lecture 15/11/2018
  • new task: ReQoL (https://www.reqol.org.uk/p/overview.html)
  • new task: mini-ACE (subset of the ACE-III)
  • new task: Andy Foster / eating disorders; e-mail of 24/5/16
  • new task: AQ10 autistic spectrum screening
  • discarded tasks - revitalize: ASRM
  • discarded tasks - revitalize: BARS
  • discarded tasks - revitalize: BFCRS
  • discarded tasks - revitalize: CSI
  • discarded tasks - revitalize: EPDS
  • discarded tasks - revitalize: FAB
  • discarded tasks - revitalize: GASS
  • discarded tasks - revitalize: LSHSA
  • discarded tasks - revitalize: LSHSLAROI2005
  • discarded tasks - revitalize: LUNSERS
  • discarded tasks - revitalize: MADRS
  • discarded tasks - revitalize: SAS

17.2. Client core


  • Have facility to upload and/or automatically feed patient details into the server, then have clients restrict to these predefined patients. Since we are aiming to minimize PID on the client, this could be implemented by having the client validate its patients with the server, and refusing to upload if they don’t match. This would be a per-group setting.
    • Client validation check implemented.
    • Just needs server-side extensions to camcops_server.cc_modules.cc_patient.is_candidate_patient_valid(), including a per-group setting for “should we validate”, and a way of getting suitable data in.
    • Note that any patient unification should be external to CamCOPS (i.e. addressing the question of “are these two patients the same person”).
    • Maybe implement as (1) a _known_patients table and (2) a _known_patient_idnums table?
    • Needs slightly more thought about what constitutes a “match” given a variable set of input and a variable set of known information. (Could have an ID policy for the known information too…)
    • Should “known” patients be across groups, or per-group?
  • Consider a “chain of tasks” concept again (see e.g. ResearchMenu.js; MenuTableRow.js; QuestionnaireHeader.js…)… or is that pointless relative to a “set of tasks” concept?
  • Test task upload (and date filtering) under Windows/SQL Server.
  • See if “database upgrade” SQL Server bug is fixable; see changelog for server v2.3.1. See also https://stackoverflow.com/questions/155246/how-do-you-truncate-all-tables-in-a-database-using-tsql#156813

Medium priority

  • iOS build.
  • Apple App Store.

Not a priority

  • OS/X build.
  • Think about a web-based client, e.g. via VNC (but this is complex and loads servers/networks considerably). Potentially more promising is Qt for WebAssembly (in preview May 2018), which compiles to a variety of portable quasi-assembly language; the browser downloads and runs it. However, at present there is no threading or DNS lookup (http://blog.qt.io/blog/2018/05/22/qt-for-webassembly/).
  • Desktop-style menu for desktop clients. (Faster to navigate around.)
  • Current Android back button behaviour may not be optimal.
  • Maybe implement pinch zoom for some subclasses of OpenableWidget, e.g. MenuWindow and Questionaire. See http://doc.qt.io/qt-5/qtwidgets-gestures-imagegestures-example.html
  • QuAudioRecording: questionnaire element to record audio
  • QuVideoRecording: questionnaire element to record video
  • Qt have fixed bug https://bugreports.qt.io/browse/QTBUG-35545 as of Qt 5.12.0 beta 1, so may be possible to improve dialogue boxes again on Android (but possibly our workaround sorted it; can’t remember); check.

May not be worth it

  • Client-side task index, to speed up the client’s patient summary view? (Not clear that this is a major performance problem!)

17.3. Server


  • Facility to hide individual sticky notes (with audit trail), so they’re not shown in HTML (+ PDF) and XML views. See e-mail RNC/JK/RE, 2018-10-12.
  • Ensure that the “system user” and “server device” are used everywhere they should be.
  • (SERVER + CLIENT) Concept of “tasks that need doing” in the context of a research study.
    • define patients on server (per group)
      • share main patient/patient_idnum tables
      • use the “server device” to create them, and always in era “NOW”
    • ScheduledTask – “task needs doing”
      • patient (by ID number); group; task; due_from; due_by; cancelled?
      • Example: “PHQ9 due for Mr X on 1 July; must be completed by 1 Aug”
    • then for metacreation: “StudySchedule” or “TaskPanel”
      • … a list of tasks, each with: task; due_from_relative_to_start_date; due_by_relative_to_start_date
      • example: “In our study, we want a PHQ9 and GAD7 at the start, a PHQ9 at 3 months, and a PHQ9 and GAD7 at 6 months.”
    • PatientSchedule
      • instantiate a “StudySchedule”/“TaskPanel” with patient, group, start date
      • e.g. “Mr Jones starts today…. enrol!”
    • Tablets should fetch “what needs doing” for any patients defined on the tablet, and display them nicely.
    • Tasks must be complete to satisfy the requirement.
  • … Relating to that: consider, on the client, a “single-patient” mode (distinct from the current “researcher” mode), tied to a specific server. “This tablet client is attached to a specific patient and will operate in a patient-friendly, single-patient mode. Show me what needs completing.” The operating concept would be: if you would like someone geographically far away to be able to download CamCOPS and complete a set of tasks for you, how could you organize so that would be simplest for them? The minimum would that you’d create login details for them, and give them a URL, username, and password.
  • What’s the optimal packaging method for the server? Is it DEB/RPM for Linux, and PyInstaller + Inno Setup (or just Inno Setup) for Windows?

Not a priority

  • Implement (from command line) “export to anonymisation staging database” = with patient info per table. (Extend cc_dump.py. See generate_anonymisation_staging_db(), and it’s also temporarily disabled in the master command-line handler.) Framework very partly done; search for db_patient_id_per_row.
    • Best to implement by fixed column names for all ID numbers, e.g. _patient_idnum1, _patient_idnum17, etc.? NULL if absent.
  • Upgrade Qt to 5.12 LTS.
  • FHIR support via fhirclient.
  • Restore autogeneration of CRIS and CRATE data dictionaries. See cc_anon.py etc.
  • Introduce f-strings; requires Python 3.6+. Needs check against CPFT CentOS version.
  • More generic e-mails to administrators, via backend task. (E-mail framework now in place.)
  • Move research export dumps to backend (via e-mail)?

17.4. Documentation

  • Finish manual esp. web site user guide.

17.5. Wishlist and blue-sky thoughts

Server-side “all tasks in full” view, like a clinical text view but for researchers?

A “research multi-task view” would be an easy extension to the task collection classes used for trackers and CTVs, if there is demand.

Improvements to “camcops merge_db” facility

The merge facility doesn’t yet allow you to say “ID#8 in database A means something different to ID#8 in database B; don’t merge that”. Should it? (Example: “research ID” that is group-specific, versus “NHS number” that isn’t.) More generally: should some ID numbers be visible only to certain groups?

Server-side ability to edit existing (finalized) task instances?

Would be done in a generic way, i.e. offer table with {fieldname, comment, old value, new value}; constrain to min/max or permitted values where applicable; at first “submit”, show differences and ask for confirmation; audit changes. For BLOBs, allow option to upload file (or leave unchanged).

Client-side index of tasks by patient ID, to speed up lookup on the tablet?

Might be worthwhile on the client side as the number of tasks grows. (The server already has indexing by patient ID.)

MRI triggering on task side

For example: CamCOPS tasks running on a desktop and communicating via TCP/IP with a tool that talks to an MRI scanner for pulse synchronization and response.

Further internationalization of task strings

Should we add an extra field for an ISO-639-1 two-letter language code (e.g. “en” for English) to the extra strings? Not clear this is required; different servers can already distribute whichever language they want, so the feature would only be relevant for “simultaneously multilingual” environments. Deferred for now.

17.6. Documentation to-do list

Things to do collected from elsewhere in this documentation.


DB_PATIENT_ID_PER_ROW not currently implemented.

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/administrator/server_config_file.rst, line 1187.)


change docs once webview updated for new export system

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/administrator/server_front_end_admin.rst, line 203.)


sort out MySQL dependencies and/or provide database driver advice

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/administrator/server_installation.rst, line 112.)


implement Windows service

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/administrator/server_installation.rst, line 114.)


write Ubuntu specimen installation

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/administrator/server_installation.rst, line 135.)


Current Windows problems: SQL DELETE taking forever during upgrade_db. Probably to do with constraints/triggers. Temporary workaround: use create_db instead. (However, the reindex command works fine.)

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/administrator/server_installation.rst, line 232.)


describe how to get camcops_tasks_snomed.xml

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/administrator/snomed.rst, line 88.)


is_candidate_patient_valid: check against predefined patients, if the group wants

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/envs/latest/lib/python3.6/site-packages/camcops_server/cc_modules/cc_patient.py:docstring of camcops_server.cc_modules.cc_patient.is_candidate_patient_valid, line 7.)


understand SQL Server behaviour (?bug) that causes a neverending DELETE during the upgrade_db command.

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/changelog.rst, line 1673.)


Does this mean that a QML onClicked event behaves differently with respect to touch events depending on whether it’s compiled on a touch-aware or a touch-unaware computer? That might represent a Qt bug; investigate and report if so. In the meantime, compile for Windows on a Surface Book 2 or similar.

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/changelog.rst, line 1874.)


Have the default ID number type configurable per group?

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/introduction/patient_identification.rst, line 101.)


Width of dropdown boxes for dates/spinboxes is too small under Win10 in tablet mode.

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/introduction/requirements.rst, line 77.)


Check: ID/ED-3D “incorrect” sound not playing under Win10, even though “correct” sound works fine (and listed correctly in resource file, and working on other platorms). Investigate.

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/introduction/requirements.rst, line 82.)


This tour is a little outdated; apologies! The screenshots are of the older Javascript/Titanium application, not the newer C++/Qt application, and the server front end has also improved. We’ll update this when we can.

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/introduction/tour.rst, line 25.)


Submit CamCOPS to Apple App Store.

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/user/client_installation.rst, line 78.)


Package CamCOPS client for easier Linux distribution.

(The original entry is located in /home/docs/checkouts/readthedocs.org/user_builds/camcops/checkouts/latest/docs/source/user/client_installation.rst, line 122.)