Mailing List Archive

On Mon, 2010-05-03 at 18:26 +1000, Michael Cassaniti wrote:
> Hi,
> First, I have been following on the mailing list for some time and while
> I haven't re-visited my test installation of DAViCal for a while, I am
> certainly pleased with the changes I have heard about on the list. I was
> happy to also find that it all worked as expected.
>
> The problem: My issue to resolve is quite simple. I wish to pull my
> publicly available calendar from Google (I have a URL to an iCalendar
> file), make sure there are no reminders set in this file, and replace
> the contents of a calendar inside my collection.
>
> The reason: My partner uses her iPhone for all her organising at
> present. I can't add the GMail calendar URL directly into the iPhone as
> a CalDAV URL because the iPhone has to hold my hand a bit too much. As a
> result she currently gets reminders for all my events on her phone and
> has full access rights because I have added my calendars in as if they
> were her own. Very non-ideal.
>
> My plan is to add a public URL to my own CalDAV server using DAViCal and
> allow her iPhone to connect to this. The calendar will simply be a
> republished calendar from my GMail calendar collection.
>
> I am looking for any suggestions/tips on how to accomplish this. My
> initial thoughts were to pull the full calendar from the supplied URL
> and push the calendar into DAViCal, replacing the existing data. Of
> course my credentials would need to be stored in the script, but that
> doesn't phase me for this project.

There is an option in DAViCal to let you hide alarms which are not in a
calendar which you have full rights to.

http://wiki.davical.org/w/Configuration/settings/hide_alarm

A problem for some people is that the calendar user they are using is
configured as the DAViCal admin, and so they *do* have admin rights over
*all* calendars. The fix is to create a separate user to use for
administrative purposes.

The configuration setting is pretty broad, and possibly there should be
a per-calendar setting for this.

Regards,
Andrew.


--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Necessity is the mother of documentation
------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100503/03fe603c/attachment.pgp>
-------------- next part --------------

Hi Andrew,
Perhaps I have not explained what I want to do as clearly as I should
have. I want to script a process which will take my GMail calendar
details from a Google supplied URL to an ics file and overwrite a
calendar within a collection stored in DAViCal. I am currently assuming
I can do all this with a HTTP GET from GMail and a HTTP PUT into
DAViCal. Am I on the right track?

Thanks in advance,
Michael Cassaniti

On 05/03/10 19:09, Andrew McMillan wrote:
> On Mon, 2010-05-03 at 18:26 +1000, Michael Cassaniti wrote:
>
>> Hi,
>> First, I have been following on the mailing list for some time and while
>> I haven't re-visited my test installation of DAViCal for a while, I am
>> certainly pleased with the changes I have heard about on the list. I was
>> happy to also find that it all worked as expected.
>>
>> The problem: My issue to resolve is quite simple. I wish to pull my
>> publicly available calendar from Google (I have a URL to an iCalendar
>> file), make sure there are no reminders set in this file, and replace
>> the contents of a calendar inside my collection.
>>
>> The reason: My partner uses her iPhone for all her organising at
>> present. I can't add the GMail calendar URL directly into the iPhone as
>> a CalDAV URL because the iPhone has to hold my hand a bit too much. As a
>> result she currently gets reminders for all my events on her phone and
>> has full access rights because I have added my calendars in as if they
>> were her own. Very non-ideal.
>>
>> My plan is to add a public URL to my own CalDAV server using DAViCal and
>> allow her iPhone to connect to this. The calendar will simply be a
>> republished calendar from my GMail calendar collection.
>>
>> I am looking for any suggestions/tips on how to accomplish this. My
>> initial thoughts were to pull the full calendar from the supplied URL
>> and push the calendar into DAViCal, replacing the existing data. Of
>> course my credentials would need to be stored in the script, but that
>> doesn't phase me for this project.
>>
> There is an option in DAViCal to let you hide alarms which are not in a
> calendar which you have full rights to.
>
> http://wiki.davical.org/w/Configuration/settings/hide_alarm
>
> A problem for some people is that the calendar user they are using is
> configured as the DAViCal admin, and so they *do* have admin rights over
> *all* calendars. The fix is to create a separate user to use for
> administrative purposes.
>
> The configuration setting is pretty broad, and possibly there should be
> a per-calendar setting for this.
>
> Regards,
> Andrew.
>
>
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 286 bytes
Desc: OpenPGP digital signature
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100504/273e3dea/attachment.pgp>
-------------- next part --------------

On Tue, 2010-05-04 at 10:02 +1000, Michael Cassaniti wrote:
> Hi Andrew,
> Perhaps I have not explained what I want to do as clearly as I should
> have. I want to script a process which will take my GMail calendar
> details from a Google supplied URL to an ics file and overwrite a
> calendar within a collection stored in DAViCal. I am currently assuming
> I can do all this with a HTTP GET from GMail and a HTTP PUT into
> DAViCal. Am I on the right track?

Yep.

There are also some more complicated things you could do which allow you
to do a bidirectional sync, but they're quite a lot more complicated
than the above, which will work fine for a one-way sync.

