Event Export does not include zoom fields

I exported all events. I like that it followed the filter rules, and only exported upcoming events when I had it set that way.

However, it did not export "Advanced Settings" (I wanted the Notification Emails field value) nor did it export the Zoom settings "Meeting ID" and "Webinar ID".

Also, I don't think it exported whether or not it was a child or parent event. I would like to see two columns for this information. "Parent/Child" (maybe "P" or "C" values?) and a "Parent ID" column for child events with the ID of the parent.

I was hoping that these would be exported, so that I could use the exported spreadsheet as a template to allow quick importing of new Zoom events.

I haven't checked the documentation to see how to define parent and repeating events yet, so I don't know if the above missing columns are defined for inport or not.

Hello Stephan

1. I can help with exporting Notification Emails if needed as it simple to modify code to export that data

2. However, it's not possible to export Meeting ID, Webinar ID. These data is stored in params columns in #__eb_events table (like many other data such as Mailchimp Mailing List ID, ACYMailing List ID...).

3. For event type, it's hard to handle it for import, too. You would need to have two new columns:

- event_type: For standard event, value = 0. For parent event, value = 1. For children events, value=2
- parent_id: For normal events, it has value = 0. For children event, it need to have the value = ID of the parent event. However, before the importing process, we do not know ID of parent event to put it here, so it's not possible

In short, for recurring events, you could not import it. You will have to create these events manually via Events Booking -> Events section manually

Tuan

Tuan Pham Ngoc wrote: 3. For event type, it's hard to handle it for import, too. You would need to have two new columns:

- event_type: For standard event, value = 0. For parent event, value = 1. For children events, value=2
- parent_id: For normal events, it has value = 0. For children event, it need to have the value = ID of the parent event. However, before the importing process, we do not know ID of parent event to put it here, so it's not possible
 

I would also like to be able to export and import children events created in excel.

My workflow would be
1) Create Parent Events, if needed
2) Export Events (Need ID, event_type and parent_id to be in the export xlsx file.)
3) If parent event didn't already have children, change event_type to 1
4) Set parent_id of children event lines to Parent event ID
5) Import events, which would update parent events and add child events

We need to change Title, alias, Dates and Times, and An Extra Information field for each child. It's fairly time consuming to do it manually.

D
 

Hi Perhaps you can do this through phpmyadmin and manipulate the data directly in the table with one or more SQL statements.

This method will probably violate all sorts of things and runs the risk of damaging the data content of your system.

So if you are intent on trying this copy your database and try it on a test system before screwing around with your production system.