X-Git-Url: http://git.cyclocoop.org/?p=lhc%2Foe_alcatel_export.git;a=blobdiff_plain;f=alcatel_export.py;fp=alcatel_export.py;h=bff9c92c6dacd3cbf28d6f76803ec2c78bee10e3;hp=01ea6d90bdfcbf835fb46c025ad238433884eaa1;hb=5d2b26d4aaf023cd9e24c3fb8b8d075a1e31d6fe;hpb=a7382b2309e1f7a02aebab52c1c17fd77b5c5541

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')