Cheers,
Andrew.
>
> Thanks in advance,
> Michael Cassaniti
>
> On 05/03/10 19:09, Andrew McMillan wrote:
> > On Mon, 2010-05-03 at 18:26 +1000, Michael Cassaniti wrote:
> >
> >> Hi,
> >> First, I have been following on the mailing list for some time and while
> >> I haven't re-visited my test installation of DAViCal for a while, I am
> >> certainly pleased with the changes I have heard about on the list. I was
> >> happy to also find that it all worked as expected.
> >>
> >> The problem: My issue to resolve is quite simple. I wish to pull my
> >> publicly available calendar from Google (I have a URL to an iCalendar
> >> file), make sure there are no reminders set in this file, and replace
> >> the contents of a calendar inside my collection.
> >>
> >> The reason: My partner uses her iPhone for all her organising at
> >> present. I can't add the GMail calendar URL directly into the iPhone as
> >> a CalDAV URL because the iPhone has to hold my hand a bit too much. As a
> >> result she currently gets reminders for all my events on her phone and
> >> has full access rights because I have added my calendars in as if they
> >> were her own. Very non-ideal.
> >>
> >> My plan is to add a public URL to my own CalDAV server using DAViCal and
> >> allow her iPhone to connect to this. The calendar will simply be a
> >> republished calendar from my GMail calendar collection.
> >>
> >> I am looking for any suggestions/tips on how to accomplish this. My
> >> initial thoughts were to pull the full calendar from the supplied URL
> >> and push the calendar into DAViCal, replacing the existing data. Of
> >> course my credentials would need to be stored in the script, but that
> >> doesn't phase me for this project.
> >>
> > There is an option in DAViCal to let you hide alarms which are not in a
> > calendar which you have full rights to.
> >
> > http://wiki.davical.org/w/Configuration/settings/hide_alarm
> >
> > A problem for some people is that the calendar user they are using is
> > configured as the DAViCal admin, and so they *do* have admin rights over
> > *all* calendars. The fix is to create a separate user to use for
> > administrative purposes.
> >
> > The configuration setting is pretty broad, and possibly there should be
> > a per-calendar setting for this.
> >
> > Regards,
> > Andrew.
> >
> >
> >
>

--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Open Source: the difference between trust and antitrust
------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100504/6e4fb510/attachment.pgp>
-------------- next part --------------

Gentlemen:

On this topic of GMail to DAViCal, is there any kind of documentation how
to migrate from Google Calendar to DAViCal? Ideally, this would include
some kind of information on how to subscribe to the DAViCal calendars in
Google Calendar, to maintain the visibility and integration with GMail.

I remember reading something about this on Andew's web page, but cannot
remember the details right now.

Thank you for a very promising product, Achim

On Tue, 04 May 2010 13:11:23 +0200
Achim <achim+davical at qustodium.net> wrote:

> Gentlemen:
>
> On this topic of GMail to DAViCal, is there any kind of documentation how
> to migrate from Google Calendar to DAViCal? Ideally, this would include
> some kind of information on how to subscribe to the DAViCal calendars in
> Google Calendar, to maintain the visibility and integration with GMail.
>
A quick response. You could export your entire Google Calendar in iCal
format and then import the file into you DAViCal account. See the web
interface: Administration->Import Calendars

--
Hilsen/Regards
Michael Rasmussen

Get my public GnuPG keys:
michael <at> rasmussen <dot> cc
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xD3C9A00E
mir <at> datanom <dot> net
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE501F51C
mir <at> miras <dot> org
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
--------------------------------------------------------------
What good is an obscenity trial except to popularize literature?
-- Nero Wolfe, "The League of Frightened Men"
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100504/29128eb8/attachment.pgp>
-------------- next part --------------

On Tue, 2010-05-04 at 13:11 +0200, Achim wrote:
> Gentlemen:
>
> On this topic of GMail to DAViCal, is there any kind of documentation how
> to migrate from Google Calendar to DAViCal? Ideally, this would include
> some kind of information on how to subscribe to the DAViCal calendars in
> Google Calendar, to maintain the visibility and integration with GMail.

Hi Achim,

If you were to do this, you would generally be subscribing to the
DAViCal calendar as an iCalendar, which is done using the URL of the
calendar collection - normally .../caldav.php/username/home/. Some
software wants that to end in ".ics" so you can do that as
well: .../caldav.php/username/home.ics for the 'home' calendar, for
example.

There isn't any page specifically about migrating from Google Calendar,
but if you want to add one to the wiki I'm sure it will help other
people in future.


> I remember reading something about this on Andew's web page, but cannot
> remember the details right now.

I did mention something in my blog about being able to sync between two
caldav servers. There is a sync-remote-caldav.php script in the Git
repository now which you can use to provide a full bidirectional sync.

This is still under development, but it works acceptably well between
Google & DAViCal. It's still a bit fiddly to set up, too.

Cheers,
Andrew.
--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
You'll be sorry...
------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100505/d6c03483/attachment.pgp>
-------------- next part --------------

Hello Michael:

I went through the following steps to import a 300KB ics file that I
downloaded from Google Calendar:

User Functions -> View my Details -> Create Collection -> Load From File:

The result: about 5 seconds of browser activity (the ics upload I assume),
an empty page with the URI
http://domain.tld/cal/admin.php?action=edit&t=collection&id=25, and a new
(empty) collection that where the owner has no "Collection Grants". I
assume there is a problem parsing the ICS from Google Calendars, how can I
debug this further?

Thanks, Achim

PS: Is it possible to change the mailing list configuration to standard
behaviour so that the "Reply to" or "From" is the list, rather than the
individual e-mail address of the sender?

On Tue, 4 May 2010 22:36:38 +0200, Michael Rasmussen <mir at datanom.net>
wrote:
> On Tue, 04 May 2010 13:11:23 +0200
> Achim <achim+davical at qustodium.net> wrote:
>
>> Gentlemen:
>>
>> On this topic of GMail to DAViCal, is there any kind of documentation
how
>> to migrate from Google Calendar to DAViCal? Ideally, this would include
>> some kind of information on how to subscribe to the DAViCal calendars
in
>> Google Calendar, to maintain the visibility and integration with GMail.
>>
> A quick response. You could export your entire Google Calendar in iCal
> format and then import the file into you DAViCal account. See the web
> interface: Administration->Import Calendars
>
> --
> Hilsen/Regards
> Michael Rasmussen
>
> Get my public GnuPG keys:
> michael <at> rasmussen <dot> cc
> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xD3C9A00E
> mir <at> datanom <dot> net
> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE501F51C
> mir <at> miras <dot> org
> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
> --------------------------------------------------------------
> What good is an obscenity trial except to popularize literature?
> -- Nero Wolfe, "The League of Frightened Men"

