Reply to thread

Message

Ok, I hit a brick wall. I worked out the following:

Tool to use to open / modify database: SQLITE3.exe
commands used:
.mode column
.headers on
.output blah.txt
select * from local_episodes;
.quit

I examine the output and it shows:
[CODE]EpisodeFilename    OriginalComposite CompositeID SeriesID SeasonIndex EpisodeIndex LocalEpisodeName LocalImportProcessed CompositeUpdated AvailableSubtitles OriginalComposite2 CompositeID2 EpisodeIndex2 videoWidth videoHeight FileDateAdded FileDateCreated IsAvailable DateWatched ext    VolumeLabel localPlaytime VideoCodec VideoFormat VideoFormatProfile VideoBitrate VideoFrameRate VideoAspectRatio AudioCodec AudioFormat AudioFormatProfile AudioBitrate AudioChannels AudioTracks TextCount StopTime
---------------------------------------------------------------------- ----------------- ----------- ---------- ----------- ------------ ---------------- -------------------- ---------------- ------------------ ------------------ ------------ ------------- ---------- ----------- ------------------- ------------------- ----------- ----------- ---------- --------------------------- ------------- --------------- ----------- ------------------ ------------ -------------- ---------------- ---------- ----------- ------------------ ------------ ------------- ----------- ---------- ----------
\\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e01 - Pilot.mkv    248741_1x1 248741 1 1    Pilot    2    1    0    0 1920 1080    2013-06-11 14:20:09 2012-12-18 23:17:50 2    mkv    \\mofo\Audio Video Media\TV 1319319 V_MPEG4/ISO/AVC AVC High@L4.1 12675000 23.976 1.778    A_DTS DTS -1 1509000 6 1 -1
\\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e02 - And the B    248741_1x2 248741 1 2    And the Breakup 2    1    0    0 1920 1080    2013-06-11 14:42:28 2012-12-18 23:44:39 2    mkv    \\mofo\Audio Video Media\TV 1286286 V_MPEG4/ISO/AVC AVC High@L4.1 8164000 23.976 1.778    A_DTS DTS -1 1509000 6 1 -1
\\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e03 - And Strok    248741_1x3 248741 1 3    And Strokes of G 2    1    0    0 1280 720 2013-06-11 15:02:31 2012-12-18 17:46:46 2    mkv    \\mofo\Audio Video Media\TV 1299299 V_MPEG4/ISO/AVC AVC High@L4.1 5657000 23.976 1.778    A_DTS DTS -1 1509000 6 1 -1
\\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e04 - And the R    248741_1x4 248741 1 4    And the Rich Peo 2    1    0    0 1280 720 2013-06-11 15:20:25 2012-12-18 18:08:58 2    mkv    \\mofo\Audio Video Media\TV 1293293 V_MPEG4/ISO/AVC AVC High@L4.1 5690000 23.976 1.778    A_DTS DTS -1 1509000 6 1 -1 [/CODE]

(I have no idea why the columns don't line up - they do in the output file and they do when I preview this forum posting. They just don't line up aftwards...) So the following may not seem clear from the table above, but its true:

The 'DateWatched' column is blank for all 25000 episodes!

What column is used in what table to indicate that an episode has been watched?

