How to bulk delete GristHidden_import

Ask for Help
1

On a self hosted instance of grist, i have ~100 hidden Imports of a huge excel sheet in the raw data.
What is the best way to bulk delete those?

2

I’ve build an UGLY (horrible and dangerous) hack…

I’ve automated the browser.

async function removeAllHiddenImports() {
  const sleep = ms => new Promise(r => setTimeout(r, ms));

  while (true) {
    var elems = document.getElementsByClassName("test-raw-data-table")
    foundElem = undefined
    for (var idx = 0; idx < elems.length; idx++) {
      var elem = elems[idx];
      if (elem.textContent.includes("GristHidden")) {
        foundElem = elem
        console.log("found")
        break
      }
    }

    if (foundElem === undefined) { 
      console.log("DONE!!!")
      return
    }

    var elem = elems[idx];
    console.log(elems[idx].textContent);

    var but = elem.getElementsByClassName("test-raw-data-table-menu")[0]
    console.log(but)
    but.click()

    // get floating menu
    await sleep(500)
    var flo = document.getElementsByClassName("test-raw-data-menu-remove")[0]
    flo.click()
    await sleep(500)
    console.log(flo)
    var conf = document.getElementsByClassName("test-modal-confirm")[0]
    conf.click()
    await sleep(1500)
    
  }
}
removeAllHiddenImports()

edit: Opened an issue Button for bulk Delete GristHidden_import · Issue #360 · gristlabs/grist-core · GitHub