--
Achim J. Latz, Qustodium Internet Security
achim.latz at qustodium.net ? http://www.qustodium.net
Data Encryption ? Backup Automatisation ? E-Mail Protection


_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

Hello Michael:

I went through the following steps to import a 300KB ics file that I
downloaded from Google Calendar:

User Functions -> View my Details -> Create Collection -> Load From File:

The result: about 5 seconds of browser activity (the ics upload I assume),
an empty page with the URI
http://domain.tld/cal/admin.php?action=edit&t=collection&id=25, and a new
(empty) collection that where the owner has no "Collection Grants". I
assume there is a problem parsing the ICS from Google Calendars, how can I
debug this further?

Thanks, Achim

PS: Is it possible to change the mailing list configuration to standard
behaviour so that the "Reply to" or "From" is the list, rather than the
individual e-mail address of the sender?

On Tue, 4 May 2010 22:36:38 +0200, Michael Rasmussen <mir at datanom.net>
wrote:
> On Tue, 04 May 2010 13:11:23 +0200
> Achim <achim+davical at qustodium.net> wrote:
>
>> Gentlemen:
>>
>> On this topic of GMail to DAViCal, is there any kind of documentation
how
>> to migrate from Google Calendar to DAViCal? Ideally, this would include
>> some kind of information on how to subscribe to the DAViCal calendars
in
>> Google Calendar, to maintain the visibility and integration with GMail.
>>
> A quick response. You could export your entire Google Calendar in iCal
> format and then import the file into you DAViCal account. See the web
> interface: Administration->Import Calendars
>
> --
> Hilsen/Regards
> Michael Rasmussen
>
> Get my public GnuPG keys:
> michael <at> rasmussen <dot> cc
> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xD3C9A00E
> mir <at> datanom <dot> net
> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE501F51C
> mir <at> miras <dot> org
> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
> --------------------------------------------------------------
> What good is an obscenity trial except to popularize literature?
> -- Nero Wolfe, "The League of Frightened Men"


_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

Le 07/05/2010 13:33, Achim a ?crit :
> PS: Is it possible to change the mailing list configuration to standard
> behaviour so that the "Reply to" or "From" is the list, rather than the
> individual e-mail address of the sender?

The current behavior is correct :
http://www.unicom.com/pw/reply-to-harmful.html

--
Fabien Grumelard


_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

OK, I investigated the topic of migrating from Google Calendars to DAViCal
a bit more:

Downloading the ICS straight from the private Google Calendar URL results
in a file of 297KB. As explained before, trying to import that file fails
with DAViCAL: no events are added to the calendar, an empty page but no
error is show after the upload.

Then I exported the Google Calendar via Lightning 1.0b1, which results in
a 697KB ICS file. Same result, however: trying to import that file fails
with DAViCAL, this time I can see the following messages in apache2's error
log:
[Fri May 07 14:22:57 2010] [error] [DAViCal: LOG: check_string:the string
is UTF8 compliant, referer:
http://domain/cal/admin.php?action=edit&t=collection&id=1274
[Fri May 07 14:22:57 2010] [error] DAViCal: LOG: check_string:the string
is UTF8 compliant, referer:
http://domain/cal/admin.php?action=edit&t=collection&id=1274

Result: No events are added to the calendar.

Finally, I tried to import the 697KB file via Lightning into an empty
DAViCal calendar, which seemed to result in a bit more activity (btw, the
calendar's time zone *is* set to Europe/Madrid, contrary to some error
messages):

[Fri May 07 14:26:50 2010] [error] DAViCal: ***: ERROR: Event includes
TZID[Europe/Madrid] but users TZID[]!
[Fri May 07 14:28:02 2010] [error] DAViCal: LOG: always: Query: Possible
slow query: SQ in '/usr/share/davical/htdocs/always.php' on line 219

Result: "Items in Collection" shows 819 events, but Lightning cannot
visualise any of them.

Questions:

1) How flaky is ICS import/export in your experience? Does it depend on
file size or type of events?

2) Is there something like an ICS checker to find the offending events and
perhaps correct/delete them manually via textediting the ICS file?

