okfn / opendataeditor

No-code application to explore and publish all kinds of data: datasets, tables, charts, maps, stories, and more. Forever free and open source project powered by open standards and generative AI.
http://opendataeditor.okfn.org
MIT License
150 stars 18 forks source link

Feature request: Metadata import from Qualtrics / RedCAP / Google Forms #323

Open khusmann opened 2 months ago

khusmann commented 2 months ago

One more quick FR that I think is key for adoption for folks in my field!

I want to be able to connect my Qualtrics / RedCAP and Google Forms account to the ODE so that I can download survey data with the metadata from the survey items already filled in.

Without this, people in my position will have to manually re-type 1000s of item text, options, and validation rules into the ODE.

I know this is possible with the Qualtrics API (I have written my own converter for this in my own data pipeline), but I have not looked too closely at the RedCAP and Google Forms APIs.

(@romicolman)

pschumm commented 1 month ago

I have a package that does this for REDCap (https://gitlab.com/pschumm/data-forge), and is fairly efficient. Specifically, you simply point it at a REDCap instance, and with just a couple lines of code you can get a complete Frictionless data package from one or more forms. You could build on that if you want, or just take the useful pieces. If you decide to do so, I would be glad to participate as my schedule allows.