Tutorial Example that stores tutorial event information in a Google Spreadsheet

[schloerke]

Make an example tutorial that saves all tutorial events to a google spreadsheet.

Possible features:

• Use options(tutorial.event_recorder = FUNC)
• Use googlesheets4 https://googlesheets4.tidyverse.org/
• Use a local .Renviron file to store passwords (maybe?)
  • Would allow for the tutorial to be shipped to shinyapps.io and still work. (System environment variables are not able to be set on shinyapps.io)

[dtkaplan]

I'm working on just such a thing. It will be very simple, but it might give you some ideas. I'm hoping to have a complete (draft) package by the start of next week.

…

On Sat, Mar 14, 2020 at 10:50 AM Barret Schloerke ***@***.***> wrote: Make an example tutorial that saves all tutorial events to a google spreadsheet. Possible features: - Use options(tutorial.event_recorder = FUNC) - Use googlesheets4 https://googlesheets4.tidyverse.org/ - Use a local .Renviron file to store passwords (maybe?) - Would allow for the tutorial to be shipped to shinyapps.io and still work. (System environment variables are not able to be set on shinyapps.io) — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#341>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAECBLNQZ52Z2HAKCSFXOS3RHORTNANCNFSM4LJJL7IA> .

[coatless]

@dtkaplan is this revisiting checkr?

https://github.com/dtkaplan/checkr

[dtkaplan]

Not yet. I just want to get a recorder working pronto, so that people can use it during this COVID-19 remote-teaching episode.

…

On Sat, Mar 14, 2020 at 12:27 PM James J Balamuta ***@***.***> wrote: @dtkaplan <https://github.com/dtkaplan> is this revisiting checkr? https://github.com/dtkaplan/checkr — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#341 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAECBLNXUPETPMRKIM44BI3RHO5BFANCNFSM4LJJL7IA> .

[dtkaplan]

I have posted an example learnr tutorial that records events to this GoogleSheet

The software behind it is available as install_github("dtkaplan/submitr"). The tutorial itself is attached, named with a TXT extension (so GitHub will accept it) -- you'll want to change the extension back to Rmd.
Testing.txt

Now some information that would not ordinarily be available to anyone but the instructor:

You can look at the Google Sheet here. Please don't edit it.

There are four users registered for the tutorial. You can see their IDs and passwords here. Feel free to sign in as any of them.

Toward the bottom of the sign-in page there is a text box labeled "For instructor". When you type in the "secret" code, a button will appear allowing you to download the submissions as a CSV file to your browser. The secret is "hello".

[dtkaplan]

There's now a vignette for the submitr package:

install_github("dtkaplan/submitr", build_vignettes = TRUE)

[ntaback]

This looks interesting. I tried to install, but it failed. Any thoughts on how to fix. Thanks.

> devtools::install_github("dtkaplan/submitr", build_vignettes = TRUE)
Downloading GitHub repo dtkaplan/submitr@master
✓  checking for file ‘/private/var/folders/d2/n3vzkgd94ml2_mjrb49f2vpm0000gn/T/RtmpwfiFNX/remotes6ca1657f719c/dtkaplan-submitr-a3e13b5/DESCRIPTION’ ...
─  preparing ‘submitr’:
✓  checking DESCRIPTION meta-information ...
─  installing the package to build vignettes
         -----------------------------------
─  installing *source* package ‘submitr’ ...
   ** using staged installation
   ** R
   ** data
   *** moving datasets to lazyload DB
   ** inst
   ** byte-compile and prepare package for lazy loading
   Error: object ‘sheets_append’ is not exported by 'namespace:googlesheets4'
   Execution halted
   ERROR: lazy loading failed for package ‘submitr’
─  removing ‘/private/var/folders/d2/n3vzkgd94ml2_mjrb49f2vpm0000gn/T/Rtmpy1ARAn/Rinst6cc4303b8326/submitr’
         -----------------------------------
   ERROR: package installation failed
Error: Failed to install 'submitr' from GitHub:
  System command error, exit status: 1, stdout + stderr (last 10 lines):
E> ** data
E> *** moving datasets to lazyload DB
E> ** inst
E> ** byte-compile and prepare package for lazy loading
E> Error: object ‘sheets_append’ is not exported by 'namespace:googlesheets4'
E> Execution halted
E> ERROR: lazy loading failed for package ‘submitr’
E> * removing ‘/private/var/folders/d2/n3vzkgd94ml2_mjrb49f2vpm0000gn/T/Rtmpy1ARAn/Rinst6cc4303b8326/submitr’
E>       -----------------------------------
E> ERROR: package installation failed

[rpruim]

You need the github version of googlesheets4 IIRC.

@dtkaplan, can you edit the DESCRIPTION file to require a new enough version?