Output csv file with Shift JIS using csb gem

README: Output csv file with Shift JIS.md

Output csv file with Shift JIS using csb gem

Requirements

• nkf
• csb gem
  • https://github.com/aki77/csb

reports_controller.rb

# app/controllers/reports_controller.rb
require 'nkf'

class ReportsController < ApplicationController
  def index
    @reports = Report.preload(:categories)

    # for csv
    @version = Time.now.strftime("%Y%m%d%H%M%S")
    @filename = "reports-#{@version}.csv"

    respond_to do |format|
      format.csv do
        csv = Csb::Builder.new(items: @reports)
        csv.cols.copy!(Report.csb_cols)
        csv_data = csv.build

        send_data(NKF::nkf('-Ws', csv_data), filename: @filename, type: 'application/x-csv;charset=Shift_JIS')
      end
    end
  end
end