JWHoneycutt To export as csv no need to think about the table plugin but once the data is there an independent export can be set up.
Although not fully documented or examples given see the https://tiddlywiki.com/#csvtiddlers%20Macro Basically <<csvtiddlers "filter">> would generate a view of the filtered tiddlers in csv format ready for export, as far as I can see it identifies all the fields, generates A heading row and CSV's each tiddler as a row. It is almost as easy to import CSV's back in, but the JSON mangler is your friend here, I have a utility wiki with JSON mangler for such import export then drag the result to the destination. Regards Tones On Monday, 25 January 2021 at 01:33:10 UTC+11 JWHoneycutt wrote: > OMG - it is embarrassing to learn that clicking the column header sorts > the whole table. I should have tried that first. > > Thank you Mohammad for creating this great solution. Is there a way to > export to spreadsheet format (or CSV) for others (non TW5 users) to add to? > > JWHoneycutt > On Saturday, January 23, 2021 at 9:58:07 PM UTC-5 Mohammad wrote: > >> Note, the table is created from a filter. It i s the main input >> parameter. It makes the rows. After creating the table, you can click on >> the sort (field) column you made to sort the table based on that field. >> By the way, dynamic tables have the feature to sort by each column >> (field), so it does not make sense to use the sort filter operator with >> input filter. >> >> Hope this helps >> >> >> >> Best wishes >> Mohammad >> >> >> On Sun, Jan 24, 2021 at 1:05 AM 'JWHoneycutt' via TiddlyWiki < >> [email protected]> wrote: >> >>> Now my macro is: >>> >>> <<table-dynamic filter:"[tag[Ayacucho]tag[Owner]tag[Person]]" >>> fields:"tbl-expand sort title lot name corp_name corp_number email phone" >>> caption:"''Ayacucho Lot Owners''" sortOp:"nsort" class:"w-100 >>> table-hover-cyan table-center thead-dark" footerRows:"0" stateTiddler:"" >>> editButton:"yes">> >>> >>> It is still sorting the filtered records by tiddler title (but I want it >>> sorted by sort field), because there is no place where I have told it to >>> "nsort[sort]" - right? >>> On Saturday, January 23, 2021 at 3:00:09 PM UTC-5 Mohammad wrote: >>> >>>> See https://kookma.github.io/TW-Shiraz/#demo%2Fdynamic-table-macro >>>> >>>> and study the sortOp. >>>> >>>> >>>> Best wishes >>>> Mohammad >>>> >>>> >>>> On Sat, Jan 23, 2021 at 9:47 PM 'JWHoneycutt' via TiddlyWiki < >>>> [email protected]> wrote: >>>> >>>>> I love Mohammad's solution for dynamic-tables, (Shiraz plugin version >>>>> 2.1.2) but... >>>>> >>>>> I need a little more help making a dynamic table sort correctly. >>>>> >>>>> I created a numeric "sort" field. Entries are (in order) 01, 021, >>>>> 022, 03, 071, 101, 102, 11, etc. >>>>> >>>>> My current best guess still does not work: >>>>> ``` >>>>> <<table-dynamic filter:"[tag[Ayacucho]tag[Owner]tag[Person]]" >>>>> fields:"tbl-expand title lot name corp_name corp_number email phone" >>>>> caption:"''Ayacucho Lot Owners''" class:"w-100 table-hover-cyan >>>>> table-center thead-dark" footerRows:"0" >>>>> stateTiddler:"$:/keepstate/dynamictables/$(sort)$" editButton:"yes">> >>>>> >>>>> ``` >>>>> >>>>> I first assumed I could just make my filter: >>>>> "[tag[Ayacucho]tag[Owner]tag[Person]sort[sort]]" and leave >>>>> stateTiddler:"" (blank), but it does not sort by the "sort" field. >>>>> >>>>> Next try is filter:"[tag[Ayacucho]tag[Owner]tag[Person]" and >>>>> stateTiddler:"sort", still fails. >>>>> How do I get the table to sort by the "sort" field? >>>>> >>>>> (The sort order can be permanent.) - Do I insert this lingo here? >>>>> $:/keepstate/dynamictables/$(currentTable)$ >>>>> >>>>> JWHoneycutt >>>>> >>>>> -- >>>>> >>>> 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 [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/tiddlywiki/79389ea1-4cff-45b1-b8bf-d50d016c4ac2n%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/tiddlywiki/79389ea1-4cff-45b1-b8bf-d50d016c4ac2n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>> 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 [email protected]. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/tiddlywiki/be262d4b-3b07-4717-8d3d-bc0160fdd165n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/tiddlywiki/be262d4b-3b07-4717-8d3d-bc0160fdd165n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/dc603cb3-6049-4cef-88ee-146d93d04925n%40googlegroups.com.
