Parse email into MySQL Database
This project was awarded to raz23vw for $46.75 USD.Get free quotes for a project like this
Project Budget$30 - $100 USD
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.
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 Independence is preferred. We will probably run the app on Linux/MySQL Programming Language - Flexible. Please suggest one.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online