Advertisement
valsaned

Add a header to a text without

Nov 4th, 2014
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.32 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>Archivos da itau</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 = "apptoken";
  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.  
  29. var dsv = d3.dsv(";", "text/plain");//creates a parser with ";""
  30. var header = "Data_Mov;Historico;Valor"//creates a header cause text has no header
  31. var data = dsv.parse(header + "\n" + reader.result);
  32. dfd.resolve(data);
  33. };
  34. reader.readAsText(this.files[0]);
  35. });
  36. }).promise();
  37. };
  38.  
  39. parseFile("myFile").then(function(data){
  40.  
  41. var csv_array = [];
  42. console.log(JSON.stringify(data, null, " "));
  43. data.forEach(function(row) {
  44. var csv_line = [];
  45. csv_line.push(row["Data_Mov"]);
  46.  
  47. csv_line.push(row["Historico"]);
  48. csv_line.push(row["Valor"]);
  49. csv_line.push(row["Data_Mov"] + "-" + row["Historico"] + "-" + row["Valor"]);//creates a unique field
  50.  
  51.  
  52. csv_array.push('"' + csv_line.join('","') + '"');
  53. });
  54. console.log(csv_array.join("\n"));
  55. alert("CONSOLA MIRA QUE BONITO");
  56. var csv_data = csv_array.join("\n");
  57. var promise = $.post(dbidTable, {
  58. act: "API_ImportFromCSV",
  59. records_csv: csv_data,
  60. clist: "7.9.11.18" //match Array order with fids of my table
  61.  
  62. });
  63.  
  64. $.when(promise).then(function(xml) {
  65. alert("yesss");
  66. console.dirxml(xml);// log para ver resultado da importacao
  67. });
  68.  
  69. });
  70. });
  71.  
  72.  
  73. </script>
  74. </head>
  75.  
  76. <body>
  77. <input type="file" id="myFile" accept=".txt">
  78. </body>
  79. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement