Convert emails into databae

  • Posted:
  • Proposals: 12
  • Remote
  • #44728
  • Expired
Unique S.Shariq K.Suhail A.Faizus S.MD Kamrul H. + 7 others have already sent a proposal.
  • 1


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

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.