cpb_admissions_csv

csv_admissions.txt

file = "#{Rails.root}/tmp/#{Date.current}-cpb-admissions-list.csv"

CSV.open(file, 'w') do |csv|
  csv << ["name", "hubspot_link", "enrollment program", "payment plan", "enrollment status", "salesforce contact link", "admission decision"]
  CpbApplication.all.joins(:user).order(reviewed_at: :desc).each do |cpb_application|
    cpb_presenter = CpbApplicationReviewPresenter.new(cpb_application)
    csv << [cpb_presenter.name, cpb_presenter.hubspot_profile_link, cpb_presenter.enrollment_program, cpb_presenter.enrollment_payment_plan, cpb_presenter.enrollment_status, cpb_presenter.salesforce_contact_link, cpb_application.user.program_admissions.where(program_id: 'community_powered_bootcamp').first.try(:status)]
  end
end


to download:
scp user@staginghostname:remote_file_name local_file_name