stevesunny Thanks for sharing that, I am really impressed. I will look into your method in more detail as I think this method may be key a number of ways to handle data in tiddly wiki. I see the data is in the relationships between a large number of "objects".
Of course over the internet it is quite slow and that's in my Firefox with dom.max_script_run_time in about:config up from 10 as high as 80 Now, yet I still get timeouts. Perhaps you could introduce a feature to display the instances grouped by N prefix characters such as Rooms by 1st letter/number Classes by first 2-3 letters Instructor by first letter If handled correctly they will not need to be rendered until you open a sub group and thus operate more quickly and the amount of data would be less intimidating. 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. Great Work Thanks 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/27643cca-413b-4409-b666-9a6ae9aaef3a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.