Updates to the EDRN Data Model

[hoodriverheather]

Please update the EDRN Data Model Tool posted on the Portal:

https://edrn.nci.nih.gov/data-and-resources/cde/edrn-data-model/

• Separate the Models: Split the Biomarker and Data Commons models to improve clarity and usability.

• Revise the Spreadsheet:

  • Include only relevant data model information in the posted spreadsheet.
  • Add a README tab at the beginning, and either remove the Structure tab, if possible, or move it to the end with an explanation in the README. Use the README tab in the EDRN LabCAS Data Model Sheet as a reference.

• Add Navigation Instructions: Include instructions for navigating the Biomarker Data Models and Cancer Biomarker Data Commons (LabCAS Data Model).

@elawsgh - please add comments if there’s anything you’d like to clarify or add.

NOTE: Updated bullet list above to indent items specific to "Revise the Spreadsheet"

[nutjob4life]

@hoodriverheather the "Structure" tab is necessary since it contains the description of each entity in the model, the stewardship information, and, critically, the parent/child relationships of each entity. We can move it to the end, but deleting it is impossible.

For reference:

• Biomarker data model is now at this location in GDrive, id = 1Kjkvi-bF5GNpAzvq4Kq6r4g1WpceIyP0Srs2OHJJtGs/
• LabCAS data model is now here in GDrive, id = 1btbwoROmVbZlzSLBn3DQ_6rakZ48j24p-NoOkI3OCFg

To do:

• README from this spreadsheet copied to the above two new spreadsheets.
• Note on the "Structure" tab added to each spreadsheet
• Update software

[nutjob4life]

Technical notes:

(These are for @nutjob4life's reference. No need to even read this.)

• Class CDEExplorerPage should go away (but not in this release since we need it to support deleting it)
• Replace the edrn-data-model (via slug) with a FlexPage (management command)
• Move (or dupe) GDrive and tree nodes from edrnsite.content to edrnsite.streams
• Tie specific tree roots to a Wagtail "block"
• Inject footer JavaScript if tree "block" is present to activate the triangles
• Add issue to remove obsolete CDEExplorerPage in future release, see Remove obsolete CDEExplorerPage #388
• Fitting multiple "Update from Google Drive" buttons tricky—use a single site-wide button?

[nutjob4life]

@hoodriverheather ready for you to take a look

Some things to note:

• There's a lot more flexibility now in that a "data element explorer" is now just another block type, like a "rich text block" or a "typed table block", and these can go on any "web page" type now or in the future
• There's some limitations about what text can go where, so things don't exactly match your red text in the screenshots above
• The link to the data model page is the same but changing the content type removes the link from the parent page; don't be alarmed. It's best to "fix it in post" using Wagtail editing (takes 60 seconds) than write the 50 lines of code needed to do it with the release (takes 2 hours)

If you want to go over it together, that's fine too. Thanks for your patience! As you can see from the diffs, this was a big change

[hoodriverheather]

@nutjob4life this is looks good! The link to the to open the LabCAS data model sheet isn't working. See screenshot below. If i want to updated the readme tab, can I just use the link in the comment above? That link works :)

Gotta go make dinner - I'll keep testing tomorrow.

[nutjob4life]

@hoodriverheather nice catch! I've made the software fix and am re-deploying the dev site. It should be ready in about 15 minutes.

[hoodriverheather]

@nutjob4life looks great!

[nutjob4life]

Thanks @hoodriverheather! Will include this in the code-freeze for release to NCI.

[hoodriverheather]

@nutjob4life Thanks! Just now wondering if Emily should take a look before you push. She's the one that made the suggested updates and is not as familiar as we are with how to use this page. WDYT?

[nutjob4life]

Tagging @elawsgh

Did you want to take a look at this too?

Does it look okay? The code freeze is 2025-01-17 at 3pm PT. If you don't want these features to go out, say so ASAP.

[elawsgh]

@nutjob4life @hoodriverheather I did review it yesterday when I got the message. I really like how it was implemented and noticed the LabCAS data model sheet couldn't be opened, and then saw that Heather has pointed it out. So all is good now and please get it out when you can. Thanks!

[nutjob4life]

@elawsgh thank you! This will be included in the code freeze.

Have a nice day everyone.

[nutjob4life]

@elawsgh and @hoodriverheather this is now live in production

One further refinement which we can do outside of the software release is get rid of the top level "root" triangles which seem redundant. When everything was in one "tree", it made sense, but now that there are two "trees" under big level-2 headings, it seems like we're forcing an extra click on users now.