Convert emails into databae
- or -
Post a project like this£200(approx. $248)
- Posted:
- Proposals: 10
- Remote
- #44728
- Expired
Full Stack Web & Software Application Developer with good knowledge of C#-ASP.Net, PHP-MySQL, Python, AJAX, jQuery, Bootstrap
Indore
1272122778587828581688814946489732999273100870116459
Description
Experience Level: Expert
We need a script or program to interpret automated email orders for different types of vouchers from an email into a spreadsheet. Or a database that can export to a spreadsheet.
The email contains the following;
Persons email address
Persons first name
Address
Order number
Items ordered on separate lines
Total value
The spreadsheet has the following fields
Order number
Full name
Address 1
Address 2
Address 3
Post code
Product
Voucher denomination
Amount / total
Delivery method.
The added complications are;
To make the full name the first name has a field in the email. The second name needs to somehow be generated from the email address. There are range of email extensions and each one encodes the surname in their email address slightly differently.
Each item ordered comes by email on a sepparate row. Duplicates of the same item are inserted on one row in the spreadsheet When different items are ordered in the same email a new row in the spreadsheet needs to be created for each new item.
The address arrived in the email in one block of text with no indicators as to which is the post code for instance. Therefore the post code would need to be identified somehow.
The spreadsheet would be checked and emailed daily to the company that sends out the vouchers
The email contains the following;
Persons email address
Persons first name
Address
Order number
Items ordered on separate lines
Total value
The spreadsheet has the following fields
Order number
Full name
Address 1
Address 2
Address 3
Post code
Product
Voucher denomination
Amount / total
Delivery method.
The added complications are;
To make the full name the first name has a field in the email. The second name needs to somehow be generated from the email address. There are range of email extensions and each one encodes the surname in their email address slightly differently.
Each item ordered comes by email on a sepparate row. Duplicates of the same item are inserted on one row in the spreadsheet When different items are ordered in the same email a new row in the spreadsheet needs to be created for each new item.
The address arrived in the email in one block of text with no indicators as to which is the post code for instance. Therefore the post code would need to be identified somehow.
The spreadsheet would be checked and emailed daily to the company that sends out the vouchers
Kevin S.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
23 Apr 2024
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