data_export.html 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209
  1. <!DOCTYPE html>
  2. <html lang="en" xml:lang="en">
  3. <head>
  4. <title>Data Export (CSV)</title>
  5. <meta charset="UTF-8"/>
  6. <style>
  7. h1 {font-size: 2em;}
  8. h2 {font-size: 1.5em; margin-block-start: 0.0em; margin-block-end: 0.2em;}
  9. h3 {font-size: 1.2em;}
  10. p {font-size: 1em;}
  11. input[type=number] {
  12. width: 138px;
  13. padding: 10px 5px;
  14. display: inline-block;
  15. border: 1px solid #ccc;
  16. font-size: 16px;
  17. }
  18. .button {
  19. padding: 5px 10px;
  20. width: 300px;
  21. font-size: 16px;
  22. }
  23. </style>
  24. <script type="text/javascript" src="common.js?v=$COMMIT_HASH"></script>
  25. <script type="text/javascript" src="jszip.min.js?v=$COMMIT_HASH"></script>
  26. <script type="text/javascript" src="FileSaver.min.js?v=$COMMIT_HASH"></script>
  27. <script type="text/javascript">var domainname = getDomainname();</script>
  28. </head>
  29. <body style="font-family: arial; padding: 0px 10px;">
  30. <h2>Data Export(CSV)</h2>
  31. <p>With the following action the <a href="/fileserver/log/data/" target="_self">data</a> folder on the SD-card gets zipped and provided as a download.</p>
  32. <button class="button" id="startExportData" type="button" onclick="startExportData()">Export Data</button>
  33. <p></p>
  34. <hr>
  35. <p id=progress></p>
  36. <script type="text/javascript">
  37. function startExportData() {
  38. document.getElementById("progress").innerHTML = "Creating Export Data...<br>\n";
  39. // Get hostname
  40. try {
  41. var xhttp = new XMLHttpRequest();
  42. xhttp.open("GET", domainname + "/info?type=Hostname", false);
  43. xhttp.send();
  44. hostname = xhttp.responseText;
  45. }
  46. catch(err) {
  47. setStatus("<span style=\"color: red\">Failed to fetch hostname: " + err.message + "!</span>");
  48. return;
  49. }
  50. // get date/time
  51. var dateTime = new Date().toJSON().slice(0,10) + "_" + new Date().toJSON().slice(11,19).replaceAll(":", "-");
  52. zipFilename = hostname + "_" + dateTime + "_csv" + ".zip";
  53. console.log(zipFilename);
  54. // Get files list
  55. setStatus("Fetching File List...");
  56. try {
  57. var xhttp = new XMLHttpRequest();
  58. xhttp.open("GET", domainname + "/fileserver/log/data/", false);
  59. xhttp.send();
  60. var parser = new DOMParser();
  61. var content = parser.parseFromString(xhttp.responseText, 'text/html');
  62. }
  63. catch(err) {
  64. setStatus("Failed to fetch files list: " + err.message);
  65. return;
  66. }
  67. const list = content.querySelectorAll("a");
  68. var urls = [];
  69. for (a of list) {
  70. url = a.getAttribute("href");
  71. urls.push(domainname + url);
  72. }
  73. // Pack as zip and download
  74. try {
  75. startExportZip(urls, zipFilename);
  76. }
  77. catch(err) {
  78. setStatus("<span style=\"color: red\">Failed to zip files: " + err.message + "!</span>");
  79. return;
  80. }
  81. }
  82. function fetchFiles(urls, filesData, index, retry, zipFilename) {
  83. url = urls[index];
  84. if (retry == 0) {
  85. setStatus("&nbsp;- " + getFilenameFromUrl(urls[index]) + " (" + (index+1) + "/" + urls.length + ")...");
  86. }
  87. else {
  88. setStatus("<span style=\"color: gray\">&nbsp;&nbsp;&nbsp;Retrying (" + retry + ")...</span>");
  89. }
  90. const xhr = new XMLHttpRequest();
  91. xhr.open('GET', url, true);
  92. xhr.responseType = "blob";
  93. if (retry == 0) { // Short timeout on first retry
  94. xhr.timeout = 2000; // time in milliseconds
  95. }
  96. else if (retry == 1) { // longer timeout
  97. xhr.timeout = 5000;
  98. }
  99. else if (retry == 2) { // longer timeout
  100. xhr.timeout = 10000;
  101. }
  102. else if (retry == 3) { // longer timeout
  103. xhr.timeout = 20000;
  104. }
  105. else { // very long timeout
  106. xhr.timeout = 30000;
  107. }
  108. xhr.onload = () => { // Request finished
  109. //console.log(url + " done");
  110. filesData[index] = xhr.response;
  111. if (index == urls.length - 1) {
  112. setStatus("Fetched all files");
  113. generateZipFile(urls, filesData, zipFilename);
  114. return;
  115. }
  116. else { // Next file
  117. fetchFiles(urls, filesData, index+1, 0, zipFilename);
  118. }
  119. };
  120. xhr.onprogress = (e) => { // XMLHttpRequest progress ... extend timeout
  121. xhr.timeout = xhr.timeout + 500;
  122. };
  123. xhr.onerror = (e) => { // XMLHttpRequest error loading
  124. console.log("Error on fetching " + url + "!");
  125. if (retry > 5) {
  126. setStatus("<span style=\"color: red\">Data Export failed, please restart the device and try again!</span>");
  127. }
  128. else {
  129. fetchFiles(urls, filesData, index, retry+1, zipFilename);
  130. }
  131. };
  132. xhr.ontimeout = (e) => { // XMLHttpRequest timed out
  133. console.log("Timeout on fetching " + url + "!");
  134. if (retry > 5) {
  135. setStatus("<span style=\"color: red\">Data Export failed, please restart the device and try again!</span>");
  136. }
  137. else {
  138. fetchFiles(urls, filesData, index, retry+1, zipFilename);
  139. }
  140. };
  141. xhr.send(null);
  142. }
  143. function generateZipFile(urls, filesData, zipFilename) {
  144. setStatus("Creating Zip File...");
  145. var zip = new JSZip();
  146. for (var i = 0; i < urls.length; i++) {
  147. zip.file(getFilenameFromUrl(urls[i]), filesData[i]);
  148. }
  149. zip.generateAsync({type:"blob"})
  150. .then(function(content) {
  151. saveAs(content, zipFilename);
  152. });
  153. setStatus("Data Export completed");
  154. }
  155. const startExportZip = (urls, zipFilename) => {
  156. if(!urls) { return; }
  157. console.log(urls);
  158. urlIndex = 0;
  159. setStatus("Fetching files...");
  160. fetchFiles(urls, [], 0, 0, zipFilename);
  161. };
  162. function setStatus(status) {
  163. console.log(status);
  164. document.getElementById("progress").innerHTML += status + "<br>\n";
  165. }
  166. function getFilenameFromUrl(url) {
  167. return filename = url.substring(url.lastIndexOf('/')+1);
  168. }
  169. </script>
  170. </body>
  171. </html>