Tony, thanks.
On Friday, July 14, 2017 at 9:28:48 PM UTC-4, TonyM wrote: > > > A practical real world question arises to me and that is how will it > handled subsequent imports from the same source?, it would be fantastic if > it could update existing items without removing additional notes applied to > the different objects (I imagine this is already so), and if it could > identify deletions and flag them it would be very cool, because you would > be able to build and maintain a database from multiple "as at" time reports. > > > I added an additional field to the xlsx import <http://sunypoly-schedule-explorer.tiddlyspot.com/#%24%3A%2Fplugins%2Ftiddlywiki%2Fxlsx-utils%2Fcontrols> to accomplish this. The imported tiddlers link to tiddlers titled static-{{!!title}}. So you can edit the static tiddlers, and reimport data, and your static tiddlers won't be overwritten. This has made me realize that I've created a general purpose "tiddly wikipedia table annotator" as you can use =importHTML function in google sheets to scrape any table in any wikipedia page (any html page, really), and then the xlsx tiddly wiki importer to import rows of the table as tiddlers, and this set of templates to allow annotation at cell level, including column headings. This will work well for an assignment in my DesignWriteStudio / TiddlyWiki classes; gives writers (importers) an opportunity to add content (as @TiddlyTweeter wants!) in a rich way. More generally, this becomes a simple table annotator as well. Thanks for the ideas. Oh, and please, add these features yourself into the next gen. Or bring into a github and make a plugin... //steve. > On Saturday, 15 July 2017 07:48:30 UTC+10, stevesuny wrote: >> >> Folks, >> >> >> Thanks to some timely help (thanks Mark & Eric), I've developed an >> interpretive lens onto a spreadsheet. >> >> >> See http://sunypoly-schedule-explorer.tiddlyspot.com/ for an example. >> >> >> >> - Demonstrates import of spreadsheet data into navigable space. One >> row per case. Each column a field in each case (as defined in xlxs plugin >> import manager). Every column/field is can be clicked on to create lists >> of >> tiddlers matching field value. >> - Start in Classes >> <http://sunypoly-schedule-explorer.tiddlyspot.com/#Classes> , and >> select one. Then select one of the class fields (such as instructor or >> days, etc. >> - A tiddler is created (see schedule elements template >> >> <http://sunypoly-schedule-explorer.tiddlyspot.com/#schedule%20elements%20template>, >> >> and then rendered using template field value template >> >> <http://sunypoly-schedule-explorer.tiddlyspot.com/#field%20value%20template> >> to >> display matching tiddlers. >> - No other code needed. >> - To do >> - clean up names of things like "schedule-elements" and >> "element-fields" etc. >> - consider writing tiddlers to temp files >> >> Comments/ suggestions/ improvements welcome. >> >> >> >> //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 tiddlywiki+unsubscr...@googlegroups.com. To post to this group, send email to tiddlywiki@googlegroups.com. 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/84f7e1dc-8558-434e-9212-629c4bbbc5f0%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
