COM03. OPC UA - Microsoft Excel (OPC UA Client) and PLC (OPC UA Server)

Подписаться 22 тыс.

Просмотров 37 тыс.

50% 1

#OPCUA #Excel #PLC #Siemens #S71200 #UaExpert
COM09. OPC UA - Siemens S7-1500(OPC UA Client) and S7-1200(OPC UA Server) TIA Portal
• COM09. OPC UA - Siemen...
Industrial Automation Data Collection playlist
• Industrial Automation ...
In this video, Microsoft Excel will run as OPC UA Client and a PLC controller Siemens S7-1200 V4.4 is the OPC UA Server. With this Client Libary and this test, you can use Excel to get the data and from PLC (built-in with OPC UA Server) directly.
OPC UA Client Library for Microsoft Excel
support.industry.siemens.com/...
The robot cell picture:
trends.directindustry.com/mot...
COM01.OPC UA - Siemens S7-1200 PLC(OPC UA Server) and UaExpert(OPC UA Client)
• COM01. OPC UA - Siemen...
COM02.OPC UA - Three OPC UA Client Tools For Free
• COM02. OPC UA - Three ...
COM08.OPC UA - BECKHOFF TwinCAT 3 TF6100(OPC UA Server) and UaExpert(OPC UA Client)
• COM08a. OPC UA Beckhof...
COM12.OPC UA - Connect PLC (PID Controller) to Matlab/Simulink (Process Model) via OPC UA
• COM12. OPC UA - Connec...

Наука

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 50

@BallAndBeam 3 года назад

Best tutorials of automation, Thank you!

@electricalautomation 3 года назад

Thanks, Happy New Year!

@leonardonieto4917 Год назад

Thank you very much for your video it was really helpfull greetings from mexico gracias 🙏

@electricalautomation Год назад

Glad it was helpful! Welcome!

@geokou18 4 года назад

you rock man!

@electricalautomation 4 года назад

Thanks!

@user-ov1qg3mp7c 2 года назад

Thanks.👍👍👍

@electricalautomation 2 года назад

Welcome 👍

@claudio1371 2 года назад

Thanks

@electricalautomation 2 года назад

Welcome

@phaman695 Год назад

I appreciate your video very much, can I ask, can I use 2 software on the same computer with the same OPC server (PLC) at the same time?

@electricalautomation Год назад

I think it could be. You could test it.

@ikkusoft 3 года назад

Thank you, Great tutorial. Can u do video on How to Get the values to MsAccess database using this Library?

@electricalautomation 3 года назад

I am not familiar with MsAccess. I would recommend you could use the OPC/OPC UA software running as the interface between PLC and MsAccess.

@genantamtam9364 3 года назад

One question... do i have to create server interface? 10:17 I heard that OPC works even without any server interface. It's enough to check ✔ the "access to OPC" Mark in the tags in DBs. Is that correct?

@electricalautomation 3 года назад

I would recommend the manual "support.industry.siemens.com/cs/document/109775168/opc-ua-server-of-the-s7-1200-cpus?dti=0&lc=en-WW". Also I recommend using server interface if you are using S7-1200. For S7-1500, making OPC in DB and Server interface all workable.

@genantamtam9364 3 года назад

@@electricalautomation Thanks for taking your time and sending me the manual. Yes iam using S7-1500 in TIA Portal v14, in that case i dont need to create "Server interface"? So the Server interface is only a tag talble to external communication right? what if i USE server interface in s7 1500 and put some tags there, will the other tags outside the interface not communicate with external comunnication? Thanks again for the professional way of explaining, i will hit the subscribe button.

@electricalautomation 3 года назад

@@genantamtam9364 For new version S7-1500, using server interface and DB OPA UA check both work. Personally I recommend using a server interface. However, TIA Portal V14 and its supported hardware firmware are a little bit old, I am not quite sure the specific firmware functionalities. how about do a quick try and see which way works better for you. I think both ways workable. Thanks for subscribing.

@nicoladelcolle3833 3 года назад

It is possibile to use this library for a connection client? No plc

@electricalautomation 3 года назад

Yes, This demonstration shows the Excel running as OPC UA Client, it can connect OPC UA Server evenif it is not a PLC.

