arcitsol
asked on
Migrating Egroupware calendar to Exchange
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.
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.
ASKER
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//NONS GML eGroupWare Calendar 1.3.001//EN
METHOD:PUBLISH
BEGIN:VEVENT
CLASS:PUBLIC
SUMMARY:BANK HOLIDAY
DTSTART:20110829T040000Z
DTEND:20110830T035959Z
ATTENDEE;CN=*******;ROLE=C HAIR;PARTS TAT=ACCEPT ED;CUTYPE= INDIVIDUAL ;
RSVP=FALSE:MAILTO:*******< ********** *********>
PRIORITY:5
TRANSP:OPAQUE
CREATED:20110602T101902Z
LAST-MODIFIED:20110602T101 900Z
UID:calendar-74188-673a083 9675aa8ce6 1ee2ced705 b484
DTSTAMP:20110929T142523Z
END:VEVENT
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//NONS
METHOD:PUBLISH
BEGIN:VEVENT
CLASS:PUBLIC
SUMMARY:BANK HOLIDAY
DTSTART:20110829T040000Z
DTEND:20110830T035959Z
ATTENDEE;CN=*******;ROLE=C
RSVP=FALSE:MAILTO:*******<
PRIORITY:5
TRANSP:OPAQUE
CREATED:20110602T101902Z
LAST-MODIFIED:20110602T101
UID:calendar-74188-673a083
DTSTAMP:20110929T142523Z
END:VEVENT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
neither worked for me, as there are only 40 users going to find a different solution
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...