Industry Online Support
Technical Forum
Navigation
WinCC Felixible Smart Access SOAP example GetValue call error
Created by: erblaha at: 8/14/2008 11:57 PM (5 Replies)
Rating 
Thanks 0
6 Entries
| 8/15/2008 9:47 AM | |
Joined: 10/19/2005 Last visit: 11/30/2020 Posts: 1611 Rating:
|
Hi, did you use the "original" template from the FAQ? did you have adjusted somethink? I also have use the excel template and its work fine. I have tested it with three Tags. In the Attachment you will find my template. I have serched in "Google" for the fault number, but i did not find anythink. AttachmentExcel_Soap.zip (1024 Downloads) |
| 1/18/2012 5:13 PM | |
|
Posts: 5 Rating:
|
I know this is an old thread, but I've been trying to get the SOAP interface working with Excel 2007 on Windows 7 and the examples don't work. In fact in the current WinCC V11 SP2 manual it states that Windows 7 is not supported. It appears that Microsoft has dropped support for the SoapClient library in Windows 7. You may still be able to get the SoapClient30 to work on Windows 7 32bit with Office 2007, but it appears that the MSSOAP30.dll file will not load on Windows 7 64bit at all and is not supported by Microsoft going forward. Microsoft wants you to use the Visual Studio Web Services to build Excel workbooks to consume services like SOAP. This isn't really practical unless you have Visual Studio Professional and know how to program. I've managed to build a "work around" of sorts using the XML library which is still supported by Microsoft. So it still accessesthe SOAP WebService of WinCC Advanced by building the XML SOAP call manually instead of automatically with the nice soap library that MS dropped. It's not perfect, I haven't tested it on Windows 64bit yet, but it should be fine. I'll try it out later this week on 64bit. I've only implemented the GetValue function, but extending this with the SetValue should be fairly simple for someone who has done VBA before. Here is a macro enabled Excel 2007 file with the code built into it. You simply fill in the name of the tag you want to pull from WinCC, enter the ip address or name of the HMI Server at the top and press the update button. The sheet will also automatically update the tag list when you load it. You can type "ignore" into lines that you don't want updated and type "end" into the last field to stop the polling script. I haven't put in any error trapping, so use at your own risk. I'm assuming that the SOAP envelope is the same for all WinCC SmartAccess servers (which is a pretty big assumption, so it may break quickly). AttachmentC:\WinCC_SOAP_Demo_Excel_2007 rev2.zip (1095 Downloads) |
Last edited by: Nic_ at: 11/22/2012 3:09 PMI updated the excel sheet to include the setvalue function. I tested it with Excel 2007 and it works fine. I have not tested the SetValue on windows 7, but I have no reason to believe it won''t work since the rest of it did work on Win 7. The only difference for the setvalue is that the tag and value aren''t surrounded by extra quotes. (because somehow that make sense...) |
|
| 12/4/2017 1:11 AM | |
Joined: 3/1/2007 Last visit: 10/17/2024 Posts: 4 Rating:
|
Hello Try SOAP 1.0 and double the " like ""var"" that! |
Follow us on