Em Andamento

Parse CSV File for Name/Email, Send Emails, Delete File, Log Results into TXT LogFile

I need a script that will parse/loop through a CSV or TXT file and (if there are rows) **remove duplicate emails** and **individually email** each person using our SMTP server.

It must then delete the CSV file, log success/failed transactions and send me an email alert.

## Deliverables

Everyday, one of our Desktop Apps drops a CSV (or TXT file if it's easier) with the same name in a folder.

Inside the CSV file are 4 columns: **Appt Date, Patient Name**, **EmailAddress**, **Doctor**.

Some days the file is empty.

Other days, the file can have between 10-50 rows of people.

The CSV file is output by a desktop app and always looks the same (same 4 lines of headers and 1 line of footer).

**Parse/Send**

I need a script that will parse/loop through the CSV file and (if there are rows) **remove duplicate emails** and **individually email** each person the following statement using our in-house SMTP Server:

> "Dear [FirstName] [Lastname] *(dynamically inserted from CSV file)*,

>

> Thanks for visiting our office on [Appt Date] *(dynamically inserted from CSV file)*. Please visit the link below to complete a brief survey.

>

> [[url removed, login to view]][1]

>

> Sincerely,

>

> [Doctor] *(dynamically inserted from CSV file)*"

>

**Logging**

Once the script is done emailing, it will delete the original CSV file and log all success/fail email transactions to a TXT log file in the same folder with the current date as the filename (ie, [url removed, login to view]).

**Alert Me**

Finally, the script will send me a "success" or "fail" email alert to a specific email address "[itdepartment@[url removed, login to view]][2]". If possible, I'd like to receive the exact error received on failures.

The only 3 accepted programming languages are ASP, PHP and Coldfusion. It's Windows 2003 with IIS, Coldfusion 8 & PHP 5 installed. I do not want a Windows Service or Desktop App.

**More Supplemental Details**

* The code must be well-commented. Just tell me what each section is doing in the code.

* If you can declare variables at the top, that would be great. I will need variables for **"From" Name**, **"From" Email Address**, **Email Subject** and "**BCC**" in outgoing "loop" emails **and** my alert emails.

* Our server is Windows 2003 with IIS, Coldfusion 8 & PHP 5 installed.

* I plan to use WGET (Windows CRON) or a Scheduled Task to trigger the script twice a day at specific times.

You can download a copy of the CSV/TXT File here:

**[url removed, login to view]**

It will always look like that...except on Saturdays and Sundays there will be no records/rows.

Habilidades: Amazon Web Services, Engenharia, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: top programming languages, script doctor, programming languages apps, line programming languages, want company log, loop programming, file download service, email address management, current programming languages, programming statement, programming loop, apps programming languages, line desktop app, cron management, coldfusion download, log company, windows house, sundays, name please, email send, delete duplicate, csv file, code name one, house inside, complete house plan

Acerca do Empregador:
( 7 comentários ) Pembroke Pines, United States

ID do Projeto: #3031779

Premiar a:

SKJoy2001

See private message.

$25.5 USD em 7 dias
(86 Avaliações)
6.1

23 freelancers estão ofertando em média $85 para este trabalho

ROWS

See private message.

$158.95 USD in 7 dias
(187 Comentários)
7.2
thundercoders

See private message.

$25.5 USD in 7 dias
(50 Comentários)
7.2
heeta

See private message.

$76.5 USD in 7 dias
(94 Comentários)
6.6
FreeDevelopers

See private message.

$211.65 USD in 7 dias
(50 Comentários)
6.5
s17

See private message.

$38.25 USD in 7 dias
(375 Comentários)
6.6
shihan033010

See private message.

$63.75 USD in 7 dias
(308 Comentários)
6.8
tonythksl

See private message.

$170 USD in 7 dias
(111 Comentários)
6.1
marconian

See private message.

$76.5 USD in 7 dias
(123 Comentários)
5.6
RabbitRoger

See private message.

$84.15 USD in 7 dias
(81 Comentários)
5.8
ashtrac

See private message.

$42.5 USD in 7 dias
(47 Comentários)
5.3
omalb

See private message.

$34 USD in 7 dias
(50 Comentários)
4.7
oasis21

See private message.

$18.7 USD in 7 dias
(38 Comentários)
4.8
toinnisfreesl

See private message.

$114.75 USD in 7 dias
(17 Comentários)
4.7
emergingcoder1

See private message.

$68 USD in 7 dias
(53 Comentários)
4.5
wajimam

See private message.

$42.5 USD in 7 dias
(14 Comentários)
5.0
ctgr

See private message.

$25.5 USD in 7 dias
(13 Comentários)
3.1
d07

See private message.

$85 USD in 7 dias
(6 Comentários)
3.7
bwsc

See private message.

$161.5 USD in 7 dias
(4 Comentários)
2.4
chintan1313

See private message.

$255 USD in 7 dias
(1 Comentário)
2.2
graduatedpr

See private message.

$42.5 USD in 7 dias
(0 Comentários)
0.0