EPG viewer application

[waellotfy77 (wael)]

I want to make EPG viewer application
I have the data in XMLTV file it contain 20 channel and data for 6 days
I can convert XML file to excel and save it in google drive as google sheet
Also i can upload data to Airtable
the data are 5 columns
start (DateTime)
end (DateTime)
channel name
program title arabic
program title english

[Xoma (Kumaraswamy)]

What you have tried?

[bestprintsf (Leandro Z)]

If the question is whether it is possible ?
The answer is yes !!!
But beware I seen very large EPG files (32 MB) and they are probably not readable exceeds the limits of ram memory !!!

[waellotfy77 (wael)]

regarding the size of EPG file we can control it through channel numbers and how many days of EPG
my idea is simple in Egypt the most important Entertainment channels is OSN channels
now it is working on many android satellite receivers but their company do not offer EPG for these channels so i try to make an application to show these channels EPG on mobile or use the application on the android receiver with adding floating properties so i can see EPG during watching TV
can you explain how it is possible as you mention in your reply

[waellotfy77 (wael)]

I convert XML file to excel and upload data to airtable
i make different views
current view show current running program
view for each channel show all day program
i can get the current view by using show row data as each channel will be in a separate row and moving between channel by next and previous buttons
now i want to use show all row but i do not know yet how to do it

[bestprintsf (Leandro Z)]

Sorry i can’t help with airtable. I created my own EPG in txt file and show program for today and complete program into two list view with search funtion for complete program (15 days)

[waellotfy77 (wael)]

can you tell me more information about your application if it is possible to share your AIA

[bestprintsf (Leandro Z)]

I’m sorry but it’s impossible for me to share my aia.
It has taken me a lot of time and effort to do.
But take a looks maybe pictures help you. If press OK on remote control play live channel and if long press OK show EPG.

96 live channels of my contry

EPG: Left lits program for today and Right lists complete program

Custom search for complete program

[waellotfy77 (wael)]

After 15 day of searching community i finish my first application
1- Transfer xml file to excel
2- Upload the data to airtable free account base limit 1200 row only and EPG data reach about 12000 row) so i use google sheet as your database
when but all the rows in one sheet it took a very long time to filter data so i divide the data on 5 sheets

3- I learn how to read data from google sheet from the post below

Read data from Google Sheet

4- Date tools extension help me to make the logic to show the current running program

DateTools : Some tools to work with date and time

1.Introduction DateTools As the name suggests it is specially made to work with Dates but since it uses SimpleDateFormat so you can also work with Time by using appropriate format. Latest Version: 6.1 Last Updated: 2020-07-20T04:07:00Z (UTC) 2.Blocks [image] [image] [image] It has 22 function blocks and 1 event block 3.Documentation It has not so much coplex blocks but some examples can help you to understand its usage. [image] Returns day of given date. Note: You can also use DateT…

5- I use floating view extension so i can use the application during watching TV

Floating View: float your component. [FREE]

1.Introduction Extension Name: Floating View Through this extension, it is possible to transfer its visible component to a floating view capable of remaining active while the user is in other activities. An example of an application that uses this feature is the messenger. Latest Version: 1.2 Released:2020-06-14T11:52:00Z (UTC) Last Updated:2020-06-28T18:25:00Z (UTC) 2.Blocks [component_method (32)] [component_method (43)] [component_method (37)] [component_method (41)] [component_met…

The final result
to get current running programs

to get full day program

finally thanks to all the people in community who help me and answer my questions