Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DAViCal: General

Export to ics and vcard

 

 

DAViCal general RSS feed   Index | Next | Previous | View Threaded


arthur.chereau at gmail

Jul 9, 2012, 1:39 PM

Post #1 of 9 (1211 views)
Permalink
Export to ics and vcard

I just installed DAViCal 1.1.1 and it's working fine. Thanks !

Now, I would like to backup my calendars and contacts in a format that's
portable and usable with any CalDAV/CardDAV server, I mean ics and vcard.

Unfortunately, I haven't found in the DAViCal package or the Web a
script that connects to the database and just outputs a calendar.ics or
a contacts.vcf file. I don't want to use wget, because I don't want to
put a password in a script, and it doesn't work with contacts
collections. I need something that gets the data directly from the DB.

Do you know where I can find such a simple ics/vcard export script ?

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Davical-general mailing list
Davical-general [at] lists
https://lists.sourceforge.net/lists/listinfo/davical-general


jon at azrider

Jul 9, 2012, 2:29 PM

Post #2 of 9 (1184 views)
Permalink
Re: Export to ics and vcard [In reply to]

I don't know about the vcard but you can dump ical from davical at:

http://username:password [at] DavicalAddres:port/caldav.php/collection/calendar.ics"]"http://username:password [at] DavicalAddres:port/caldav.php/collection/calendar.ics"


in my case (collection name is 'calendar'):
http://username:password [at] 192:8118/caldav.php/calendar/jon.ics"]http://username:password [at] 192:8118/caldav.php/calendar/jon.ics


I have also set up a 60 minute chron to output to an intranet address in linux for a oneway sync for my phone:

#!/bin/bash
#
cd /home/jon/www/calendar
wget -N http://username:password [at] 192:8118/caldav.php/calendar/marlo.ics"]http://username:password [at] 192:8118/caldav.php/calendar/marlo.ics /home/jon/www/calendar/marlo.ics
wget -N http://username:password [at] 192:8118/caldav.php/calendar/jon.ics"]http://username:password [at] 192:8118/caldav.php/calendar/jon.ics /home/jon/www/calendar/jon.ics
wget -N http://username:password [at] 192:8118/caldav.php/calendar/both.ics"]http://username:password [at] 192:8118/caldav.php/calendar/both.ics /home/jon/www/calendar/both.ics



Hope this helps.

Jon Archer
"I can't change the direction of the wind, but I can adjust my sails to always reach my destination." - Jimmy Dean

Down to Earth Enterprises - Psychological Services
1237 W. Auburn Dr.
Tempe, AZ 85283
http://www.drmarlo.com"]www.drmarlo.com
480-705-5007


On 07/09/2012 01:39 PM, Arthur Chereau wrote:
I just installed DAViCal 1.1.1 and it's working fine. Thanks ! Now, I would like to backup my calendars and contacts in a format that's portable and usable with any CalDAV/CardDAV server, I mean ics and vcard. Unfortunately, I haven't found in the DAViCal package or the Web a script that connects to the database and just outputs a calendar.ics or a contacts.vcf file. I don't want to use wget, because I don't want to put a password in a script, and it doesn't work with contacts collections. I need something that gets the data directly from the DB. Do you know where I can find such a simple ics/vcard export script ? ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/"]http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Davical-general mailing list Davical-general [at] lists https://lists.sourceforge.net/lists/listinfo/davical-general"]https://lists.sourceforge.net/lists/listinfo/davical-general


arthur.chereau at gmail

Jul 10, 2012, 1:33 PM

Post #3 of 9 (1188 views)
Permalink
Re: Export to ics and vcard [In reply to]

Thanks, but as I said I don't want to use wget because I don't want to
put passwords in a script, and your method doesn't work with contacts. I
need something that directly queries the database.

With all the calendar/contacts client applications, you can always
export your data to ics or vcard. It's a "standard" feature, and a
feature that allows you to import your current data into DAViCal.

It's quite surprising that DAViCal lacks this feature. That means you
can't backup your data into a standard format. That means when you
choose DAViCal, you're locked into DAViCal: the software doesn't even
allow you to export your data as any client app does.

Please tell me I'm wrong. Where are the scripts to export my data to ics
and vcard from the database ? (and, I repeat, not with wget)

