Navigation
Export Datalog to CSV (TIA19 MTP19 Unified Comfort)
Created by: Damian-CIM at: 4/25/2025 9:42 AM (4 Replies)
Rating 
Thanks 0
5 Entries
| 4/25/2025 9:42 AM | |
Joined: 6/24/2024 Last visit: 6/24/2025 Posts: 12 Rating:
|
Hi, I have an issue with recording my Data log into a csv. The values come out as 'null'. I attached some images in the .zip of how the tag is configured. Current script: // File path (adjust for your environment) let fileName = "C:\\Users\\Public\\TagLogFile.csv"; // Get current time let end = new Date(); // Subtract one hour to get the start time let start = new Date(end.getTime() - 60 * 60 * 1000); // CSV formatting let delimiter = ","; let csvData = "Name" + delimiter + "Timestamp" + delimiter + "Value" + delimiter + "Quality\n"; // Get the logged tag let tag1 = HMIRuntime.TagLogging.LoggedTags("Test_Trend_Log"); HMIRuntime.Trace("Tag Name : " + tag1.Name); // Read logged values within the last hour let tagValue = tag1.Read(start, end, 0); tagValue.then((loggedTagResult) => { let error = loggedTagResult.Error; let tagArray = loggedTagResult.Values; for (let loggedTag of tagArray){ csvData += tag1.Name + delimiter + loggedTag.TimeStamp + delimiter + loggedTag.Value + delimiter + loggedTag.Quality + "\n"; } HMIRuntime.FileSystem.WriteFile(fileName, csvData, "utf8").then( function() { HMIRuntime.Trace("Write file finished successfully"); }).catch(function(errCode) { HMIRuntime.Trace("Write failed, Error: " + errCode); }); }).catch((errCode) => { HMIRuntime.Trace("Read failed, Error: " + errCode); });
AttachmentExportDataLog.zip (142 Downloads) |
Follow us on