Perl query MySQL to csv and send using SFTP


This is a Perl job.

I need a script that can be called from cron or shell and does the following:

- Query a MySQL table to select a set of records.

- If the result is not empty, export all selected records, but just a subset of columns (defined by an array of column names that is hard-coded in the Perl script) to a single csv file (named using a static value plus the current date and time) to a local directory. In the process, convert a few field values (such as converting default date values “0000-00-00” to null values).

- If the csv file was created, connect to an external FTP server (address and login hard coded in the Perl script) using SFTP protocol [<< IMPORTANT] and upload the file to the FTP server.

- Send an email (addresses hard-coded in the Perl script) indicating outcome including date, result (success, ftp connection error, no records, etc), and number of records found in the query.

The server is Linux. Any Perl modules can be installed.

It needs to be well commented especially the query, column subset, ftp info, and email info areas (so I can edit them).

Please don’t propose/use an existing third-party script. I don’t want all the baggage of a “full-featured” script that does 20 things when all I need is the few simple things above. If you really want to use existing scripts, they must be open source and you need to package them in a way that the excess code is removed or “hidden” -- AND YOU NEED TO EXPLAIN THEM IN YOUR BID or else I’ll assume you’re using none.



Kemahiran: Linux, Perl

Lihat lagi: perl mysql csv, perl query csv, mysql csv perl, perl export mysql table csv, perl export csv, convert mysql csv perl, mysql export csv perl, parse process mysql query results using shell script, send mail csv linux, perl export mysql csv, cron send csv, perl mysql empty query, perl sftp cron, perl export mysql query csv, mysql csv using perl, scripts send records sftp, n query, named query, login modules, job values, c plus plus array, send mysql query using sftp, perl export query csv, export mysql csv perl, export mysql table csv file perl

Tentang Majikan:
( 88 ulasan ) Durham, United States

ID Projek: #254058

Dianugerahkan kepada:


Please see PM

$50 USD dalam sehari
(6 Ulasan)

12 pekerja bebas membida secara purata $58 untuk pekerjaan ini


can create this

$50 USD dalam sehari
(100 Ulasan)

Hi. That's my specialty. Please check PM.

$70 USD dalam 2 hari
(173 Ulasan)

can help you. tnx.

$50 USD dalam sehari
(81 Ulasan)

Hi , I'd Like to pleasure you with my rich perl programming experiences since 1996. We are developer of LookMyPC, can can give you support over LookMyPC. pls check pm for more

$35 USD dalam 2 hari
(4 Ulasan)

kindly check PM.

$70 USD dalam 4 hari
(7 Ulasan)

Hi, see PM, please.

$60 USD dalam sehari
(7 Ulasan)

Hi sir, Happy to collaborate with you, plz see PM;

$45 USD dalam 0 hari
(2 Ulasan)

I can do that for you sir.

$40 USD dalam 0 hari
(1 Ulasan)

Hi Thr, Like to take up this and can assure you 100%satisfaction and timely, bug free delivery. Please see my PM.

$40 USD dalam 2 hari
(0 Ulasan)

i'ld like t o do the job, money is not a problem.

$30 USD dalam 0 hari
(0 Ulasan)

Quality Guaranteed.

$120 USD dalam 4 hari
(0 Ulasan)

What a fun little project to do. I can definitely supply what you need. Look forward to hearing from you.

$80 USD dalam 4 hari
(0 Ulasan)