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: www apps programming com, what is an apps script, what is a loop in programming, what are programming languages, top programming languages, top 5 programming languages, top 10 programming languages, script doctor, programming languages for apps, parse programming, on line programming languages, mediafire.com, log company, i want a company log, for loop in c programming, for loop c programming, file download service, email address management, doing a log for a company, current programming languages, c programming if statement, c programming for loop, apps programming languages, a company log, parse log file email alert

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