WP Eventmanager DATE format imports incorrectly

  • Resolved meushar

    (@meushar)


    3 years, 9 months ago

    I am using WordPress 5.9.3 and WP Event Manager 3.1.29 and WP All Import Pro 4.7.3

    When I import events using start and end date format d/m/Y, then the dates in the ‘All Events’ listing look correct, but the dates in the ‘detailed listing’ of the event are totally incorrect and mostly 1/1/1970

    When I import events using start and end date format d-m-Y, then the dates in the ‘All Events’ listing as well as the ‘detailed event’ listing look correct, but the ordering of the events in the events view (shortcode [events]) is incorrect and the selected_datetime shortcode does not find any of the events (even though the events show up without the selected_datetime shortcode)

    If I press ‘update’ on the ‘detailed event’ without making any changes, then all the dates work correctly, with correct ordering and selected_datetime working as well.

    This all suggests that the internal DATE calculations and storage are not working properly when dates are imported

Viewing 3 replies - 1 through 3 (of 3 total)
  • Priya Goenka

    (@priyagoenka)

    3 years, 9 months ago

    Hi @meushar

    Can you please try importing using Migration Plugin by wp event manager.
    https://wordpress.org/plugins/wp-event-manager-migration/

    If you are still facing a issue, We will look into this in detail on our support forum, as WP import is a third party plugin, and we will need to get insights into this. Hope you undertstand.

    Regards,
    Priya

    Thread Starter meushar

    (@meushar)

    3 years, 9 months ago

    Hi Priya
    Thanks for the reply.
    Your own documentation says to use WP All Import Pro. That’s why I bought it.

    I tried Event Manager Migration.
    The documentation states that its exports and imports. I only get import.
    Migration does not allow import of event expiry date
    Migration does not import the image banner to the thumbnail image
    Migration does not allow import of a thumbnail image separate from a banner image
    Migration does not import the start and end dates suitable to work with the selected_dates shortcode
    Migration needs the date to be in d-m-Y format

    If you ‘update’ the ‘detailed event’ without making any changes, then all the dates work correctly, with correct ordering and selected_datetime working as well. (same as for WP ALL Import), and the thumbnail image is set equal to the banner image.

    I have 1000 events to import. Its impossible to ‘update’ each one to make this work. Please help.

    Thread Starter meushar

    (@meushar)

    3 years, 9 months ago

    Hi Priya

    I did a bit of database inspection and found that WP EventManager stores dates in the US format yyyy-mm-dd hh-mm-ss.

    If you import the start, end and expiry dates/times in that format (irrespective of your date picker setting) then the dates operate correctly.

    I used WP All Import which gave me access to all the fields I required, including expiry date

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

The topic ‘WP Eventmanager DATE format imports incorrectly’ is closed to new replies.