Skip to Content

Register Login

工业业务领域支持中心

Technical Forum

Navigation

How to write data from SQL to User Archive Wincc V7?

Created by: DIAN113 at: 3/26/2024 3:16 AM (2 Replies)

Rating (0)

Thanks 0

3 Entries

3/26/2024 3:16 AM	Rate (0)
DIAN113 Member Joined: 2/24/2022 Last visit: 7/2/2024 Posts: 1 Rating: (0)	nicopoi Thank's for responding. You can put data in user archive wincc using vbs script ??? If i have to put a vbs script for reading data, put into wincc internal variable and then read internal variable and put in user archive using c script... little bit tricky It's the preconize method by siemens ? I would like to know wich are the preconization by siemens. Maybe i have to ask to support request Hi nicopoi Are you complete this project, can you guide me how to write data from SQL to User Archive Wincc V7 ------------------------------------------------------------------------------------------ Split from Insert data in User Archive.
	Last edited by: DIAN113 at: 03/26/2024 03:18:06 Last edited by: Jen_Moderator at: 03/26/2024 12:21:47 New subject after splitting
Suggestion To thank Quote Answer

4/15/2024 8:56 AM	Rate (0)
Fess Advanced Member Joined: 1/22/2009 Last visit: 10/15/2024 Posts: 116 Rating: (17)	Hallo DIAN113, if you don't use the redundancy you can write the data into the UserArchive via VBS like you would it do if write it to an other Database. If you use the redundancy, you can use the VBS, too, but this recordset will not be synchronized. Solutions by the redundancy with synchronisation of the Recordsets: 1. you can read the data, save it in the Tags, they are connected to the columns/fields of UserArchive, and use Control Tags, to write the data into UserArchive. 2. you write the data into internal tags, set a trigger tag and write the data into User Archive via C-Script. Note: if you have a lot of fields in your UserArchive second method is faster BR, Fess.

Suggestion To thank Quote Answer

4/17/2024 11:08 AM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 10/31/2024 Posts: 14079 Rating: (1764)	Hello DIAN113 where do you get the data from? additional to the already posted suggestions you can also work with files to exchange data. Its a little bit oldschool but would also work. Perhaps there is an easy way of exportinig the data to csv file or similar from your data source. in WinCC you can also read out the files by script and use CStandard interface for Userarchive. OPC would also be an option but in WinCC the standard interface for writing data to Userarchive is the C Interface Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on