3) Can we stop DAViCal blowing up the error log with (info) logging
information that should probably be eliminated:
[Fri May 07 14:31:52 2010] [error] DAViCal: LOG: REPORT: Query: SQ: Took:
0.380431 for SELECT caldav_data.*,calendar_item.* FROM caldav_data INNER
JOIN calendar_item USING(dav_id, user_no, dav_name, collection_id) LEFT
JOIN collection USING(collection_id) WHERE caldav_data.collection_id =
1274AND caldav_dat
[Fri May 07 14:31:52 2010] [error] DAViCal: LOG: REPORT: Query: SQ:
a.dav_name IN ( :href0, :href1, :href2, :href3, :href4, :href5, :href6,
:href7, :href8, :href9, :href10, :href11, :href12, :href13, :href14,
:href15, :href16, :href17, :href18, :href19, :href20, :href21, :href22,
:href23, :href24, :href25,
[Fri May 07 14:31:52 2010] [error] DAViCal: LOG: REPORT: Query: SQ:
:href26, :href27, :href28, :href29, :href30, :href31, :href32, :href33,
:href34, :href35, :href36, :href37, :href38, :href39, :href40, :href41,
:href42, :href43, :href44, :href45, :href46, :href47, :href48, :href49,
:href50, :href51, :href5

Thanks, Achim

On Fri, 07 May 2010 13:33:45 +0200, Achim <achim+davical at qustodium.net>
wrote:
> Hello Michael:
>
> I went through the following steps to import a 300KB ics file that I
> downloaded from Google Calendar:
>
> User Functions -> View my Details -> Create Collection -> Load From
File:
>
> The result: about 5 seconds of browser activity (the ics upload I
assume),
> an empty page with the URI
> http://domain.tld/cal/admin.php?action=edit&t=collection&id=25, and a
new
> (empty) collection that where the owner has no "Collection Grants". I
> assume there is a problem parsing the ICS from Google Calendars, how can
I
> debug this further?
>
> Thanks, Achim
>
> PS: Is it possible to change the mailing list configuration to standard
> behaviour so that the "Reply to" or "From" is the list, rather than the
> individual e-mail address of the sender?
>
> On Tue, 4 May 2010 22:36:38 +0200, Michael Rasmussen <mir at datanom.net>
> wrote:
>> On Tue, 04 May 2010 13:11:23 +0200
>> Achim <achim+davical at qustodium.net> wrote:
>>
>>> Gentlemen:
>>>
>>> On this topic of GMail to DAViCal, is there any kind of documentation
> how
>>> to migrate from Google Calendar to DAViCal? Ideally, this would
include
>>> some kind of information on how to subscribe to the DAViCal calendars
> in
>>> Google Calendar, to maintain the visibility and integration with
GMail.
>>>
>> A quick response. You could export your entire Google Calendar in iCal
>> format and then import the file into you DAViCal account. See the web
>> interface: Administration->Import Calendars
>>
>> --
>> Hilsen/Regards
>> Michael Rasmussen
>>
>> Get my public GnuPG keys:
>> michael <at> rasmussen <dot> cc
>> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xD3C9A00E
>> mir <at> datanom <dot> net
>> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE501F51C
>> mir <at> miras <dot> org
>> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
>> --------------------------------------------------------------
>> What good is an obscenity trial except to popularize literature?
>> -- Nero Wolfe, "The League of Frightened Men"
>
>


_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

On Fri, 2010-05-07 at 13:29 +0200, Achim J. Latz wrote:
>
> PS: Is it possible to change the mailing list configuration to standard
> behaviour so that the "Reply to" or "From" is the list, rather than the
> individual e-mail address of the sender?

Hi Achim,

It is in no way standard behaviour to overwrite user-supplied headers
with arbitrary values. Such (broken) processing makes it difficult to
reply to only the poster of an e-mail, especially one who actually makes
use of the Reply-to header to indicate where replies should be directed
to.

No mailing list that I administer will *ever* behave in such a manner.

:-)
Andrew.

--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
I have not seen high-discipline processes succeed in commercial
settings. - Alistair Cockburn

------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100509/78d98aff/attachment.pgp>
-------------- next part --------------

-------------- next part --------------
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

On Fri, 2010-05-07 at 14:45 +0200, Achim wrote:
> OK, I investigated the topic of migrating from Google Calendars to DAViCal
> a bit more:
>
> Downloading the ICS straight from the private Google Calendar URL results
> in a file of 297KB. As explained before, trying to import that file fails
> with DAViCAL: no events are added to the calendar, an empty page but no
> error is show after the upload.

When DAViCal processes the import, it does an 'all or nothing' job. In
fact it wraps the whole process in a database transaction, and if import
fails at some point then the entire process fails.

I have seen a number of errors in Google event data which can cause such
a failure, notably I have seen events set for year '0000' which
obviously never happened(!)

In 0.9.9 you can set the following configuration item:

$c->skip_bad_event_on_import = true;

Which will narrow the transaction boundary only to each individual
event, meaning that each event which is successfully imported will be
added, and the ones that aren't will not.

Another reason for the import failing is often because the memory
allocated to PHP is insufficient. Unfortunately the process of parsing
a large iCalendar file involves holding several times that quantity of
data in memory, so it's best to increase PHP's memory settings, at least
temporarily, while doing this.


> Then I exported the Google Calendar via Lightning 1.0b1, which results in
> a 697KB ICS file. Same result, however: trying to import that file fails
> with DAViCAL, this time I can see the following messages in apache2's error
> log:
> [Fri May 07 14:22:57 2010] [error] [.DAViCal: LOG: check_string:the string
> is UTF8 compliant, referer:
> http://domain/cal/admin.php?action=edit&t=collection&id=1274
> [Fri May 07 14:22:57 2010] [error] DAViCal: LOG: check_string:the string
> is UTF8 compliant, referer:
> http://domain/cal/admin.php?action=edit&t=collection&id=1274
>
> Result: No events are added to the calendar.
>
> Finally, I tried to import the 697KB file via Lightning into an empty
> DAViCal calendar, which seemed to result in a bit more activity (btw, the
> calendar's time zone *is* set to Europe/Madrid, contrary to some error
> messages):
>
> [Fri May 07 14:26:50 2010] [error] DAViCal: ***: ERROR: Event includes
> TZID[Europe/Madrid] but users TZID[]!
> [Fri May 07 14:28:02 2010] [error] DAViCal: LOG: always: Query: Possible
> slow query: SQ in '/usr/share/davical/htdocs/always.php' on line 219
>
> Result: "Items in Collection" shows 819 events, but Lightning cannot
> visualise any of them.
>
> Questions:
>
> 1) How flaky is ICS import/export in your experience? Does it depend on
> file size or type of events?

In general DAViCal does as little parsing of event data as it can get
away with. Primarily this involves parsing the structure, and
extracting fields from it. The error above indicates that the event
includes a VTIMEZONE for Europe/Madrid, but the event itself does not
refer to that timezone.


> 2) Is there something like an ICS checker to find the offending events and
> perhaps correct/delete them manually via text editing the ICS file?

Not that I'm aware of...


> 3) Can we stop DAViCal blowing up the error log with (info) logging
> information that should probably be eliminated:

> [Fri May 07 14:31:52 2010] [error] DAViCal: LOG: REPORT: Query: SQ: Took:

