I have created solutions with VFP and incoming messages, using everything from Outlook Automation to Exchange event sinks. The gist of my learning experiences is that VFP is an excellent database language, but it was never really intended to be a long-running or multi-threaded language runtime. If you're looking at processing inbound responses that have big peaks (like after you've just send out a wave of marketing materials), you'll find scalability issues in getting VFP to handle these real-time.
VFP's ODBC support is old (VFP6 era) and won't be updated nor supported. I wouldn't recommend that as a key component in new development. Something like Email2DB sounds ideal at handling the first of the tasks: intercepting the mail and converting it to data. Rather than dumping directly into VFP DBFs, I'd recommend a database server such as SQLite or MariaDB. These are robust and reliable database servers, unencumbered by commercial licenses, that won't need their tables packed (well, not too often) or their indexes reindexed, and are intended to run 24x7. Then, write a VFP app to periodically read through the data and pluck out the new info you need. On Mon, Dec 29, 2014 at 12:31 PM, Kevin Salisbury <[email protected] > wrote: > Happy Holidays all, > > Has anyone any tips for creating records in VFP 9 from email messages > and/or attachments to those messages? We generate outbound automated emails > all the time but we have never handled inbound here. The idea behind a > separate app like email2db ( http://www.email2db.com/ ) using odbc seems > OK > if it handles vfp record locks, and attachments, etc. properly. I am open > to any ideas (open source or closed) from anyone in the community that has > accomplished this with success using native VFP, ActiveX or odbc, etc. > > Thoughts? > > Kevin > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ 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/CACW6n4tPQHa3Y+S=p_ttL=4-vconwasj1fsryton8tt482e...@mail.gmail.com ** 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.
