Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>xmlimportar</title>
- <script src="http://d3js.org/d3.v3.min.js" charset="utf-8"></script>
- <script src="https://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.6.0/underscore-min.js"></script>
- <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.1/jquery.js"></script>
- <script src="https://cdnjs.cloudflare.com/ajax/libs/accounting.js/0.4.1/accounting.min.js"></script>
- <script src="https://cdnjs.cloudflare.com/ajax/libs/datejs/1.0/date.min.js"></script>
- <script>
- //File: myscript.js
- $(function(){
- var dbid = "";
- var dbidTable = "";
- var apptoken = "";
- $.ajaxSetup({data: {apptoken: apptoken}});
- var parseFile = function(id) {
- return $.Deferred(function(dfd) {
- $("#" + id).on("change", function(){
- var reader = new FileReader();
- reader.onload = function () {
- dfd.resolve(reader.result);
- };
- reader.readAsText(this.files[0]);
- });
- }).promise();
- console.log(reader);
- };
- parseFile("myFile").then(function(data){
- var csv_array = [];
- var $xml = $(data);
- var tagText = $xml.find("InfNfse").text();
- console.log(JSON.stringify(tagText, null, " "));
- $xml.find("InfNfse").each(function(row) {
- var csv_line = [];
- var CodigoVerificacao = $(this).find('CodigoVerificacao').text();
- csv_line.push(CodigoVerificacao);
- var Dataemissao = $(this).find('DataEmissao').text();
- csv_line.push(Dataemissao);
- var Competencia = $(this).find('Competencia').text();
- csv_line.push(Competencia);
- //servicos=============================================================================================
- var ValorServicos = $(this).find('ValorServicos').text();
- csv_line.push(ValorServicos);
- var ValorDeducoes = $(this).find('ValorDeducoes').text();
- csv_line.push(ValorDeducoes);
- var ValorPis = $(this).find('ValorPis').text();
- csv_line.push(ValorPis);
- var ValorCofins = $(this).find('ValorCofins').text();
- csv_line.push(ValorCofins);
- var ValorInss = $(this).find('ValorInss').text();
- csv_line.push(ValorInss);
- var ValorIr = $(this).find('ValorIr').text();
- csv_line.push(ValorIr);
- var ValorCsll = $(this).find('ValorCsll').text();
- csv_line.push(ValorCsll);
- var IssRetido = $(this).find('IssRetido').text();
- csv_line.push(IssRetido);
- var ValorIss = $(this).find('ValorIss').text();
- csv_line.push(ValorIss);
- var OutrasRetencoes = $(this).find('OutrasRetencoes').text();
- csv_line.push(OutrasRetencoes);
- var BaseCalculo = $(this).find('BaseCalculo').text();
- csv_line.push(BaseCalculo);
- var Aliquota = $(this).find('Aliquota').text();
- csv_line.push(Aliquota);
- var ValorLiquidoNfse = $(this).find('ValorLiquidoNfse').text();
- csv_line.push(ValorLiquidoNfse);
- var Cnae = $(this).find('CodigoCnae').text();
- csv_line.push(Cnae);
- var Discriminacao = $(this).find('Discriminacao').text();
- csv_line.push(Discriminacao);
- var Discriminacao = $(this).find('Discriminacao').text();
- csv_line.push(Discriminacao);
- csv_array.push('"' + csv_line.join('","') + '"');
- });
- console.log(csv_array.join("\n"));
- //==============================API PARA IMPORTAR CSV
- });
- });
- </script>
- </head>
- <body>
- <input type="file" id="myFile" accept=".txt">
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment