View Issue Details

IDProjectCategoryView StatusLast Update
0004777MMW v4Otherpublic2008-12-02 21:59
ReporterLudek Assigned To 
PriorityurgentSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version3.0 
Fixed in Version3.1 
Summary0004777: Podcasts: PubDate field of the PodcastEpisodes table doesn't get populated with the time portion
DescriptionAs Aaron reported in the ticket:

The PubDate field of the PodcastEpisodes table only getting populated with the date portion in many cases. For example:

http://www.npr.org/rss/podcast.php?id=1090&uid=b65ec27c2cdc209bd5237dce3d494d52

has the following type of date value.

<pubDate>Sun, 29 Jun 2008 01:03:42 -0400</pubDate>

The PubDate field does not retain the time. This is not a problem for this feed because it is daily but it is a problem for podcasts that are more frequently posted.

I am assuming that this date and time are used to populate the Date field associated to the audio file in the Songs table. If my assumption is correct I would recommend that an option be provided to display the time for the Date field. Or for clarity it might be better to do what is done in winamp. They have several dedicated fields for podcasts that can be used when creating playlists such as Podcast Publish Date.

At a minimum you need to capture that time with the date.

Thanks,
Aaron
Additional InformationReported in ticket:
http://www.mediamonkey.com/support/staff/index.php?_m=tickets&_a=viewticket&ticketid=1099&highlight=--+Mixed+--&ticketsearchid=723
TagsNo tags attached.
Fixed in build1185

Activities

Ludek

2008-07-09 11:52

developer   ~0014334

Last edited: 2008-07-09 12:09

Btw.
Some routines from http://www.dirfile.com/esbdates.htm could help?

Or maybe better one: http://fundementals.sourceforge.net/cDateTime.html
function RFCDateTimeToGMTDateTime(const S: String): TDateTime;

peke

2008-07-09 15:54

developer   ~0014336

Ludek,
Check my last.fm plugin and see how I solved date conversion in lastfm_unit.pas, function DateTime2UTC and procedure LastFMLoadMMInfo to see how I read check track info from SONGDATA Object.

Ludek

2008-07-10 00:45

developer   ~0014337

Peke,
I don't understand how this is related to the RFC-822 date format? Do you mean a handling of the TimeZone?

peke

2008-07-10 01:51

developer   ~0014339

Yes,
In those two examples I do handling of timezone and UTC convert if you can use it and excluding need to use additional source.

It depends on our needs in the issue.

Ludek

2008-07-10 23:27

developer   ~0014341

Fixed in build 1185.