+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, CSV Calendar Export from Outlook in Technical; I am hoping someone can help to clarify the following... We are running Outlook 2010, running off an Exchange 2003 ...
  1. #1

    Join Date
    Nov 2007
    Posts
    44
    Thank Post
    1
    Thanked 3 Times in 2 Posts
    Rep Power
    14

    CSV Calendar Export from Outlook

    I am hoping someone can help to clarify the following...

    We are running Outlook 2010, running off an Exchange 2003 server (not that I think this matters).

    Every year we carry out a CSV export of our main school calendar, which is in turn given to the company that manage our website to import into an online calendar. They haven't, up till now, had a facility to automatically sync between the two.

    However we noticed that there is a problem with calendar events that are marked as an "all day event". The event displays correctly in Outlook, but when exported to CSV, the start date and end dates are different. For example:

    OUTLOOK

    Bank Holiday, All day event, 27/05/13

    CSV EXPORT

    Start Date - 27/05/13
    Subject - Bank Holiday
    Start Time - 00:00:00
    End Time - 00:00:00
    End Date - 28/05/13
    All day event - TRUE

    Am I right in assuming that the exported data is correct, and that actually there is no problem with the way Outlook/Exchange is handling the export? Interestingly I notice that when sending an appointment request via Outlook, the email contains similar information regarding the start date and end date (although once accepted, it appears correctly in the Outlook calendar).

    Is it therefore a problem with the way the website company is interpreting the data their end, when importing it into their own calendar system.

    Thanks!!

  2. #2

    Join Date
    Dec 2008
    Location
    Essex
    Posts
    2,144
    Thank Post
    1
    Thanked 326 Times in 316 Posts
    Rep Power
    77
    That looks good to me, seems like an issue at their end.

  3. #3

    Join Date
    Nov 2007
    Posts
    44
    Thank Post
    1
    Thanked 3 Times in 2 Posts
    Rep Power
    14
    Quote Originally Posted by sukh View Post
    That looks good to me, seems like an issue at their end.
    Thanks for your reply!

    So am I right in thinking that the start and end dates should be different, although the event only takes place on one day? i.e. this is by design

  4. #4

    Join Date
    Dec 2008
    Location
    Essex
    Posts
    2,144
    Thank Post
    1
    Thanked 326 Times in 316 Posts
    Rep Power
    77
    Correct, that is by design, it will have 2 dates.

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle Calendar - import from MS Outlook
    By IT_Man_Dan in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 12th November 2009, 09:08 AM
  2. [MS Office - 2007] Changing Calendar View In Outlook 2007
    By FN-GM in forum Office Software
    Replies: 1
    Last Post: 10th October 2008, 09:40 AM
  3. Exporting From Active Directory
    By tri_94 in forum Learning Network Manager
    Replies: 13
    Last Post: 24th April 2008, 03:42 PM
  4. Migrating to Outlook 2003 from Outlook Express
    By Mintsoft in forum Windows
    Replies: 3
    Last Post: 5th July 2007, 09:42 AM
  5. Moving from Outlook 2000 to 2003
    By SimonC in forum Windows
    Replies: 5
    Last Post: 9th May 2007, 04:42 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •