vue.config.js

csvHeaders = JSON.parse(`{
  "id": {
    "type": "integer",
    "label": "id"
  },
  "challenge": {
    "type": "string",
    "label": "Challenge"
  },
  "title": {
    "type": "string",
    "label": "Idea Title"
  },
  "url": {
    "type": "string",
    "label": "Idea URL"
  },
  "assessor": {
    "type": "string",
    "label": "Assessor"
  },
  "triplet_id": {
    "type": "string",
    "label": "triplet_id"
  },
  "proposal_id": {
    "type": "integer",
    "label": "proposal_id"
  },
  "challenge_id": {
    "type": "integer",
    "label": "challenge_id"
  },
  "impact_note": {
    "type": "string",
    "label": "Impact / Alignment Note"
  },
  "impact_rating": {
    "type": "integer",
    "label": "Impact / Alignment Rating"
  },
  "feasibility_note": {
    "type": "string",
    "label": "Feasibility Note"
  },
  "feasibility_rating": {
    "type": "integer",
    "label": "Feasibility Rating"
  },
  "auditability_note": {
    "type": "string",
    "label": "Auditability Note"
  },
  "auditability_rating": {
    "type": "integer",
    "label": "Auditability Rating"
  },
  "proposer_mark": {
    "type": "boolean",
    "label": "Proposer Mark"
  },
  "proposer_rationale": {
    "type": "string",
    "label": "Proposer Filtered Out rationale or Feedback"
  },
  "excellent": {
    "type": "boolean",
    "label": "Excellent"
  },
  "good": {
    "type": "boolean",
    "label": "Good"
  },
  "filtered_out": {
    "type": "boolean",
    "label": "Filtered Out"
  },
  "vpa_feedback": {
    "type": "string",
    "label": "vPA Feedback"
  }
}`);

const transformData = function (value, col) {
  if (csvHeaders[col]) {
    if (csvHeaders[col].type === 'integer') {
      return parseInt(value)
    }
    if (csvHeaders[col].type === 'string') {
      return value
    }
  } else {
    return value
  }
};
const transformHeader = function (header) {
  const newHeaders = {}
  Object.keys(csvHeaders).forEach((h) => {
    newHeaders[csvHeaders[h].label] = h
  })
  if (newHeaders[header]) {
    return newHeaders[header]
  }
  return header
};


let publicPath = ''
if (process.env.APP_ENV === 'production') {
  publicPath = '/vpa-tool/'
}
if (process.env.APP_ENV === 'staging') {
  publicPath = '/'
}

module.exports = {
  publicPath: publicPath,
  chainWebpack: config => {
    config
      .module
      .rule("csv")
      .test(/\.csv$/)
      .use("csv-loader")
      .loader("csv-loader")
      .options({
        dynamicTyping: true,
        header: true,
        skipEmptyLines: true,
        //transform: transformData,
        transformHeader: transformHeader,
      })
      .end();
  }
}