How to get a list of all posts, date, title, category?

I want to be able to show a potential funder a full list of all the posts in my Waikawa News blog, with date, title and category, like the partial list in the attached MarsEdit screenshot.

https://waikawanews.nz

I’ve downloaded the json file and am about to look at the bar file and could use BBEdit to pull out what I want, but wondered if there’s an easier way to get it.

I’d be very happy if there was some Terminal command, for example, I could use.

1 Like

The .bar file (if you rename it .zip and unzip it) has a JSON Feed with all the posts. I’m not sure the best way to get that into more of a text format.

Because you’re using MarsEdit, though, another option would be to script it. I whipped up a little AppleScript that should have the basics:

tell application "MarsEdit"
	set all_posts to posts of first blog
	set s to ""
	set AppleScript's text item delimiters to ", "
	
	repeat with the_post in all_posts
		set s to s & title of the_post & tab
		set s to s & published date of the_post & tab
		set s to s & (category names of the_post as string) & return
	end repeat
	
	display dialog s
end tell

Try pasting that into Script Editor and run it, then copy the resulting text out into a text file. It gets the first blog, so may need some tweaks.

Many thanks. I’ve tested it on a blog with half a dozen posts so will now tweak for the blog I really want.

Much appreciated.