Thanks.



Le 09/07/2012 23:29, Jon a écrit :
> I don't know about the vcard but you can dump ical from davical at:
>
> "http://username:password [at] DavicalAddres:port/caldav.php/collection/calendar.ics"
>
>
> in my case (collection name is 'calendar'):
> http://username:password [at] 192:8118/caldav.php/calendar/jon.ics
>
>
> I have also set up a 60 minute chron to output to an intranet address in
> linux for a oneway sync for my phone:
>
> #!/bin/bash
> #
> cd /home/jon/www/calendar
> wget -N
> http://username:password [at] 192:8118/caldav.php/calendar/marlo.ics
> /home/jon/www/calendar/marlo.ics
> wget -N
> http://username:password [at] 192:8118/caldav.php/calendar/jon.ics
> /home/jon/www/calendar/jon.ics
> wget -N
> http://username:password [at] 192:8118/caldav.php/calendar/both.ics
> /home/jon/www/calendar/both.ics
>
>
>
> Hope this helps.
>
> Jon Archer
> "I can't change the direction of the wind, but I can adjust my sails to
> always reach my destination." - Jimmy Dean
> ------------------------------------------------------------------------
> Down to Earth Enterprises - Psychological Services
> 1237 W. Auburn Dr.
> Tempe, AZ 85283
> www.drmarlo.com
> 480-705-5007
> ------------------------------------------------------------------------
> On 07/09/2012 01:39 PM, Arthur Chereau wrote:
>> I just installed DAViCal 1.1.1 and it's working fine. Thanks !
>>
>> Now, I would like to backup my calendars and contacts in a format that's
>> portable and usable with any CalDAV/CardDAV server, I mean ics and vcard.
>>
>> Unfortunately, I haven't found in the DAViCal package or the Web a
>> script that connects to the database and just outputs a calendar.ics or
>> a contacts.vcf file. I don't want to use wget, because I don't want to
>> put a password in a script, and it doesn't work with contacts
>> collections. I need something that gets the data directly from the DB.
>>
>> Do you know where I can find such a simple ics/vcard export script ?
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> Davical-general mailing list
>> Davical-general [at] lists
>> https://lists.sourceforge.net/lists/listinfo/davical-general
>>
>>
>
>



------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Davical-general mailing list
Davical-general [at] lists
https://lists.sourceforge.net/lists/listinfo/davical-general


jan.mate at inf-it

Jul 10, 2012, 2:11 PM

Post #4 of 9 (1181 views)
Permalink
Re: Export to ics and vcard [In reply to]

Hi,

exporting data from davical is only 5 minute basic work for any skilled admin. Here is the command to export a collection:

psql database -Atc "SELECT array_to_string(array(SELECT caldav_data FROM caldav_data WHERE dav_name LIKE '/username/collection/%'),'');" > export_file


example addressbook export (database_name: "davical", user_name: "peter", addressbook_name: "addresses"):

psql davical -Atc "SELECT array_to_string(array(SELECT caldav_data FROM caldav_data WHERE dav_name LIKE '/peter/addresses/%'),'');" > exported_addressbook.vcf


example calendar export (database_name: "davical", user_name: "mark", calendar_name: "calendar"):

psql davical -Atc "SELECT array_to_string(array(SELECT caldav_data FROM caldav_data WHERE dav_name LIKE '/mark/calendar/%'),'');" > exported_calendar.ics


JM



On Jul 10, 2012, at 10:33 PM, Arthur Chereau wrote:

> Thanks, but as I said I don't want to use wget because I don't want to
> put passwords in a script, and your method doesn't work with contacts. I
> need something that directly queries the database.
>
> With all the calendar/contacts client applications, you can always
> export your data to ics or vcard. It's a "standard" feature, and a
> feature that allows you to import your current data into DAViCal.
>
> It's quite surprising that DAViCal lacks this feature. That means you
> can't backup your data into a standard format. That means when you
> choose DAViCal, you're locked into DAViCal: the software doesn't even
> allow you to export your data as any client app does.
>
> Please tell me I'm wrong. Where are the scripts to export my data to ics
> and vcard from the database ? (and, I repeat, not with wget)
>
> Thanks.
>
>


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Davical-general mailing list
Davical-general [at] lists
https://lists.sourceforge.net/lists/listinfo/davical-general


arthur.chereau at gmail

Jul 11, 2012, 1:25 PM

Post #5 of 9 (1172 views)
Permalink
Re: Export to ics and vcard [In reply to]

Thanks a lot !


Le 10/07/2012 23:11, Ján Máté a écrit :
> Hi,
>
> exporting data from davical is only 5 minute basic work for any skilled admin. Here is the command to export a collection:
>
> psql database -Atc "SELECT array_to_string(array(SELECT caldav_data FROM caldav_data WHERE dav_name LIKE '/username/collection/%'),'');" > export_file
>
>
> example addressbook export (database_name: "davical", user_name: "peter", addressbook_name: "addresses"):
>
> psql davical -Atc "SELECT array_to_string(array(SELECT caldav_data FROM caldav_data WHERE dav_name LIKE '/peter/addresses/%'),'');" > exported_addressbook.vcf
>
>
> example calendar export (database_name: "davical", user_name: "mark", calendar_name: "calendar"):
>
> psql davical -Atc "SELECT array_to_string(array(SELECT caldav_data FROM caldav_data WHERE dav_name LIKE '/mark/calendar/%'),'');" > exported_calendar.ics
>
>
> JM
>



------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Davical-general mailing list
Davical-general [at] lists
https://lists.sourceforge.net/lists/listinfo/davical-general


andrew at morphoss

Jul 13, 2012, 2:17 AM

Post #6 of 9 (1184 views)
Permalink
Re: Export to ics and vcard [In reply to]

On Tue, 2012-07-10 at 22:33 +0200, Arthur Chereau wrote:
> Thanks, but as I said I don't want to use wget because I don't want to
> put passwords in a script, and your method doesn't work with contacts. I
> need something that directly queries the database.

The latest version of DAViCal includes a script in the scripts
subdirectory which you can use to dump any calendar (or addressbook) to
a file.

You need to have the PHP command-line installed, and then you should be
able to run:

/path/to/davical/scripts/export_calendar.php site.domain.name /username/calendar/

Which will export that calendar to STDOUT.

Cheers,
Andrew.

> With all the calendar/contacts client applications, you can always
> export your data to ics or vcard. It's a "standard" feature, and a
> feature that allows you to import your current data into DAViCal.
>
> It's quite surprising that DAViCal lacks this feature. That means you
> can't backup your data into a standard format. That means when you
> choose DAViCal, you're locked into DAViCal: the software doesn't even
> allow you to export your data as any client app does.
>
> Please tell me I'm wrong. Where are the scripts to export my data to ics
> and vcard from the database ? (and, I repeat, not with wget)
>
> Thanks.
>
>
>
> Le 09/07/2012 23:29, Jon a écrit :
> > I don't know about the vcard but you can dump ical from davical at:
> >
> > "http://username:password [at] DavicalAddres:port/caldav.php/collection/calendar.ics"
> >
> >
> > in my case (collection name is 'calendar'):
> > http://username:password [at] 192:8118/caldav.php/calendar/jon.ics
> >
> >
> > I have also set up a 60 minute chron to output to an intranet address in
> > linux for a oneway sync for my phone:
> >
> > #!/bin/bash
> > #
> > cd /home/jon/www/calendar
> > wget -N
> > http://username:password [at] 192:8118/caldav.php/calendar/marlo.ics
> > /home/jon/www/calendar/marlo.ics
> > wget -N
> > http://username:password [at] 192:8118/caldav.php/calendar/jon.ics
> > /home/jon/www/calendar/jon.ics
> > wget -N
> > http://username:password [at] 192:8118/caldav.php/calendar/both.ics
> > /home/jon/www/calendar/both.ics
> >
> >
> >
> > Hope this helps.
> >
> > Jon Archer
> > "I can't change the direction of the wind, but I can adjust my sails to
> > always reach my destination." - Jimmy Dean
> > ------------------------------------------------------------------------
> > Down to Earth Enterprises - Psychological Services
> > 1237 W. Auburn Dr.
> > Tempe, AZ 85283
> > www.drmarlo.com
> > 480-705-5007
> > ------------------------------------------------------------------------
> > On 07/09/2012 01:39 PM, Arthur Chereau wrote:
> >> I just installed DAViCal 1.1.1 and it's working fine. Thanks !
> >>
> >> Now, I would like to backup my calendars and contacts in a format that's
> >> portable and usable with any CalDAV/CardDAV server, I mean ics and vcard.
> >>
> >> Unfortunately, I haven't found in the DAViCal package or the Web a
> >> script that connects to the database and just outputs a calendar.ics or
> >> a contacts.vcf file. I don't want to use wget, because I don't want to
> >> put a password in a script, and it doesn't work with contacts
> >> collections. I need something that gets the data directly from the DB.
> >>
> >> Do you know where I can find such a simple ics/vcard export script ?
> >>
> >> ------------------------------------------------------------------------------
> >> Live Security Virtual Conference
> >> Exclusive live event will cover all the ways today's security and
> >> threat landscape has changed and how IT managers can respond. Discussions
> >> will include endpoint security, mobile security and the latest in malware
> >> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> >> _______________________________________________
> >> Davical-general mailing list
> >> Davical-general [at] lists
> >> https://lists.sourceforge.net/lists/listinfo/davical-general
> >>
> >>
> >
> >
>
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Davical-general mailing list
> Davical-general [at] lists
> https://lists.sourceforge.net/lists/listinfo/davical-general
>

--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Does the turtle move for you? www.kame.net
------------------------------------------------------------------------
Attachments: signature.asc (0.82 KB)


arthur.chereau at gmail

Jul 13, 2012, 11:15 AM

Post #7 of 9 (1169 views)
Permalink
Re: Export to ics and vcard [In reply to]

Thanks, but I checked in the scripts directory before asking, and there
is no such script in it.

I have 1.1.1 as a debian package from your server. In the scripts
directory I only have:
- cron-sync-ldap.php
- tz-update.php

Cheers.


Le 13/07/2012 11:17, Andrew McMillan a écrit :
> On Tue, 2012-07-10 at 22:33 +0200, Arthur Chereau wrote:
>> Thanks, but as I said I don't want to use wget because I don't want to
>> put passwords in a script, and your method doesn't work with contacts. I
>> need something that directly queries the database.
>
> The latest version of DAViCal includes a script in the scripts
> subdirectory which you can use to dump any calendar (or addressbook) to
> a file.
>
> You need to have the PHP command-line installed, and then you should be
> able to run:
>
> /path/to/davical/scripts/export_calendar.php site.domain.name /username/calendar/
>
> Which will export that calendar to STDOUT.
>
> Cheers,
> Andrew.
>
>> With all the calendar/contacts client applications, you can always
>> export your data to ics or vcard. It's a "standard" feature, and a
>> feature that allows you to import your current data into DAViCal.
>>
>> It's quite surprising that DAViCal lacks this feature. That means you
>> can't backup your data into a standard format. That means when you
>> choose DAViCal, you're locked into DAViCal: the software doesn't even
>> allow you to export your data as any client app does.
>>
>> Please tell me I'm wrong. Where are the scripts to export my data to ics
>> and vcard from the database ? (and, I repeat, not with wget)
>>
>> Thanks.
>>
>>
>>
>> Le 09/07/2012 23:29, Jon a écrit :
>>> I don't know about the vcard but you can dump ical from davical at:
>>>
>>> "http://username:password [at] DavicalAddres:port/caldav.php/collection/calendar.ics"
>>>
>>>
>>> in my case (collection name is 'calendar'):
>>> http://username:password [at] 192:8118/caldav.php/calendar/jon.ics
>>>
>>>
>>> I have also set up a 60 minute chron to output to an intranet address in
>>> linux for a oneway sync for my phone:
>>>
>>> #!/bin/bash
>>> #
>>> cd /home/jon/www/calendar
>>> wget -N
>>> http://username:password [at] 192:8118/caldav.php/calendar/marlo.ics
>>> /home/jon/www/calendar/marlo.ics
>>> wget -N
>>> http://username:password [at] 192:8118/caldav.php/calendar/jon.ics
>>> /home/jon/www/calendar/jon.ics
>>> wget -N
>>> http://username:password [at] 192:8118/caldav.php/calendar/both.ics
>>> /home/jon/www/calendar/both.ics
>>>
>>>
>>>
>>> Hope this helps.
>>>
>>> Jon Archer
>>> "I can't change the direction of the wind, but I can adjust my sails to
>>> always reach my destination." - Jimmy Dean
>>> ------------------------------------------------------------------------
>>> Down to Earth Enterprises - Psychological Services
>>> 1237 W. Auburn Dr.
>>> Tempe, AZ 85283
>>> www.drmarlo.com
>>> 480-705-5007
>>> ------------------------------------------------------------------------
>>> On 07/09/2012 01:39 PM, Arthur Chereau wrote:
>>>> I just installed DAViCal 1.1.1 and it's working fine. Thanks !
>>>>
>>>> Now, I would like to backup my calendars and contacts in a format that's
>>>> portable and usable with any CalDAV/CardDAV server, I mean ics and vcard.
>>>>
>>>> Unfortunately, I haven't found in the DAViCal package or the Web a
>>>> script that connects to the database and just outputs a calendar.ics or
>>>> a contacts.vcf file. I don't want to use wget, because I don't want to
>>>> put a password in a script, and it doesn't work with contacts
>>>> collections. I need something that gets the data directly from the DB.
>>>>
>>>> Do you know where I can find such a simple ics/vcard export script ?
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Live Security Virtual Conference
>>>> Exclusive live event will cover all the ways today's security and
>>>> threat landscape has changed and how IT managers can respond. Discussions
>>>> will include endpoint security, mobile security and the latest in malware
>>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>>>> _______________________________________________
>>>> Davical-general mailing list
>>>> Davical-general [at] lists
>>>> https://lists.sourceforge.net/lists/listinfo/davical-general
>>>>
>>>>
>>>
>>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> Davical-general mailing list
>> Davical-general [at] lists
>> https://lists.sourceforge.net/lists/listinfo/davical-general
>>
>



------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Davical-general mailing list
Davical-general [at] lists
https://lists.sourceforge.net/lists/listinfo/davical-general


andrew at morphoss

Jul 16, 2012, 2:13 PM

Post #8 of 9 (1162 views)
Permalink
Re: Export to ics and vcard [In reply to]

On Fri, 2012-07-13 at 20:15 +0200, Arthur Chereau wrote:
> Thanks, but I checked in the scripts directory before asking, and there
> is no such script in it.
>
> I have 1.1.1 as a debian package from your server. In the scripts
> directory I only have:
> - cron-sync-ldap.php
> - tz-update.php

Ah, it missed inclusion in the Debian package. I'll make sure it's in
the next one.

Meanwhile you can pull it from Gi here:

http://repo.or.cz/w/davical.git/tree/HEAD:/scripts

Cheers,
Andrew.


> Cheers.
>
>
> Le 13/07/2012 11:17, Andrew McMillan a écrit :
> > On Tue, 2012-07-10 at 22:33 +0200, Arthur Chereau wrote:
> >> Thanks, but as I said I don't want to use wget because I don't want to
> >> put passwords in a script, and your method doesn't work with contacts. I
> >> need something that directly queries the database.
> >
> > The latest version of DAViCal includes a script in the scripts
> > subdirectory which you can use to dump any calendar (or addressbook) to
> > a file.
> >
> > You need to have the PHP command-line installed, and then you should be
> > able to run:
> >
> > /path/to/davical/scripts/export_calendar.php site.domain.name /username/calendar/
> >
> > Which will export that calendar to STDOUT.
> >
> > Cheers,
> > Andrew.
> >
> >> With all the calendar/contacts client applications, you can always
> >> export your data to ics or vcard. It's a "standard" feature, and a
> >> feature that allows you to import your current data into DAViCal.
> >>
> >> It's quite surprising that DAViCal lacks this feature. That means you
> >> can't backup your data into a standard format. That means when you
> >> choose DAViCal, you're locked into DAViCal: the software doesn't even
> >> allow you to export your data as any client app does.
> >>
> >> Please tell me I'm wrong. Where are the scripts to export my data to ics
> >> and vcard from the database ? (and, I repeat, not with wget)
> >>
> >> Thanks.
> >>
> >>
> >>
> >> Le 09/07/2012 23:29, Jon a écrit :
> >>> I don't know about the vcard but you can dump ical from davical at:
> >>>
> >>> "http://username:password [at] DavicalAddres:port/caldav.php/collection/calendar.ics"
> >>>
> >>>
> >>> in my case (collection name is 'calendar'):
> >>> http://username:password [at] 192:8118/caldav.php/calendar/jon.ics
> >>>
> >>>
> >>> I have also set up a 60 minute chron to output to an intranet address in
> >>> linux for a oneway sync for my phone:
> >>>
> >>> #!/bin/bash
> >>> #
> >>> cd /home/jon/www/calendar
> >>> wget -N
> >>> http://username:password [at] 192:8118/caldav.php/calendar/marlo.ics
> >>> /home/jon/www/calendar/marlo.ics
> >>> wget -N
> >>> http://username:password [at] 192:8118/caldav.php/calendar/jon.ics
> >>> /home/jon/www/calendar/jon.ics
> >>> wget -N
> >>> http://username:password [at] 192:8118/caldav.php/calendar/both.ics
> >>> /home/jon/www/calendar/both.ics
> >>>
> >>>
> >>>
> >>> Hope this helps.
> >>>
> >>> Jon Archer
> >>> "I can't change the direction of the wind, but I can adjust my sails to
> >>> always reach my destination." - Jimmy Dean
> >>> ------------------------------------------------------------------------
> >>> Down to Earth Enterprises - Psychological Services
> >>> 1237 W. Auburn Dr.
> >>> Tempe, AZ 85283
> >>> www.drmarlo.com
> >>> 480-705-5007
> >>> ------------------------------------------------------------------------
> >>> On 07/09/2012 01:39 PM, Arthur Chereau wrote:
> >>>> I just installed DAViCal 1.1.1 and it's working fine. Thanks !
> >>>>
> >>>> Now, I would like to backup my calendars and contacts in a format that's
> >>>> portable and usable with any CalDAV/CardDAV server, I mean ics and vcard.
> >>>>
> >>>> Unfortunately, I haven't found in the DAViCal package or the Web a
> >>>> script that connects to the database and just outputs a calendar.ics or
> >>>> a contacts.vcf file. I don't want to use wget, because I don't want to
> >>>> put a password in a script, and it doesn't work with contacts
> >>>> collections. I need something that gets the data directly from the DB.
> >>>>
> >>>> Do you know where I can find such a simple ics/vcard export script ?
> >>>>
> >>>> ------------------------------------------------------------------------------
> >>>> Live Security Virtual Conference
> >>>> Exclusive live event will cover all the ways today's security and
> >>>> threat landscape has changed and how IT managers can respond. Discussions
> >>>> will include endpoint security, mobile security and the latest in malware
> >>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> >>>> _______________________________________________
> >>>> Davical-general mailing list
> >>>> Davical-general [at] lists
> >>>> https://lists.sourceforge.net/lists/listinfo/davical-general
> >>>>
> >>>>
> >>>
> >>>
> >>
> >>
> >>
> >> ------------------------------------------------------------------------------
> >> Live Security Virtual Conference
> >> Exclusive live event will cover all the ways today's security and
> >> threat landscape has changed and how IT managers can respond. Discussions
> >> will include endpoint security, mobile security and the latest in malware
> >> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> >> _______________________________________________
> >> Davical-general mailing list
> >> Davical-general [at] lists
> >> https://lists.sourceforge.net/lists/listinfo/davical-general
> >>
> >
>
>

