Importing epg123.mxf to Excel

An evolving, supported alternative to Rovi
Forum rules
★ Download the latest EPG123 here: http://epg123.garyan2.net <> Setup guide here: http://epg123.garyan2.net/downloads/epg123_Guide.pdf
Post Reply
tirebiter

Posts: 20
Joined: Mon Jul 03, 2017 8:33 pm
Location:

HTPC Specs: Show details

Importing epg123.mxf to Excel

#1

Post by tirebiter » Tue Sep 22, 2020 5:32 pm

Hi all,

Every Sunday, I scan the TV guide for shows I want to watch in the coming week, especially premieres. I used to search through zap2it listings, which was tedious and trouble prone.

I recently came up with another approach as follows:

1. Edit out the newline chars in a copy of the mxf file.
2. Import selected fields from the mxf file into a free developer's edition of Microsoft SQL Server. Two tables are built, one for channel info and the other for shows.
3. Export selected columns from the tables (using a join to merge channel and show info) into a flat file.
4. Import the flat file into Excel (a newer version that supports over 64K rows)

The Excel spreadsheet is easy to filter and sort to find shows and movies that are premiering. I can also locate actors, genres, etc.

I don't know if there's an easier way, but this works for me. I'll be happy to provide more detail if there is interest.

User avatar
garyan2

Posts: 5344
Joined: Fri Nov 27, 2015 7:23 pm
Location:

HTPC Specs: Show details

#2

Post by garyan2 » Tue Sep 22, 2020 5:45 pm

In WMC with EPG123, on the TV Strip, you can select 'Search', 'Categories', and 'Premieres' to see all Series Premieres, Season Premieres, and Miniseries Premieres. I can't remember if I have movie premieres in the movie category or not... at one point I'm sure I did. This was probably one of the best suggestions from the community and I personally use it a lot.
- Gary
Keeping WMC alive beyond January 2020. http://epg123.garyan2.net

NOYB

Posts: 36
Joined: Thu Sep 10, 2020 8:03 am
Location:

HTPC Specs: Show details

#3

Post by NOYB » Tue Sep 22, 2020 5:58 pm

What Gary said plus in add recording can have it automatically schedule based on Actor, Director, Movie Title, Program Title, or Generic Keyword. Then just look at the recording schedule to see what it found.

tirebiter

Posts: 20
Joined: Mon Jul 03, 2017 8:33 pm
Location:

HTPC Specs: Show details

#4

Post by tirebiter » Tue Sep 22, 2020 6:22 pm

@Gary. I use that feature a lot too, but for my weekly planning, I like to have the information in a separate list program (ListPro) that I can confirm later the shows were recorded. In addition to WMC, I am still a diehard ReplayTV user. So I record shows on both units. The DVArchive app exports shows to a PC in mpeg format. When I was doing a lot of business travel, I'd copy the shows to a tablet to watch on the airplane, subway, train. Back in the day, people would be surprised to see me watching the previous night's shows.

Plus, Excel's grid is easier to view than WMC's list which requires each entry be expanded individually.

@NOYB - The Wish List option in the Add Recording page is probably the best feature I've ever seen. I currently have 70 entries of actors and movies. It's great to see what it finds. I'm presently going through a Una Merkel phase right now :)

Whoever programmed that feature knew what they were doing. For example, I have Sally Field in the list, but I hate The Flying Nun. All I had to do was click on one entry of the show and select Delete Series. This works on movies too. When I click to delete Smokey and the Bandit, it never reappears. But the guide shows the (I) Information icon indicating that it would have recorded it.

Space

Posts: 2043
Joined: Sun Jun 02, 2013 9:44 pm
Location:

HTPC Specs: Show details

#5

Post by Space » Tue Sep 22, 2020 10:29 pm

I never knew about the "Delete Series" option on an Actor recording. Wouldn't selecting "Delete Series" just delete the entire Actor Series and not just that series but continue to schedule other series/movies/programs that that actor was in?

Also, probably not what you are looking for, but I use this to find season/series premieres of shows. It doesn't always have everything (such as if the show was aired previously on a different platform or another country) but the guide data also may sometimes be missing some of these, so checking both makes missing these less likely.

tirebiter

Posts: 20
Joined: Mon Jul 03, 2017 8:33 pm
Location:

HTPC Specs: Show details

#6

Post by tirebiter » Wed Sep 23, 2020 12:07 am

AFAICT, WMC treats shows that are selected via a actor in the wish list as series. So when you delete it, it only removes that show, and nothing else by that actor. However, it also remembers single event items, like movies.

It was designed by someone who understood what people would/wouldn't like.

tirebiter

Posts: 20
Joined: Mon Jul 03, 2017 8:33 pm
Location:

HTPC Specs: Show details

#7

Post by tirebiter » Wed Sep 23, 2020 12:10 am

I've seen the futon critic list before. It's not bad. I prefer not seeing what's on the streaming services for this purpose because I'm building weekly lists of broadcast shows. However, I do subscribe to some of the streaming services too, and it's good to know what they have on.

Post Reply