Jump to content
ajb

Excel based channel list editor based on KingOfSat

Recommended Posts

ajb

I’ve written a spreadsheet that gathers all information from kingofsat and converts it into a usable DVBViewer channel list. There are only two macros: one to get the data and one to output it. To run them first enable the blocked content, then run them by pressing Alt-F8.

 

There are several advantages to using this method:

• Rely on the very well maintained KingOfSat data source instead of the hit and miss channel scans

• Rely on the categories and Pay TV tags from KingOf Sat

• Ignore categories or languages I don’t need (e.g. Pay Per View)

• Ignore Pay TV I can’t receive

• Use the power of Excel to arrange channels

• Combine multiple satellites into one group if required

 

To use you need some familiarity with Excel (preferably 2007 or 2010):

 

On the settings page enter the URLS and a few other settings specific to your setup (DiSEqC, LNB etc) as well as a few preferences (eg AC3) and where to output the final ini file to. Use a channel scan and the resulting ini file to guide you through the settings here. Standard destination is your temp directory, which you can get to by typing %TEMP% into the Windows Explorer address bar.

 

On the categories page please edit the categories into fewer categories and languages that make sense for you. There is an “x” category of all the things you don’t want (unless you set it to output on the preferences sheet). Next rank these categories in order. Column 12 allows you to separate the categories and languages. Finally column 15 allows you to specify which pay TV packages you can receive. To output all type all into the CI box on the preferences page.

 

Running the macro can take a few minutes so please be patient.

 

On the channel editor the key column is column 62 where you put down a rank in the category. If you insert a channel later you can use decimals to squeeze them in, in the end only the ranking matters. By creating a unique ID at the front any work on the ordering should remain intact even after an update (though I cannot guarantee this). Also note the override fields to the right, which allow overrides to the various parameters, e.g. category, language or name.

 

I got this to work for my needs but I don’t intend to maintain it on an ongoing basis or document it much further. Nevertheless I thought it would be useful to share and for others to use or expand on.

 

ajb

kingofsat3.zip

Share this post


Link to post
Siggi0904

Hello ajb,

 

great work. But can u make it more userfriendly? I had some problems to find the right functions to generate a list only für Astra 19.2. Does the Excel works with the german website of kingsofsat too?

 

Thanks.

Share this post


Link to post
mirecek1965

Thanks for this, works fine :-)

Share this post


Link to post
Mohamed Yousri

Hello All, 

 

Can't use the excel file ! can any one help how can i use it ?! 

Share this post


Link to post
Mohamed Yousri

I get this error while trying to create the ini file 

Screenshot (3).png

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...