Advertisement
valsaned

CsV(;) with transformations

Nov 4th, 2014
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.49 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>Archivos da Caixa</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. <script>
  16. //File: myscript.js
  17. $(function(){
  18. var dbid = "dbid";
  19. var dbidTable = "dbidtable";
  20. var apptoken = "token";
  21. $.ajaxSetup({data: {apptoken: apptoken}});
  22.  
  23. var parseFile = function(id) {
  24. return $.Deferred(function(dfd) {
  25. $("#" + id).on("change", function(){
  26. var reader = new FileReader();
  27. reader.onload = function () {
  28. var lines = reader.result.split('\n');
  29. lines.splice(0,0);
  30. var newtext = lines.join('\n');
  31. var dsv = d3.dsv(";", "text/plain");
  32. var data = dsv.parse(newtext);
  33. dfd.resolve(data);
  34. };
  35. reader.readAsText(this.files[0]);
  36. });
  37. }).promise();
  38. };
  39.  
  40. parseFile("myFile").then(function(data){
  41.  
  42. var csv_array = [];
  43. console.log(JSON.stringify(data, null, " "));
  44. data.forEach(function(row) {
  45. var csv_line = [];
  46.  
  47. csv_line.push(row["Conta"]);
  48.  
  49. var data = row["Data_Mov"];
  50. var dateFormat = data.substr(0,4) + "/" + data.substr(4,2) + "/" + data.substr(6,2);
  51. csv_line.push(dateFormat);
  52.  
  53. csv_line.push(row["Nr_Doc"]);
  54.  
  55. csv_line.push(row["Historico"]);
  56.  
  57.  
  58. var valorFormat = row["Valor"].replace(".", ",");
  59. csv_line.push(valorFormat);
  60.  
  61.  
  62. csv_line.push(row["Deb_Cred"]);
  63.  
  64. csv_line.push(row["Conta"] + "-" + row["Nr_Doc"] + "-" + row["Valor"].replace(".", ","));
  65.  
  66.  
  67. csv_array.push('"' + csv_line.join('","') + '"');
  68. });
  69. console.log(csv_array.join("\n"));
  70. alert("CONSOLA MIRA");
  71. var csv_data = csv_array.join("\n");
  72. var promise = $.post(dbidTable, {
  73. act: "API_ImportFromCSV",
  74. records_csv: csv_data,
  75. clist: "6.7.8.9.11.10.18"
  76.  
  77. });
  78.  
  79. $.when(promise).then(function(xml) {
  80. alert("all done");
  81. console.dirxml(xml);
  82. });
  83.  
  84. });
  85. });
  86.  
  87.  
  88. </script>
  89. </head>
  90.  
  91. <body>
  92. <input type="file" id="myFile" accept=".txt">
  93. </body>
  94. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement