valsaned

Import xml to quickbase transforming to csv

Dec 9th, 2014
215
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.60 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>xmlimportar</title>
  5.  
  6. <script src="http://d3js.org/d3.v3.min.js" charset="utf-8"></script>
  7. <script src="https://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.6.0/underscore-min.js"></script>
  8. <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.1/jquery.js"></script>
  9. <script src="https://cdnjs.cloudflare.com/ajax/libs/accounting.js/0.4.1/accounting.min.js"></script>
  10. <script src="https://cdnjs.cloudflare.com/ajax/libs/datejs/1.0/date.min.js"></script>
  11.  
  12.  
  13.  
  14.  
  15.  
  16.  
  17. <script>
  18. //File: myscript.js
  19. $(function(){
  20. var dbid = "";
  21. var dbidTable = "";
  22. var apptoken = "";
  23. $.ajaxSetup({data: {apptoken: apptoken}});
  24.  
  25.  
  26.  
  27. var parseFile = function(id) {
  28. return $.Deferred(function(dfd) {
  29. $("#" + id).on("change", function(){
  30. var reader = new FileReader();
  31. reader.onload = function () {
  32. dfd.resolve(reader.result);
  33. };
  34. reader.readAsText(this.files[0]);
  35. });
  36. }).promise();
  37. console.log(reader);
  38. };
  39.  
  40. parseFile("myFile").then(function(data){
  41.  
  42. var csv_array = [];
  43. var $xml = $(data);
  44. var tagText = $xml.find("InfNfse").text();
  45. console.log(JSON.stringify(tagText, null, " "));
  46.  
  47. $xml.find("InfNfse").each(function(row) {
  48. var csv_line = [];
  49.  
  50. var CodigoVerificacao = $(this).find('CodigoVerificacao').text();
  51. csv_line.push(CodigoVerificacao);
  52.  
  53. var Dataemissao = $(this).find('DataEmissao').text();
  54. csv_line.push(Dataemissao);
  55.  
  56. var Competencia = $(this).find('Competencia').text();
  57. csv_line.push(Competencia);
  58. //servicos=============================================================================================
  59. var ValorServicos = $(this).find('ValorServicos').text();
  60. csv_line.push(ValorServicos);
  61.  
  62. var ValorDeducoes = $(this).find('ValorDeducoes').text();
  63. csv_line.push(ValorDeducoes);
  64.  
  65. var ValorPis = $(this).find('ValorPis').text();
  66. csv_line.push(ValorPis);
  67.  
  68. var ValorCofins = $(this).find('ValorCofins').text();
  69. csv_line.push(ValorCofins);
  70.  
  71. var ValorInss = $(this).find('ValorInss').text();
  72. csv_line.push(ValorInss);
  73.  
  74. var ValorIr = $(this).find('ValorIr').text();
  75. csv_line.push(ValorIr);
  76.  
  77. var ValorCsll = $(this).find('ValorCsll').text();
  78. csv_line.push(ValorCsll);
  79.  
  80. var IssRetido = $(this).find('IssRetido').text();
  81. csv_line.push(IssRetido);
  82.  
  83. var ValorIss = $(this).find('ValorIss').text();
  84. csv_line.push(ValorIss);
  85.  
  86. var OutrasRetencoes = $(this).find('OutrasRetencoes').text();
  87. csv_line.push(OutrasRetencoes);
  88.  
  89.  
  90. var BaseCalculo = $(this).find('BaseCalculo').text();
  91. csv_line.push(BaseCalculo);
  92.  
  93. var Aliquota = $(this).find('Aliquota').text();
  94. csv_line.push(Aliquota);
  95.  
  96. var ValorLiquidoNfse = $(this).find('ValorLiquidoNfse').text();
  97. csv_line.push(ValorLiquidoNfse);
  98.  
  99. var Cnae = $(this).find('CodigoCnae').text();
  100. csv_line.push(Cnae);
  101.  
  102. var Discriminacao = $(this).find('Discriminacao').text();
  103. csv_line.push(Discriminacao);
  104.  
  105. var Discriminacao = $(this).find('Discriminacao').text();
  106. csv_line.push(Discriminacao);
  107.  
  108.  
  109.  
  110.  
  111. csv_array.push('"' + csv_line.join('","') + '"');
  112. });
  113. console.log(csv_array.join("\n"));
  114.  
  115. //==============================API PARA IMPORTAR CSV
  116.  
  117.  
  118. });
  119. });
  120.  
  121.  
  122. </script>
  123. </head>
  124.  
  125. <body>
  126. <input type="file" id="myFile" accept=".txt">
  127. </body>
  128. </html>
Advertisement
Add Comment
Please, Sign In to add comment