The 'SQ:' log is a 'Slow Query' which is triggered for any query taking
'longer than expected'. What is 'normal' for a query during calendar
import does tend to differ from normal operation, so it isn't unusual to
see some of these at that time. During normal operation you should only
see them occasionally.

Since this stuff operates in the background, it is important to have
this kind of facility to know that 'something is running slower than
expected', and logging the full detail of the query is essential for
debugging that kind of thing...

Cheers,
Andrew.

--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
I have not seen high-discipline processes succeed in commercial
settings. - Alistair Cockburn

------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100509/2347b353/attachment.pgp>
-------------- next part --------------

-------------- next part --------------
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

Hello Andrew:

On Wed, 05 May 2010 08:53:37 +1200, Andrew McMillan <andrew at morphoss.com>
wrote:
> If you were to do this, you would generally be subscribing to the
> DAViCal calendar as an iCalendar, which is done using the URL of the
> calendar collection - normally .../caldav.php/username/home/. Some
> software wants that to end in ".ics" so you can do that as
> well: .../caldav.php/username/home.ics for the 'home' calendar, for
> example.

OK, although I get the infamous "Could not fetch the URL because
robots.txt prevents us from crawling the URL." error on my
password-protected calendars. It appears that Google cannot subscribe to
password-protected calendards at the moment [1], despite the underlying
concern of giving Google the password. Leaving the calendar unprotected is
not an option, IMHO.

Did anybody already investigate how to make DAViCal more friendly towards
iPhone autoconfiguration, e.g. using 8443 as the port and
/pricincipals/username as the path, rather than $alias/caldav.php?

> There isn't any page specifically about migrating from Google Calendar,
> but if you want to add one to the wiki I'm sure it will help other
> people in future.

After going through it, I can attest that the process is as easy as

1) Install DAViCal
2) Export calendars from google to ICS files
3) Create calendars in DAViCal and import the ICS files from step 2)
4) Done

Optional 3a) Subscribe to calendars from within Google, but this is
prevented for me at the moment due to the password issue outlined above.

> I did mention something in my blog about being able to sync between two
> caldav servers. There is a sync-remote-caldav.php script in the Git
> repository now which you can use to provide a full bidirectional sync.
>
> This is still under development, but it works acceptably well between
> Google & DAViCal. It's still a bit fiddly to set up, too.

This could be a hack to get Google to the same status as the DAViCal
calendars, but I understand that a lot of manual configuration is required
WRT passwords etc for different users and calendars, so I haven't looked
further into it.

Thanks for the help, Achim

[1]
<http://www.google.com/support/forum/p/Calendar/thread?tid=5194ce75b3788c36&hl=en>


_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

On Tue, 11 May 2010 18:02:56 +0200
Achim <achim+davical at qustodium.net> wrote:

>
> Did anybody already investigate how to make DAViCal more friendly towards
> iPhone autoconfiguration, e.g. using 8443 as the port and
> /pricincipals/username as the path, rather than $alias/caldav.php?
>
Portnumber:
Simply configure your Apache to listen on port 8443 as well.

URL:
use mod_rewrite
eg. (untested since I have no iPhone)
RewriteRule ^/principals/(.*)$ /caldav.php/$1 [NC,L]

--
Hilsen/Regards
Michael Rasmussen

Get my public GnuPG keys:
michael <at> rasmussen <dot> cc
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xD3C9A00E
mir <at> datanom <dot> net
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE501F51C
mir <at> miras <dot> org
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
--------------------------------------------------------------
Each module should do one thing well.
- The Elements of Programming Style (Kernighan & Plaugher)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100511/657866de/attachment.pgp>
-------------- next part --------------

-------------- next part --------------
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

On Tue, 2010-05-11 at 18:02 +0200, Achim wrote:
> Hello Andrew:
>
> On Wed, 05 May 2010 08:53:37 +1200, Andrew McMillan <andrew at morphoss.com>
> wrote:
> > If you were to do this, you would generally be subscribing to the
> > DAViCal calendar as an iCalendar, which is done using the URL of the
> > calendar collection - normally .../caldav.php/username/home/. Some
> > software wants that to end in ".ics" so you can do that as
> > well: .../caldav.php/username/home.ics for the 'home' calendar, for
> > example.
>
> OK, although I get the infamous "Could not fetch the URL because
> robots.txt prevents us from crawling the URL." error on my
> password-protected calendars. It appears that Google cannot subscribe to
> password-protected calendards at the moment [1], despite the underlying
> concern of giving Google the password. Leaving the calendar unprotected is
> not an option, IMHO.

Ah, OK. Then you would really need to use my sync-remote-caldav script
and push changes to Google that way.



> Did anybody already investigate how to make DAViCal more friendly towards
> iPhone autoconfiguration, e.g. using 8443 as the port and
> /pricincipals/username as the path, rather than $alias/caldav.php?

Lots of people. There's a page or so on the wiki about what to do
there, though I don't think it goes as far as adding _srv records to
your DNS to publicise the CalDAV server. It would be great to see
documentation of that added to it, if you're in a position to do that.

DAViCal recognises the /principals/users/... path for a first hit, so
you just need to ensure that gets rewritten to a call to caldav.php so
that it sees it.


> > There isn't any page specifically about migrating from Google Calendar,
> > but if you want to add one to the wiki I'm sure it will help other
> > people in future.
>
> After going through it, I can attest that the process is as easy as
>
> 1) Install DAViCal
> 2) Export calendars from google to ICS files
> 3) Create calendars in DAViCal and import the ICS files from step 2)
> 4) Done
>
> Optional 3a) Subscribe to calendars from within Google, but this is
> prevented for me at the moment due to the password issue outlined above.

Sounds correct.


> > I did mention something in my blog about being able to sync between two
> > caldav servers. There is a sync-remote-caldav.php script in the Git
> > repository now which you can use to provide a full bidirectional sync.
> >
> > This is still under development, but it works acceptably well between
> > Google & DAViCal. It's still a bit fiddly to set up, too.
>
> This could be a hack to get Google to the same status as the DAViCal
> calendars, but I understand that a lot of manual configuration is required
> WRT passwords etc for different users and calendars, so I haven't looked
> further into it.

