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

  • Livius Chebeleu
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
4 months 3 days ago #127330 by Livius Chebeleu
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

Please Log in or Create an account to join the conversation.

More
4 months 2 days ago #127338 by Tuan Pham Ngoc
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
The following user(s) said Thank You: Livius Chebeleu

Please Log in or Create an account to join the conversation.

  • Livius Chebeleu
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
4 months 2 days ago #127345 by Livius Chebeleu
This worked fine, no problem. The system does still export those old parameters.

Thanks/Livius

Please Log in or Create an account to join the conversation.

  • Livius Chebeleu
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 months 4 weeks ago #127415 by Livius Chebeleu
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

Please Log in or Create an account to join the conversation.

More
3 months 4 weeks ago #127417 by Tuan Pham Ngoc
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
The following user(s) said Thank You: Livius Chebeleu

Please Log in or Create an account to join the conversation.

More
3 months 4 weeks ago #127438 by Tuan Pham Ngoc
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
The following user(s) said Thank You: Livius Chebeleu

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc