// Format CSV data to Entry JSON to update entries
const csvTable = input.csvTable;
let csvColumn=csvTable['tableState']['data'][0];
let fieldUids = Object.values(input.csvTable['tableState']['data'][0]);//Field UIDs
let csvData=csvTable['tableState']['data']
csvData.shift();
let entries=csvData.map(a => a.column4);
const FinalObj=[];
for(let i=0;i<csvData.length;i++){
let formattedArr=[]
let formattedObj={}
for(let k=0;k<fieldUids.length;k++){
let keyID=k+1
formattedObj[fieldUids[k]]=csvData[i]['column'+keyID]
}
FinalObj.push(formattedObj)
}//Formatted Entry JSON from CSV
let createEntries = FinalObj.filter(function (el) {
return el.uid == undefined
}); // Create Entries Objects Array where no UIDs provieded
let localiseEntries = FinalObj.filter(function (el) {
return !(el.uid == undefined)
}); // Update/Localise Entries Objects Array where UIDs provieded
console.log(createEntries,localiseEntries)
return {'createEntries':createEntries,'localiseEntries':localiseEntries};
This Pen doesn't use any external CSS resources.
This Pen doesn't use any external JavaScript resources.