Results 1 to 5 of 5

Thread: [SOLVED] .ics File Import Went Bad...:-<

  1. #1
    Join Date
    Jan 2008
    Location
    Columbia City IN
    Posts
    68
    Rep Power
    7

    Default [SOLVED] .ics File Import Went Bad...:-<

    Have 5.0.6_GA_2313 OSS
    Importing an .ics file in from a users calender from his current calendar application. Did last month's data ok (about 70 or so events) (on 5.0.1 OSS at that time....) with out any issues. Today I imported the next three months of data (about 200 or so events) using the same method and now have 5 copies of every event that I just imported in his calendar. :-<
    Only difference is now I am on Zimbra 5.0.6 OSS - if that makes any change. Question is how can I easily go in an clean out this users calendar with out using the Web Interface and selecting each duplicate item and deleting (which I am doing now)? Looking through the .ics file I imported I do not see any dups of events. Any ideas out there?

  2. #2
    Join Date
    Oct 2007
    Location
    Columbus, OH
    Posts
    70
    Rep Power
    8

    Default

    Do you want to delete everything in the calendar? It is a little unclear if you want to remove and re-import or if you are trying to just remove duplicates. If you want to remove everything and re-import you can do it from the commandline with:
    Code:
    su - zimbra
    zmmailbox -z -m account@domain.com ef /Calendar
    .

    the "ef" will empty folder, which you cannot do to the Calendar under the web client.

    If you have the .ics file stored on the mailbox server, you can re-import it from the zmmailbox command with the PutRestUrl command

    Code:
    zmmailbox -z -m account@domain.com pru /Calendar /tmp/calendar.ics
    Last edited by alexkelly; 06-11-2008 at 10:33 AM.

  3. #3
    Join Date
    Jan 2008
    Location
    Columbia City IN
    Posts
    68
    Rep Power
    7

    Default

    I kinda wish I could remove it all...That would make things soooooo much easier, however this user has put a *ton* of new appointments in even since I did the one month migration/.ics file import a while back, which worked. At this point I am just looking for an easy way to remove the 200 x5 or so dups.
    Thanks for the responce!

  4. #4
    Join Date
    Oct 2007
    Location
    Columbus, OH
    Posts
    70
    Rep Power
    8

    Default

    That does make it a lot more difficult. I don't have any real answer on how to do that, but I would probably start with getting the .ics file from zimbra, and figuring out some shell/PERL script to parse through the .ics and remove things that are the same. Though it is entirely possible that there is some small difference between each entry that would make that step more difficult too.

    From my previous example, you can get the ics of the user from the command line by doing:
    Code:
    zmmailbox -z -m user@domain.com gru -o /tmp/calendar.ics /Calendar
    That will get the .ics of the user, and you can work on it from there...but of course, getting the ICS is easy, cleaning it up is certainly the hard part.

  5. #5
    Join Date
    Jan 2008
    Location
    Columbia City IN
    Posts
    68
    Rep Power
    7

    Default

    Alexkelly,
    Many thanks for the command line syntax!
    Using those was able to export existing, reimport origional .ics exports without any issues.:-> My suggestion to others is if you have a large amount of Calendar items to import from a .ics file, use the command line instead of the Web Interface-world of differance in speed and results. On the existing items I was able to use my friend grep then ->copy->paste->re-import <plus a bit of time> without any issues also.:-> Issue solved!

Similar Threads

  1. speed up the net
    By mcesari in forum Administrators
    Replies: 10
    Last Post: 04-25-2008, 12:24 PM
  2. mobile calender Internal Server Error
    By padraig in forum Administrators
    Replies: 19
    Last Post: 04-24-2008, 09:04 AM
  3. centos 5 zimbra 4.5.6 no statistics
    By rutman286 in forum Installation
    Replies: 9
    Last Post: 08-14-2007, 10:30 AM
  4. Traslation SVN tree status
    By meikka in forum I18N/L10N - Translations
    Replies: 7
    Last Post: 02-13-2007, 11:13 AM
  5. M3 problem with shares
    By titangears in forum Users
    Replies: 4
    Last Post: 01-12-2006, 01:01 PM

Posting Permissions

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