On 12/30/2014 1:08 AM, Malcolm Greene wrote:
Hi Kevin,
Over 10 years ago I built a CRM system whose entire user interface was
via email messages. Users created, edited, deleted, and reported on
customers by sending and receiving emails.
The email send and receive code was based on Dart PowerTCP Mail Tool
from www.dart.com. This was a set of ActiveX controls for sending (SMTP)
and receiving (IMAP) email.
If I was going to do this type of project again, I would write the mail
handling code in Python using the native Python SMTP and IMAP libraries.
Malcolm
I wrote a procedure to do this yesterday in Python. I am certainly no
Pythonista but the nice thing about Python is being able to write code
and test it as you go. It is also very easy to convert to an exe which
can be called with the run command in FoxPro. In about an hour I wrote
the Python part which reads the Gmail inbox and downloads the body of
the message into a text file which I parse in FoxPro.
The emails are cleverly formatted with a specific signature which has
the fields of data. So starting the email already has all of the fields
ready to fill out. I just scan the text file for the field names and
put the data in a record.
Example "PHONE: 602-555-1212"
The only problem I had was that one user is using rich text formatted
emails which I can't read, but that is easy to resolve by instruction on
turning that off.
I use both wwipstuff and Python but wwipstuff will not read SSL
encrypted emails as far as I can see. Send, but not receive. So Python
was called up for the task.
HTH
--
Jeff
Jeff Johnson
[email protected]
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
