Hi all! I know I've been spamming the forum the last few weeks, and I promise this is my last one. I've just had a few tools I've put together over the last couple of years for my own workflow. While I recognize that some of these tools may be only useful to me - I thought I'd post them here in the off chance that someone else might find them useful and be able to borrow or copy any example.
It's a codebook generator for ODK.
I create a lot of surveys in ODK, and usually do so by creating the form first in excel, and then uploading to a kobo server or ONA (and now possibly Get ODK). I often, then, later have a need to create a single document with a codebook - especially when handing a dataset over to a different data analyst. I had been using the LINKS Codebook Generator that Nafundi and Task Force created. However, I found that was often insufficient for my needs, and new development seems to have gone dormant since 2013. I wrote ny own R Shiny app for a few reasons:
- More sophisticated calculations, like
pulldata(), broke the LINKS codbook generator (it may have been a function that was added after the generator was supported).
- Additionally, I wanted a codebook which showed skip patterns and calculations.
- Finally - it output the codebook into pdf format, which made edits or rearranging more challenging.
Since I always start my XFORMS in Excel, it made sense to simply create an app that would take an xls form and turn it into a single sheet codebook. So, I wrote a few lines of R code and made this!
This is a simple project, but open source. You can find the code for this and other apps here. If you find it useful, you can use the one hosted at figured.io, or copy the code and deploy your own! Currently, this only takes xlsx forms. If you develop your forms in Excel, you can upload it directly here. If you work in kobotoolbox or ONA, you should be able to download your work as an xlsx file and do the same. At some point, I may add support for XForms in XML, but the parser for that will add a considerable level of sophistication that I just don't need or use. If that is of any interest to you, comment on my github or send me a message there.
- You cannot use a file with multiple languages. Currently, only the
labelcolumn will be recognized. If you want multiple languages - currently, you'll need to manually upload different versions with just "label".
- There may be versions of ODK that the current codebook maker will not work for.
Both of these issues should be infrequent, but will be addressed in future versions. Find the source code for this app under a GNU license at https://github.com/jwilliamrozelle/figuredio.