Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

record into sql table

Created by: aguere at: 9/5/2010 6:16 PM (4 Replies)

Rating (0)

Thanks 0

5 Entries

9/5/2010 6:16 PM	Rate (0)
aguere Posts: 48 Rating: (1)	Hello, I need to record into sql table every day at 24:00 . There are abou 30 tags , and after i use excel to take from sql. I don,t know how it,s script in wincc flexible for this. Somebody help me abou it. Where I can found similar script etc... Thank you very much. aguere
aguere Posts: 48 Rating: (1)
Suggestion To thank Quote Answer

9/9/2010 9:42 AM	Rate (0)
Darius Platinum Expert Joined: 9/28/2005 Last visit: 8/27/2024 Posts: 2957 Rating: (242)	Hello, Create script that triggers data logging only once and run this script in scheduler. Configure shceduler job to run daily at 24:00:00
	Best regards, Darius
Suggestion To thank Quote Answer

9/9/2010 9:49 PM	Rate (0)
aguere Posts: 48 Rating: (1)	Thank you very much, you know where I can found some sample about it,s. It,s difficult to me start.
aguere Posts: 48 Rating: (1)
Suggestion To thank Quote Answer

9/10/2010 10:18 AM	Rate (0)
Darius Platinum Expert Joined: 9/28/2005 Last visit: 8/27/2024 Posts: 2957 Rating: (242)	Hello, I'm too lazy to search for manuals. You can allways do it yourself :) I've created simple project for you with only one tag wich is logged every hour at minute 00. Look at the project and I hope it will be clear to you what I did. Attachment New Folder.zip (99 Downloads)
	Best regards, Darius
Suggestion To thank Quote Answer

9/11/2010 12:49 AM	Rate (0)
aguere Posts: 48 Rating: (1)	Thank you very much for your help, I try this sample, but I don,t know how or where put the value every hour , I see thr file, record for 500 time , It,s possible to do with script that, when are 00:00 take the value of tag and store into table sql. I want to do every 00:00 store 100 tags into table sql, next day the client can see in excel this value, for example. There are some counter of water in the factory, you can show in screen winccflex the liter are counted, but in the excel I would like to put every 00:00 and excel put different beetwen days. Foy client is easier work with excel. Sample excel: count 1 count 2 count 3............ 9-9-2010 1234 2221 3333 10-9-2010 126627893444 In the next sheet show Consumition date count 1 count 2 count 3...... 10-9-2010 32 568 111 Thank you very much Perhaps not it,s possible to do in wincc flexible
aguere Posts: 48 Rating: (1)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on