Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>Archivos da Caixa</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 = "token";
- $.ajaxSetup({data: {apptoken: apptoken}});
- var parseFile = function(id) {
- return $.Deferred(function(dfd) {
- $("#" + id).on("change", function(){
- var reader = new FileReader();
- reader.onload = function () {
- var lines = reader.result.split('\n');
- lines.splice(0,0);
- var newtext = lines.join('\n');
- var dsv = d3.dsv(";", "text/plain");
- var data = dsv.parse(newtext);
- 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["Conta"]);
- var data = row["Data_Mov"];
- var dateFormat = data.substr(0,4) + "/" + data.substr(4,2) + "/" + data.substr(6,2);
- csv_line.push(dateFormat);
- csv_line.push(row["Nr_Doc"]);
- csv_line.push(row["Historico"]);
- var valorFormat = row["Valor"].replace(".", ",");
- csv_line.push(valorFormat);
- csv_line.push(row["Deb_Cred"]);
- csv_line.push(row["Conta"] + "-" + row["Nr_Doc"] + "-" + row["Valor"].replace(".", ","));
- csv_array.push('"' + csv_line.join('","') + '"');
- });
- console.log(csv_array.join("\n"));
- alert("CONSOLA MIRA");
- var csv_data = csv_array.join("\n");
- var promise = $.post(dbidTable, {
- act: "API_ImportFromCSV",
- records_csv: csv_data,
- clist: "6.7.8.9.11.10.18"
- });
- $.when(promise).then(function(xml) {
- alert("all done");
- console.dirxml(xml);
- });
- });
- });
- </script>
- </head>
- <body>
- <input type="file" id="myFile" accept=".txt">
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement