RSS/XML Import – date errors

  • AndyMc

    (@andymc)


    18 years, 3 months ago

    I am trying to load a batch of old jounal and calendar entries in to family blog on my home machine (WAMP + WordPress).

    Can anyone shed some light as to the correct format to enable the date to be set correctly. My XML seems to specify the dat e correctly but at various points in the year it seems to lose a day and an entry destined for, say, 1st June ends up blogged on 31st May.

    This is the typical format of an “item”…

    `<item>
    <title></title>
    <link></link>
    <pubDate> Fri, 15 Jan 1999</pubDate>
    <dc:creator>Admin</dc:creator>
    <category><![CDATA[Work]]></category>
    <description></description>
    <content:encoded><![CDATA[Cal: 01:25:00-11:50:00 BA282 LAX-LHR]]></content:encoded>
    <wp:post_id></wp:post_id>
    <wp:post_date>1999-01-15 01:25:00</wp:post_date>
    <wp:post_date_gmt>1999-01-15 01:25:00</wp:post_date_gmt>
    </item>`

    Any help or suggestions would be gratefully received.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter AndyMc

    (@andymc)

    18 years, 3 months ago

    Could this be a “leap year” error?

    I have noticed that it only seems to affect dates March-December.

    Thread Starter AndyMc

    (@andymc)

    18 years, 2 months ago

    Well I have not solved the problem, but I have found a circumvention.

    Firstly, there is evidently a bug in the way WP handles the post_date information as it time slips the date, and seems to set the time to 23:00.

    However, by converting the RSS input files to MySQL Load Data format all 4000+ entries were added to the system without incident or error.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘RSS/XML Import – date errors’ is closed to new replies.

Tags