Posts: 4,036
Joined: Oct 2007
Reputation:
87
zag
Team-Kodi Member
Posts: 4,036
Awesome, just the SQL will be perfect.
Posts: 211
Joined: Sep 2012
Woppie
Closed Account
Posts: 211
2015-06-02, 15:38
(This post was last modified: 2015-06-02, 15:39 by Woppie.)
My country is not even on the list
But I could simply make a list in Excel which channels are in use here, I know all that are available to the whole country.
Local channels are a bit difficult; each region has a max of 6 local channels on the cable here.
We only have a few providers so it's easy; just iptv is tricky but as far as I know they don't have any additional channels over cable/sattelite/aerial.
lol a post above me disappeared?
Posts: 211
Joined: Sep 2012
Woppie
Closed Account
Posts: 211
I'll just see whenever it online if it's any use to me

The key is size in order to get a nice list; even square logo's I put in a rectangular 800x450 box just to make them fit in with the rest.
That's basically what I learned over the years, no matter different styles or versions of logo's; if they get scaled and they're a different size to begin with it gets a mess real quickly.
Make that mess even worse if you use logo's from different packs... that's why I love 1 single pack for the Dutch market; there's one source for all.
My pack has 210 logo's of about 300 channels available to the market, the main ones I miss are from satellite (planing to do those later) and the local ones of which I can't find a clear list.
Think about size... it DOES matter XD (No particular reference here

)
Posts: 211
Joined: Sep 2012
Woppie
Closed Account
Posts: 211
2015-06-02, 16:28
(This post was last modified: 2015-06-02, 16:49 by Woppie.)
Maybe a "standard" template; 800x480 with 15 pixels offset on both the top and bottom.
For elongated logo's you get all the space you desperately need versus scaling; for square style logo's you get the offset for the guide view in DVBviewer and the like.
Also it's easy to fix/change in my next logo pack, wouldn't cause me to change much, I bet it can be done by script in photoshop.
Quick sketch;
Posts: 211
Joined: Sep 2012
Woppie
Closed Account
Posts: 211
(2015-06-02, 17:11)enen92 Wrote: Can you check if the others are there as well or if canaldigitaal has all the channels you made logos for?
Some of the missing channels might be part of other packages.
http://www.lyngsat.com/packages/CanalDigitaal-23E.html
I miss half a dozen Canal Digital also has, also Ziggo has some channels which Canal Digital doesn't have and visa versa.
The only provider not worth mentioning is Digitenne (DVB-T), it has 40 channels or so none of which are exclusive.
The Ziggo one I made is the most complete one, I'll add the Canal Digitaal ones later if you like to my package to get to a total of +/- 250 logo's which covers 99% of the market.
Posts: 211
Joined: Sep 2012
Woppie
Closed Account
Posts: 211
2015-06-02, 17:35
(This post was last modified: 2015-06-02, 17:47 by Woppie.)
(2015-06-02, 17:30)enen92 Wrote: It seems the ziggo package needs to be created later as I can't find it on lyngsat, probably it is IPTV only. That's why when I was grabbing the info to the sql I treated channels as individual entities that can belong to multiple packages. That way we can probably create a new package called ziggo as an IPTV package and import channels from canaldigitaal. Then only the missing channels are created, if they in fact are exclusive and don't belong to other "foreign" packages already 
Ziggo is DVB-C (about 85% of the market has access to this provider), not iptv
Digitenne is DVB-T (about 1% uses this, became unpopular due to lack of HD)
Canal Digitaal is DVB-S (Good old satellite

)
KPN is iptv (with a lot of sub brands with slightly different offers, increasingly popular but heavily DRM Encrypted unfortunately)
Edit: Batch resized my logo's to 800x480 through Photoshop, quick and easy