Windows application - Poll MySQL DB and retrieve records to send as emails VB
- or -
Post a project like this2994
£500(approx. $622)
- Posted:
- Proposals: 6
- Remote
- #1015464
- Awarded
PHP/Wordpress/Python/React/Flutter - Web Development,Mobile Development,Data Science
Bay Minette
Web design,PHP,CMS,E-commerce,Mobile application ERP and 2D/3D Animation video design and development
Kolkata
69624813523852200166003411253531148591
Description
Experience Level: Intermediate
General information for the business: Have an in-house application that has expanded and need to be able to automate some email sending to your customers.
Kind of development: New program from scratch
Num. of modules: 1
Description of every module: We have an in-house application (written in VB) that operates on a MySQL Back-end. As our business has expanded we have a need to automate email sending (to our own staff, customers etc) that we cannot meet with current application logic.
I want a standalone executable that can be configured to :
- Poll a DB at a definable interval with a definable mysql query
- The query will return one ore mutliple records
- For each record an email is to be sent, and the record updated to mark it as sent
- The record will contain the relevant email fields (To, cc, bcc, Subject, Body, attachments)
- The new executable will log transactions to a logfile to interrogate in case of any future errors
This product may already exist but cannot find it after numerous internet searches. Keen to get in asap as have a pressing requirement.
Description of requirements/functionality: Logfile to be .txt and appended to with each transaction
The application will ideally run in a window and minimise to the icon tray where necessary.
CMS and Admin requirements: The executable needs to have the ability to configure :
DSN / DB Connection string
DB Username
DB Password
Default Database to use
Poll Interval
Email server address
Email server port
Email server username (optional)
Email Server Password (optional)
Query string to execute against database
update query to run once record has successfully been processed and email sent
Specific technologies required: Preferrably the app is written in VBA so we can further develop and adapt as needs increase.
OS requirements: Windows
Extra notes:
Kind of development: New program from scratch
Num. of modules: 1
Description of every module: We have an in-house application (written in VB) that operates on a MySQL Back-end. As our business has expanded we have a need to automate email sending (to our own staff, customers etc) that we cannot meet with current application logic.
I want a standalone executable that can be configured to :
- Poll a DB at a definable interval with a definable mysql query
- The query will return one ore mutliple records
- For each record an email is to be sent, and the record updated to mark it as sent
- The record will contain the relevant email fields (To, cc, bcc, Subject, Body, attachments)
- The new executable will log transactions to a logfile to interrogate in case of any future errors
This product may already exist but cannot find it after numerous internet searches. Keen to get in asap as have a pressing requirement.
Description of requirements/functionality: Logfile to be .txt and appended to with each transaction
The application will ideally run in a window and minimise to the icon tray where necessary.
CMS and Admin requirements: The executable needs to have the ability to configure :
DSN / DB Connection string
DB Username
DB Password
Default Database to use
Poll Interval
Email server address
Email server port
Email server username (optional)
Email Server Password (optional)
Query string to execute against database
update query to run once record has successfully been processed and email sent
Specific technologies required: Preferrably the app is written in VBA so we can further develop and adapt as needs increase.
OS requirements: Windows
Extra notes:
Nick C.
100% (9)Projects Completed
12
Freelancers worked with
13
Projects awarded
65%
Last project
10 Aug 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies