iCalendar “Field” list (for database schema based on iCalendar standard)

I’ve done this (for VEvents only, not supporting TODO items or Journal entires or anything like that). My implementation looks like this (after removing columns that are not specific to the question): — One table for each event. An event may have multiple rRules. Create Table [vEvent] (vEventID Integer Identity(1, 1) Not Null Constraint [vEvent.pk] … Read more

Should I store dates or recurrence rules in my database when building a calendar app?

Separate your data into two parts: the “canonical” data (the recurrence rule) and “serving” (generated dates; read-only aside from regeneration). If the canonical data changes, regenerate the “serving” data at that point. For infinite recurrences, keep some number of instances and generate more if you run out (e.g. if the user looks at their calendar … Read more

webcal:// support on Android not working – is there a supported calendar feed alternative [closed]

As the webpage says Android phones do not support webcals. However, you can subscribe the calendars to Microsoft Outlook or Google Calendar and then synchronize GoogleCalendar with Android. Also, you can install ICSSync on your device and then add calendar links to that app. https://www.webcal.guru/en-US/help?question_id=subscribe

HTML in iCal attachment

After doing some research and testing. The answer is a qualified no. Meaning: you could throw it in there, but you shouldn’t. It is not strictly forbidden by the RFC, but DESCRIPTION is not the appropriate property for HTML content. DESCRIPTION should be the plain text version of your content. The property X-ALT-DESC with a … Read more

Grouping multiple events in a single ics file (icalendar stream)

here is a simple example of an icalendar file with two events. BEGIN:VCALENDAR VERSION:2.0 PRODID:-//bobbin v0.1//NONSGML iCal Writer//EN CALSCALE:GREGORIAN METHOD:PUBLISH BEGIN:VEVENT DTSTART:20100701T080000Z DTEND:20100701T110000Z DTSTAMP:20091130T213238Z UID:1285935469767a7c7c1a9b3f0df8003a@yoursever.com CREATED:20091130T213238Z DESCRIPTION:Example event 1 LAST-MODIFIED:20091130T213238Z SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Example event 1 TRANSP:OPAQUE END:VEVENT BEGIN:VEVENT DTSTART:20100701T120000Z DTEND:20100701T130000Z DTSTAMP:20091130T213238Z UID:1285935469767a7c7c1a9b3f0df8003b@yoursever.com CREATED:20091130T213238Z DESCRIPTION:Example event 2 LAST-MODIFIED:20091130T213238Z SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Example event 2 TRANSP:OPAQUE END:VEVENT END:VCALENDAR … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)