Email, CSV parsing, MS SQL DB write

Email, CSV parsing, MS SQL DB write

Closed - This job posting has been filled and work has been completed.

Job Description

Hi,

We are looking for a person who can create an application with the following functionality:

1. Read incomming email from a gmail hosted email address (pop/imap)
2. If an email from a particular email address is recieved and it has a CSV file attachment read the CSV file
3. CSV file can have 0 or more than 0 records
4. If more than 0 records are present - read all the records in the file and save each row of records into MSSQL 2k8 DB into particular table

CSV has 20 field - we need to extract 6 fields.

Application needs to be programmed in a way that there is a config file which can be amended and it will contain:

A) email access details
B) DB conn string
C) CSV fields and their mapping into DB fields

Application should be a console app that will be run via Windows Scheduler every X minutes.

Application should be programmed in .net 3.5 or higher.

Terms & Conditions:

To be considered for this position you must cover the following in your cover letter:

You will need to finish this job within 1 week of hire.

In your cover letter confirm that you understood every bit of the specification that is included in this job posting. The only other thing you will get is the CSV file with highlighted fields we require and Email and DB credentials. There will be no other spec - There is no need to discuss the project any further a clear and exact requirements are stated.

Answer how much is 3+4 (this is to ensure you have actually read this)

Do not post lots of links on your porjects that are not relevant - post maximum 2 links for each of the requirements above.

Do not ask for more information or discussion on skype - outline your experience and price if we like what you have written we will shortlist you and if you are the best applicant in our view you will be selected.

NO AGENCIES - If you are an Agency you will be automatically rejected.
We are looking for a professional contractor who is looking to work with a professional Software company based in UK

I am sorry about the harsh conditions of this Job Post however we get lots of applications that are spam or complete mismatch of required skills - please read and take the time to write a dedicated job application if you are serious.

Thank you.

---
Skills: gmail, imap, .net