From ef6211b319b58b4c35e8cb8555e1caa4da9b2a8f 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 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 Signed-off-by: Jonathan Druart --- tools/export.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/tools/export.pl b/tools/export.pl index 0165cf1ea4..208d7f4d78 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.39.5