PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Time Zone Issues with CSV Export

  1. When entries are entered AFTER 8PM Eastern Time (New York), and then an export is done for the date those entries are made, those entries do not show. They DO show on the next day's export. However, the data in the entry fields is all correct, the issue only seems to be with the exported csv files.

    Example:
    Form entry submitted on 1/7/12
    Export downloaded on 1/8/12, and the export dates are both set to 1/7/12.
    Any entry made AFTER 8PM on 1/7/12 does NOT appear on the export file.

    If the export dates are changed to 1/7/12 through 1/8/12, those entires made after 8pm on 1/7 DO appear in that csv file. The entry date shows correctly, 1/7/12, but they only show up in 1/8/12 export file.

    I imagine it has to do with my server being in a different time zone, and therefore MySQL is using a different time, but is there a workaround?

    Thanks!

    Posted 7 years ago on Tuesday January 8, 2013 | Permalink
  2. It does sound like a server configuration issue. Does the WordPress timezone on this page of your site wp-admin/options-general.php match up with your server time? And is your MySQL installation on the same machine as the website (i.e. in wp-config.php, is the database host "localhost" or something else?)

    Posted 7 years ago on Wednesday January 9, 2013 | Permalink
  3. MySQL does read "localhost"

    Server is in Utah, and is on RMT. Client is in Connecticut, EST. Wordpress General settings are set for clients local time (Using the "New York" option in Wordpress.). It's important to the client that form entries are made at the correct local time/date.

    Posted 7 years ago on Wednesday January 9, 2013 | Permalink
  4. What I don't get is this... The Server reads 2 hours BEHIND local time. But the file exports seem to cut off at 4 hours AHEAD of EST, which is close to GMT if I'm not mistaken...

    Posted 7 years ago on Wednesday January 9, 2013 | Permalink
  5. Also, I just ran an export, and the file was named with the date for tomorrow, not today. So obviously, the export is pulling UTC/GMT and is not compensating for the wordpress setting of minus 4.

    Posted 7 years ago on Wednesday January 9, 2013 | Permalink
  6. I sent this information to the development team for their feedback. Thank you for the information.

    Posted 7 years ago on Wednesday January 9, 2013 | Permalink
  7. Thanks Chris. The sooner I can get a workaround, the better.

    Posted 7 years ago on Wednesday January 9, 2013 | Permalink
  8. Just to clarify, are the dates in the CSV file incorrect? Or is the search when creating the CSV incorrect? Or both?

    Entry dates are stored as GMT, so this does look like a place where Gravity Forms is not making the proper conversion. I will be glad to take a look, but please let me know the exact problem so that I can look in the right places.

    Posted 7 years ago on Wednesday January 9, 2013 | Permalink
  9. The fields in the CSV file are 100% correct, as I would like them.

    The titles of the csv files created after 8PM include the wrong file name. EG if I create an export tonight at 8:27PM EST, it will be called form-name-2013-01-10.csv when it should read todays date.

    The entries included in an export, though I select 1/8/2013 for both start and end, will include any entries made after 8PM on 1/7/2013, and will not include any entries made after 8PM on 1/8/2013.

    The 1/7/2013 entries included on 1/8/2013 export will list 1/7/2013 as their entry date, so that portion is correct. The form entry data is correct. It is only the GMT localization conversion in the export procedure that is wrong.

    Am I being clear, or am I just muddling it up more? I have a tendency to ask confusing questions so please let me know if I need to rephrase, happy to do so!

    Thanks so much you all for your help!

    Posted 7 years ago on Wednesday January 9, 2013 | Permalink
  10. Your information is good; very helpful, not muddying. I will pass this back to Alex. Thank you.

    Posted 7 years ago on Wednesday January 9, 2013 | Permalink
  11. I think I get it. The date search is wrong and the filename is wrong. I will take a look at it and let you know

    Posted 7 years ago on Wednesday January 9, 2013 | Permalink
  12. Hi. We were able to recreate this issue and have implemented a fix. I have a new version of the Gravity Forms plugin I would like to send you. Please email chris@rocketgenius.com and I will send the new version. Thank you.

    Posted 7 years ago on Thursday January 10, 2013 | Permalink
  13. WOW!!! This is incredible, so excited to try it out.
    I sent you an email Chris.
    Please extend my thanks to everyone involved.

    Posted 7 years ago on Thursday January 10, 2013 | Permalink
  14. Alex, I sent the latest version of the plugin to your gmail account. Let us know how it goes.

    Posted 7 years ago on Friday January 11, 2013 | Permalink
  15. CHris, I just responded via email. The CSV export is now completely blank. All Entries are intact in the admin, it just sends me a blank file.

    Posted 7 years ago on Friday January 11, 2013 | Permalink
  16. Well, that's no good. I will ping Alex and see what he has to say. You can download 1.6.11 from the downloads page if you want to go back to it while we investigate. Sorry about that.

    Posted 7 years ago on Friday January 11, 2013 | Permalink
  17. Any word on this?

    Posted 7 years ago on Friday January 18, 2013 | Permalink
  18. Chris, thanks for your reply to my email last week. Has Alex gotten back any response on this?

    Posted 7 years ago on Sunday January 27, 2013 | Permalink
  19. I don't have a response from Alex. Let me check on this for you today.

    Posted 7 years ago on Monday January 28, 2013 | Permalink
  20. Alex, I sent you an email just now with instructions on how to resolve this problem once and for all.

    Posted 7 years ago on Tuesday January 29, 2013 | Permalink
  21. The patch worked great so far! Thanks for this.

    Posted 7 years ago on Thursday January 31, 2013 | Permalink
  22. You're welcome. Let us know if you need anything else. Sorry for the inconvenience.

    Posted 7 years ago on Friday February 1, 2013 | Permalink

This topic has been resolved and has been closed to new replies.