~select usual contacts

[lhc/oe_alcatel_export.git] / alcatel_export.py

diff --git a/alcatel_export.py b/alcatel_export.py
index 01ea6d9..bff9c92 100644 (file)
--- 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')