Skip to Content

SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

WinCC Unified Export to CSV Javascript not working

Created by: Ganners96 at: 6/6/2025 1:26 PM (14 Replies)

Rating (0)

Thanks 1

Result pages:: |; 1 | 2; |

15 Entries

Entries per page: 10 | all

6/6/2025 1:26 PM	Rate (0)
Ganners96 Member Joined: 10/14/2021 Last visit: 12/11/2025 Posts: 8 Rating: (0)	I have been trying to export logged tags to a CSV file. I tried the given snippet in TIA but it didnt work so ive adapted it for debugging. At the moment i get a CSV where i want called what i want. However the data in it is only one row with a timestamp of 01/01/1601 with a value of null. Here is the code: export function ExportLogAsCSV(parameter1, parameter2) { // Please note, the format of a file path is device and operating system specific. // You need to adapt the given path to your environment. // Example for a Unified Comfort device (Linux OS): /home/user1/data.dat // Example for a Unified PC-based device (MS Windows OS): C:\Users\Public\data.dat let timeStamp = new Date().toLocaleDateString().replace(/[/]/g, "_"); let tag1 = Tags("iDB10000_UserCode_ShopNumber"); let tagValue1 = tag1.Read(); let tag2 = Tags("iDB10000_UserCode_SerialNumber"); let tagValue2 = tag2.Read(); let tag3 = Tags("iDB10000_UserCode_OperatorInitials"); let tagValue3 = tag3.Read(); let path = "/media/simatic/X62/LoggedTags" + timeStamp + "_Shop Order" + tagValue1 + "_Serial Number" + tagValue2 + "_Operator Initials" + tagValue3 + ".csv"; let delimiter = ','; let start = new Date(); let end = new Date(start.getTime() - 60601000); HMIRuntime.Trace("**********" + start); HMIRuntime.Trace("***********" + end); let tag = HMIRuntime.TagLogging.LoggedTags("TopTemp:Top_Plate_Temp"); let tagValue = tag.Read(start, end, 0); let csvData = "Timestamp:" + delimiter + "Tag Name:" + delimiter + "Value:" + "\n"; tagValue.then((loggedTagResult) => { let error = loggedTagResult.Error; let tagArray = loggedTagResult.Values; for (let loggedTag of tagArray){ csvData += new Date(loggedTag.TimeStamp) + delimiter + "Top Temp" + delimiter + loggedTag.Value + delimiter + "\n"; } HMIRuntime.FileSystem.WriteFile(path, 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); }); } Any help at what ive done wrong would be great. Attachment Screenshot 2025-06-06 142554.png (320 Downloads)

Suggestion To thank Quote Answer

6/6/2025 5:46 PM	Rate (0)
Stefan Arcularius Platinum Expert Joined: 1/21/2013 Last visit: 1/16/2026 Posts: 4405 Rating: (653)	Hi Ganners96, Your start time comes after your end time. This will not work. Create your end time with the new Date() function, then calculate the start time. Kind regards Stefan

Suggestion To thank Quote Answer

6/9/2025 10:07 AM	Rate (0)
Ganners96 Member Joined: 10/14/2021 Last visit: 12/11/2025 Posts: 8 Rating: (0)	Hi Stefan, I have tried this as it didn't make sense to me either but its how all other examples have done it. Changing this around does not make a difference though.

Suggestion To thank Quote Answer

6/10/2025 5:02 PM	Rate (0)
AutoGen_7461951 Joined: 6/8/2023 Last visit: 11/15/2025 Posts: 8 Rating: (0)	Is the write path /media/simatic/X62/ accessible and has write permissions?
	Last edited by: AutoGen_7461951 at: 06/24/2025 13:42:19 Last edited by: AutoGen_7461951 at: 09/23/2025 20:23:17
Suggestion To thank Quote Answer

6/10/2025 6:25 PM	Rate (0)
Stefan Arcularius Platinum Expert Joined: 1/21/2013 Last visit: 1/16/2026 Posts: 4405 Rating: (653)	Hi Ganners96, Your script contains multiple calls to the "Trace" method. Use these calls to identify where your script is failing. Which trace messages are visible in the TraceViewer? Adding more "Trace" calls may help you determine the exact location of the error. Kind regards Stefan

Suggestion To thank Quote Answer

6/11/2025 8:26 AM	Rate (0)
Ganners96 Member Joined: 10/14/2021 Last visit: 12/11/2025 Posts: 8 Rating: (0)	Hi AutoGen, Yes i'm already writing the files to this address its just the data in them that isn't right.

Suggestion To thank Quote Answer

6/11/2025 8:52 AM	Rate (0)
Stefan Arcularius Platinum Expert Joined: 1/21/2013 Last visit: 1/16/2026 Posts: 4405 Rating: (653)	Hi Ganners96, Ganners96 Hi AutoGen, Yes i'm already writing the files to this address its just the data in them that isn't right. Could you describe the contents of the file? Kind regards Stefan

Suggestion To thank Quote Answer

6/11/2025 9:14 AM	Rate (0)
Ganners96 Member Joined: 10/14/2021 Last visit: 12/11/2025 Posts: 8 Rating: (0)	Hi Stefan, I've been working on the code so a new code and the file it creates is attached. Attachment 110625.zip (266 Downloads)

Suggestion To thank Quote Answer

6/11/2025 10:03 AM	Rate (0)
Stefan Arcularius Platinum Expert Joined: 1/21/2013 Last visit: 1/16/2026 Posts: 4405 Rating: (653)	Hi Ganners96, It appears that you are only receiving the default values for each tag you requested. This indicates that no tags were logged within the specified time range. The default and recommended logging mode is "on change." If a tag does not change within the specified time range, no logging entry will be created. Kind regards Stefan

Suggestion To thank Quote Answer

6/11/2025 11:12 AM	Rate (0)
Ganners96 Member Joined: 10/14/2021 Last visit: 12/11/2025 Posts: 8 Rating: (0)	Hi Stefan, The logging for these values was cyclic at 1s. I changed them to on change and the time of csv range to 1 min as I can see in the chart on the HMI that I have logging data for that time. However still no change.

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on