From 5d2b26d4aaf023cd9e24c3fb8b8d075a1e31d6fe Mon Sep 17 00:00:00 2001 From: Ludovic CHEVALIER Date: Mon, 6 Mar 2017 12:09:11 +0100 Subject: [PATCH] ~select usual contacts --- alcatel_export.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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') -- 2.20.1