Convert GoogleCL gmail contacts to cone adress book

google contacts list name,name,email|perl -pne 's%^((?!N\/A)(.+?)),((?!N\/A)(.+?)),([a-z0-9\._-]+\@([a-z0-9][a-z0-9-]*[a-z0-9]\.)+([a-z]+\.)?([a-z]+))%${1}:${3} <${5}>%imx' #see below for full command
Full Command: google contacts list name,name,email|perl -pne 's%^((?!N\/A)(.+?)),((?!N\/A)(.+?)),([a-z0-9\._-]+\@([a-z0-9][a-z0-9-]*[a-z0-9]\.)+([a-z]+\.)?([a-z]+))%${1}:${3} <${5}>%imx'|grep -oP '^((?!N\/A)(.+?)) <[a-z0-9\._-]+\@([a-z0-9][a-z0-9-]*[a-z0-9]\.)+([a-z]+\.)?([a-z]+)>' | sort You'll need googlecl and python-gdata. First setup google cl via: google Then give your PC access google contacts list name,email Then do the command, save it or use this one to dump it in the cone-address.txt file in your home dir: google contacts list name,name,email | perl -p -n -e 's%^((?!N\/A)(.+?)),((?!N\/A)(.+?)),([a-z0-9\._-]+\@([a-z0-9][a-z0-9-]*[a-z0-9]\.)+([a-z]+\.)?([a-z]+))%${1}:${3} <${5}>%imx' | grep -o -P '^((?!N\/A)(.+?)) <[a-z0-9\._-]+\@([a-z0-9][a-z0-9-]*[a-z0-9]\.)+([a-z]+\.)?([a-z]+)>' | sort > ~/cone-adress.txt Then import into cone. It filters out multiple emails, and contacts with no email that have N/A. (Picasa photo persons without email for example...)
Sample Output
Contact One: Contact2 <contact1@domain.org>
Contact Two: Contact2 <contact2@othersite.nl>

What Others Think

