From 5a999408ca619de148ceada96e33f15de327711c Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Tue, 30 May 2017 16:55:19 -0400 Subject: [PATCH] Bug 18704 - File types limit in tools/export.pl is causing issues with csv files generated by MS/Excel Content-Type: text/plain; charset=utf-8 To test: 1 - Save a csv of biblionumber from MS/Excel 2 - Attempt to export records using this file 3 - It fails (mimetype is appliction/vnd.ms-excel) 4 - Apply patch 5 - Try again 6 - It succeeds! Signed-off-by: Jason Palmer Signed-off-by: Marcel de Rooy --- tools/export.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/tools/export.pl b/tools/export.pl index 0165cf1..208d7f4 100755 --- a/tools/export.pl +++ b/tools/export.pl @@ -74,7 +74,7 @@ if ( $op eq 'export' ) { my $filename = $query->param('id_list_file'); if ( $filename ) { my $mimetype = $query->uploadInfo($filename)->{'Content-Type'}; - my @valid_mimetypes = qw( application/octet-stream text/csv text/plain ); + my @valid_mimetypes = qw( application/octet-stream text/csv text/plain application/vnd.ms-excel ); unless ( grep { /^$mimetype$/ } @valid_mimetypes ) { push @messages, { type => 'alert', code => 'invalid_mimetype' }; $op = ''; -- 2.1.4