(Solved) Follow UP (cant re-open original): fields for date and featured image

[efromdc]

Original post: https://theeventscalendar.com/support/forums/topic/data-dictionary-database-fields-needed-for-csv-import/

1. If Im importing CSV data into event_start_date/event_end_date, what is the correct date format? Is it “YYMMDD”? Is it “YY-MM-DD”? Four letters for year, “YYYY-MM-DD”? Relatedly, whats the proper import format for time, event_start_time / event_end_time?

2. Whats the field name for a featured image? Can it accept a url already stored on my server in my uploads dir?

[Barry]

Hi – great questions!

1. If Im importing CSV data into event_start_date/event_end_date, what is the correct date format? Is it “YYMMDD”? Is it “YY-MM-DD”? Four letters for year, “YYYY-MM-DD”? Relatedly, whats the proper import format for time, event_start_time / event_end_time?

It’s pretty tolerant and actually accepts any valid date, time or compound date/time format as specified here. A format like yyyy-mm-dd (such as 2014-02-04 for 4th February 2014) is certainly going to be valid and 24hr times expressed in hh:mm format (such as 13:00 for 1pm) will similarly be a valid format choice.

2. Whats the field name for a featured image? Can it accept a url already stored on my server in my uploads dir?

Currently that is not supported; but please do post a feature request if you feel it would be a worthy feature – we’ll certainly consider it 🙂

Does that answer your questions?

[efromdc]

I forked the plugin. I have the events excepting remote images now.

[Barry]

Great – please do consider making a pull request on our GitHub page.

https://github.com/moderntribe/the-events-calendar

[Author]

Posts