Encerrado

perl script emailing information from SQL query

I need a simple Perl script that will email my customers with information about payments posted to their account in a given period. Must be in Perl and will run on CentOS 5. Typically I would run this from cron every night.

I will give you the SQL query to run. Your script will fill in an HTML template and then email that to customers.

## Deliverables

I need a simple Perl script that will email my customers with information about payments posted to their account in a given period. Must be in Perl and will run on CentOS 5. Typically I would run this from cron every night.

You may make use of CPAN modules, but let me know if you need modules other than the default plus:

DBI

MIME::Lite

Date::Format

Locale::Currency::Format

Getopt::Long

Your script will:

1) Run an SQL query against an MSSQL database. I already have the SQL query designed which returns all the information you need. You DO NOT need to worry about any SQL work in this project. I also have a Perl script that connects and runs the query - so you DO NOT need to worry about how to connect to the MSSQL database - this is all done.

2) You need to query two tables - one is new deposits and one is reversed deposits. You then take those values and insert them into a basic HTML email template that is sent to each customer - detailing amount and date of payment info.

3) Your script needs to keep a running total of all amounts sent to customers and then email an admin address with a summary of what is has just sent out.

4) I will give you the HTML templates (one for deposits, one for reversals) with [[column]] tags in the HTML. You will replace [[column]] with the appropriate column variable from what you get returned in the database.

5) I will give you sample output of the query for you to test against. I will also give you shell access to a machine that can access a test database. You will not be able to access the database remotely. I will need the IP you are coming from to open the firewall for you to access the test machine.

Script will run from command prompt and will need to have the following options:

-h -> print usage help

-v -> if set should put debug info to STDOUT as script runs (e.g. who it's email, what values it will email etc. Default off.

-e address -> should use 'address' as the recipient email address, instead of the address given in the database - this allows me to do a full run and get all the emails myself - instead of customers. Default is to email customers.

-t deposits|reversals|both -> email out either deposits or reversals (default is both)

-s date -> start/from date (to be used in query)

-f -> end/to date (to be used in query)

-d -> dry-run. Just say what you woudl do, not actually do it. Would need to have -v to be any use

* * *This broadcast message was sent to all bidders on Sunday Jul 20, 2008 5:08:38 AM:

I have realized that I have already done a lot of the work for this project. I estimate a good coder can write this script in about 1-2 hours with maybe a another hour of testing (max). Therefore I am looking for bids under $50. Reminder what I have done: 1) Figuring out connection to MSSQL with Perl (using DBI)- I will give you the code. 2) SQL Queries - there are just two queries, and I have written them. What you have to do: 1) Execute the queries 2) For each row in result, substitute values into an HTML template and send an email. 3) Keep track of totals sent out. 4) Provide a test mode that overrides where mail is sent. Please take this into account and consider rebidding. Please still consider the previous description and requirements as still valid. Thanks David

Habilidades: Engenharia, MySQL, Perl, PHP, Gestão de projetos, Arquitetura de software, Teste de Software

Ver mais: sql get date, run shell script php, perl get, night fill, html command, write good summary, keep track customers, perl used, basic shell script, basic html email template, sql query, sql queries, send query, information about, need sql coder, html email template used, get sql help, from fill, emailing, cron command, php script execute, sql query format, insert variable, sample perl, simple perl shell

Acerca do Empregador:
( 11 comentários ) United States

ID do Projeto: #3054497

12 freelancers estão ofertando em média $56 para este trabalho

bocodevw

See private message.

$76.5 USD in 3 dias
(76 Comentários)
6.0
b0tivw

See private message.

$80.75 USD in 3 dias
(17 Comentários)
5.1
spx2vw

See private message.

$85 USD in 3 dias
(38 Comentários)
4.7
nvilochan

See private message.

$85 USD in 3 dias
(25 Comentários)
4.0
MohsenV

See private message.

$42.5 USD in 3 dias
(6 Comentários)
2.8
OnQuailty

See private message.

$15.3 USD in 3 dias
(6 Comentários)
2.6
coolbiddervw

See private message.

$21.25 USD in 3 dias
(4 Comentários)
1.9
kingisthebestvw

See private message.

$85 USD in 3 dias
(4 Comentários)
1.8
navigand

See private message.

$42.5 USD in 3 dias
(3 Comentários)
1.6
FocusService

See private message.

$15.3 USD in 3 dias
(4 Comentários)
1.3
djeaux

See private message.

$51 USD in 3 dias
(1 Comentário)
1.3
bsdguruvw

See private message.

$68 USD in 3 dias
(2 Comentários)
1.2