diff options
| author | breadcat | 2020-07-25 14:28:37 +0100 |
|---|---|---|
| committer | breadcat | 2020-07-25 14:28:37 +0100 |
| commit | 1247795992ca2ea8e387f489e068acb7dd55dbf0 (patch) | |
| tree | 347b29357969d81a1885fd2ce44b774fd0c49326 /content/posts/kodi-watched-list-export.md | |
| parent | ec4d17e3f81dda4472a50a79823f50d800207b83 (diff) | |
| download | blog.minskio.co.uk-1247795992ca2ea8e387f489e068acb7dd55dbf0.tar.gz blog.minskio.co.uk-1247795992ca2ea8e387f489e068acb7dd55dbf0.tar.bz2 blog.minskio.co.uk-1247795992ca2ea8e387f489e068acb7dd55dbf0.zip | |
Update posts to reflect URL changes
Diffstat (limited to 'content/posts/kodi-watched-list-export.md')
| -rw-r--r-- | content/posts/kodi-watched-list-export.md | 4 |
1 files changed, 2 insertions, 2 deletions
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 ``` |