@satheeshkumaran274 4 года назад

HI, What Liscense should I have to install for the OPC in TIA?

@electricalautomation 4 года назад

As I know, likely there is no physical file needed to be in TIA Portal. The license is a certificate paper. For more specific, I would recommend asking Siemens support.

@satheeshkumaran274 4 года назад

@@electricalautomation Thank you! and I made it work now, Further if I use UDT in the excel at read struct udt tab the values are not updating cyclically.? any suggestions

@electricalautomation 4 года назад

@@satheeshkumaran274 I didn't try UDT in the list before. But if you find once you use the udt, then the communication will not work, then you'd better use a normal way. I recommend that not paying to much time on this try, because it might be the limitation on the current firmware of the CPU. Good luck!

@rangaswamy8604 3 года назад

Please do a video on getting data into OPC UA from RS232 devices.

@electricalautomation 3 года назад

Hello, you could use S7-1200 runs as a bridge, RS232 device S7-1200 + RS232 Signal board, then S7-1200 runs as OPC UA Server to communicate with any other OPC UA Client. S7-1200 PLC can play diversities roles, it is real handy controller with cost effective price.

@revolver2329 Год назад

does it work with any plc or only with s7-1500 ?

@electricalautomation Год назад

Any PLC with OPC UA functions, they should work.

@YMM_Play-Learn 3 года назад

When i complete path for opc.excel but can't getendpoint ,pop up error Please advice

@electricalautomation 3 года назад

Use another OPC UA Client software for a test, e.g. UaExpert. Review every setting shown in the video. Also, turn off the windows firewall and anti-virus software

@joonchoi5419 2 года назад

Hey man, thanks for your awesome tutorial. I've been using this library since 2021 and everything seems to be ok except for a little issue I have. for some reason the excel client seems to crash every 3-4 hours a day and the only work around I have is to manually reconnect to the database. I'm currently using WinCC Unified Runtime v17 (OPC UA Server) running on Windows Server 2022. Have you ever had the same issue like mine? I am using an allen bradley PLC as well and everytime this happens I can see crash logs for Excel.exe and WCCILpah.exe (libAllenBradleyEip.dll_unloaded).

@electricalautomation 2 года назад

Hi Joon, I didn't have this issue. Sorry for hearing this issue. May be you could try to use VB script to 'save as' the excel every 2 hours. also try to increase the RAM of your computer.

@joonchoi5419 2 года назад

@@electricalautomation My RAM's 16GB I think i have enough ram, about saving, I think excel itself does auto saving quite often so I'm not quite sure your suggestion to 'save as' by VBS may help. I can try regardless. Thanks!

@electricalautomation 2 года назад

@@joonchoi5419 Except the software compatibility issue, I am slightly concern the buffer of the Excel is gradually increased. So "save as"/ or close-reopen can alternately release the RAM resources.

@gabbermafia2 2 года назад

i'm having a problem when i want to get the endpoints in excell, i did the command prompt, i enabled the opcua in tia portal and i have made a opcua server. do i need to do anything else?

@electricalautomation 2 года назад

You could use UaExpert OPC UA Client software for a test, then you could have a rough idea if the Excel side has issue or you server side has issue.

@gabbermafia2 2 года назад

@@electricalautomation the problem is in excell saying "microsoft visual basic, class not registered. Runtime error"

@electricalautomation 2 года назад

@@gabbermafia2Pls check the library register from 5:15.

@gabbermafia2 2 года назад

@@electricalautomation Got it solved, i have redone the registration via cmd again and now it works.

@electricalautomation 2 года назад

@@gabbermafia2 Glad it got solved

@joymohadani9366 2 года назад

Pls help it's showing run time error

@electricalautomation 2 года назад

Please make sure the runtime register was done correctly around 8:00

@virlocloic 7 месяцев назад

Hello. I am using an B&R OPC server I know that the certificat for the connection should be tranfert. Is it automatic. By clicking on "get point" I have an error message. Erreur d'exécution '-2147221164 (80040154)':

@electricalautomation 7 месяцев назад

You could use another OPC UA Client for a test to connect your B&R OPC Server. This can validate if the problem comes from client or server.