Yeah. It probably needs to be wrapped in a shell script, and then you
would probably want to run it from cron.

Cheers,
Andrew.

--
------------------------------------------------------------------------
http://andrew.mcmillan.net.nz/ Porirua, New Zealand
Twitter: _karora Phone: +64(272)DEBIAN
question = ( to ) ? be : ! be;
-- Wm. Shakespeare
------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100512/b00d6d79/attachment.pgp>
-------------- next part --------------

-------------- next part --------------
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

Hi All,
I have tried the following successfully to overwrite and upload a
calendar from Google:

curl
http://www.google.com/calendar/ical/....%40group.calendar.google.com/public/basic.ics
curl -u <username>:<password> -T basic.ics
http://c<server_FQDN>/davical/caldav.php/<username>/<collection>/

I found I required the following setting:
$c->readonly_webdav_collections = false

Without it the command completes successfully, but calendar is empty. A
check of the Apache logs does not reveal anything.
I don't believe there is a comprehensive list of DAViCal options
anywhere as of yet, so this might be a good idea to start. I know the
wiki has some, but it needs a lot more I feel.

I thought I would send this along as an FYI.

Regards,
Michael Cassaniti

On 05/04/10 10:09, Andrew McMillan wrote:
> On Tue, 2010-05-04 at 10:02 +1000, Michael Cassaniti wrote:
>
>> Hi Andrew,
>> Perhaps I have not explained what I want to do as clearly as I should
>> have. I want to script a process which will take my GMail calendar
>> details from a Google supplied URL to an ics file and overwrite a
>> calendar within a collection stored in DAViCal. I am currently assuming
>> I can do all this with a HTTP GET from GMail and a HTTP PUT into
>> DAViCal. Am I on the right track?
>>
> Yep.
>
> There are also some more complicated things you could do which allow you
> to do a bidirectional sync, but they're quite a lot more complicated
> than the above, which will work fine for a one-way sync.
>
> Cheers,
> Andrew.
>
>> Thanks in advance,
>> Michael Cassaniti
>>
>> On 05/03/10 19:09, Andrew McMillan wrote:
>>
>>> On Mon, 2010-05-03 at 18:26 +1000, Michael Cassaniti wrote:
>>>
>>>
>>>> Hi,
>>>> First, I have been following on the mailing list for some time and while
>>>> I haven't re-visited my test installation of DAViCal for a while, I am
>>>> certainly pleased with the changes I have heard about on the list. I was
>>>> happy to also find that it all worked as expected.
>>>>
>>>> The problem: My issue to resolve is quite simple. I wish to pull my
>>>> publicly available calendar from Google (I have a URL to an iCalendar
>>>> file), make sure there are no reminders set in this file, and replace
>>>> the contents of a calendar inside my collection.
>>>>
>>>> The reason: My partner uses her iPhone for all her organising at
>>>> present. I can't add the GMail calendar URL directly into the iPhone as
>>>> a CalDAV URL because the iPhone has to hold my hand a bit too much. As a
>>>> result she currently gets reminders for all my events on her phone and
>>>> has full access rights because I have added my calendars in as if they
>>>> were her own. Very non-ideal.
>>>>
>>>> My plan is to add a public URL to my own CalDAV server using DAViCal and
>>>> allow her iPhone to connect to this. The calendar will simply be a
>>>> republished calendar from my GMail calendar collection.
>>>>
>>>> I am looking for any suggestions/tips on how to accomplish this. My
>>>> initial thoughts were to pull the full calendar from the supplied URL
>>>> and push the calendar into DAViCal, replacing the existing data. Of
>>>> course my credentials would need to be stored in the script, but that
>>>> doesn't phase me for this project.
>>>>
>>>>
>>> There is an option in DAViCal to let you hide alarms which are not in a
>>> calendar which you have full rights to.
>>>
>>> http://wiki.davical.org/w/Configuration/settings/hide_alarm
>>>
>>> A problem for some people is that the calendar user they are using is
>>> configured as the DAViCal admin, and so they *do* have admin rights over
>>> *all* calendars. The fix is to create a separate user to use for
>>> administrative purposes.
>>>
>>> The configuration setting is pretty broad, and possibly there should be
>>> a per-calendar setting for this.
>>>
>>> Regards,
>>> Andrew.
>>>
>>>
>>>
>>>
>>
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 286 bytes
Desc: OpenPGP digital signature
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100514/1bf3df09/attachment.pgp>
-------------- next part --------------

-------------- next part --------------
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

On Fri, 2010-05-14 at 20:27 +1000, Michael Cassaniti wrote:
> Hi All,
> I have tried the following successfully to overwrite and upload a
> calendar from Google:
>
> curl
> http://www.google.com/calendar/ical/....%40group.calendar.google.com/public/basic.ics
> curl -u <username>:<password> -T basic.ics
> http://c<server_FQDN>/davical/caldav.php/<username>/<collection>/
>
> I found I required the following setting:
> $c->readonly_webdav_collections = false
>
> Without it the command completes successfully, but calendar is empty. A
> check of the Apache logs does not reveal anything.

It could well be subtle, but what you should see in the Apache logs is a
"405 Method Not Allowed" response. At least that's what the code
currently says, but it's possible something has changed in that area
since 0.9.9 was released.


> I don't believe there is a comprehensive list of DAViCal options
> anywhere as of yet, so this might be a good idea to start. I know the
> wiki has some, but it needs a lot more I feel.

Yes, it does.

There are a lot which are documented in the example configuration file,
and it would be nice if someone could take it upon themselves to convert
each of those to a wiki page under configuration/settings, as I have
been endeavouring to do for each new one, and also for old ones where
people ask me about them, or where I have to tell people about them.

