@@ -, +, @@
- Create a csv profile (or use the default one) with a type 'sql'.
- Go to serials/claims.pl, select the wanted csv profile and click on
the "Export selected items data".
- Verify the csv file is correctly generated.
---
installer/data/mysql/en/optional/csv_profiles.sql | 1 +
installer/data/mysql/en/optional/csv_profiles.txt | 3 +
installer/data/mysql/updatedatabase.pl | 24 ++++
.../prog/en/modules/serials/claims.tt | 15 ++-
serials/claims.pl | 2 +
serials/lateissues-excel.pl | 134 +++++++-------------
6 files changed, 87 insertions(+), 92 deletions(-)
create mode 100644 installer/data/mysql/en/optional/csv_profiles.sql
create mode 100644 installer/data/mysql/en/optional/csv_profiles.txt
--- a/installer/data/mysql/en/optional/csv_profiles.sql
+++ a/installer/data/mysql/en/optional/csv_profiles.sql
@@ -0,0 +1, @@
+INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type ) VALUES ( "issues claims", "default csv export for issues claims", "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate", ";", "sql" );
--- a/installer/data/mysql/en/optional/csv_profiles.txt
+++ a/installer/data/mysql/en/optional/csv_profiles.txt
@@ -0,0 +1,3 @@
+csv profiles
+
+issues claims: Bug XXXXX allow to choose a csv profile for exporting claims. This profile is the default one.
--- a/installer/data/mysql/updatedatabase.pl
+++ a/installer/data/mysql/updatedatabase.pl
@@ -7123,6 +7123,30 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
SetVersion($DBversion);
}
+
+
+
+
+
+
+
+
+
+
+
+
+
+$DBversion = "3.13.00.XXX";
+if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
+ $dbh->do(q{
+ INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type ) VALUES ( "issues claims", "default csv export for issues claims", "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serial
+ });
+ print "Upgrade to $DBversion done (Bug 10854: Add the default csv profile for claiming issues)\n";
+ SetVersion($DBversion);
+}
+
+
+
=head1 FUNCTIONS
=head2 TableExists($table)
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt
+++ a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt
@@ -25,7 +25,6 @@
// Checkboxes : Select All / None
$("span.checkall").html(" "+_("Check All")+"");
- $("span.exportSelected").html(" "+_("Export selected items data") +"<\/a>");
$("#CheckAll").click(function() {
$("#claimst tr:visible :checkbox").attr('checked', $("#CheckAll").is(':checked'));
@@ -46,6 +45,7 @@
for (var i = 0; i < selected.length; i++) {
url += '&serialid=' + selected[i].value;
}
+ url += '&csv_profile=' + $("#csv_profile_for_export option:selected").val();
// And redirecting to the CSV page
location.href = url;
return false;
@@ -300,7 +300,18 @@
[% END %]
-
+
+ [% IF csv_profiles %]
+
+ Export selected items data
+ using the following csv profile:
+
+
+ [% END %]
[% IF ( letter ) %]