Lukket

Email to MySQL database script

I need a perl script that can be run using crontab on a Linux system. The script will need to connect to a pop3 email server and check the new messages. If a new message exists with a subject like “MyCompanyName Sales Receipt - 62214-R99999999?? (mycompany name will be replaced and the 9’s will be random numbers) it will need to take certain values out of the database and insert them into a database. An example email is included: Selling Company: MyCompany ( [url removed, login to view] ) [url removed, login to view] Order Number: 62214-R99999999 ID# Description Interval Charge Windows ZestDevelope ZestDeveloper (windows) Every 1 Year(s) $ 30.00 Start Up Cost One Time $ 0.00 Total Billed Today $ 30.00 The order was billed to: NEW CUSTOMER Payment Method - Visa customersemailaddress 0222 222 333 2639 Long Street New York, NA 20111 USA IP Address: [url removed, login to view] IP Location: New York, , United States Card Type: Visa AVS Code: YY Code Explanation CVV Code: Matched Bank Records 2co_ip: [url removed, login to view] Using this data it would have to insert the following into a MySQL database (field name : value): name : NEW CUSTOMER 2checkout : R99999999 startdate : (date email received yyyy-mm-dd) lastpaydate : (date email received yyyy-mm-dd) expiresdate : (date email received + 1 year yyyy-mm-dd) email : customersemailaddress domain : ? username : ? WINDOWS paymentamount : 30 totalpaid : 30 It will then need to send a standard welcome email to customersemailaddress (I will provide the text and subject for this email). The script will also have to check before inserting the new order into the database if the order R99999999 already exists in the database - the 2checkout field is a unique key field. If it already exists it should just ignore the email but it must leave all emails intact on the server as this email account is also used for other emails.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Linux, Redhat, Perl

Evner: Ingeniørarbejde, MySQL, Perl, PHP, Software Arkitektur, Software Testning

Se mere: welcome new hire email, u. s. bank.com, standard payment agreement, script ip address, php send email source code, new york new hire, new hire welcome email, new hire email, mysql database software, mysql database server, key bank, it sales new york, ip address script, hire sales company usa, hire company to type, hire a coder united states, dd for hire, dd 4 hire, bank united, bank id type

Om arbejdsgiveren:
( 0 bedømmelser ) United Kingdom

Projekt ID: #3318126

10 freelancere byder i gennemsnit $36 på dette job

slimbvw

See private message.

$42.5 USD in 5 dage
(156 bedømmelser)
7.5
sasdataservices

See private message.

$42.5 USD in 5 dage
(16 bedømmelser)
5.5
toshirovw

See private message.

$42.5 USD in 5 dage
(63 bedømmelser)
5.4
matcoder

See private message.

$42.5 USD in 5 dage
(7 bedømmelser)
3.7
nonzerovw

See private message.

$3.4 USD in 5 dage
(20 bedømmelser)
3.6
ridcode

See private message.

$34 USD in 5 dage
(18 bedømmelser)
3.6
vw1299032vw

See private message.

$38.25 USD in 5 dage
(3 bedømmelser)
1.1
jas969

See private message.

$42.5 USD in 5 dage
(2 bedømmelser)
1.3
vitalielvw

See private message.

$42.5 USD in 5 dage
(0 bedømmelser)
0.0
kizamp1089

See private message.

$25.5 USD in 5 dage
(0 bedømmelser)
0.0