Cheers,
Andrew.


>
> I thought I would send this along as an FYI.
>
> Regards,
> Michael Cassaniti
>
> On 05/04/10 10:09, Andrew McMillan wrote:
> > On Tue, 2010-05-04 at 10:02 +1000, Michael Cassaniti wrote:
> >
> >> Hi Andrew,
> >> Perhaps I have not explained what I want to do as clearly as I should
> >> have. I want to script a process which will take my GMail calendar
> >> details from a Google supplied URL to an ics file and overwrite a
> >> calendar within a collection stored in DAViCal. I am currently assuming
> >> I can do all this with a HTTP GET from GMail and a HTTP PUT into
> >> DAViCal. Am I on the right track?
> >>
> > Yep.
> >
> > There are also some more complicated things you could do which allow you
> > to do a bidirectional sync, but they're quite a lot more complicated
> > than the above, which will work fine for a one-way sync.
> >
> > Cheers,
> > Andrew.
> >
> >> Thanks in advance,
> >> Michael Cassaniti
> >>
> >> On 05/03/10 19:09, Andrew McMillan wrote:
> >>
> >>> On Mon, 2010-05-03 at 18:26 +1000, Michael Cassaniti wrote:
> >>>
> >>>
> >>>> Hi,
> >>>> First, I have been following on the mailing list for some time and while
> >>>> I haven't re-visited my test installation of DAViCal for a while, I am
> >>>> certainly pleased with the changes I have heard about on the list. I was
> >>>> happy to also find that it all worked as expected.
> >>>>
> >>>> The problem: My issue to resolve is quite simple. I wish to pull my
> >>>> publicly available calendar from Google (I have a URL to an iCalendar
> >>>> file), make sure there are no reminders set in this file, and replace
> >>>> the contents of a calendar inside my collection.
> >>>>
> >>>> The reason: My partner uses her iPhone for all her organising at
> >>>> present. I can't add the GMail calendar URL directly into the iPhone as
> >>>> a CalDAV URL because the iPhone has to hold my hand a bit too much. As a
> >>>> result she currently gets reminders for all my events on her phone and
> >>>> has full access rights because I have added my calendars in as if they
> >>>> were her own. Very non-ideal.
> >>>>
> >>>> My plan is to add a public URL to my own CalDAV server using DAViCal and
> >>>> allow her iPhone to connect to this. The calendar will simply be a
> >>>> republished calendar from my GMail calendar collection.
> >>>>
> >>>> I am looking for any suggestions/tips on how to accomplish this. My
> >>>> initial thoughts were to pull the full calendar from the supplied URL
> >>>> and push the calendar into DAViCal, replacing the existing data. Of
> >>>> course my credentials would need to be stored in the script, but that
> >>>> doesn't phase me for this project.
> >>>>
> >>>>
> >>> There is an option in DAViCal to let you hide alarms which are not in a
> >>> calendar which you have full rights to.
> >>>
> >>> http://wiki.davical.org/w/Configuration/settings/hide_alarm
> >>>
> >>> A problem for some people is that the calendar user they are using is
> >>> configured as the DAViCal admin, and so they *do* have admin rights over
> >>> *all* calendars. The fix is to create a separate user to use for
> >>> administrative purposes.
> >>>
> >>> The configuration setting is pretty broad, and possibly there should be
> >>> a per-calendar setting for this.
> >>>
> >>> Regards,
> >>> Andrew.
> >>>
> >>>
> >>>
> >>>
> >>
> >
>

--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Q: Why did Menachem Begin invade Lebanon?
A: To impress Jodie Foster.

------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100514/2838c6d4/attachment.pgp>
-------------- next part --------------

-------------- next part --------------
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

Post is at the bottom (where were my manners before)