+1 for GoogleCL. For those who haven't heard of it, GoogleCL allows command-line access to your Google Apps. Very useful. http://code.google.com/p/googlecl/
StefanLasiewski · 584 weeks and 6 days ago
You can also do it with the abook: data=name,email,phone,address,im,company,notes; (echo $data; google contacts list $data) | abook --convert --informat csv --outformat abook --outfile ~/.abook/addressbook
matthewbauer · 584 weeks and 6 days ago
googlecl no more works since google has update is auth service from OAuth1 to OAuth2 :(.
rcspam · 304 weeks ago
When the writers are working on Religion and Theology Writing Services, they have to ensure they conduct thorough Religion and Theology Research Writing Services on the topic areas in order to complete the best Custom Religion & Theology Research Paper using recent sources.
florahwilliams · 83 weeks and 4 days ago
WritePaperFor.Me is the best site here . You’ll provide even the most challenging papers by the deadline .
TomNill · 74 weeks and 5 days ago
There are a multitude of resources available for a wide variety of industries looking to hire freelancers. Field Engineer is a well-known global marketplace, where you can hire engineers and technicians to assist your workforce
kotifield · 70 weeks and 2 days ago
Nice concept, briefly described, and helpful for website content writing help for beginners like me to learn new things and unique content. Good work!
RidaHashmi · 69 weeks and 4 days ago
I think this site https://soclikes.com/ is good to buy tiktok likes
Danielwilson · 66 weeks and 2 days ago
I think this site https://soclikes.com/ is good to buy tiktok likes
Danielwilson · 66 weeks and 2 days ago
its a good information, thanks for sharing. ">[pii_email_11fe1b3b7ddac37a081f]
neerajawtm · 53 weeks and 4 days ago
its a good information, thanks for sharing. [pii_email_11fe1b3b7ddac37a081f]
neerajawtm · 53 weeks and 4 days ago
The information mentioned by the forum is very helpful, and I would also like to share some fun infotainment. https://iogames.onl https://iogames.onl/skribbl-io-games
navonwolf · 50 weeks and 3 days ago
The article has outstanding image content. All information in the article is very delicate. I will keep waiting for your posts. ">technology “write for us”
saichinni · 49 weeks and 1 day ago
Thanks for sharing.< a href="https://www.webtechmantra.com/tamilrockers-proxy/">tamilrockers proxy
saichinni · 47 weeks and 4 days ago
TechUpdatesDaily-A resource where one can find the latest updates & news about technology, software, gadgets and business ideas for the start-ups.
lanarose · 43 weeks ago
tech write for us Trendstechblog Our Aim at the availability our readers with more information about the most recent technology news, upcoming gadgets, mobile apps social media, daily changing business strategies, day to day changes in digital marketing.
lanarose · 39 weeks and 4 days ago
You can be popular on tiktok with such video how to fix some technical problems. Read this article https://omegaunderground.com/the-best-way-to-control-your-popularity-and-success-on-social-media/ to know how to get tiktok likes
Danielwilson · 37 weeks and 3 days ago
You can be popular on tiktok with such video how to fix some technical problems. Read this article https://omegaunderground.com/the-best-way-to-control-your-popularity-and-success-on-social-media/ to know how to get tiktok likes
Danielwilson · 37 weeks and 3 days ago
H?w d? ???n-??ur?? ?r?du?t?v?t? ?u?t?? compare t? MS Office - ?nd d??? ?t m?k? ??n?? f?r ??ur ?rg?n?z?t??n t? ?h???? fr?? ??mmun?t? software r?th?r th?n Microsoft's commercially licensed ?ff?r?ng? www.office.com/setup www.office.com/setup
sambattherford · 32 weeks and 3 days ago
H?w d? ???n-??ur?? ?r?du?t?v?t? ?u?t?? compare t? MS Office - ?nd d??? ?t m?k? ??n?? f?r ??ur ?rg?n?z?t??n t? ?h???? fr?? ??mmun?t? software r?th?r th?n Microsoft's commercially licensed ?ff?r?ng? https://w-w-office.com/setup/ https://www.office-help-setup.com
sambattherford · 32 weeks and 3 days ago
H?w d? ???n-??ur?? ?r?du?t?v?t? ?u?t?? compare t? MS Office - ?nd d??? ?t m?k? ??n?? f?r ??ur ?rg?n?z?t??n t? ?h???? fr?? ??mmun?t? software r?th?r th?n Microsoft's commercially licensed ?ff?r?ng? https://w-w-office.com/setup https://www.office-help-setup.com/
sambattherford · 32 weeks and 3 days ago
Hey there! I could have sworn I’ve been to this website before but after checking through some of the posts I realized it’s new to me. https://telegra.ph/How-to-install-Microsoft-office-04-19 https://wordpress.com/post/officewwwofficesetup.home.blog https://telegra.ph/Mcafee-activation-help-04-19 https://officewwwofficesetup.home.blog/ https://officewwwofficecom.wordpress.com/ https://wwwoffice-comsetup.com/ https://www.pearltrees.com/baniblanko https://3prv5m9lgf8f.blog.fc2.com/ https://officecomsetup.odoo.com/ https://office-setup-help.company.site/ https://office-www-office.com/setup/ https://mmcafeeactivate.com/
mikeee · 22 weeks and 3 days ago
Thanks for giving me grateful information. I think this is very important to me. Your post is quite different. That’s why I regularly visit your site. [url=https://hospital-software.dataman.in/]Hospital Software[/url]
shreyamishra · 22 weeks and 1 day ago
Thanks for giving me grateful information. I think this is very important to me. Your post is quite different. That’s why I regularly visit your site. https://hospital-software.dataman.in/
shreyamishra · 22 weeks and 1 day ago
hbomax.com/tvsignin streaming service has a deep catalogue full of great TV shows, from popular comedies Friends and Big Bang Theory. hbomax.com/tvsignin activate has replaced all other HBO apps and services.It's home to all of HBO's premium TV shows and movies, as well as additional. It has amazing video and audio quality ,Users used to be able to sign up for a seven-day free trial of hbomax.com/tvsignin code. https://hbomax-comtvsignin.com https://hboxsignin.launchaco.com/ https://hbomaxcomtvsignin.launchaco.com/
hbomaxtvsignin · 11 weeks and 6 days ago
Espn plus activate is one of their media.Espn plus is one of the fascinating sports broadcasting organizations delivering every micro-detail about any game for many years. Due to this, today, it has millions and billions of followers who don't want to miss any update. https://espnactivate.launchaco.com/ https://www.espncom-activate.com/ https://espn-comactivate.com/
williamrobin · 11 weeks and 6 days ago
Amazing work done norton.com/setup
setupnortons · 11 weeks and 6 days ago
This was such a helpful content in which they are discussing the ways to dump Android contacts SMS using the code and also have provided a brief description about the code that is shared here which makes the code much more clear Magicard 600
Dwyane · 10 weeks and 3 days ago
mcafee.com/activate is an independent website where you can learn the steps involves in the installation process of any antivirus. You will not only get step by step procedure of www.mcafee.com/activatebut also the advantages and disadvantages of various antivirus softwares. on our website we provide whole information in english and german language but still if you need any type of help then our linguistic agents are ready 24×7 to help you so it does not matter from where are you from we can provide support in any language.
mcafeeactivated · 8 weeks ago
Enter the 6 character code on the site amazon.com/mytv enter code This amazon my TV looks like UENKSE. Enter this code on the box & Tap on the register button.Amazon prime is a paid online streaming services used . It gives users access to a wide range of services like fast delivery, watches unlimited videos online, online movies, or prime videos. Users can watch instant videos for free or with amazon prime membership.To watch online prime videos on devices like computers, laptops, smartphones, and smart tv. You need to enter the 6 digit amazon activation code at watch the prime video for free. Watch amazon prime episodes on your device to sign in or create a new amazon account using email and password. Enter the 6 character code on the site [url=https://wwwamazncamazn.com/] amazon.com/mytv enter code [/url] This amazon my TV looks like UENKSE. Enter this code on the box & Tap on the register button.Amazon prime is a paid online streaming services used . It gives users access to a wide range of services like fast delivery, watches unlimited videos online, online movies, or prime videos. Users can watch instant videos for free or with amazon prime membership.To watch online prime videos on devices like computers, laptops, smartphones, and smart tv. You need to enter the 6 digit amazon activation code at watch the prime video for free. Watch amazon prime episodes on your device to sign in or create a new amazon account using email and password.
Panth0101 · 7 weeks and 6 days ago
Amazon Prime Day has entered its final day and Shopping readers are taking full advantage of deals on everything from tech and fashion to kitchenware and skin care. There are also notable deals for fitness enthusiasts and pet owners, along with savings at short-term Lightning Deals and daylong deals on Amazon devices and Dyson air purifiers, vacuums and hot tools. But only Amazon Prime members have access to the exclusive sale items on Amazon, which incentivizes new membership sign-ups
Panth0101 · 7 weeks and 6 days ago
Amazon Prime Day has entered its final day and Shopping readers are taking full advantage of deals on everything from tech and fashion to kitchenware and skin care. There are also notable deals for fitness enthusiasts and pet owners, along with savings at short-term Lightning Deals and daylong deals on Amazon devices and Dyson air purifiers, vacuums and hot tools. But only Amazon Prime members have access to the exclusive sale items on Amazon, which incentivizes new membership sign-ups
Panth0101 · 7 weeks and 6 days ago
Microsoft Office is the productivity suite used for homes and offices and developed by Microsoft. If you wanted to renew MS Office on your device, then you have to visit to the office.com/setup and log in to your MS account with the email ID which you have used to register your product key, it will direct you to renew your Microsoft Office subscription with few clicks.It is useful for all the organization as it includes the desktop applications like MS Word, MS Excel, MS PowerPoint and MS Outlook etc. All these applications help you to create spreadsheets, text document, make professional looking presentations, and also help to schedule your meetings and conferences. You can install this productivity suite through www.office.com/setup . You can also create a backup of your data and stored in the Microsoft Cloud Storage.
Panth0101 · 7 weeks and 6 days ago
ESPN is a live sports streaming service available to anyone, so it doesn't require a cable subscription. And that makes it popular with people who are looking to add some sports to their streaming setup. The service is also a hit with fans of the exclusive sports available only on ESPN, like UFC, FA Cup soccer, or Top Rank boxing. There may no longer be a free trial, but here is how to sign up for ESPN.Log in with your Espn.com/activate . If you don't have an account, you can click Sign Up link to create on www.espn.com/activate . You can also login with Facebook if you prefer.
Panth0101 · 7 weeks and 6 days ago
ESPN is a live sports streaming service available to anyone, so it doesn't require a cable subscription. And that makes it popular with people who are looking to add some sports to their streaming setup. The service is also a hit with fans of the exclusive sports available only on ESPN, like UFC, FA Cup soccer, or Top Rank boxing. There may no longer be a free trial, but here is how to sign up for ESPN.Log in with your Espn.com/activate . If you don't have an account, you can click Sign Up link to create on www .espn.com/activate . You can also login with Facebook if you prefer.
Panth0101 · 7 weeks and 6 days ago
canon.com/ijsetup - Download the Canon Pixma Canon.com/ijsetup/mg2522 or Canon.com/ijsetup mg2522printer driver according to your operating system. Visit www.canon.com/ijsetup to download and install the best-suited canon printer drivers and software for your specific printer by entering model number.
roanparker158 · 6 weeks and 6 days ago
To access the web interface you'll also probably need a username and password, and an ATT Router IP if you find your model in the list there's a link to the default settings for that model. Most AT&T routers use the same default usernames and passwords so you can also check the Default AT&T password list to try with that one.
markwatson1008 · 1 week ago
To access the web interface you'll also probably need a username and password, and an [url=https://connectrouter.com/att-router-ip-address/]ATT Router IP[/url] if you find your model in the list there's a link to the default settings for that model. Most AT&T routers use the same default usernames and passwords so you can also check the Default AT&T password list to try with that one.
markwatson1008 · 1 week ago
To access the web interface you'll also probably need a username and password, and an ATT Router IP if you find your model in the list there's a link to the default settings for that model. Most AT&T routers use the same default usernames and passwords so you can also check the Default AT&T password list to try with that one. https://connectrouter.com/att-router-ip-address/
markwatson1008 · 1 week ago
Thanks for the post and I for me now formatting is really crucial, cause here I am converting into apa 7th edition format https://bestwritingservice.com/apa-7th-edition-format.html my coursework with the help of BestWritingService which always helps me with my academic studyings and maybe it will be useful for your too.
heileydurst · 6 days ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands



Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for: