Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>Archivos da itau</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 = "dbid";
- var dbidTable = "dbidtable";
- var apptoken = "apptoken";
- $.ajaxSetup({data: {apptoken: apptoken}});
- var parseFile = function(id) {
- return $.Deferred(function(dfd) {
- $("#" + id).on("change", function(){
- var reader = new FileReader();
- reader.onload = function () {
- var dsv = d3.dsv(";", "text/plain");//creates a parser with ";""
- var header = "Data_Mov;Historico;Valor"//creates a header cause text has no header
- var data = dsv.parse(header + "\n" + reader.result);
- dfd.resolve(data);
- };
- reader.readAsText(this.files[0]);
- });
- }).promise();
- };
- parseFile("myFile").then(function(data){
- var csv_array = [];
- console.log(JSON.stringify(data, null, " "));
- data.forEach(function(row) {
- var csv_line = [];
- csv_line.push(row["Data_Mov"]);
- csv_line.push(row["Historico"]);
- csv_line.push(row["Valor"]);
- csv_line.push(row["Data_Mov"] + "-" + row["Historico"] + "-" + row["Valor"]);//creates a unique field
- csv_array.push('"' + csv_line.join('","') + '"');
- });
- console.log(csv_array.join("\n"));
- alert("CONSOLA MIRA QUE BONITO");
- var csv_data = csv_array.join("\n");
- var promise = $.post(dbidTable, {
- act: "API_ImportFromCSV",
- records_csv: csv_data,
- clist: "7.9.11.18" //match Array order with fids of my table
- });
- $.when(promise).then(function(xml) {
- alert("yesss");
- console.dirxml(xml);// log para ver resultado da importacao
- });
- });
- });
- </script>
- </head>
- <body>
- <input type="file" id="myFile" accept=".txt">
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement