Updating event email reminder settings via import/export of a spreadsheet

Hi Tuan,

I need to update all my events to send a reminder email 1 day before event date. I found these fields in the import template enable_auto_reminder and remind_before_x_days.

• Where is enable_auto_reminder parameter found on the event details backend definition and how is it used by the system?
• There are two email reminder parameters that can be set for an event, First reminder and Second reminder. Does the template parameter remind_before_x_days only control the First reminder? Is it possible to update the Second email reminder setting via the spreadsheet?

General questions for updating events via spreadsheet:

• I'm nervous to import event data for fields that haven't changed. Can the spreadsheet only contain the changed fields, the event ID included of course?
• Are there specific fields required in the spreadsheet to update an event?
• Or, are all fields required? The import function compares each one and if different, updates the changed value.

Thanks/Livius

Hello

1. enable_auto_reminder and remind_before_x_days are not used anymore. Forgot about these fields, please.

2. To control sending reminder emails, you can use two fields:

- send_first_reminder
- send_second_reminder

If you want to send reminder after event started, use a negative number like -4 (mean send reminder 4 days after event started)

3. To import (and update data), you will have to have data for these columns:

- id
- title
- category
- event_date
- access
- registration_access
- additional_categories

Other fields are optional

Hope it's clear and help answering your question

Regards,

Tuan

This worked fine, no problem. The system does still export those old parameters.

Thanks/Livius

Tuan,

I discovered an issue with importing just the fields you indicated in addition to the fields to be updated. If location column is not included, all events in the list have the location unset.

While not necessary for import like you indicated, location should be included in the required list.

Regards/Livius

Ah, Yes. I think I will improve the import code a bit so that the data won't be changed if you are updating data for an existing event and data for that column is not included. That would be updating data much easier.

Tuan

Hello

I improved the import code. You can now access to My Downloads menu item, download latest package, upgrade it to your site

Now, if you want to update data, you only need to include id column (contains id of the events) and the columns of the fields which you want to update. Other fields are all optional

That would help the update data process much easier, I think

Please do that and let us know if you need more assist

Regards,

Tuan

As mentioned by Livius Chebeleu, the export still includes the old fields enable_auto_reminder and remind_before_x_days.
Could you please replace them by send_first_reminder and send_second_reminder?

It would prevent me from stumbling on the same problem not able to ex/import these values.

Thanks! Nico

Ah, Yes. Thanks. I just updated the code to include these fields. This will be included in the next release of the extension (planned tomorrow)

Regards,

Tuan

Thanks for the update. The new fields are in the export table.

On the next update could you remove enable_auto_reminder column? It may be confusing for customers who don't know about this history as some events have a first reminder value but a blank value for enable_auto_reminder in the exported spreadsheet.

Regards/Livius

Yes. That makes sense. Just updated the code to remove enable_auto_reminder from export

Regards,

Tuan