Industry Online Support
Technical Forum
Navigation
Configuration Historical Date WinCC RT Professional
Created by: *PHS* at: 6/17/2012 11:53 PM (11 Replies)
Rating 
Thanks 1
| 6/17/2012 11:53 PM | |
Joined: 9/19/2009 Last visit: 1/18/2025 Posts: 459 Rating:
|
Hello everybody I´m trying to configurate the Historical Date (Data Logs) with Data Base, the question is that I don´t know where is the Date source mode like with WinCC Flexible. I have created a new DSN from ODBC and my Database. When I try to do the configuration of Data Log I can choise between the storage location DataBase/Memory but there isn´t nothing more about this configuration and the name of data source There is another Post here in the forum from Mr.Tweety that said You can select only csv file for location of historical data at WinCC Advanced RT. You can use only a database for location of historical data at WinCC Advanced RT. Then only is possible database with WinCC Advanced RT. Thanks |
|
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
| 6/18/2012 10:50 PM | |
|
Joined: 9/19/2009 Last visit: 1/18/2025 Posts: 459 Rating:
|
Thank you very much for your reply. But still I have a doubt, I don´t know where is the field for Datasource name. If you can see the image attached, maybe I´m wrong because I am comparing Wincc RT with wincc Flexible PC Runtime [IMG]http://i46.tinypic.com/2nm3de1.jpg[/IMG] Thanks again |
Last edited by: JM76 at: 6/18/2012 10:59 PMIf my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
| 6/20/2012 1:37 PM | |
|
Joined: 9/19/2009 Last visit: 1/18/2025 Posts: 459 Rating:
|
Thank you very much for your reply. My english isn´t very good, but I hope this can be understand . When the project is in Runtime, the software create several database, you can see it if you have installed SQL Server Management Studio and all your configuration is here. I though that would be a table with all the records, but I was unable to find it. I have been looking for in every table that is create with Runtime and only I found dbo.Archive where there is the configuration, but any record, the screenshot is attached I Guess that this information have to be some place, still I´m looking for I have been making some proves, when you create a new project, this is in the next path C:\Documents and Settings\Admin\My Documents\Automation\Nameofproject\IM\HMI\{11866113-5404}\D\HMI_ZQ4C for default Here there is four database, so I have open Microsoft SQL Server Management and I have attach... the dababases, but when I have open the tables, there isn´t nothing all is empty, I guess that when the project is open then this load the configuration |
Last edited by: JM76 at: 6/20/2012 5:15 PMLast proves If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
| 6/21/2012 2:30 PM | |
|
Posts: 3037 Rating:
|
Hello, Do you have still any questions to the database? Tweety |
| 6/21/2012 5:57 PM | |
|
Joined: 9/19/2009 Last visit: 1/18/2025 Posts: 459 Rating:
|
Yes, where is all the records stores? Or like said Mr.Pegaia,
But, How I can see after a while this information ... I have made another proves, with the object Wincc Online Table there is the chance to Data export, but I have was unable to find it the file *.csv Thanks for your interest |
|
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
| 6/22/2012 2:45 PM | |
|
Posts: 3037 Rating:
|
Hello, You can use the excel application in this following FAQ. Export of WinCC / CAS Archive Data using the WinCC OLE DB Provider Tweety |
| 6/22/2012 5:01 PM | |
|
Joined: 9/19/2009 Last visit: 1/18/2025 Posts: 459 Rating:
|
Thanks you! |
|
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
Follow us on