From 5346b03eaad4160aa60406494f0c36c6694d8ead Mon Sep 17 00:00:00 2001
From: Zog
Date: Fri, 23 Feb 2018 09:49:44 +0100
Subject: Refs #5927 @1h; Add a BOM at the beginning of CSVs

In the exported csv, add a BOM at the beginning to tell Excdel we use
UTF-8
---
 app/models/compliance_check_message_export.rb | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/app/models/compliance_check_message_export.rb b/app/models/compliance_check_message_export.rb
index 04e1a9caa..bbaaa8e3f 100644
--- a/app/models/compliance_check_message_export.rb
+++ b/app/models/compliance_check_message_export.rb
@@ -26,12 +26,14 @@ class ComplianceCheckMessageExport
   end
 
   def to_csv(options = {})
-    CSV.generate(options.slice(:col_sep, :quote_char, :force_quotes)) do |csv|
+    csv_string = CSV.generate(options.slice(:col_sep, :quote_char, :force_quotes)) do |csv|
       csv << column_names
       compliance_check_messages.each do |compliance_check_message|
         csv << [compliance_check_message.compliance_check.criticity, *compliance_check_message.message_attributes.values_at('test_id', 'source_objectid'), options[:server_url] + compliance_check_message.message_attributes['source_object_path'], I18n.t("compliance_check_messages.#{compliance_check_message.message_key}", compliance_check_message.message_attributes.deep_symbolize_keys)]
       end
     end
+    # We add a BOM to indicate we use UTF-8
+    "\uFEFF" + csv_string
   end
 
   def to_zip(temp_file,options = {})
-- 
cgit v1.2.3