Hello folks, I'm an avid user of the xlsx import plugin (see http://tiddlywiki.com/prerelease/editions/xlsx-utils/ ) using it for various purposes, including having students complete google forms and importing their responses to a class wiki, as a way to build student engagement with their texts (textbooks, articles, etc.). I'm beginning to roll out this approach to other faculty as well through a series of workshops & conferences.
One way that my colleagues are considering is to create a google form that students complete, and to import the submissions into a tiddlywiki file. For example: https://docs.google.com/forms/d/e/1FAIpQLSc9xmQ7sDbqAmSIZr-xe0dGGkum_QiorJlhqAMEF6leNbzGHA/viewform Recall that Google Forms saves its responses to Google Sheets, which are then downloaded as xlsx files. Google accomplishes this by taking the question text from the form and using it as the column heading. That column heading is then used by the xlsx plugin to become aligned to a field. Thus, the column heading (or, in this case, the question text) becomes the field name or tiddler title. It occurs to me that one way to make the process of importing a spreadsheet much, much easier would be to establish this as default (or option): 1. Designate a specific Column (ColA, ColB,etc) as the tiddler title. 2. Auto assign fields by columns. In other words, import contents of column A into field ColA; contents of column B into field ColB, etc. 3. Create "caption" or "label" tiddlers with import sheet name-column as title (Sheet-ColA) and question text as either text field or caption field. This would make the import process much faster and transparent, and leverage the work of the forms creator / spreadsheet creator into the wiki. Is this a trivial change to the plugin? Any other thoughts on ways to improve this really useful plugin? //steve. -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/tiddlywiki. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/af2deecc-5e49-4d0d-b557-d50742bb0b05%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
