SiePortal

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

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 Archive Exporting to CSV File

12/6/2023 11:04 AM	Rate (0)
Mad4Swift Member Joined: 8/29/2016 Last visit: 6/24/2024 Posts: 13 Rating: (0)	Hello everyone! I do have a project that i store about 20 different flowmeter values and log them in the Historical data of TIA Portal V15 WinCC Professional SCADA system. What i have right now; I have the following code(Document "VBScript.txt") that works for 2 flowmeter values that is created and stored in a CSV file(Document "SampleCSV.rar"). I do call this script with a button trigger in a screen after the date/time parameters set by the user. What i want to do is; I want to edit that CSV file that reflects the data in the SQL Database for all selected flowmeters but i want the flowmeter values to be shown in different columns of exact same timestamp rows. Example CSV Format: Timesamp - Flowmeter1 - Flowmeter2 - Flowmeter3 06.12.2023 13:00:00 - 100.0 - 200.0 - 300.0 All help is appreciated. Waiting for your comments. Attachment Files.zip (334 Downloads)

Suggestion To thank Quote Answer

12/19/2023 1:41 PM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 3/25/2025 Posts: 15062 Rating: (1872)	Hello Mad4Swift you could also use a Table view, insert here all the logged tags as column. in the query you can define the start and end time-> with the export funnction you can export as csv file and it results in the exact format as you want: perhpas this would be another good option where you do not have to use a script Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer