SuiteCrm for customer database

Asked Aug 07 '23 at 01:15

Active Aug 07 '23 at 01:17

Viewed 32 times

-2

Using SuiteCrm for a customer database.

https://www.cdata.com/kb/tech/suitecrm-python-petl.rst

How can I write a sample code that would get all customer data named jeff and sort by age ?

I tried to do it in this way but however, I dont know if it is correct or wrong:

import petl as etl
import cdata.suitecrm as mod

cnxn = mod.connect("URL=http://mySuiteCRM.com;User=myUser;Password=myPassword;")

sql = "SELECT * FROM Contacts WHERE first_name = 'Tom' ORDER BY age"

table1 = etl.fromdb(cnxn, sql)

table2 = etl.sort(table1, 'age')

etl.tocsv(table2, 'contacts_data.csv')

edited Aug 07 '23 at 01:17

ewokx

2,204
3
14
27

asked Aug 07 '23 at 01:15

Ahthesham Ali Syed

Welcome to Stack Overflow. What happens when you run that script? – ewokx Aug 07 '23 at 01:18
Your query won't find people named Jeff, because it's looking for people named Tom. Please do some testing **before** you post a question here. – Tangentially Perpendicular Aug 07 '23 at 01:37
Also, never store age. People become older every year, and your data will soon become out-of-date. Store date of birth instead. – jarlh Aug 07 '23 at 08:01

SuiteCrm for customer database

0 Answers0