Solved

Migrating Egroupware calendar to Exchange

Posted on 2011-09-29
4
1,006 Views
Last Modified: 2012-05-12
Hi.

I'm trying to migrate calendar entries from Egroupware v1.3.015 into exchange. I've exported a users calendar to .ics file and imported this into outlook. all went fine except that all entries are five hours ahead of where they should be. I've checked the settings in eGroupware and it is set to -5 hours from server time.

I've tried moving the time to 0 hours and re-doing the export/import to no avail. I've also tried setting a PC back 5 hours and importing the ics file stil they are 5hours ahead. Any help with this would be really appreciated.

Does anyone know of any way to get this to happen, I have 40 users on eGroupware and need to get them using outlook asap.
0
Comment
Question by:arcitsol
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 9

Expert Comment

by:MNH1966
ID: 36814185
Changing the clock won't help. The TimeZone in you ics file is apparently different from your timezone. Best is to edit the ICS file (it's textbased) and modify the timezone "manually"
Search/Replace should do the trick. The Parameter you're looking for is most likely TZONE
What the value should be, depends on the timezone you're in.
Still takes some puzzeling! Reading the RFC: http://tools.ietf.org/html/rfc5545 may help...
0
 

Author Comment

by:arcitsol
ID: 36815453
Thanks for the response.

I've just gone into the file to check and below is a short extract from the start of the file, there is no TZONE settings anywhere in the file. the stars are where I've removed personal context from the user.

I'm guessing the time zone is somehow stored in the actual event.

BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//eGroupWare//NONSGML eGroupWare Calendar 1.3.001//EN
METHOD:PUBLISH

BEGIN:VEVENT
CLASS:PUBLIC
SUMMARY:BANK HOLIDAY
DTSTART:20110829T040000Z
DTEND:20110830T035959Z
ATTENDEE;CN=*******;ROLE=CHAIR;PARTSTAT=ACCEPTED;CUTYPE=INDIVIDUAL;
 RSVP=FALSE:MAILTO:*******<*******************>
PRIORITY:5
TRANSP:OPAQUE
CREATED:20110602T101902Z
LAST-MODIFIED:20110602T101900Z
UID:calendar-74188-673a0839675aa8ce61ee2ced705b484
DTSTAMP:20110929T142523Z
END:VEVENT
0
 
LVL 9

Accepted Solution

by:
MNH1966 earned 500 total points
ID: 36817134
DTSTART:20110829T040000Z
DTEND:20110830T035959Z

I read the trailing Z makes the timestamp UTC (or GMT).
If that is your timezone, I'm not sure what you can do. If not, try removing the Z and import...
0
 

Author Closing Comment

by:arcitsol
ID: 36909287
neither worked for me, as there are only 40 users going to find a different solution
0

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
In this video we show how to create an email address policy in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Mail Flow…
This video discusses moving either the default database or any database to a new volume.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question