Is anyone else using the xlsx import tool? Just curious.... Another possible development: would it be possible to make a copy of a workbook (and all of its specifications) so that it becomes straight-forward to import 3 or 4 similar workbooks, without having to go through the entire field-level specification?
Thanks, //steve. On Thursday, May 11, 2017 at 11:23:40 AM UTC-4, Steven Schneider wrote: > > 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/7de8c30d-7430-4c90-9517-c6cfac753987%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
