Bulk Calendar .ics Import

plateau_dustind

• March 01, 2023 14:51

We are migrating many email accounts from another mail server (MailSite) into cPanel. MailSite uses a modified version of maildir++ and saves all calendars in the .ics format. Is there a cPanel script or process that imports the calendar .ics files into Roundcube in bulk? I know we can manually add the calendar but that is very inefficient when there are more than a handful of email accounts with calendars that need to be migrated.

• 

  cPRex Jurassic Moderator

  • March 02, 2023 22:17

  Hey there! I don't have any good news on this one, as I don't have any tools readily-available on my end that will handle that. I only have the single upload option through Roundcube. While it doesn't help your current situation, this would make an excellent feature request if you'd like to submit one using the link in my signature. If you can do that, I'll bring it up with the team during our meeting next week.

  0
• 

  plateau_dustind

  • March 08, 2023 16:19

  I was able to import by following this knowledge base article written for /home/cpanelusername/.cpanel/icals
  . This plugin was designed specifically for ICS files exported from Horde.
  MailSite saves all calendar events as individual .ics files. This is very inconvenient as I had to first compile all those files into one. The cpanelicsimport Roundcube plugin is set to create a touch file if an import was attempted previously. I removed that file inside of /home/cpanelusername/.cpanel/icals/
  which is named .cpanel_ics_import_mailboxName@domainName
  . This can be configured to not create the touch file in /usr/local/cpanel/base/3rdparty/roundcube/plugins/cpanelicsimport/config.inc.php
  . The calendar needs to be saved as mailboxName@domainName.ics
  and dropped inside of the ../.cpanel/icals/
  directory. Then on login to Roundcube the calendar will be imported automatically.

  0
• 

  cPRex Jurassic Moderator

  • March 08, 2023 16:20

  I'm glad you found a good workaround!

  0
• 

  plateau_dustind

  • March 10, 2023 21:19

  We noticed that inside the config file ../plugins/cpanelicsimport/config.inc.php
  line 22 has a check for duplicate events. If we set it to true
  it does nothing as it will still duplicate the events in the calendar. // whether or not to check for duplicate events $config['cpanel_unique'> = false;
  Why this is important is that we want to do prep work before the move for the domains that are migrating with more than a handful of mailboxes. One of the domains has ~4000 mailboxes. We do not know how long it will take to migrate email and the calendar data on the night of the migration and would want to be prepared that we might have to migrate data one night then do a true up the following for any new messages or calendar events on the night we swing the DNS over. (Update: Our script to combine all calendar files for 4200+ mailboxes finished in ~3 minutes) Support created the case ID CPANEL-42508 for the duplicate event issue and linked the following article.

  0

Please sign in to leave a comment.