Author Topic: Atmail to Roundcube?  (Read 99 times)

Offline CubaLindsell

  • Newbie
  • *
  • Posts: 1
Atmail to Roundcube?
« on: August 29, 2019, 07:11:42 AM »
Greetings,

Newbie here so please forgive any transgressions.

My company is moving from Atmail to Roundcube and I've been tasked with the data migration.

So far so good, I have some Perl that takes the Atmail addressbooks and calendars then converts and inserts into Roundcube.

But I'm stuck on one final part - recurring calendar events.

In the Atmail MySQL database there is a table called calendarObjects which has a column calendardata.
calendardata is a VCS VCALENDAR, containing the recurrance rule such as
            RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10

In Roundcube I can see in the events table the column recurrance.  Creating a new event in the roundcube GUI and making it re-occur I see
that events.recurrance now has RRULE data as above (FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10)

So my process is to update events.recurrance with the RRULE text from Atmail.
events.recurrance = YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10

After doing this I can login in to the roundcube GUI and see the calendar event but it is not recurring.
If I edit the event, Roundcube tells me it is a recurring event and would I like to save my change to all instances or just this one.
Once saved, the event becomes recurring and multiple instances are displayed.

I cannot see any change in the roundcube tables before and after I do the above.

Could anyone advise me on what I'm missing?

many thanks.