Sedang Disiapkan

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.

Thanks.

-

Kemahiran: Linux, Perl

Lihat lebih lanjut: perl mysql csv, perl query csv, mysql csv perl, perl export csv, convert mysql csv perl, mysql export csv perl, send mail csv linux, perl export mysql csv, cron send csv, perl mysql empty query, perl sftp cron, mysql csv using perl, scripts send records sftp, n query, named query, login modules, job values, perl export query csv, export mysql csv perl, perl mysql csv export, perl mysql query csv, perl script mysql export, perl sftp csv files, perl sftp example, query mysql comma seperated

Tentang Majikan:
( 88 ulasan ) Durham, United States

ID Projek: #254058

Dianugerahkan kepada:

james5400

Please see PM

$50 USD dalam sehari
(6 Ulasan)
3.7

12 pekerja bebas membida secara purata $58 untuk pekerjaan ini

meral

can create this

$50 USD dalam sehari
(100 Ulasan)
7.5
nknk

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

$70 USD dalam 2 hari
(173 Ulasan)
7.0
CoVaLiDiTy

can help you. tnx.

$50 USD dalam sehari
(81 Ulasan)
5.5
WShuttle

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)
4.1
HeoQue

kindly check PM.

$70 USD dalam 4 hari
(7 Ulasan)
4.1
fuzzoid

Hi, see PM, please.

$60 USD dalam sehari
(7 Ulasan)
3.5
bendriss

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

$45 USD dalam 0 hari
(2 Ulasan)
2.7
onuraslan

I can do that for you sir.

$40 USD dalam 0 hari
(1 Ulasan)
1.2
softwareprof

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)
0.0
cslinux

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

$30 USD dalam 0 hari
(0 Ulasan)
0.0
nitzATbest

Quality Guaranteed.

$120 USD dalam 4 hari
(0 Ulasan)
0.0
LesleyB

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)
0.0