From: Ludovic CHEVALIER <ludovic.chevalier@heureux-cyclage.org>
Date: Mon, 6 Mar 2017 11:09:11 +0000 (+0100)
Subject: ~select usual contacts
X-Git-Url: http://git.cyclocoop.org/?p=lhc%2Foe_alcatel_export.git;a=commitdiff_plain;h=5d2b26d4aaf023cd9e24c3fb8b8d075a1e31d6fe

~select usual contacts
---

diff --git a/alcatel_export.py b/alcatel_export.py
index 01ea6d9..bff9c92 100644
--- a/alcatel_export.py
+++ b/alcatel_export.py
@@ -15,7 +15,7 @@ conn = psycopg2.connect("dbname=%s user=%s host=%s" % (db_name, db_user, db_host
 cur = conn.cursor()
 
 # import datas in dicos
-query = "SELECT name, phone, mobile, is_company from res_partner where name != '/' and name is not null and (phone is not null or mobile is not null) and active = True and is_company = True"
+query = "SELECT name, phone, mobile, is_company from res_partner where name != '/' and name is not null and (phone is not null or mobile is not null) and active = True and usual_contact = True"
 cur.execute(query)
 
 root = etree.Element('directory')