Create email processing application
$100-250 USD
Оплачується при отриманні
Standalone application to check POP3 mailbox for emails of a certain subject line, then download the email and process the body text, which is XML text. Data from the body text contains information to insert, update, or delete data in a SQLServer database.
## Deliverables
Functions:
1. Read designated email box for list of emails
2. Download messages from email box
3. Process email messages from box
1. Validate subject line
2. Read email body
3. Process transactions in body text
4. Data in email interact with a database
i. Insert
ii. Update
iii. Delete
iv. Exec (used to call a stored procedure and pass variables from the email)
1. 1. Delete email from mailbox at conclusion of successful processing
2. Log all activities to text log file
1. Processing log
i. Date & time
ii. Action
iii. Result
1. Errors in process creates separate error log, one log per day
Application runs as a service, with timed check of the designated mailbox
Application uses a configuration file ([url removed, login to view])
a. Email settings
b. Process settings
c. Database settings
d. Data format settings
ID Проекту: #3453999