URL needed from retired plug-in iCal Importer

[tiboston]

The plug-in we were using, iCal Importer, to import events from EMS Desktop Client retired and so we upgraded to Event Aggregator. We are unable to locate the URL needed to do the scheduled import. Can you assist with helping us recover the URL that iCal Importer was using? Thank you for the help!

[Cliff]

Hi. I can try to help here.

So you’re saying the migration didn’t bring it over to your saved imports at wp-admin > Events > Imports > “Scheduled Imports” or “History” tab?

If not, you could search your database’s postmeta table for the ‘_EventIcalSource’ or ‘_EventSavedImport’ meta key(s). Let me know if you find anything there regarding EMS Desktop Client’s data. (Note it may not be the URL you’re looking for, but please send me what you find if it might be relevant.)

[tiboston]

Hi Cliff,

Thank you for the help!

Yes, so the migration did not bring over our saved imports and I can’t find anything in the WordPress admin under Events called “Scheduled Imports” or “History.” I can see look at individual events that came over and see the following EMS sync data:

EMS SYNC DATA
BookingID: 41035
Raw Event Data:
stdClass Object
(
[BookingDate] => 2020-01-04T00:00:00-05:00
[StartBookingDate] => 2020-01-04T00:00:00-05:00
[RoomDescription] => Sanctuary
[TimeEventStart] => 2020-01-04T10:15:00-05:00
[TimeEventEnd] => 2020-01-04T12:00:00-05:00
[GroupName] => Bar/Bat Mitzvah Schedule
[EventName] => Zoe Wilen Georgantas Bat Mitzvah Shabbat Service
[SetupTypeDescription] => (none)
[SetupCount] => 0
[ReservationID] => 1968
[EventCoordinator] => stdClass Object
(
)

[GroupID] => 146
[VIP] => stdClass Object
(
[0] =>
)

[VIPEvent] => false
[ClosedAllDay] => false
[OpenTime] => 1900-01-01T00:00:00-05:00
[CloseTime] => 1900-01-01T00:00:00-05:00
[GroupTypeDescription] => Worship Services
[EventTypeDescription] => Services
[Contact] => Events Manager x 153
[AltContact] => stdClass Object
(
)

[BookingID] => 41035
[TimeBookingStart] => 2020-01-04T10:15:00-05:00
[TimeBookingEnd] => 2020-01-04T12:00:00-05:00
[GMTStartTime] => 2020-01-04T10:15:00-05:00
[GMTEndTime] => 2020-01-04T12:00:00-05:00
[BuildingCode] => TI
[Building] => Temple Israel
[RoomCode] => SA
[Room] => Sanctuary
[RoomID] => 6
[BuildingID] => 1
[StatusID] => 1
[StatusTypeID] => -14
[EventTypeID] => 55
[GroupTypeID] => 5
[DateAdded] => 2017-01-11T14:49:48.8-05:00
[AddedBy] => Jennifer Cinnante
[DateChanged] => 2017-01-11T14:59:00.943-05:00
[ChangedBy] => Jennifer Cinnante
)

But this doesn’t contain an iCal feed. Is there anywhere else you can think of that would contain this link? I will talk to the IT tech about the database searches you advised.

Thank you again!

-Paul

[Cliff]

Do you have a backup of your site’s database from before Event Aggregator?

[tiboston]

Hi Cliff,

We were able to figure out this issue. There was a problem with EMS Master Calendar and it wasn’t generating the iCal feed. We have another problem though. We’re doing a scheduled import and events are now showing up twice. Can you assist with this? I went through the settings, but couldn’t find anything to change for this.

Thank you very much for the assistance!

Best,

-Paul

[Cliff]

Hi. Glad that got figured out. Bummer about the duplicates. Have you verified the iCalendar source file/URL is absent of duplicates?

[tiboston]

Yes, the source is absent of duplicates. Is there a way to delete all events on the calendar so we can do a clean import from the iCal feed? I’m only seeing that we can delete 20 at a time (and we have over 3,000 events). Thank you!

[Cliff]

First, make sure to fully delete that scheduled import job. You’ll want to set it up fresh after completing your deleting.

Increasing 20 at a time is possible by choosing “Screen Options” in the top-right corner of any post listing in wp-admin (Posts, Pages, Events, etc)

Change it from the default 20 to 100. If you change it to too high a number, like 500, selecting all and deleting will likely time out on your site… in which case you’d know to refresh the post listing page and change it to a lower number… usually 100 is okay on all server setups.

Make sure to empty the trash before setting up the import again… and make sure to select a date in the past for your new import job, or else it will import from today-forward.

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts