Databases
StackOverflow2013
Postsdbo
PO
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p>see RFC5546 <a href="http://tools.ietf.org/html/rfc5546#section-4.2.3" rel="noreferrer">Update an Event</a></p> <blockquote> <p>The event is moved to a different time. The combination of the "UID" property (unchanged) and the "SEQUENCE" (bumped to 1) properties indicate the update.</p> </blockquote> <p>in your case given what you shared you probably need to add a SEQUENCE property in your ical file and increment it for every update you make.</p> <p><strong>Update:</strong> given the ical file you added, you are missing the organiser and attendee fields with below file the update work</p> <pre><code>BEGIN:VCALENDAR VERSION:2.0 CALSCALE:GREGORIAN PRODID:pyICSParser METHOD:REQUEST BEGIN:VEVENT DTSTART:20130425T090000 DTEND:20130425T100000 DTSTAMP:20130206T101100 ORGANIZER:mailto:organiser@example.com ATTENDEE:mailto:attendee@example.com UID:CALEVENT_TS090519840000000005 DESCRIPTION:test SUMMARY:test LOCATION:Test SEQUENCE:1 STATUS:CONFIRMED END:VEVENT END:VCALENDAR </code></pre> <p>Also you need to match the email address of the sender with the one from organiser and same about the attendee, something like below has been validated with google calendar.</p> <p>eml_as_string:</p> <pre><code>Subject: New Event Message-ID: &lt;238497c6d05cffae45716486e74a8009@localhost&gt; X-Priority: 3 X-Mailer: PHPMailer 5.2.2 (http://code.google.com/a/apache-extras.org/p/phpmailer/) MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="b1_238497c6d05cffae45716486e74a8009" X-Spam-Rating: mxavas8.ad.aruba.it 1.6.2 0/1000/N --b1_238497c6d05cffae45716486e74a8009 Content-Type: multipart/alternative; boundary="b2_238497c6d05cffae45716486e74a8009" --b2_238497c6d05cffae45716486e74a8009 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit test DateTimeRoom 02/05/201309.00 - 10.15ROOM1 --b2_238497c6d05cffae45716486e74a8009 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit &lt;html&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html;"&gt; &lt;style type="text/css"&gt; &lt;!-- td{ background-color: #eee; } --&gt; &lt;/style&gt; &lt;/head&gt; &lt;body style="font-family: Arial, Helvetica, sans-serif; color: #333;"&gt; &lt;p style="text-align:center;"&gt;&lt;img src="images/logo2.png" alt="Logo" /&gt;&lt;/p&gt; &lt;hr style="border: 1px solid #ccc; width: 80%;" /&gt; &lt;div style=" width: 80%; margin: 10px auto;"&gt; &lt;h4&gt;&lt;/h4&gt; &lt;h3&gt;test&lt;/h3&gt; &lt;table style="width: 400px; table-layout: fixed; border: 1px solid #ccc;"&gt; &lt;tr&gt;&lt;th&gt;Date&lt;/th&gt;&lt;th&gt;Time&lt;/th&gt;&lt;th&gt;Room&lt;/th&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;02/05/2013&lt;/td&gt;&lt;td&gt;09.00 - 10.15&lt;/td&gt;&lt;td&gt;ROOM 1&lt;/td&gt;&lt;/tr&gt; &lt;/table&gt; &lt;/div&gt; &lt;/body&gt; &lt;/html&gt; --b2_238497c6d05cffae45716486e74a8009-- --b1_238497c6d05cffae45716486e74a8009 Content-Type: text/calendar; name="event.ics" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="event.ics" BEGIN:VCALENDAR VERSION:2.0 CALSCALE:GREGORIAN PRODID:tsCalendar METHOD:REQUEST BEGIN:VEVENT DTSTART:20130502T090000 DTEND:20130502T101000 DTSTAMP:20130209T170100 ORGANIZER:mailto:test@test.eu ATTENDEE:mailto:test@test.eu UID:CALEVENT_TS090519840000000013 DESCRIPTION:test SUMMARY:test LOCATION:ROOM1 (floor: prova) SEQUENCE:1 STATUS:CONFIRMED END:VEVENT END:VCALENDAR --b1_238497c6d05cffae45716486e74a8009-- </code></pre> <p>on which below script was applied:</p> <pre><code># -*- coding:utf-8 -*- import smtplib def sendInvite(fro,to,emlasstring): mailServer = smtplib.SMTP('smtp.gmail.com', 587) mailServer.ehlo() mailServer.starttls() mailServer.ehlo() mailServer.login(login, password) mailServer.sendmail(fro, to, emlasstring) mailServer.close() newUID = "UID:newCALEVENT_TS090519840000000016" #needed to change UID as once an event was sent its UID is locked and a few attempts were needed to make the script work eml = open("SO14712929_1.eml",'r').read() emlhead = "To: "+attendee_eml+CRLF emlhead += "From:"+fro+CRLF emlhead += "Reply-To: "+fro+CRLF eml = emlhead+eml eml = eml.replace("ORGANIZER:mailto:test@test.eu","ORGANIZER:mailto:"+fro_eml) eml = eml.replace("ATTENDEE:mailto:test@test.eu","ATTENDEE:mailto:"+attendee_eml) eml = eml.replace("UID:CALEVENT_TS090519840000000013",newUID) sendInvite(fro,attendees,eml) print "invite sent" eml = open("SO14712929_2.eml",'r').read() emlhead = "To: "+attendee_eml+CRLF emlhead += "From:"+fro+CRLF emlhead += "Reply-To: "+fro+CRLF eml = emlhead+eml eml = eml.replace("ORGANIZER:mailto:test@test.eu","ORGANIZER:mailto:"+fro_eml) eml = eml.replace("ATTENDEE:mailto:test@test.eu","ATTENDEE:mailto:"+attendee_eml) eml = eml.replace("UID:CALEVENT_TS090519840000000013",newUID) sendInvite(fro,attendees,eml) print "updated invite sent" </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload