+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Add-on Support (https://forum.kodi.tv/forumdisplay.php?fid=27)
+---- Forum: Program Add-ons (https://forum.kodi.tv/forumdisplay.php?fid=151)
+---- Thread: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) (/showthread.php?tid=282157)
Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - JQZ* - 2019-03-19
Okay... I updated DB Browser for SQLite, and reminders are now showing up in TVGF after I export, delete, and import notifications now. So that version of a sqlite editor is working for me now. But after importing with it, TVGF is still not showing Don't Remind... just Remind for the reminders set.
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - primaeval - 2019-03-19
(2019-03-19, 17:02)JQZ* Wrote: Okay... I updated DB Browser for SQLite, and reminders are now showing up in TVGF after I export, delete, and import notifications now. So that version of a sqlite editor is working for me now. But after importing with it, TVGF is still not showing Don't Remind... just Remind for the reminders set.Do you get DATETIME or TIMESTAMP for your start_date value after you have imported your reminders in DB Browser for Sqlite?
It it is not TIMESTAMP it will not work.
This is your original source.db that you sent me with the wrong value.
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - JQZ* - 2019-03-19
(2019-03-19, 16:57)primaeval Wrote:Okay, fresh sources.db created with basically the same script.tvguide.fullscreen folder I sent you. Loading my old 206 notifications csv from the old folder went fine, and the 5 key brought them all up properly. But the Don't Remind menu not being there is still an issue.(2019-03-19, 16:30)JQZ* Wrote: Reload that, I edited it.Try using a fresh source.db to import your old notifications.csv into.
There were a couple of changes to the database format fairly recently that could be causing problems if yours comes from before then.
https://github.com/primaeval/script.tvguide.fullscreen/commit/d31ddbdf2bd17833f87043e97049d5f6e269e049#diff-078f5f54ae7748ab33591d30e6b944b9R326
But still... if I load a fresh sources.db and set a reminder, Don't Remind is shown before deleting the table. But after exporting the table with just that 1 reminder, deleting the table, and then importing it again... Don't Remind isn't there anymore. Just Remind.
At least DB Browser for SQLite seems to be working properly for me now. I won't have to exit FF and load the old portable version to use the old SQLite Manager anymore. Thanks for getting me to explore that primaeval.
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - primaeval - 2019-03-19
(2019-03-19, 17:34)JQZ* Wrote:Does importing from the cvs file still change the type for start_date to DATETIME?(2019-03-19, 16:57)primaeval Wrote:Okay, fresh sources.db created with basically the same script.tvguide.fullscreen folder I sent you. Loading my old 206 notifications csv from the old folder went fine, and the 5 key brought them all up properly. But the Don't Remind menu not being there is still an issue.(2019-03-19, 16:30)JQZ* Wrote: Reload that, I edited it.Try using a fresh source.db to import your old notifications.csv into.
There were a couple of changes to the database format fairly recently that could be causing problems if yours comes from before then.
https://github.com/primaeval/script.tvguide.fullscreen/commit/d31ddbdf2bd17833f87043e97049d5f6e269e049#diff-078f5f54ae7748ab33591d30e6b944b9R326
But still... if I load a fresh sources.db and set a reminder, Don't Remind is shown before deleting the table. But after exporting the table with just that 1 reminder, deleting the table, and then importing it again... Don't Remind isn't there anymore. Just Remind.
At least DB Browser for SQLite seems to be working properly for me now. I won't have to exit FF and load the old portable version to use the old SQLite Manager anymore. Thanks for getting me to explore that primaeval.
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - JQZ* - 2019-03-19
(2019-03-19, 17:24)primaeval Wrote:D***. This is what I'm seeing in DB Browser for SQLite after I thought I'd gotten it working correctly: INTEGER(2019-03-19, 17:02)JQZ* Wrote: Okay... I updated DB Browser for SQLite, and reminders are now showing up in TVGF after I export, delete, and import notifications now. So that version of a sqlite editor is working for me now. But after importing with it, TVGF is still not showing Don't Remind... just Remind for the reminders set.Do you get DATETIME or TIMESTAMP for your start_date value after you have imported your reminders in DB Browser for Sqlite?
It it is not TIMESTAMP it will not work.
This is your original source.db that you sent me with the wrong value.
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - JQZ* - 2019-03-19
(2019-03-19, 17:42)primaeval Wrote:DATETIME only showed up when I was using the FF addon version of SQLite Manager to import the csv. But now using DB Browser for SQLite to export and import, I'm getting INTEGER where TIMESTAMP should be.(2019-03-19, 17:34)JQZ* Wrote:Does importing from the cvs file still change the type for start_date to DATETIME?(2019-03-19, 16:57)primaeval Wrote: Try using a fresh source.db to import your old notifications.csv into.Okay, fresh sources.db created with basically the same script.tvguide.fullscreen folder I sent you. Loading my old 206 notifications csv from the old folder went fine, and the 5 key brought them all up properly. But the Don't Remind menu not being there is still an issue.
There were a couple of changes to the database format fairly recently that could be causing problems if yours comes from before then.
https://github.com/primaeval/script.tvguide.fullscreen/commit/d31ddbdf2bd17833f87043e97049d5f6e269e049#diff-078f5f54ae7748ab33591d30e6b944b9R326
But still... if I load a fresh sources.db and set a reminder, Don't Remind is shown before deleting the table. But after exporting the table with just that 1 reminder, deleting the table, and then importing it again... Don't Remind isn't there anymore. Just Remind.
At least DB Browser for SQLite seems to be working properly for me now. I won't have to exit FF and load the old portable version to use the old SQLite Manager anymore. Thanks for getting me to explore that primaeval.
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - primaeval - 2019-03-19
(2019-03-19, 17:47)JQZ* Wrote:That's even worse than DATETIME.(2019-03-19, 17:24)primaeval Wrote:D***. This is what I'm seeing in DB Browser for SQLite after I thought I'd gotten it working correctly: INTEGER(2019-03-19, 17:02)JQZ* Wrote: Okay... I updated DB Browser for SQLite, and reminders are now showing up in TVGF after I export, delete, and import notifications now. So that version of a sqlite editor is working for me now. But after importing with it, TVGF is still not showing Don't Remind... just Remind for the reminders set.Do you get DATETIME or TIMESTAMP for your start_date value after you have imported your reminders in DB Browser for Sqlite?
It it is not TIMESTAMP it will not work.
This is your original source.db that you sent me with the wrong value.
Try the Import Table from CSV again. Press Yes To All at the end.
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - JQZ* - 2019-03-19
(2019-03-19, 18:05)primaeval Wrote: That's even worse than DATETIME.Same result. I noticed you have 'Quote Character' set to: " ..So I tried it again with that set. But still came up with INTEGER. Seems this has turned more into your helping me with sqlite than it's been my helping you with your new code. The new code just seems to have focused on an old problem with my imported csv files that I hadn't noticed, or had any issues with before.
Try the Import Table from CSV again. Press Yes To All at the end.
I've got a few things to take care of p, so I'll check in later today and see what you've come up with. Maybe I can dust off my old USB stick with a copy of Linux Mint and see if I can set up DB Browser for SQLite. Looks like you may be using some flavor of Linux.
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - primaeval - 2019-03-19
(2019-03-19, 18:27)JQZ* Wrote:I'm just using win10 at the moment.(2019-03-19, 18:05)primaeval Wrote: That's even worse than DATETIME.Same result. I noticed you have 'Quote Character' set to: " ..So I tried it again with that set. But still came up with INTEGER. Seems this has turned more into your helping me with sqlite than it's been my helping you with your new code. The new code just seems to have focused on an old problem with my imported csv files that I hadn't noticed, or had any issues with before.
Try the Import Table from CSV again. Press Yes To All at the end.
I've got a few things to take care of p, so I'll check in later today and see what you've come up with. Maybe I can dust off my old USB stick with a copy of Linux Mint and see if I can set up DB Browser for SQLite. Looks like you may be using some flavor of Linux.
pm me the full notifications.csv file.
Maybe there is something strange in there that is forcing it to INTEGER.
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - JQZ* - 2019-03-19
2 PMs sent P
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - Cangeoboy - 2019-03-21
Wondering if there is a way to reset the channel order without resetting the streams associated with each channel. IE If I change the channel order in my xmltv file and then upload to TV Guide Fullscreen, any channel changes or new channels appear at the bottom of my current channel list. Then I have to move them manually which takes a long time if you have many channels.
Thanks
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - JQZ* - 2019-03-22
(2019-03-21, 23:31)Cangeoboy Wrote: Wondering if there is a way to reset the channel order without resetting the streams associated with each channel. IE If I change the channel order in my xmltv file and then upload to TV Guide Fullscreen, any channel changes or new channels appear at the bottom of my current channel list. Then I have to move them manually which takes a long time if you have many channels.
Thanks
After I make channel order, added channel or removed channel changes to my webgrab++ config.xml, I 1st use an sqlite program to export the custom_stream_url table in source.db to an csv file. Then I rename, move or delete source.db in TVGF's data folder and then let TVGF load a fresh one from the new xmltv file. Then I import the custom_stream_url.csv file and write over the empty one in the new source.db.
But primaeval has EXPORT CHANNEL MAPPINGS, and IMPORT CHANNEL MAPPINGS functions in TVGF's settings. I've never tried them, but they may function similarly to the process I use. He'll clear that up when he reads these posts,
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - JQZ* - 2019-03-22
My browser hung up posting that last message resulting in a duplicate post here. I don't see a way to delete this duplicate, so I'm just editing it.
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - primaeval - 2019-03-22
(2019-03-21, 23:31)Cangeoboy Wrote: Wondering if there is a way to reset the channel order without resetting the streams associated with each channel. IE If I change the channel order in my xmltv file and then upload to TV Guide Fullscreen, any channel changes or new channels appear at the bottom of my current channel list. Then I have to move them manually which takes a long time if you have many channels.There is
Thanks
Settings \ Optional \ Order Channels by m3u position
which might help.
Back up your
userdata\addon_data\script.tvguide.fullscreen
before you start experimenting though.
RE: TV Guide Fullscreen - possibly the most powerful TV Guide in the world. ;) - georgepana - 2019-03-24
Hello. It has been a few weeks since we last talked. I appreciate all your help with the setup and it works well for me with a mix of an EPG URL and and additional Webgrab source guide.xml in Lab 3 under "Secondary XMTV File." I have a couple of questions for you.
First, is there a way to prevent TVGF from exiting via Backspace? There is currently a radio button labelled "Exit from EPG on Back Button" under "Playback." Basically, when that radio button is checked it means that the Back Button will exit the EPG. When that button is unchecked it does not exit the EPG IF a channel is active, meaning if a channel is playing at that time. The back button will open the guide when the Back Button is pushed (and toggle between full screen channel and guide with the current channel displayed in the upper right corner.) X will stop the active channel from playing. The problem I am running into is that if I am in the guide without an active stream displayed in the upper right corner and I hit the back button inadvertently the program shuts down, because that "Exit from EPG on Back Button", on or off, only applies to a case where a stream is showing. What happens from time to time is that a stream dies and just shows a green screen. At that point there is no stream showing, so hitting Back Space in an effort to go back to the guide shuts the entire program down. Is there a way to prevent the program from shutting down at all with Back Space, even when no stream is displayed at that point, and only allow it when C is pressed (or MENU on a remote) and then EXIT is chosen in the options there? Or is there a setting that allows me to lock the program in, no matter what, unless EXIT is chosen in the Options menu?
Secondly, can you guide me to the pages that explain how to set up a DVR feature (I am assuming it is Catchup) for a Windows 10 machine running Kodi with substantial hard drive space (4 TB)?
Thanks again for all your help,
George