Hello Am 21.09.2017 um 09:27 schrieb Лскавян Витя Артемович ([email protected]): > > Hello, SOGo! > I’m writing you, because we have some problems. > After calendar migration from exchange to SOGo we have 10k wrong records in > Calendar. How can we mark this field for 10k records in Calendar (see > picture) ? > Maybe we can do it in DB ? > Thank you in advance from Moscow =) >
You can not set flags or settings from the UI in the DB. All events are stored in ics representation. Therefore you need to generate the correct ics representation of these events. Whole day events do not have any timezone setting, and their CREATED, DTSTAMP and LAST-MODIFIED entries are in UTC (Z at the end). Example: Event on saturday for the whole day generated by SOGo. BEGIN:VCALENDAR PRODID:-//Inverse inc./SOGo 2.3.22//EN VERSION:2.0 BEGIN:VEVENT UID:6A3B-59CD0D00-4F-4B18F280 SUMMARY:whole day event CLASS:PUBLIC CREATED:20170928T145418Z DTSTAMP:20170928T145418Z LAST-MODIFIED:20170928T145418Z DTSTART;VALUE=DATE:20170930 DTEND;VALUE=DATE:20171001 TRANSP:OPAQUE END:VEVENT END:VCALENDAR I would use a script doing a backup with sogo-tool of the affected users, modify their events and restore the calendars which were modified afterwards with sogo-tool restore -F ... Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
