Hi Osin, Sorry, I've not been on the site for a bit so missed your post.
I actually imported the .csv file using Joshua's Json Mangler as referenced above. I figured out a few things that were needed, but they're referenced in the thread above as well. Regards Jon On Thursday, 14 January 2021 at 17:31:41 UTC Osin wrote: > 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/34753945-922e-4e26-937a-f57251e4229en%40googlegroups.com.