<blockquote data-quote="dir" data-source="post: 1005546" data-attributes="member: 24485">Ok, I hit a brick wall. I worked out the following:&nbsp;Tool to use to open / modify database: SQLITE3.execommands used:.mode column.headers on.output blah.txtselect * from local_episodes;.quit&nbsp;I examine the output and it shows:[CODE]EpisodeFilename&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OriginalComposite&nbsp; CompositeID&nbsp; SeriesID&nbsp; &nbsp; SeasonIndex&nbsp; EpisodeIndex&nbsp; LocalEpisodeName&nbsp; LocalImportProcessed&nbsp; CompositeUpdated&nbsp; AvailableSubtitles&nbsp; OriginalComposite2&nbsp; CompositeID2&nbsp; EpisodeIndex2&nbsp; videoWidth&nbsp; videoHeight&nbsp; FileDateAdded&nbsp; &nbsp; &nbsp; &nbsp; FileDateCreated&nbsp; &nbsp; &nbsp; IsAvailable&nbsp; DateWatched&nbsp; ext&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; VolumeLabel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; localPlaytime&nbsp; VideoCodec&nbsp; &nbsp; &nbsp; VideoFormat&nbsp; VideoFormatProfile&nbsp; VideoBitrate&nbsp; VideoFrameRate&nbsp; VideoAspectRatio&nbsp; AudioCodec&nbsp; AudioFormat&nbsp; AudioFormatProfile&nbsp; AudioBitrate&nbsp; AudioChannels&nbsp; AudioTracks&nbsp; TextCount&nbsp; StopTime ----------------------------------------------------------------------&nbsp; -----------------&nbsp; -----------&nbsp; ----------&nbsp; -----------&nbsp; ------------&nbsp; ----------------&nbsp; --------------------&nbsp; ----------------&nbsp; ------------------&nbsp; ------------------&nbsp; ------------&nbsp; -------------&nbsp; ----------&nbsp; -----------&nbsp; -------------------&nbsp; -------------------&nbsp; -----------&nbsp; -----------&nbsp; ----------&nbsp; ---------------------------&nbsp; -------------&nbsp; ---------------&nbsp; -----------&nbsp; ------------------&nbsp; ------------&nbsp; --------------&nbsp; ----------------&nbsp; ----------&nbsp; -----------&nbsp; ------------------&nbsp; ------------&nbsp; -------------&nbsp; -----------&nbsp; ----------&nbsp; ----------\\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e01 - Pilot.mkv&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 248741_1x1&nbsp; 248741&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Pilot&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1920&nbsp; &nbsp; &nbsp; &nbsp; 1080&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2013-06-11 14:20:09&nbsp; 2012-12-18 23:17:50&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; mkv&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; \\mofo\Audio Video Media\TV&nbsp; 1319319&nbsp; &nbsp; &nbsp; &nbsp; V_MPEG4/ISO/AVC&nbsp; AVC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; High@L4.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12675000&nbsp; &nbsp; &nbsp; 23.976&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.778&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; A_DTS&nbsp; &nbsp; &nbsp; DTS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1509000&nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e02 - And the B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 248741_1x2&nbsp; 248741&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; And the Breakup&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1920&nbsp; &nbsp; &nbsp; &nbsp; 1080&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2013-06-11 14:42:28&nbsp; 2012-12-18 23:44:39&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; mkv&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; \\mofo\Audio Video Media\TV&nbsp; 1286286&nbsp; &nbsp; &nbsp; &nbsp; V_MPEG4/ISO/AVC&nbsp; AVC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; High@L4.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8164000&nbsp; &nbsp; &nbsp; 23.976&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.778&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; A_DTS&nbsp; &nbsp; &nbsp; DTS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1509000&nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e03 - And Strok&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 248741_1x3&nbsp; 248741&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; And Strokes of G&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1280&nbsp; &nbsp; &nbsp; &nbsp; 720&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2013-06-11 15:02:31&nbsp; 2012-12-18 17:46:46&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; mkv&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; \\mofo\Audio Video Media\TV&nbsp; 1299299&nbsp; &nbsp; &nbsp; &nbsp; V_MPEG4/ISO/AVC&nbsp; AVC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; High@L4.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5657000&nbsp; &nbsp; &nbsp; 23.976&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.778&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; A_DTS&nbsp; &nbsp; &nbsp; DTS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1509000&nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e04 - And the R&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 248741_1x4&nbsp; 248741&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; And the Rich Peo&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1280&nbsp; &nbsp; &nbsp; &nbsp; 720&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2013-06-11 15:20:25&nbsp; 2012-12-18 18:08:58&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; mkv&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; \\mofo\Audio Video Media\TV&nbsp; 1293293&nbsp; &nbsp; &nbsp; &nbsp; V_MPEG4/ISO/AVC&nbsp; AVC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; High@L4.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5690000&nbsp; &nbsp; &nbsp; 23.976&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.778&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; A_DTS&nbsp; &nbsp; &nbsp; DTS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1509000&nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/CODE]&nbsp;(I have no idea why the columns don't line up - they do in the output file and they do when I preview this forum posting.&nbsp; They just don't line up aftwards...)&nbsp; So the following may not seem clear from the table above, but its true:&nbsp;The 'DateWatched' column is blank for all 25000 episodes!&nbsp;What column is used in what table to indicate that an episode has been watched?</blockquote>

[QUOTE="dir, post: 1005546, member: 24485"] Ok, I hit a brick wall. I worked out the following: Tool to use to open / modify database: SQLITE3.exe commands used: .mode column .headers on .output blah.txt select * from local_episodes; .quit I examine the output and it shows: [CODE]EpisodeFilename OriginalComposite CompositeID SeriesID SeasonIndex EpisodeIndex LocalEpisodeName LocalImportProcessed CompositeUpdated AvailableSubtitles OriginalComposite2 CompositeID2 EpisodeIndex2 videoWidth videoHeight FileDateAdded FileDateCreated IsAvailable DateWatched ext VolumeLabel localPlaytime VideoCodec VideoFormat VideoFormatProfile VideoBitrate VideoFrameRate VideoAspectRatio AudioCodec AudioFormat AudioFormatProfile AudioBitrate AudioChannels AudioTracks TextCount StopTime ---------------------------------------------------------------------- ----------------- ----------- ---------- ----------- ------------ ---------------- -------------------- ---------------- ------------------ ------------------ ------------ ------------- ---------- ----------- ------------------- ------------------- ----------- ----------- ---------- --------------------------- ------------- --------------- ----------- ------------------ ------------ -------------- ---------------- ---------- ----------- ------------------ ------------ ------------- ----------- ---------- ---------- \\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e01 - Pilot.mkv 248741_1x1 248741 1 1 Pilot 2 1 0 0 1920 1080 2013-06-11 14:20:09 2012-12-18 23:17:50 2 mkv \\mofo\Audio Video Media\TV 1319319 V_MPEG4/ISO/AVC AVC High@L4.1 12675000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 \\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e02 - And the B 248741_1x2 248741 1 2 And the Breakup 2 1 0 0 1920 1080 2013-06-11 14:42:28 2012-12-18 23:44:39 2 mkv \\mofo\Audio Video Media\TV 1286286 V_MPEG4/ISO/AVC AVC High@L4.1 8164000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 \\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e03 - And Strok 248741_1x3 248741 1 3 And Strokes of G 2 1 0 0 1280 720 2013-06-11 15:02:31 2012-12-18 17:46:46 2 mkv \\mofo\Audio Video Media\TV 1299299 V_MPEG4/ISO/AVC AVC High@L4.1 5657000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 \\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e04 - And the R 248741_1x4 248741 1 4 And the Rich Peo 2 1 0 0 1280 720 2013-06-11 15:20:25 2012-12-18 18:08:58 2 mkv \\mofo\Audio Video Media\TV 1293293 V_MPEG4/ISO/AVC AVC High@L4.1 5690000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 [/CODE] (I have no idea why the columns don't line up - they do in the output file and they do when I preview this forum posting. They just don't line up aftwards...) So the following may not seem clear from the table above, but its true: The 'DateWatched' column is blank for all 25000 episodes! What column is used in what table to indicate that an episode has been watched? [/QUOTE]