Convert Amazon VAT

by musicreader

HTML

<input type="file" id="fileinput" />

<textarea name="csv" rows="20" cols="75" id="data">
</textarea>

<input type="button" value="Convert" onClick="convertData();"/>
<input type="button" value="Download" onClick="downloadFile();"/>

JavaScript

var months=["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"];

function convertData(){
 var indexOrderID=5; //DONE
 var indexDate=12; //DONE
 var indexJurisdiction=22; //DONE
 var indexPriceExcl=25; //DONE
 var indexTaxAmount=24; //DONE
 var indexPriceIncl=23; //DONE
 var indexBTWNummer=43; //DONE
 var indexValuta=15; //DONE
 var indexCity=59;
 var indexState=60;
 var indexCountry=61;
 var indexPostalCode=62;
 var data=document.getElementById('data').value;
 document.getElementById('data').value="";
 var lines=data.split("\n");
 for(var i=1;i<lines.length;i++){
        var line=lines[i];
        var parts=line.split(",");
        if(parts.length<50)
        	continue;
        var jurisdiction=parts[indexJurisdiction].replace(/\"/gi,"");
        var order_id=parts[indexOrderID];
        var srcDate=parts[indexDate].replace(/ UTC/gi,"").replace(/\"/gi,"");
        var srcDateParts=srcDate.split("-");
        var year=srcDateParts[2];  
        var month=months.indexOf(srcDateParts[1])+1;
        var monthString=month;
        if(monthString<10)
        	monthString="0"+month;
        var targetDate=year+"-"+monthString+"-"+srcDateParts[0];
				var btwNummer=parts[indexBTWNummer];
        
        var priceExcl=parts[indexPriceExcl];
        var priceIncl=parts[indexPriceIncl];
 				var taxAmount = parts[indexTaxAmount];
        var valuta=parts[indexValuta];
        var address= parts[indexPostalCode].replace(/\"/gi,"")+" "+parts[indexCity].replace(/\"/gi,"")+" "+parts[indexState].replace(/\"/gi,"")+" "+parts[indexCountry].replace(/\"/gi,"");
        address=address.replace(/\,/gi,"");
        
        if(jurisdiction=="Jurisdiction Name" || priceExcl=="0.00"){
         continue;
        }
        var resultLine=[];
        resultLine[0]=valuta;
        resultLine[1]=year;
        resultLine[2]=month;
        resultLine[3]=targetDate;
        resultLine[4]="77"; //Dagboek EURO
        if(valuta=="GBP")
        	resultLine[4]="75" //Dagboek...