Release - WatchedList - service to automatically save/restore watched state

  Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
schapplm Offline
Member
Posts: 84
Joined: Apr 2013
Reputation: 2
Post: #166
(2017-07-04 14:57)Boyzie Wrote:  Do not know what I am missing. How could get the export?
It works with the MyVideos107.db
You can not use the query of the MyVideos.db (tables see wiki) for the watchedlist.db (tables movie_watched, episode_watched) since they are completely different...
For the watchedlist.db you have to use the queries from my first answer.

My addon: service.watchedlist
My HTPC: Kodi 17.0; Ubuntu 16.04 LTS x64; AMD A6-6400K; MSI FM2-A55M-E33; 4GB Kingston HyperX RAM; Digital Devices Cine CT V6 DVB-C; Streacom FC8B Evo with 120W picoPSU
find quote
Boyzie Offline
Senior Member
Posts: 170
Joined: Feb 2017
Reputation: 0
Post: #167
Ah yes, very sorry. Many thanks for the links!

Quote:For Windows: In SQLite DB Browser do "Database Structure" > right click on movie_watched > Export as CSV file. The Output can be processed with LibreOffice Calc or Microsoft Excel or a plain text editor

How could I export only the movie titles?

Thank you very much, again

Windows 10 Home, 64bit | Newest stable Kodi in portable mode
find quote
alexxxx Offline
Junior Member
Posts: 1
Joined: Jul 2017
Reputation: 0
Post: #168
Hello all,

I want to see which movies or episodes I have already watched before I download them (again) and see it with WatchedList in Kodi So I wrote a little program for Windows which shows the data of WatchedList.

Cheers,
Alex

Program & sourcecode: written in PureBasic
http://s000.tinyupload.com/index.php?fil...9997228143
https://www.sendspace.com/file/mh63ta

Configuration: watched.ini
database: Location of WatchedList sqlite-database
movies: Query for movies
episodes: Query for episodes
font: Font
fontsize: Fontsize
width: Window-width
height: Window-height

Screenshot:
[Image: VezgQO.jpg]
(This post was last modified: 2017-07-16 14:56 by alexxxx.)
find quote
Post Reply