https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33308 --- Comment #6 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 189909 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=189909&action=edit Bug 33308: Add S/FTP upload support to runreport.pl This patch adds S/FTP upload support to runreport.pl by adding additional command-line flags that will, when utilised, deposit a report onto the configured S/FTP Server. == TO TEST == a) Goto /cgi-bin/koha/admin/file_transports.pl?op=add_form b) Configure an S/FTP Server *) If one needs an S/FTP Server to utilise, contact me directly c) Configure an SQL report under Reports > Create from SQL *) If you're stuck, you can use `SELECT * FROM items` to select every item in k.t.d to report on == APPLY PATCH == d) Run `./misc/cronjobs/runreport.pl` without arguments *) Notice `--sftp-dest-id` and `--filename` *) `--sftp-dest-id` specifies the ID of the configured server to use, which can be garnered from the URL when editing the server (look for the file_transport_id parameter) *) `--filename` optionally specifies what the file should be called when uploaded, and can be customised with bash variables if necessary e) Run `./misc/cronjons/runreport.pl --sftp-dest-id 1 1` *) Notice the script outputs nothing, indicating success *) On your S/FTP server, notice a report now named report(id)-(date).csv *) Notice that the outputted file contains a CSV-formatted report f) Run `./misc/cronjobs/runreport.pl --format html --sftp-dest-id 1 1` *) Notice the script outputs nothing, indicating success *) On your S/FTP server, notice a report now named report(id)-(date).html *) Notice that the outputted file contains an HTML-formatted report g) Run `./misc/cronjons/runreport.pl --filename custom.csv --sftp-dest-id 1 1` *) Notice the script outputs nothing, indicating success *) On your S/FTP server, notice a report now named custom.csv *) Notice that the outputted file contains a CSV-formatted report h) Run `./misc/cronjons/runreport.pl --format html --filename custom.somehtml --sftp-dest-id 1 1` *) Notice the script outputs nothing, indicating success *) On your S/FTP server, notice a report now named custom.somehtml *) Notice that the outputted file contains an HTML-formatted report == SIGN OFF == Signed-off-by: Andrew Fuerste Henry <andrew@bywatersolutions.com> Signed-off-by: Martin Renvoize <martin.renvoize@openfifth.co.uk> -- You are receiving this mail because: You are watching all bug changes.