Sync Google Contacts with Asterisk

Awesome, I think I'll integrate this but with a small improvement, change the database table to be cidname_. That way I can use multiple gmail accounts, and also use it in conjunction with other cid lookup and caching scripts.

I've also been pondering using google documents to make a two way bridge between the asterisk database, and something that is easy to access from the web (blacklist, whitelist, distinctive ring, call logs, etc).

Hello! Thanks for the script!
I was looking for something like this for ages.
I have a problem tough. Can you explain the formating options in your script?
I have both belgian (+32) and us (+1) numbers and I can't get it work.
I don't get the
phone.text = re.sub('^\+1|^1|\(|\)|\s|-', '', phone.text)
os.system("asterisk -rx \'database put cidname +1%s \"%s\"\'" % (phone.text,entry.title.text))
part.
Could you develop a little bit? Thanks!

very nice program, it works perfectly but what if I have my local cardDAV server??

I want to have a global address book editable from my network users. I used carddav.

It is the same as googles but it is locally. Can I somehow change the address of the server???

Good morning!

Nice, useful script, very comprehend HOWTO.

Everything worked fine for me, but one problem occured: As I'm working with a couple of russian clients, my gmail-adress-book stores names them in cyrillic letters. By importing these contacts to my *-DB cyrillic letters convert to "Ðлена Ðойнова", for example.

As I'm not familiar with python hope you can propose a workaround.

Best regards,
Sebastian, Germany

I am still getting asterisks as the callerid for all the calls, can you please give me some pointers.

when i run the following command:
database show cidname

OpenWrt*CLI> database show cidname
/cidname/+17407075678 : Testing Tester

Appreciate your help.
Thanks

Amazing post regarding Sync Google Contacts with Asterisk. Never have I thought it could be implemented. Thanks

Wow, I love this! Fantastic, elegant solution. Thank you!

Everything worked fine for me, but one problem occured: As I'm working with a couple of russian clients, my gmail-adress-book stores names them in cyrillic letters. By importing these contacts to my *-DB cyrillic letters convert to "Ðлена Ðойнова",

Thank you very much for sharing it... I was looking for something similar, and this one just did the job! :P

Thanks a million for this. I just moved ported my mobile number to google voice. I use an Obi110 with asterisk and the callerid comes in without the + symbol. I removed the + from the database put cidname line so all my contacts go in without the plus and callerid matching was perfect.

Great script. I made a little change because the incoming callerid format coming from my VOIP service is unpredictable (+XXY.., 00XXY.., 0Y..). Instead of trying to match the entire number, prefix and country code, I'm stripping the incoming number down to the last 8 digits and matching against that. It works very well.

In the script:
<snip>
phone.text = phone.text[-8:]
phone.text = re.sub('\D', '', phone.text)
os.system("asterisk -rx \'database put cidname %s%s \"%s\"\'" % (country_code,phone.text,entry.title.text))
<snip>

And on the Asterisk side:
exten => s,1,Set(CALLERID(name)=${DB(cidname/${CALLERID(num):-8,8})})

Does anyone knows how to get google voice to work oversea @ thriftywholesaler

Thanks for putting together a great script. This was a fantastic place to start in my quest to sync with Asteridex (for PBX in a Flash).

Here's my modified code (insert after line beginning with "feed = ", and reformat for Python). I don't pretend to be a programmer, but I enjoy learning new things, so this was a fun challenge for me.

# Create a connection to MySQL
# Change the parameters if you are not using PBX in a Flash
con = MySQLdb.connect(host='localhost', user='root', passwd='passw0rd', db='asteridex')
cur = con.cursor()

# delete all of our contacts before we refetch them, this will allow deletions to propogate
cur.execute("DELETE FROM user1")
cur.close()

# re-instantiate the cursor
cur = con.cursor()

# for each phone number in the contacts
for i, entry in enumerate(feed.entry):
for phone in entry.phone_number:
# Strip out any non numeric characters
phone.text = re.sub('\D', '', phone.text)

# Remove leading digit if it exists, we will add this again later for all numbers
# Only if a country code is defined.
if country_code != "":
phone.text = re.sub('^\+?%s' % country_code, '', phone.text)

# Insert the number into the cidname database, reinsert the country code if defined.
name = entry.title.text
num = phone.text
if str(name).strip() != "None":
cur.execute("INSERT INTO user1(`name`, `out`, `email`) VALUES (%s,%s,%s)",(name,num,"NULL"))
print str(name) + " was inserted into the database"

cur.close()
con.close()

Found these guys done it..... waiting for their launch though..

http://aptus.com/phonebook-contacts.html