LiveCode and Google Contact data
keith.clarke at clarkeandclarke.co.uk
Fri Sep 16 16:35:20 EDT 2011
Thanks for the responses (Andre & Bill), though export of individual contacts via vCard is not what I'm trying to achieve.
Looking into it, I'm not sure LiveCode would save much over reverting to the pre-Google approach of creating a Word mail-merge template that can target the manually exported Google Contacts CSV file.
So, I'll create the semi-automated process for now and then review.
On 16 Sep 2011, at 20:10, Bill Vlahos wrote:
> I'm not familiar with Google Contacts but .csv or vCARD formats are known text formats. You can easily see what they look like but they are tedious to deal with.
> Is it that you now have the information in Google Contacts and want to export it into a LC app you are writing? InfoWallet has the ability to import and export vCARD format. If you can export from Google in vCARD format try importing it into InfoWallet (say the Contacts section). If that works I can send you the code I use or you can try Andre's library which looks pretty nice. The free trial version of InfoWallet can import records but not export them. This way you can see if it is going to work.
> I prefer TAB delimited records over CSV because it is common to have commas in real records but rare to have tabs. CSV forces you to escape out commas so it is a little trickier.
> The Address Book in both Macintosh and Windows also have the ability to import and export contacts via vCARD and other methods too. You could also try those.
> Bill Vlahos
> InfoWallet (http://www.infowallet.com) is about keeping your important life information with you, accessible, and secure.
> On Sep 16, 2011, at 11:20 AM, Andre Garzia wrote:
>> You can probably output a vCards file from Google Contacts. I built a
>> vObject library for LiveCode in 2004, it might help you.
>> I made it available at http://fon.nu/vobjectlib I was going to share on
>> RevOnline but I can't find the damn login.
>> Be Prepared, or as we say here, Sempre Alerta
>> PS: Former Sea Scout Master of the Seventh Sea Scout Group of Rio de Janeiro
>> - Benevenuto Cellini.
>> On Fri, Sep 16, 2011 at 12:55 PM, Keith Clarke <
>> keith.clarke at clarkeandclarke.co.uk> wrote:
>>> Hi folks,
>>> Has anyone experimented with extracting Google Contact data from within
>>> As a weekend project, I intend to replace the sprawling spreadsheet that is
>>> our current local Scouts' District directory with:
>>> a) Google Contacts to manage the details of the ~150 volunteers who work
>>> in/across 6 related Scout Group charity organisations within our District
>>> b) (as Google Docs has no mail-merge facility) LiveCode to generate a
>>> printable PDF directory (that gets shared as a Google Doc, back to these
>>> I've managed to squeeze the multiple roles that volunteers undertake across
>>> organisational boundaries into Google Contacts Groups and custom fields, but
>>> I'm wondering whether to even attempt any automation of the manual Google
>>> Contacts CSV export step to get the data into LiveCode.
>>> I've not played with any of the Google APIs, so don't know how complex this
>>> would be - or where to start, really. Is this a one-line of code HTTP(S) get
>>> call or a library I ned to build. Any insights would be greatly appreciated.
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>> http://www.andregarzia.com All We Do Is Code.
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode