Participants Database date field question

  • Resolved loosefast

    (@loosefast)


    10 years, 8 months ago

    Hi,
    Great Plugin! We are using Participants Database to display record albums on our site. We imported a csv file with a column called Timestamp that had entries in this format 2008-08-01. Unfortunately, we imported them into a Participants Database field set to “text line” which was re-assigned to “date” after import and everything was reset to January 01, 1970.
    Questions
    If we re-import the csv with the Timestamp field set to date, will the 2008-08-01 format be correctly changed to August 01, 2008?
    When entering new records in Add Participant, can the date be auto entered in this field?
    We want the frontend display to have Timestamp sortable
    Thanks!

    https://wordpress.org/plugins/participants-database/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author xnau webdesign

    (@xnau)

    10 years, 8 months ago

    You can re-import the CSV to fix this, but you need to make sure your incoming records match and overwrite existing records or you’ll get duplicates. Also, with a non-standard date format like that, you should use “strict dates” and set the “input date format” to match the format of the incoming dates. Note that this will affect all date fields, so if you have some date fields with a different format, those won’t import correctly.

    Thread Starter loosefast

    (@loosefast)

    10 years, 8 months ago

    thanks, will check those settings.
    When entering new records in Add Participant, is there a way the date be auto entered in the Timestamp field each time a new record is added?

    Plugin Author xnau webdesign

    (@xnau)

    10 years, 8 months ago

    This is already set up, look under the “record info” field group.

    Thread Starter loosefast

    (@loosefast)

    10 years, 8 months ago

    Hi,
    This would need to be a field that can be displayed & sorted on the public side of the site. It does not look like the “record info” field group allows that.
    Thanks

    Plugin Author xnau webdesign

    (@xnau)

    10 years, 8 months ago

    OK, you can do that, you just need to use the “fields” attribute in the list shortcode to specify which fields are shown in the list. You can sort it by the timestamp in the shortcode as well.

    Thread Starter loosefast

    (@loosefast)

    10 years, 8 months ago

    Thanks for your help!

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

The topic ‘Participants Database date field question’ is closed to new replies.