In Progress

Parse email into MySQL Database

This is a simple project. Create a program that checks an POP email account on a regular, user-defined basis. Retrieve any emails and parse certain text from them into a database table. The emails are always in the same format. Here's a sample with some text replaced by xxxx's and etc., etc., etc.: "Please Quote XXXXXXXXX would like to order the following list of material from you. If you have any available please contact the listed representative at xxxxxxxx or simply reply to this email. etc., etc., etc If you would like to be removed from our sourcing system, please click Remove Me or contact etc., etc., etc. We appreciate your support and hope to be a great customer to you. Thank you, XXXXXXX Please Note: If you have surplus or used items you need to liquidate please visit etc., etc., etc. Items Requested Qty Manufacturer & Part Number 13 ADVANCE BALLAST R-4S40-A-TP-AC BALLAST 120V 4 F40T12/RS To replenish inventory, Contact purchasing Ext: 843 5 AGASTAT 7012X3A TIMER To fill a sales order, added by Rich Monteiro Ext: 854 5 AGASTAT 7022X3BT TIMER To fill a sales order, added by Rich Monteiro Ext: 854" It is the Items Requested section that we are interested in. Create a table in MySQL to store the Quantity, Manufacturer, Part Number, Reason and Contact information. When the app receives an email, it will parse out all of the Items Requested and add each one to the database. Each database entry should include the Timestamp of the email. The winning bidder will be provided with complete samples of the emails. At this time, no other functionality is required.

## 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

Platform Independence is preferred. We will probably run the app on Linux/MySQL Programming Language - Flexible. Please suggest one.

Skills: Engineering, MySQL, PHP, Software Architecture, Software Testing

See more: parse emails inventory, we need sales representative, we need a sales representative, web for buyer sourcing, the r programming language, sample thank you email, sales representative hire, rs components, programming language r, php inventory system sample, parse programming, out sourcing sites, out source purchasing, order entry representative, need a sales representative, mysql database software, manufacturer's code list, linux programming language, hire manufacturer, hire ac coder, functional programming in r, engineering sales representative, email support number, database entry software, customer support out sourcing

About the Employer:
( 22 reviews ) United States

Project ID: #3379845

Awarded to:

raz23vw

See private message.

$46.75 USD in 5 days
(13 Reviews)
2.4

13 freelancers are bidding on average $67 for this job

betatea

See private message.

$51 USD in 5 days
(562 Reviews)
7.4
adyzah

See private message.

$68 USD in 5 days
(89 Reviews)
7.3
n08kiwi

See private message.

$85 USD in 5 days
(45 Reviews)
5.9
oscommercevw

See private message.

$76.5 USD in 5 days
(137 Reviews)
5.6
braduku

See private message.

$63.75 USD in 5 days
(46 Reviews)
5.0
pimiela

See private message.

$72.25 USD in 5 days
(31 Reviews)
4.6
asalah

See private message.

$63.75 USD in 5 days
(33 Reviews)
4.5
jitd

See private message.

$170 USD in 5 days
(2 Reviews)
3.3
vw1776269vw

See private message.

$16.15 USD in 5 days
(1 Review)
0.2
ubaid

See private message.

$68 USD in 5 days
(0 Reviews)
0.0
yubiicoders

See private message.

$85 USD in 5 days
(1 Review)
0.0
rethvw

See private message.

$8.5 USD in 5 days
(0 Reviews)
0.0