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. Best, Keith.. On 16 Sep 2011, at 20:10, Bill Vlahos wrote: > Keith, > > 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: > >> Keith, >> >> 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 >> andre >> 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.cla...@clarkeandclarke.co.uk> wrote: >> >>> Hi folks, >>> Has anyone experimented with extracting Google Contact data from within >>> Livecode? >>> >>> 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 >>> volunteers). >>> >>> 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. >>> Best, >>> Keith.. >>> _______________________________________________ >>> use-livecode mailing list >>> use-livecode@lists.runrev.com >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >>> >> >> >> >> -- >> http://www.andregarzia.com All We Do Is Code. >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
