Bug 33308

Summary: Add ability to to use SFTP with runreport.pl
Product: Koha Reporter: Liz Rea <wizzyrea>
Component: Command-line UtilitiesAssignee: Jake Deery <jake.deery>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: dcook, kyle, martin.renvoize, robin, wizzyrea
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on: 35761    
Bug Blocks:    

Description Liz Rea 2023-03-22 16:01:32 UTC
It would be very awesome to be able to specify a sftp/ftps target with the cronjob runreport.pl job, to complement the ability currently available to email the report somewhere. 

Some kind of secure solve for "allowing the koha user to automatically accept the hostkey" on the first connection would also be nice, but not a requirement.
Comment 1 Katrin Fischer 2023-03-23 22:34:35 UTC
I like the idea, but maybe a workaround: would be using the 'access files' tools and a directory on the Koha server work? It would limit access to Koha staff users with the right permission set.
Comment 2 Liz Rea 2023-03-27 22:39:26 UTC
We do this in some places, but by and large our partners do not like this approach for a few reasons:

They often have to send things other places without human intervention, on a schedule.
The UX of the access_files is very poor (no directory structures allowed, cannot remove files themselves, among other things.)
They have workflows that involve 3rd party vendors who require sftp/ftp deliveries of files.

Right now, we generate the files and use other tools to deliver the files, which works but is very labor intensive when you have many of them to administer.
Comment 3 Katrin Fischer 2023-04-04 09:31:24 UTC
Thx for the reply, Liz, that makes sense.