CiviCRM Community Forums (archive)

Greetings

I've added another date field to the New Event page, making the required edits to /ManageEvent/EventInfo.php, ManageEvent/EventInfo.tpl, DAO/Event.php files and creating a new date field in the civicrm_event table.

The field displays and works as expected, but always inserts NULL into the database. Is there another file I've neglected to edit in order to get this working?

Thanks Lobo

I'm pretty sure I added everything to DOA/Event. I attached...much appreciate it if you could take a look...this is driving me nuts.

The SQL query has NULL for recurring_date

Why didn't you just use custom fields? You can assign a custom field set to events or participants -- the former is for data specific to the event, the latter for people registering for the event.

Did you also add it to the postprocess function in that file?

I believe plans are in the works to enable the attachment of javascript to custom fields from within the interface, in one of the upcoming releases. That should improve functionality.

I think it also needs to be added to the properties array in:
CRM/Event/BAO/Event.php
around line 334.

Usually the file that is controlling the form has an associated file in the BAO subdirectory which manages how the field data is inserted/updated in the db.

Good luck with recurring events! I suspect that will present some challenges, given the existing structure.

For what it's worth (and off the top of my head), if were going to try to create a pseudo-recurring event, I would create a custom field that lists the date options for the event (e.g. if I were offering a workshop six times over the course of a year, I would create a custom  field for the participant that shows those six dates. Then when someone registers for the event, they must select which workshop date they are registering for. All registrations are tracked within the single event; you would use the Find Event to search for a specific date within that event.

But I don't know all the details of your structure. Just an idea in case you want to avoid reworking the whole event structure.

Thanks.

I've added to this file too.

'endDate'         => 'end_date',         'recurringDate'           => 'recurring_date',  ...etc.

I think the problem is I can't find where else I need to place the $rdate variable because I'm basing my knowledge on  the $end and $start variables in the EventInfo.php formRule function....which, btw, are wonderfully unique variable names.

I figured for recurring events I'd just tag each event with a unique ID and loop the INSERT for however many recurrences there are. When editing or deleting an event the user has an option to delete or edit the series, or just the particular event details they're on. I need them to show up in a calendar view as distinct entries..which is partially why I went this way.

Tried hardcoding a date value...works fine.

I've updated both BAO/Event.php and DAO/Event.php