Display Dates Don’t Match Dates in Event Listing

  • Resolved jeepers8675309

    (@jeepers8675309)


    9 years, 4 months ago

    Hello,

    I need some support. I exported upcoming dates from two band’s websites then imported the csv files right away to my website. The problem is when I look at the list of shows on my website in Gigpress or on my webpgage all Jan dates are listed as Jan 1, all Feb dates are listed as Feb 2, all March dates are listed as Mar 3 and so one with the month and day being the same.

    Incorrect Dates in GigPress Listing

    I opened the CSV files and checked that the dates are correctly formatted and don’t have the dreaded apostrophe in front of them. They were fine. I figured I’d just go in to each show for now and edit the dates manually but when I open a show for editing, the date is correct so I can’t even correct the display dates!

    Correct date in GigPress Show Details

    How can I fix this besides deleting the shows and entering each one separately?

    Thanks,
    jeepers

Viewing 11 replies - 1 through 11 (of 11 total)
  • westonjeff

    (@westonjeff)

    9 years, 4 months ago

    I’m no expert, but suggest you make sure your dates are formatted as “yyyy-mm-dd” in the CSV file.

    In Excel, choose cell properties, date, under “Locale” choose “Afrikaans”, then “2001-03-14”

    Save file and reimport.

    Thread Starter jeepers8675309

    (@jeepers8675309)

    9 years, 4 months ago

    Thanks @westonjeff. The csv files came directly from a GigPress export so should already have the proper format. When I open the csv file the dates are in the correct format.

    Does choosing Afrikanns do something special with the formatting if it’s already yyyy-mm-dd? Is there an equivalent to this process in Numbers or Open Office? I don’t have Excel.

    westonjeff

    (@westonjeff)

    9 years, 4 months ago

    Choosing Afrikanns does nothing special with the formatting that I know of — just way I discovered in Excel to create mySQL-friendly dates.

    What program did you open the CSV file in to edit?

    Can you cut and paste a row or two of the file here?

    Thread Starter jeepers8675309

    (@jeepers8675309)

    9 years, 4 months ago

    That’s the crazy thing. I didn’t open the file. I just exported from one GigPress installation then immediately imported to another. I only opened the csv file afterwards to check the date format when the dates weren’t displaying properly after import.

    Here’s some of the file from a text editor:
    Date,Time,End date,Artist,Artist URL,Venue,Address,City,State,Postal code,Country,Venue phone,Venue URL,Admittance,Price,Ticket URL,Ticket phone,External URL,Notes,Tour,Status,Related ID,Related URL
    2017-05-18,,,The Young Novelists,,Huntington’s Cinema Arts Centre,,Huntington,NY,,US,,http://fmsh.org/,Not sure,,,,,,,active,0,
    2017-05-06,,,The Young Novelists,,Arts Barn Series,,Rockville,MD,,US,,http://www.gaithersburgmd.gov/leisure/arts/arts-on-the-green,Not sure,,,,,,,active,0,

    westonjeff

    (@westonjeff)

    9 years, 4 months ago

    How does your event for 2017-05-06 look?

    Wondering if the second digit of your dates is being cut off. “d” instead of “dd” maybe in your WordPress date display settings?

    • This reply was modified 9 years, 4 months ago by westonjeff.
    • This reply was modified 9 years, 4 months ago by westonjeff.
    Thread Starter jeepers8675309

    (@jeepers8675309)

    9 years, 4 months ago

    Oh man…that’s what it was! I put n instead of j for displaying the dates so it was displaying the numeric month instead of day!

    Thanks!!!!

    westonjeff

    (@westonjeff)

    9 years, 4 months ago

    Glad to hear!

    Wondering if you’ve ever done any customizing of the gigpress_shows() function found in the file gigpress_shows.php

    My original post to this forum = https://wordpress.org/support/topic/order-by-date-using-gigpress_shows/

    Seems strange you can’t order shows by date when using the [gigpress_shows] short code??

    Thread Starter jeepers8675309

    (@jeepers8675309)

    9 years, 4 months ago

    wait…can you use this [gigpress_shows group_artists=no] to sort by date instead of artist? is that what you’re looking to do?

    westonjeff

    (@westonjeff)

    9 years, 4 months ago

    Thanks Jeepers . . . will give it a try later after done with my “real job”

    westonjeff

    (@westonjeff)

    9 years, 4 months ago

    Jeepers:

    Your suggestion to use [gigpress_shows group_artists=no] worked like a charm! Now I think I’m going to get in and do a little customizing of the way shows display on pages and in the widget.

    Wish me luck!

    Clifford Paulick

    (@cliffpaulick)

    9 years, 3 months ago

    Thanks to both of you for helping each other out.

    It looks like you’ve got this resolved now. Kudos! 🙂

    (Please let us know if it’s not.)

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

The topic ‘Display Dates Don’t Match Dates in Event Listing’ is closed to new replies.