Reading emails from a VFP app and creating "tickets" based on them

[m***@mbsoftwaresolutions.com]

VFP9SP2, Network Solutions web email account

We've got a clunky manual process here at the Corporate gig whereby we
have an Excel file we track customer interactions, and several of those
interactions come from incoming email. Boss wants solution that
auto-creates tickets based on incoming emails to that web mail account.
Currently, it's just manual adding into Excel by help desk staff.

Anyone ever do that?

(I personally use ZenDesk for my MBSS clients, and I love it, but not
sure if that's an option here at the Corporate gig or not. Probably not
since it's not a budgeted expense--although it's dirt cheap imo!!!)

tia,
--Mike

_______________________________________________
Post Messages to: ***@leafe.com
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/***@mbsoftwaresolutions.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.

[Stephen Russell]

https://www.cio.com.au/article/320110/5_open_source_help_desk_apps_watch/
has a few.

Post by m***@mbsoftwaresolutions.com
VFP9SP2, Network Solutions web email account
We've got a clunky manual process here at the Corporate gig whereby we
have an Excel file we track customer interactions, and several of those
interactions come from incoming email. Boss wants solution that
auto-creates tickets based on incoming emails to that web mail account.
Currently, it's just manual adding into Excel by help desk staff.
Anyone ever do that?
(I personally use ZenDesk for my MBSS clients, and I love it, but not
sure if that's an option here at the Corporate gig or not. Probably not
since it's not a budgeted expense--although it's dirt cheap imo!!!)
tia,
--Mike

[excessive quoting removed by server]

_______________________________________________
Post Messages to: ***@leafe.com
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/CAJidMYKH3DtTr6vHLzSB+***@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.

[Eric Selje]

Second on FreshDesk.

Hi Mike,

Boss wants solution that auto-creates tickets based on incoming emails

to that web mail account.
If ZenDesk is too expensive, check out FreshDesk and Zoho for cheaper
alternatives.
If you go the build route, find an IMAP compatible control that works with
VFP, create a dedicated account to receive mail, poll that account and use
the IMAP component to parse the message into a structure you can process.
Sounds easy, but gets complicated when you start to factor in non-text
emails (RTF or HTML) and attachments.
If you're willing to expand your tool set for this project, Python has a
built in IMAP library ("batteries included").
Good luck,
Malcolm

[excessive quoting removed by server]

_______________________________________________
Post Messages to: ***@leafe.com
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/CAAwxvUm2zMrhLniEXcpz6O7ufL1qL=***@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.