[tw] Re: A TiddlyWikified Lens on Spreadsheets

[stevesuny]

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 

 
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 
>> , and 
>>select one. Then select one of the class fields (such as instructor or 
>>days, etc.
>>- A tiddler is created (see schedule elements template 
>>
>> ,
>>  
>>and then rendered using template field value template 
>>
>>  
>> 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.

[tw] Re: A TiddlyWikified Lens on Spreadsheets

[PMario]

Hi Steve,

Interesting. ... You could create a "backdrop" tiddler like this: 

title:  $:/config/EmptyStoryMessage

{{HelloThere||$:/core/ui/ViewTemplate}}


With this configuration, the "HelloThere" tiddler will be allways on, if 
the story is empty. 

have fun!
mario

-- 
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/e29d112a-dd54-4f8b-bcb4-913bb059597d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[tw] Re: A TiddlyWikified Lens on Spreadsheets

[Jiří Veselý]

Dne sobota 15. července 2017 3:28:48 UTC+2 TonyM napsal(a):
>
> 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 
>> , and 
>>select one. Then select one of the class fields (such as instructor or 
>>days, etc.
>>- A tiddler is created (see schedule elements template 
>>
>> ,
>>  
>>and then rendered using template field value template 
>>
>>  
>> 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/9e2cb349-68cc-430c-8b8a-5d5df5c4407d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[tw] Re: A TiddlyWikified Lens on Spreadsheets

[TonyM]

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 
> , and 
>select one. Then select one of the class fields (such as instructor or 
>days, etc.
>- A tiddler is created (see schedule elements template 
>
> ,
>  
>and then rendered using template field value template 
>
>  
> 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.

[tw] Re: A TiddlyWikified Lens on Spreadsheets

[@TiddlyTweeter]

Ciao Steve 

Its really impressive in its scope and organisation.

Its a mess as a demo. THERE IS NO REAL CONTENT in anything I could find. 

*What's the point other than proving you can create a skeleton? *

IMO you need content FLESH too to make it real. To show what its all FOR.

Given the vast numbers of things it covers I really don't understand why 
they all lack details. There is NO WAY you could manually enter the data 
needed to fill them unless you got a full-time typist. 

Surely the point would be to POPULATE the end Tiddlers with substantive 
information on import? I do not understand why you are flagging this up 
before that was achieved.

I'm a bit of concretist. x

Best wishes
Josiah

On Friday, 14 July 2017 23:48:30 UTC+2, 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 
> , and 
>select one. Then select one of the class fields (such as instructor or 
>days, etc.
>- A tiddler is created (see schedule elements template 
>
> ,
>  
>and then rendered using template field value template 
>
>  
> 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/0c81a25e-a0c5-4257-8844-eca61218c0f8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.