--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Suggest you just sit there and wait till life gets easier.
------------------------------------------------------------------------
Attachments: signature.asc (0.82 KB)


cyrus at bobobeach

Aug 11, 2012, 10:10 AM

Post #9 of 9 (1061 views)
Permalink
Re: Export to ics and vcard [In reply to]

When I run this script, all of the SUMMARY lines come through as "BUSY". Do I need to somehow authenticate myself before I run the script?

thanks,

Cyrus

On Jul 13, 2012, at 2:17 AM, Andrew McMillan <andrew [at] morphoss> wrote:

> On Tue, 2012-07-10 at 22:33 +0200, Arthur Chereau wrote:
>> Thanks, but as I said I don't want to use wget because I don't want to
>> put passwords in a script, and your method doesn't work with contacts. I
>> need something that directly queries the database.
>
> The latest version of DAViCal includes a script in the scripts
> subdirectory which you can use to dump any calendar (or addressbook) to
> a file.
>
> You need to have the PHP command-line installed, and then you should be
> able to run:
>
> /path/to/davical/scripts/export_calendar.php site.domain.name /username/calendar/
>
> Which will export that calendar to STDOUT.
>
> Cheers,
> Andrew.
>
>> With all the calendar/contacts client applications, you can always
>> export your data to ics or vcard. It's a "standard" feature, and a
>> feature that allows you to import your current data into DAViCal.
>>
>> It's quite surprising that DAViCal lacks this feature. That means you
>> can't backup your data into a standard format. That means when you
>> choose DAViCal, you're locked into DAViCal: the software doesn't even
>> allow you to export your data as any client app does.
>>
>> Please tell me I'm wrong. Where are the scripts to export my data to ics
>> and vcard from the database ? (and, I repeat, not with wget)
>>
>> Thanks.
>>
>>
>>
>> Le 09/07/2012 23:29, Jon a écrit :
>>> I don't know about the vcard but you can dump ical from davical at:
>>>
>>> "http://username:password [at] DavicalAddres:port/caldav.php/collection/calendar.ics"
>>>
>>>
>>> in my case (collection name is 'calendar'):
>>> http://username:password [at] 192:8118/caldav.php/calendar/jon.ics
>>>
>>>
>>> I have also set up a 60 minute chron to output to an intranet address in
>>> linux for a oneway sync for my phone:
>>>
>>> #!/bin/bash
>>> #
>>> cd /home/jon/www/calendar
>>> wget -N
>>> http://username:password [at] 192:8118/caldav.php/calendar/marlo.ics
>>> /home/jon/www/calendar/marlo.ics
>>> wget -N
>>> http://username:password [at] 192:8118/caldav.php/calendar/jon.ics
>>> /home/jon/www/calendar/jon.ics
>>> wget -N
>>> http://username:password [at] 192:8118/caldav.php/calendar/both.ics
>>> /home/jon/www/calendar/both.ics
>>>
>>>
>>>
>>> Hope this helps.
>>>
>>> Jon Archer
>>> "I can't change the direction of the wind, but I can adjust my sails to
>>> always reach my destination." - Jimmy Dean
>>> ------------------------------------------------------------------------
>>> Down to Earth Enterprises - Psychological Services
>>> 1237 W. Auburn Dr.
>>> Tempe, AZ 85283
>>> www.drmarlo.com
>>> 480-705-5007
>>> ------------------------------------------------------------------------
>>> On 07/09/2012 01:39 PM, Arthur Chereau wrote:
>>>> I just installed DAViCal 1.1.1 and it's working fine. Thanks !
>>>>
>>>> Now, I would like to backup my calendars and contacts in a format that's
>>>> portable and usable with any CalDAV/CardDAV server, I mean ics and vcard.
>>>>
>>>> Unfortunately, I haven't found in the DAViCal package or the Web a
>>>> script that connects to the database and just outputs a calendar.ics or
>>>> a contacts.vcf file. I don't want to use wget, because I don't want to
>>>> put a password in a script, and it doesn't work with contacts
>>>> collections. I need something that gets the data directly from the DB.
>>>>
>>>> Do you know where I can find such a simple ics/vcard export script ?
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Live Security Virtual Conference
>>>> Exclusive live event will cover all the ways today's security and
>>>> threat landscape has changed and how IT managers can respond. Discussions
>>>> will include endpoint security, mobile security and the latest in malware
>>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>>>> _______________________________________________
>>>> Davical-general mailing list
>>>> Davical-general [at] lists
>>>> https://lists.sourceforge.net/lists/listinfo/davical-general
>>>>
>>>>
>>>
>>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> Davical-general mailing list
>> Davical-general [at] lists
>> https://lists.sourceforge.net/lists/listinfo/davical-general
>>
>
> --
> ------------------------------------------------------------------------
> andrew (AT) morphoss (DOT) com +64(272)DEBIAN
> Does the turtle move for you? www.kame.net
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
> Davical-general mailing list
> Davical-general [at] lists
> https://lists.sourceforge.net/lists/listinfo/davical-general


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Davical-general mailing list
Davical-general [at] lists
https://lists.sourceforge.net/lists/listinfo/davical-general

DAViCal general RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.