Hi Jon, How did you initially import the CSV, just drag and drop? I can't seem to find the demo or documentation. When I import, the csv is a "type: application/vnd.ms-excel" Thank you
On Monday, June 15, 2020 at 2:01:53 AM UTC-4 Jon wrote: > Thanks Joshua and for the extra bit about the message. > > After using your suggestion for the filtering syntax, I actually like the > idea of keeping everything bundled as a plugin - what I've imported is 19 > years' worth of diary entries, so I'm not going to edit them anyway and I > like the warning message which pops up if I attempt to (but it's good to > know I can unpack them if needed). After opening, they also don't appear in > the recent tab which also suits me by keeping that free. > > Just as an aside, I noticed that I wasn't able to drag and drop the diary > plugin into another wiki - nothing is imported. > > Thanks again. > Jon > > On Sunday, 14 June 2020 23:41:57 UTC+1, Joshua Fontany wrote: >> >> Excellent work figuring out the Filter syntax needed to set the title! >> >> Handling all the possibilities around CSV data in a flexible way was a >> complicated problem, so thank you for the feedback (notes for the next >> version's UI, which is a while out). >> >> In order to get rid of the shadow tiddler warning, once you have >> confirmed that the source plugin is unpacked to your specs, you can simply >> delete the source plugin tiddler. It will leave all the "modified" tiddlers >> behind. >> >> Best, >> Joshua Fontany >> >> On Sunday, June 14, 2020 at 9:22:56 AM UTC-7, Jon wrote: >>> >>> Hi Joshua, >>> >>> A bit more experimenting and yes, it does appear that using another >>> field for the created date does allow for correct sorting etc. >>> >>> I also found that adding a 'tags' column in the spreadsheet is respected >>> for the import and so a tag is added to each tiddler. >>> >>> Thank you! >>> >>> Regards >>> Jon >>> >>> On Sunday, 14 June 2020 16:32:11 UTC+1, Jon wrote: >>>> >>>> Just played around with this a bit and having the 'title' in the 1st >>>> column of the spreadsheet, setting the primary key to 0 and then >>>> putting [<primaryKey>] in the box for the shadow name filter names the >>>> resulting tiddlers with the 'title' field - so all good! >>>> >>>> With regard to the creation date, if I gave it a different name (so >>>> that it is imported), I suppose I could still perform ordering and >>>> searching etc. in the same way. >>>> >>>> Good to have some confirmation of this before I go any further. >>>> >>>> Thanks >>>> Jon >>>> >>>> On Sunday, 14 June 2020 12:37:24 UTC+1, Jon wrote: >>>>> >>>>> Hi Joshua, >>>>> >>>>> The unpacking worked really well and things are looking promising but >>>>> there are few glitches I can't get past. >>>>> >>>>> For the .csv file to import, I included the fieldnames 'title' 'text' >>>>> & 'created'. >>>>> >>>>> The text field appeared in the body of the tiddler as it should but >>>>> the created & title fields appear to be absent. >>>>> >>>>> Instead, the name of the tiddler is derived from the name of the >>>>> plug-in. >>>>> >>>>> I noticed there is an option to define the primary key and as the >>>>> title field is in the first row of the spreadsheet, I chose the column 0 >>>>> option. >>>>> This created a name for each tiddler which includes the contents of >>>>> the 'title' field but combined with the name of the plugin - so perhaps a >>>>> bit of tweaking will solve this easily. >>>>> >>>>> Also, I notice that for the unpacked tiddlers, there is still a >>>>> message which appears in edit mode: >>>>> >>>>> "This is a modified shadow tiddler. You can revert to the default >>>>> version in the plugin Data/Metrics - HH by deleting this tiddler" >>>>> >>>>> Regards >>>>> Jon >>>>> >>>>> >>>>> This is a modified shadow tiddler. You can revert to the default >>>>> version in the plugin Data/Metrics - HH by deleting this tiddler >>>>> >>>>> On Sunday, 14 June 2020 07:25:46 UTC+1, Jon wrote: >>>>>> >>>>>> Hi Joshua, >>>>>> >>>>>> many thanks for getting back to me with the missing piece. >>>>>> >>>>>> I'll have a go later and report back. >>>>>> >>>>>> Regards >>>>>> Jon >>>>>> >>>>>> On Sunday, 14 June 2020 00:46:13 UTC+1, Joshua Fontany wrote: >>>>>>> >>>>>>> Hi Jon, author of JsonMangler here. I setup the import to package >>>>>>> the imported tiddlers into a plugin to have a simple way of >>>>>>> overwriting.updating/deleting a whole import at once. >>>>>>> >>>>>>> The way that tiddlywiki is setup, "shadow" tiddlers are full >>>>>>> tiddlers in the system (beware of confusing this with "system" tiddlers >>>>>>> that start with "$:/" because something can be both a shadow and a >>>>>>> system >>>>>>> tiddler). >>>>>>> >>>>>>> Meaning that you can search for and/or filter-query any "shadow" >>>>>>> tiddler just like any other tiddler, BUT you have to start your filter >>>>>>> runs >>>>>>> with `all[shadows+tiddlers]` instead of the default (asumed if missing) >>>>>>> `all[tiddlers]`. The one special feature of shadow tiddlers is that you >>>>>>> can >>>>>>> edit them, creating a "regular" tiddler of that name to store the >>>>>>> edits, >>>>>>> and then if you delete the edited version the "backup/shadow" version >>>>>>> is >>>>>>> immediately referenced in its place. >>>>>>> >>>>>>> For example, after importing the Video Games CSV in my example wiki, >>>>>>> you can hit the Filter tab of $:/AdvancedSearch and enter >>>>>>> `[all[shadows+tiddlers]search:*[Mario]]` to display links to all >>>>>>> references >>>>>>> to "Mario". >>>>>>> >>>>>>> If you want to promote a shadow tiddler to a regular one, the >>>>>>> easiest way to do that is a weird little hack I picked up, where you >>>>>>> setup >>>>>>> a button to delete a field that DOES NOT EXIST from each shadow >>>>>>> tiddler, >>>>>>> like so: >>>>>>> ``` >>>>>>> \define plugin-target() Data/vgsales >>>>>>> \define unpack-actions() >>>>>>> <$list variable="shadowtiddler" >>>>>>> filter="[<plugin-target>indexes[/tiddlers]]"> >>>>>>> <$action-setfield $tiddler=<<shadowtiddler>> >>>>>>> $field="does.not.exit.in.this.wiki452369084306093845760894253" /> >>>>>>> </$list> >>>>>>> \end >>>>>>> >>>>>>> <$button actions=<<unpack-actions>> > >>>>>>> Press here to unpack <<plugin-target>> >>>>>>> </$button> >>>>>>> >>>>>>> <$list variable="test" filter="[<plugin-target>indexes[/tiddlers]]"> >>>>>>> >>>>>>> </$list> >>>>>>> >>>>>>> ``` >>>>>>> This creates a regular tiddler that is identical to the shadow, for >>>>>>> each one in the plugin-target. Change the definition of that line to >>>>>>> your >>>>>>> target plugin containing yuor imported tiddlers and it will "unpack" it >>>>>>> for >>>>>>> you (you will no longer need `all[shadows+tiddlers]` in filters to >>>>>>> target >>>>>>> the "unpacked" tiddlers). You will see the links to your tiddlers go >>>>>>> from >>>>>>> being Bold to normal font to show that they are now "overwritten shadow >>>>>>> tiddlers", and exist as normal tiddlers in the wiki. >>>>>>> >>>>>>> Best, >>>>>>> Joshua F. >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Saturday, June 13, 2020 at 12:40:10 AM UTC-7, Jon wrote: >>>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> I'm importing a .csv file and I want each row to be a separate >>>>>>>> tiddler. >>>>>>>> What's the best way to do this? >>>>>>>> >>>>>>>> I have tried TW5-JsonMangler/ >>>>>>>> <https://joshuafontany.github.io/TW5-JsonMangler/> where "each >>>>>>>> individual row is rendered to a tiddler, then these tiddlers are >>>>>>>> packaged >>>>>>>> as shadow-tiddlers into a plugin." >>>>>>>> but then there doesn't appear to be any instructions as to what to >>>>>>>> do with the resulting plugin (sorry, I'm only an end user). >>>>>>>> >>>>>>>> Any guidance about using this method or an alternative much >>>>>>>> appreciated. >>>>>>>> >>>>>>>> Regards >>>>>>>> Jon >>>>>>>> >>>>>>> -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/2445f6f7-82e0-452b-a1b1-a24eb8e87956n%40googlegroups.com.
