Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Exporting the database to microsoft Excel

Created by: Shamsher at: 11/10/2005 5:38 PM (35 Replies)

Rating (1)

Thanks 1

Result pages:: |; 1 | 2 | 3 | 4; |

36 Entries

Entries per page: 10 | 20 | all

11/10/2005 5:38 PM	Rate (0)
Shamsher Posts: 102 Rating: (3)	Hai All, SOmebody please suggest me how to export the *.db files to Microsoft Excell Regards Shamsher
Shamsher Posts: 102 Rating: (3)
Suggestion To thank Quote Answer

11/10/2005 6:03 PM	Rate (0)
Freddy Experienced Member Joined: 9/13/2005 Last visit: 11/18/2019 Posts: 86 Rating: (10)	Hello Shamsher, two options that allow a data export of WinCC V6 are described in following FAQ: http://support.automation.siemens.com/WW/view/de/19300688
	Best Regards - Mit freundlichem Gruß - yoroshiku onegaisimasu - Sincères salutations -Freddy- [8)]
Suggestion To thank Quote Answer

11/11/2005 10:23 AM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	In addition to the two options mentioned by Freddy, you can also use IndustrialDatabridge - http://www2.automation.siemens.com/hmi/html_76/products/software/wincc_optionen/industrial-data-bridge.htm PM-OPEN-EXPORT - http://www2.automation.siemens.com/hmi/html_76/products/software/wincc_addons/wcc_addon_pm_open_export.htm Ideally you should have an idea of how you want the data presented, what type of data you want to export, how much coding are you prepared to develop, how much money do you wish to spend, do you want ad-hoc reporting, fixed reports or both, etc.. If you ask yourself all these questions then it will help determine which option is right for you.

Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Hit_Formula

11/13/2005 3:41 PM	Rate (0)
Shamsher Posts: 102 Rating: (3)	Hai Freddy and Salma, Thanks for the support that you continue to provide. But what I simply want is to export the data that I have collected in archived tags to microsoft excell Regards Shamsher
Shamsher Posts: 102 Rating: (3)
Suggestion To thank Quote Answer

11/15/2005 9:37 AM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	WinCC V6 uses Microsoft SQL Server and therefore the same rules that apply to SQLServer now apply to WinCC [:(] I am afraid there is no "free" way to export historical data ( - only a "free" way to export current tag values using OPC). If you wish to export WinCC runtime data (Tag Logging or Alarm Logging) then you must purchase one of the above options. The cheapest option is the Connectivity Pack (CP) and will allow you to write a script in WinCC to export the data. I have done this plenty of times and if you buy the CP then I can forward you example scripts.

Suggestion To thank Quote Answer

11/15/2005 4:19 PM	Rate (0)
Ikkezelf Posts: 1084 Rating: (72)	There is another way...free of charge. You can program a VBS script in WinCC runtime that starts ie every 10 minutes. This script looks for DB's that are historical (you could make some settings in the alarm logging that it should create a backup of the database files). When the script find those db's , you could start "DTSrun". Open the SQL Server and look in the Help for DTS / DTSrun utility. What I did: Created a DTS Package in SQL Server that does the following: It attaches the Database files (.mdf & .ldf) that are given to him by global variables when being called for. Then it prcesses all containing data (ie, rermoves not needed columns etc). After this has been completed it writes the data that is left to a Comma Separated File. Think this is all you need, and it's free. Only "thing" is that you are not sure if WinCC keeps all table names etc the same whenever you switch to a new wincc version (but then it's a small change I think). If you need more information, Just leave me a message. Regards.
Ikkezelf Posts: 1084 Rating: (72)
Suggestion To thank Quote Answer

11/15/2005 5:45 PM	Rate (0)
Freddy Experienced Member Joined: 9/13/2005 Last visit: 11/18/2019 Posts: 86 Rating: (10)	[quote user="Ikkezelf"]There is another way...free of charge. You can program a VBS script in WinCC runtime that starts ie every 10 minutes. Ikkezelf, thank you for sharing your experience and solutions with us. My concern is about compressed archive data: How do you handle compressed data? I don't think that this is possible with your script, although DTS is very powerfull [:D] Isn't the compression done by WinCC itself and not by means of SQL functions? At this point I am not sure...[:blush:]
	Last edited by: Freddy at: 11/15/2005 5:46 PM Best Regards - Mit freundlichem Gruß - yoroshiku onegaisimasu - Sincères salutations -Freddy- [8)]
Suggestion To thank Quote Answer

11/18/2005 10:18 AM	Rate (1)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	[quote user="Ikkezelf"]There is another way...free of charge. Nooo ! My understanding, after talks with the WinCC Product Managers, is that ANY access to the SQL Server databases is covered by a licence. Microsoft demand this and so Siemens have no real choice but to enforce it. At a minimum you must buy the Connectivity Pack (and WinCC CALs for remote machines) to have a legal and fully licenced system. Yes you can technically access the databases without a licenced option BUT doing this will put you in violation of the licencing agreement. Your solution works but it is neither supported not legal (to use a strong term ! ) Sorry to keep going on about this. It is a shame that it is not more clearly stated in the WinCC literature.
	Last edited by: salma at: 11/18/2005 10:19 AM
Suggestion To thank Quote Answer

11/22/2005 9:06 AM	Rate (0)
Ikkezelf Posts: 1084 Rating: (72)	Hi, Not sure if the data is compressed in this version, but I use a queary to access the data. That query is also used by wincc. It is actually a View. "AlgViewEnu" or something like that. Salma: If I want to keep this solution, what additional licenses do I need to purchase to keep it legal? Thanks in advance.
Ikkezelf Posts: 1084 Rating: (72)
Suggestion To thank Quote Answer

11/22/2005 1:25 PM	Rate (0)
Reuben Posts: 70 Rating: (13)	Hi ANY access to the WinCC MS SQL Server instance requires a Client Access License (CAL), be it from WinCC, Excel, an ASP web page or some custom VB/Delphi application. WinCC internally is licenced to do this, and the Connectivity Pack includes a CAL for MS SQL Server. I think if you buy a SQL Server CAL from Microsoft for each PC that accesses the SQL server (assuming you do not buy the Connectivity Pack) then it should be legal. In order to access the compressed archive data however, I really think you need the Connectivity Pack - this gives an OLE DB provider that you can query with SQL, and it will handle the de-compression of the data. Reuben
Reuben Posts: 70 Rating: (13)
Suggestion To thank Quote Answer

Result pages:: |; 1 | 2 | 3 | 4; |

36 Entries

Entries per page: 10 | 20 | all

|

Share this page:

Share this page on...

Follow us on