How to export a list of all tiddlers with url (on website or though node)

#1

Hello,
I wanted to export a csv file for all the tiddlers I’ve written.
http://wwwhww.news/u/cwSNkeLNXf#Year-in-Review(2022)

I should get something like

csv:
@lucasmanual — Technology, Strategy, and Leadership @lucasmanual - Powered by w5hnews.com,
@lucasmanual — Technology, Strategy, and Leadership @lucasmanual - Powered by w5hnews.com,
…aka each url with Example Domain,
@lucasmanual — Technology, Strategy, and Leadership @lucasmanual - Powered by w5hnews.com,
@lucasmanual — Technology, Strategy, and Leadership @lucasmanual - Powered by w5hnews.com,

Thanks
Lucas

#2

Have you looked at this csvtiddlers Macro ?

I created this as a result and your example online;

<$macrocall $name="csvtiddlers" filter="[!is[system]] :filter[get[created]prefix[2022]] +[sort[title]]" format="quoted-comma-sep" $output="text/raw"/>

The result is displayed as a valid CSV

  • There is currently no way to exclude fields however in many cases you can ignore or delete columns when importing a CSV into excel etc…

Perhaps a request to allow a list or filter to include or exclude fields used in the csvtiddlers Macro could be raised.

#3

This is good.
Is there a way to run this on a command line instead? or other node package way?

Thanks
Lucas

#4

I prefer interactive solutions and avoid the command line, I am confident it can be done;

Basically you most likely still use the code/template I shared, just have the command line render it and save it.

Have you worked out the filter to list all tiddlers “with url” to give to the csvtiddlers macro.

  • What is “with url?” a field, begins http ?
  • Or is it just get[created]prefix[2022]?
1 Like