EDRN data model spreadsheet missing

[nutjob4life]

🐛 Describe the Bug

When visiting the EDRN Data Model page, the link View as a spreadsheet goes to Google and Google says "Sorry, the file you have requested has been deleted."

Did the spreadsheet get deleted? Is there a copy somewhere?

📜 How To Reproduce

Put steps to reproduce the behavior here, including URLs, such as

1. Go to the EDRN production portal
2. Under "Data and Resources", click "Informatics"
3. Click "LabCAS"
4. Click "EDRN Data Model"
5. Click "View as a spreadsheet"

🔎 Expected Behavior

A spreadsheet 😅

🖼 Screenshots

[hoodriverheather]

@nutjob4life That's strange. I think it's this one https://docs.google.com/spreadsheets/d/1xrtQkEO0kkuJQbK7cqQR70sep_prsL_X3vvCU-dT3a0/edit#gid=604377651 Does it need to be shared or put somewhere different?

[nutjob4life]

Oh that's a different one all right.

Up until this issue, the portal was using GDrive spreadsheet 1PAVUvmi0J-j6fK5dpltRIW8vRzVjh4kzpNReGFOQIe4 but this one is 1xrtQkEO0kkuJQbK7cqQR70sep_prsL_X3vvCU-dT3a0.

And this one only has Collection, Dataset, and Files—no DMCC or BMDB data elements. And it's missing the "Stewardship" column.

I wonder what happened to the original 😬

[hoodriverheather]

@nutjob4life Oh dang! you're right. I don't know where that is, was that something you created with the additional BMDB data elements?

[nutjob4life]

@hoodriverheather, I believe it was originally in your GDrive, shared with me, and we both collaborated on it. We added the additional tabs for the DMCC and BMDB CDEs. I believe the last update was to the "Structure" tab, adding the "Stewardship" information that Dan wanted.

If it's gone, we can re-create it from what we have in the portal. It'll take a while, though ☹️

[hoodriverheather]

@nutjob4life OK, i think i found it in my JPL GDrive :) https://docs.google.com/spreadsheets/d/1xrtQkEO0kkuJQbK7cqQR70sep_prsL_X3vvCU-dT3a0/edit#gid=906699802 Let me know if this isn't it.

[nutjob4life]

Argh, I'm afraid that isn't it. The spreadsheet we used to have had the following tabs:

• Cancer Biomarker Data Commons
• Collection
• Dataset
• File
• Biomarker Data Models
• Biomarker Database
• Biomarker
• Biomarker-Organ
• Biomarker-Organ-Study
• Biomarker Study Data
• Body System
• Disease
• Site
• Person
• Protocol
• Publication
• Structure

Do you have anything with those tabs? If not, I think it's gone forever 😭

[hoodriverheather]

@nutjob4life UGH! I can't find it. If you know of a good way to search I would be happy to try :(

[nutjob4life]

I think we'll have to re-create it. I'll work on that over the weekend

[hoodriverheather]

:(

[nutjob4life]

So much for the weekend! I've had to put this on hold multiple times as other priorities bubbled up.

I'm working on this again. The new spreadsheet is in a GDrive owned by edrn-bot@jpl.nasa.gov.