On 05/14/10 20:36, Andrew McMillan wrote:
> On Fri, 2010-05-14 at 20:27 +1000, Michael Cassaniti wrote:
>
>> Hi All,
>> I have tried the following successfully to overwrite and upload a
>> calendar from Google:
>>
>> curl
>> http://www.google.com/calendar/ical/....%40group.calendar.google.com/public/basic.ics
>> curl -u <username>:<password> -T basic.ics
>> http://c<server_FQDN>/davical/caldav.php/<username>/<collection>/
>>
>> I found I required the following setting:
>> $c->readonly_webdav_collections = false
>>
>> Without it the command completes successfully, but calendar is empty. A
>> check of the Apache logs does not reveal anything.
>>
> It could well be subtle, but what you should see in the Apache logs is a
> "405 Method Not Allowed" response. At least that's what the code
> currently says, but it's possible something has changed in that area
> since 0.9.9 was released.
>
>
>
>> I don't believe there is a comprehensive list of DAViCal options
>> anywhere as of yet, so this might be a good idea to start. I know the
>> wiki has some, but it needs a lot more I feel.
>>
> Yes, it does.
>
> There are a lot which are documented in the example configuration file,
> and it would be nice if someone could take it upon themselves to convert
> each of those to a wiki page under configuration/settings, as I have
> been endeavouring to do for each new one, and also for old ones where
> people ask me about them, or where I have to tell people about them.
>
> Cheers,
> Andrew.
>
>
>
>> I thought I would send this along as an FYI.
>>
>> Regards,
>> Michael Cassaniti
>>
>> On 05/04/10 10:09, Andrew McMillan wrote:
>>
>>> On Tue, 2010-05-04 at 10:02 +1000, Michael Cassaniti wrote:
>>>
>>>
>>>> Hi Andrew,
>>>> Perhaps I have not explained what I want to do as clearly as I should
>>>> have. I want to script a process which will take my GMail calendar
>>>> details from a Google supplied URL to an ics file and overwrite a
>>>> calendar within a collection stored in DAViCal. I am currently assuming
>>>> I can do all this with a HTTP GET from GMail and a HTTP PUT into
>>>> DAViCal. Am I on the right track?
>>>>
>>>>
>>> Yep.
>>>
>>> There are also some more complicated things you could do which allow you
>>> to do a bidirectional sync, but they're quite a lot more complicated
>>> than the above, which will work fine for a one-way sync.
>>>
>>> Cheers,
>>> Andrew.
>>>
>>>
>>>> Thanks in advance,
>>>> Michael Cassaniti
>>>>
>>>> On 05/03/10 19:09, Andrew McMillan wrote:
>>>>
>>>>
>>>>> On Mon, 2010-05-03 at 18:26 +1000, Michael Cassaniti wrote:
>>>>>
>>>>>
>>>>>
>>>>>> Hi,
>>>>>> First, I have been following on the mailing list for some time and while
>>>>>> I haven't re-visited my test installation of DAViCal for a while, I am
>>>>>> certainly pleased with the changes I have heard about on the list. I was
>>>>>> happy to also find that it all worked as expected.
>>>>>>
>>>>>> The problem: My issue to resolve is quite simple. I wish to pull my
>>>>>> publicly available calendar from Google (I have a URL to an iCalendar
>>>>>> file), make sure there are no reminders set in this file, and replace
>>>>>> the contents of a calendar inside my collection.
>>>>>>
>>>>>> The reason: My partner uses her iPhone for all her organising at
>>>>>> present. I can't add the GMail calendar URL directly into the iPhone as
>>>>>> a CalDAV URL because the iPhone has to hold my hand a bit too much. As a
>>>>>> result she currently gets reminders for all my events on her phone and
>>>>>> has full access rights because I have added my calendars in as if they
>>>>>> were her own. Very non-ideal.
>>>>>>
>>>>>> My plan is to add a public URL to my own CalDAV server using DAViCal and
>>>>>> allow her iPhone to connect to this. The calendar will simply be a
>>>>>> republished calendar from my GMail calendar collection.
>>>>>>
>>>>>> I am looking for any suggestions/tips on how to accomplish this. My
>>>>>> initial thoughts were to pull the full calendar from the supplied URL
>>>>>> and push the calendar into DAViCal, replacing the existing data. Of
>>>>>> course my credentials would need to be stored in the script, but that
>>>>>> doesn't phase me for this project.
>>>>>>
>>>>>>
>>>>>>
>>>>> There is an option in DAViCal to let you hide alarms which are not in a
>>>>> calendar which you have full rights to.
>>>>>
>>>>> http://wiki.davical.org/w/Configuration/settings/hide_alarm
>>>>>
>>>>> A problem for some people is that the calendar user they are using is
>>>>> configured as the DAViCal admin, and so they *do* have admin rights over
>>>>> *all* calendars. The fix is to create a separate user to use for
>>>>> administrative purposes.
>>>>>
>>>>> The configuration setting is pretty broad, and possibly there should be
>>>>> a per-calendar setting for this.
>>>>>
>>>>> Regards,
>>>>> Andrew.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>

I found that the data does upload when running the following on the
database: select * from caldav_data; This showed me that the ics file
was uploaded by looking at the dav_name field (it was
<username>/google/google.ics).

I could successfully upload the Google calendar using the we interface
of DAViCal, but I am not sure if this can be exposed easily at the
command line. At present I wish to keep a cloned copy of my Google
calendar within DAViCal, not migrate.

Any ideas,

Thanks in advance,
Michael Cassaniti


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 286 bytes
Desc: OpenPGP digital signature
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100519/31469716/attachment.pgp>
-------------- next part --------------

-------------- next part --------------
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general

On Wed, 2010-05-19 at 20:24 +1000, Michael Cassaniti wrote:

> >> I have tried the following successfully to overwrite and upload a
> >> calendar from Google:
> >>
> >> curl
> >> http://www.google.com/calendar/ical/....%40group.calendar.google.com/public/basic.ics
> >> curl -u <username>:<password> -T basic.ics
> >> http://c<server_FQDN>/davical/caldav.php/<username>/<collection>/
> >>
> >> I found I required the following setting:
> >> $c->readonly_webdav_collections = false
> >>
> >> Without it the command completes successfully, but calendar is empty. A
> >> check of the Apache logs does not reveal anything.
> >>
> > It could well be subtle, but what you should see in the Apache logs is a
> > "405 Method Not Allowed" response. At least that's what the code
> > currently says, but it's possible something has changed in that area
> > since 0.9.9 was released.


> Hi,
> This technique was successfully working (I found I was using 0.9.8.3),
> but is not working with the same configuration on a brand new install of
> 0.9.9.
>
> I found that the data does upload when running the following on the
> database: select * from caldav_data; This showed me that the ics file
> was uploaded by looking at the dav_name field (it was
> <username>/google/google.ics).

Sounds like you are PUTing it to the wrong URL. Surely it should
be .../caldav.php/<username>/google/ - without any 'google.ics' on the
end.

The command-line above seems deficient in that you also need to provide
a "Content-type: text/calendar" along with the request. Perhaps some
magic was happening in the earlier case for Curl to provide that for
you, but you should probably add something like this to be doubly
sure...:

--header 'Content-type: text/calendar'


> I could successfully upload the Google calendar using the web interface
> of DAViCal, but I am not sure if this can be exposed easily at the
> command line.

It would be way more complicated, requiring login session cookies and
suchlike, to the extent that I wouldn't recommend it.

Cheers,
Andrew.

--
------------------------------------------------------------------------
http://andrew.mcmillan.net.nz/ Porirua, New Zealand
Twitter: _karora Phone: +64(272)DEBIAN
You are number 6! Who is number one?
------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100520/5ebb4848/attachment.pgp>
-------------- next part --------------

-------------- next part --------------
_______________________________________________
rscds-general mailing list
rscds-general at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rscds-general