Back to bug 36766

Who When What Removed Added
alexbuckley 2024-05-02 18:49:39 UTC Status NEW ASSIGNED
Assignee koha-bugs alexbuckley
Change sponsored? --- Sponsored
alexbuckley 2024-05-02 18:50:32 UTC Summary Add abilities to use SFTP with export_records.pl Add ability to use SFTP with export_records.pl
alexbuckley 2024-05-02 20:53:49 UTC Attachment #166085 Attachment is obsolete 0 1
alexbuckley 2024-05-02 21:25:32 UTC Summary Add ability to use SFTP with export_records.pl Add command-line utility to SFTP a file to a remote server
dcook 2024-05-02 23:55:11 UTC CC dcook
alexbuckley 2024-05-09 18:35:04 UTC Status ASSIGNED Needs Signoff
david 2024-05-28 00:17:55 UTC CC david
nick 2024-09-27 18:34:24 UTC Status Needs Signoff Signed Off
nick 2024-09-27 18:34:27 UTC Attachment #166089 Attachment is obsolete 0 1
Attachment #166471 Attachment is obsolete 0 1
Attachment #166859 Attachment is obsolete 0 1
nick 2024-09-27 18:37:02 UTC CC nick
david 2024-09-27 19:40:07 UTC Attachment #172151 Attachment is obsolete 0 1
david 2024-09-27 19:40:10 UTC Attachment #172152 Attachment is obsolete 0 1
david 2024-09-27 19:40:13 UTC Attachment #172153 Attachment is obsolete 0 1
david 2024-09-27 19:40:15 UTC Attachment #172154 Attachment is obsolete 0 1
kyle 2024-09-27 19:47:50 UTC See Also https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35761
CC kyle
kyle 2024-09-27 19:49:43 UTC QA Contact testopia kyle
wizzyrea 2024-09-27 19:52:52 UTC CC wizzyrea
kyle 2024-09-27 20:26:42 UTC Status Signed Off Passed QA
kyle 2024-09-27 20:26:44 UTC Attachment #172164 Attachment is obsolete 0 1
Attachment #172162 Attachment is obsolete 0 1
Attachment #172161 Attachment is obsolete 0 1
Attachment #172163 Attachment is obsolete 0 1
martin.renvoize 2024-10-08 09:52:18 UTC Blocks 35761
CC martin.renvoize
martin.renvoize 2024-10-08 09:54:40 UTC CC david.roberts
katrin.fischer 2024-10-23 17:53:05 UTC Keywords additional_work_needed
katrin.fischer 2024-10-23 18:03:14 UTC Version(s) released in 24.11.00
Status Passed QA Pushed to main
katrin.fischer 2024-10-28 20:43:01 UTC Blocks 38282
martin.renvoize 2024-11-08 14:38:03 UTC Keywords release-notes-needed
david 2024-11-08 21:35:45 UTC Text to go in the release notes KohaAdminEmailAddress if ReplytoDefault is not set.

Example of usage and workflow
-----------------------------

In New Zealand
Keywords release-notes-needed
Text to go in the release notes list of bibliographic numbers.
2. Using the export_records.pl cronjob to generate the MARC file for those bibliographic numbers.
3. Use a new sftp_file cronjob to transfer the MARC file to the remote SFTP server., libraries need to send MARC files to a remote server (using SFTP) to keep the national Te Puna union catalogue up to date.

This enhancement allows NZ libraries to automate sending their MARC files by:
1. Using the runreport.pl cronjob to generate a --file /tmp/test.mrc

Additional information:
1. Use misc/cronjobs/sftp_file.pl --help to list all the options available.
2. Two new notices are available: SFTP_FAILURE and SFTP_SUCCESSFUL.
3. The from address for any emails defaults to This enhancement adds a new command line utility misc/cronjobs/sftp_file.pl that allows libraries to securely transfer MARC data to an SFTP server.

Example usage: misc/cronjobs/sftp_file.pl --host sftp --user koha --pass koha --upload_dir upload
katrin.fischer 2024-11-14 15:34:19 UTC Keywords rel_24_11_candidate
martin.renvoize 2024-11-18 13:53:06 UTC Text to go in the release notes This enhancement adds a new command line utility misc/cronjobs/sftp_file.pl that allows libraries to securely transfer MARC data to an SFTP server.

Example usage: misc/cronjobs/sftp_file.pl --host sftp --user koha --pass koha --upload_dir upload --file /tmp/test.mrc

Additional information:
1. Use misc/cronjobs/sftp_file.pl --help to list all the options available.
2. Two new notices are available: SFTP_FAILURE and SFTP_SUCCESSFUL.
3. The from address for any emails defaults to KohaAdminEmailAddress if ReplytoDefault is not set.

Example of usage and workflow
-----------------------------

In New Zealand, libraries need to send MARC files to a remote server (using SFTP) to keep the national Te Puna union catalogue up to date.

This enhancement allows NZ libraries to automate sending their MARC files by:
1. Using the runreport.pl cronjob to generate a list of bibliographic numbers.
2. Using the export_records.pl cronjob to generate the MARC file for those bibliographic numbers.
3. Use a new sftp_file cronjob to transfer the MARC file to the remote SFTP server.
This enhancement adds a new command line utility misc/cronjobs/sftp_file.pl that allows libraries to securely transfer MARC data to an SFTP server.

Example usage: misc/cronjobs/sftp_file.pl --host sftp --user koha --pass koha --upload_dir upload --file /tmp/test.mrc

Additional information:
1. Use misc/cronjobs/sftp_file.pl --help to list all the options available.
2. Two new notices are available: SFTP_FAILURE and SFTP_SUCCESSFUL.
3. The from address for any emails defaults to KohaAdminEmailAddress if ReplytoDefault is not set.

##### Example of usage and workflow

In New Zealand, libraries need to send MARC files to a remote server (using SFTP) to keep the national Te Puna union catalogue up to date.

This enhancement allows NZ libraries to automate sending their MARC files by:
1. Using the runreport.pl cronjob to generate a list of bibliographic numbers.
2. Using the export_records.pl cronjob to generate the MARC file for those bibliographic numbers.
3. Use a new sftp_file cronjob to transfer the MARC file to the remote SFTP server.
lucas 2024-11-18 23:03:07 UTC CC lucas
Status Pushed to main Needs documenting

Back to bug 36766