@@ -, +, @@ basket export csv profiles --- acqui/basket.pl | 2 +- installer/data/mysql/atomicupdate/bug_8612.sql | 1 + .../prog/en/modules/tools/csv-profiles.tt | 36 +++++++++++++--------- serials/claims.pl | 2 +- t/db_dependent/Acquisition/GetBasketAsCSV.t | 2 +- t/db_dependent/Koha/CsvProfiles.t | 2 +- 6 files changed, 26 insertions(+), 19 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_8612.sql --- a/acqui/basket.pl +++ a/acqui/basket.pl @@ -424,7 +424,7 @@ if ( $op eq 'list' ) { unclosable => @orders ? $basket->{is_standing} : 1, has_budgets => $has_budgets, duplinbatch => $duplinbatch, - csv_profiles => [ Koha::CsvProfiles->search({ type => 'sql' }) ], + csv_profiles => [ Koha::CsvProfiles->search({ type => 'export_basket' }) ], ); } --- a/installer/data/mysql/atomicupdate/bug_8612.sql +++ a/installer/data/mysql/atomicupdate/bug_8612.sql @@ -0,0 +1, @@ +UPDATE export_format SET type = 'late_issues' WHERE type ='sql'; --- a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/csv-profiles.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/csv-profiles.tt @@ -101,6 +101,14 @@ function reloadPage(p) { [% END %] [% END %] +[% BLOCK type_description %] + [% IF type_code == 'marc' %] MARC for export records + [% ELSIF type_code == 'late_issues' %] SQL for late serial issues claims + [% ELSIF type_code == 'export_basket' %] SQL for basket export in acquisition + [% ELSE %] Uknown type + [% END %] +[% END %] + [% IF op == 'add_form' %] [% IF csv_profile %]
You have to define which fields you want to export, separated by pipes.
-You can also use your own headers (instead of the ones from Koha) by prefixing the field name with an header, followed by the equal sign.
-Example: Name=subscription.name|Title=subscription.title|Issue number=serial.serialseq
+ + +You have to define which fields you want to export, separated by pipes.
+You can also use your own headers (instead of the ones from Koha) by prefixing the field name with an header, followed by the equal sign.
+Example: Name=subscription.name|Title=subscription.title|Issue number=serial.serialseq
+For late issues claims you can use data from following tables: serial, subscription, biblio, biblioitems and aqbookseller.
+For basket exports you can use data from following tables: biblio, biblioitems, aqorders, aqbudgets and aqbasket.