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

record into sql table

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 Member Joined: 9/28/2005 Last visit: 12/9/2025 Posts: 2957 Rating: (243)	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 Member Joined: 9/28/2005 Last visit: 12/9/2025 Posts: 2957 Rating: (243)	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 (187 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...