data_export.html 6.0 KB

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