From 1247795992ca2ea8e387f489e068acb7dd55dbf0 Mon Sep 17 00:00:00 2001 From: breadcat Date: Sat, 25 Jul 2020 14:28:37 +0100 Subject: Update posts to reflect URL changes --- content/posts/kodi-watched-list-export.md | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'content/posts/kodi-watched-list-export.md') diff --git a/content/posts/kodi-watched-list-export.md b/content/posts/kodi-watched-list-export.md index 0786379..abbd1b0 100644 --- a/content/posts/kodi-watched-list-export.md +++ b/content/posts/kodi-watched-list-export.md @@ -4,13 +4,13 @@ date: 2019-01-31T10:25:00 tags: [ "Guides", "Kodi", "Linux", "Media", "Movies", "Servers", "Snippets", "Software" ] --- -As I've outlined in [this page](/archive/movies/) I'd prefer to save space on my server and delete movies once I've seen them but also keep a log so I don't need to remember everything. +As I've outlined in [this page](/archived-movies/) I'd prefer to save space on my server and delete movies once I've seen them but also keep a log so I don't need to remember everything. Step in the Kodi plugin [WatchedList](https://kodi.wiki/view/Add-on:WatchedList) which will happily export your status to a SQLite database that can be worked with as follows: ``` if [ -f "movies.csv" ]; then rm movies.csv; fi sqlite3 -noheader -csv watchedlist.db "select title from movie_watched;" > movies.csv -sed -i -e 's|\"||g' -e 's|^|* |g' movies.csv +sed -i -e 's|\"||g' -e 's|^|* |g' movies.csv sort -k 2 < movies.csv > movies.md rm movies.csv ``` -- cgit v1.2.3