Search the Community

Showing results for tags 'Excel OPC Micrologix Value'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Found 99 results

  1. Hey everyone, I'm new to programming PLCs and I've run into a problem. I have a Micrologix 1400 Series B PLC, and for the past month, I've been using a free trial of RSLogix 500 Starter. But now, the trial ran out, and so I bought a license for "RSLogix Micro Starter". The problem is that when I downloaded my updated file to the PLC for the first time with micro starter, the PLC's outputs don't work anymore. I checked the PLC screen and the inputs from the HMI screen are getting recognized, but the inputs from the physical sensors are not. Also, none of the outputs are being activated on the PLC at all, which I can tell by looking at the I/O status on the PLC screen itself. I then uploaded a new test program, where you press a button and a light turns on, but that doesn't work either. I haven't changed any of the physical wiring, only thing I've changed is that I'm using RSLogix Micro Starter as opposed to RSLogix 500 Starter. I spoke to a Rockwell technician about this and he said that there shouldn't be any problem, as I haven't done anything wrong. So I now ask everyone on this forum if they could help me out a bit.
  2. Hello everyone,   I'm working on a project where I'm using Vtscada Light to communicate with a MicroLogix 1200 PLC. Currently, I can read values from the PLC without any issues. However, I'm facing difficulties when attempting to write values back to the PLC.   Setup: PLC: MicroLogix 1200 SCADA Software: Vtscada Light Communication: Rockwell Driver with a serial port and serial-to-ethernet converter   I'm looking for guidance on the proper method to write values to the. If anyone has experience with this setup or similar, your insights would be much appreciated.   Thank you for your help!  
  3. Hi guys, my site uses mainly Mitsi PLC's & HMI's so not familiar with AllenBradley but i have two Micrologixe 1200 PLC's connected to Panelview 300 HMI's. The machines are twenty plus years old and now both HMI's are barely legible as the screens are so dim.  I want to upgrade the HMI's as they are obsolete but my problem is, the program within the PLC is Password Protected and i cannot read, upload or download to the PLC.  The original manufacturer has been taken over some years ago and no-one knows the password. They have sent me an old program that could possibly work which is not password protected, but i cannot download it to the PLC without the original Password. Can anyone help me?
  4. Uploaded a program from a micrologix 1400, I added an integer data file. Went to download it, and the processor types were different. I suppose I am just going to change it to match what is on the machine, but why did this happen? The controller was password protected. so maybe it did not get the processor info for some reason. Even when online with the processor, it reads incorrect.  
  5.  I am very green at this and learning online as I have purchased a brand new Micrologix 1400 1766L32BXBA. I am pulling my hair out as I cannot even power an LED or for that matter get any 24 volt reading from the outputs via program. I have even forced them on so shouldnt I be able to see something? I am connected via Ethernet ,Rslinx in concert with using Micro starter software (not lite) and the unit does not show any faults and is in the run mode. I can see the bits forced on the software and on the unit's LCD screen in I/O status. Is there a way to trouble shoot if the unit is bad or I am overlooking something incredibly simple. I do not have any floating inputs or outputs with the common from the power supply and the unit is properly grounded all nice and tidy on a din rail. Like I said I am very new at this so I am sorry if this is a bad question.
  6. Hello everyone, I am a newbie with PLC. I have a Micrologix 1000. The last time I connected with RSLinx easy, however, I change it to DH485 (I do not remember exactly). And now I can not connect it to RSLinx, I tried many times for all types of drivers. Please help me. Thank you very much.
  7. Reporting for Siemens PLC

    Hello, We want to do excel reports on Siemens PLC. We do not want to use historian programs. Do you know another programs?
  8. LOGO For Excel

    Version 1.0.0

    22 downloads

    LOGO For Excel allows you to retrieve, view, log and write data to one or more Siemens LAN connected LOGO! 8 basic modules using Microsoft Excel without the need of a touchpanel or any other hardware or driver. Configure in no time Excel spreadsheets that contains live LOGO! data.
  9. View File LOGO For Excel LOGO For Excel allows you to retrieve, view, log and write data to one or more Siemens LAN connected LOGO! 8 basic modules using Microsoft Excel without the need of a touchpanel or any other hardware or driver. Configure in no time Excel spreadsheets that contains live LOGO! data. Submitter progpro Submitted 03/25/22 Category Demo Software
  10. I have 23 Micrologix 1400s and I want to take the same register, N100:99, out of each one and put in a single array in a CompactLogix L18ER. From what I have tried, it only seems like I can only map a range of integers, N100:77-N100:100, to the array and not an individual register to a particular element. (For example, mapping N100:99 from machine 16 to Selected_Model[15]) Can you map to individual elements in an array? If so, are there any instructions on how to do so? Thank you in advance for reading my post!
  11. Good day everyone, First post here so hopefully I'm not violating community guidelines in anyway. I've got a system that has some 50 odd Micrologix 1100 and 1400 in use and I'm currently working on setting up an auto timesync for all of them using just 1 of the PLCs that will be my master time PLC. So far I've put together the logic for all the message instructions with the corresponding IP of the slave devices. I'm running. Into an issue with not being able to terminate/break the message connection on a PLC that I have already synced. Is this even possible to do on the ML1100. Once I get to 16-17 messages DN it starts to ER and will not complete any further messages. What I have is a message instruction ladder with a timed trigger to activate a MSG and write the RTC data then time down and connect and write to the next and so on. When it triggers the message instruction of one PLC it also fires an OTE to trigger the BK of the previous message instruction. However it doesn't seem to be actually cutting the message connection and holds it persistent until a power cycle/download event.
  12. S7 Excel Connect

    Version 2.0.0

    61 downloads

    S7 Excel Connect allows you to read, log and write one or more Siemens S7 PLCs data using Microsoft Excel. This can be data from a datablock, marker, input/output as well as digital as analog (not peripheral), timer and counter. S7 Excel Connect can be used for many uses ranging from a reporting tool, to a tool to write recipes to any S7 PLC.
  13. View File S7ExcelReader The S7ExcelReader Add-In enables users to load and work with data from a profinet connected Siemens S7 PLC. The retrieved S7 PLC data can be used to visualize proess data, create custom reports, perform complex calculations on process data, … . With one click on the refresh button, all the data of one or more S7 PLC’s are refreshed in your worksheet. Download your free trial of S7ExcelReader today! Submitter progpro Submitted 11/03/21 Category Demo Software
  14. Hey guys,   I know this is a topic that has been discussed before, but I am having trouble finding exactly what I am looking for.. I want to know the most efficient way to record data from my PLC to an Excel file on my PC. I want this to be done without the use of the PLC's webserver.  Specifically I am trying to record vfd speed every 10seconds with a time and date stamp. How can I do this?   Thanks, James  
  15. Version 1.4.0

    36 downloads

    ASComm IoT for .NET 7.0, 6.0, 5.0 & .NET Core 3.1+ developers. Class library for use in Visual Studio.NET to create HMI/SCADA apps that communicate with A-B ControlLogix, CompactLogix, Micro800 Series, PLC5, SLC500, and MicroLogix PLCs via Ethernet. Does not require OPC, RSLinx, or 3rd party drivers Visual Studio.NET 2017, 2019 and 2022 compatible All .NET 7.0, .NET 6.0, .NET 5.0 & .NET Core 3.1+ targets are supported, including Web, Windows, console, and service apps. Runs on Windows, Linux & Android Extremely high performance - less than 5 mSec typical transaction time Supports ControlLogix family native tag names Supports reading and writing entire ControlLogix family UDTs and PDTs Supports unsolicited messages Abstract base classes allow you to write generic code that works with all drivers Synchronous and asynchronous read/write methods Data change notifications Provides common user interface across all driver classes No limit on number of devices or data points Multi-threaded for high data throughput Includes extensive help system Example applications with VB and C# source code included. Easily connect office systems to factory floor. Runtime-free for qualified applications
  16. View File Allen-Bradley Ethernet Driver for .NET Core & .NET 5 .NET Core / .NET 5 compatible class library for use in Visual Studio.NET to create HMI/SCADA apps that communicate with A-B ControlLogix, CompactLogix, Micro800 Series, PLC5, SLC500, and MicroLogix PLCs via Ethernet. Supports unsolicited messages Does not require OPC, RSLinx, or 3rd party drivers Visual Studio.NET 2017 and 2019 compatible All .NET Core & .NET 5 targets are supported, including Web, Windows, console, and service apps. Extremely high performance - 5~10 mSec typical transaction time Supports ControlLogix family native tag names Supports reading and writing entire ControlLogix family UDTs and PDTs Abstract base classes allow you to write generic code that works with all drivers Synchronous and asynchronous read/write methods Data change notifications Provides common user interface across all driver classes No limit on number of devices or data points Multi-threaded for high data throughput Includes extensive help system Example applications with VB and C# source code included. Easily connect office systems to factory floor. Runtime-free for qualified applications Submitter Automated Solutions Submitted 10/25/21 Category Demo Software
  17. Here is a step by step tutorial... Utilizing the CX Server DDE Manager will allow us to provide a link to the information in the Omron PLC. This link can be placed on an Excel spreadsheet. Charts, graphs, etc. can be made from the data. We will create links on an excel spread sheet from a CQM1H and a CP1L PLC. The information will then be displayed as a bar graph comparing the first ten memory areas. Here is a step by step tutorial... Watch on YouTube : Implementing the Omron CX Server DDE and Excel Let me know what you think. Regards, Garry
  18. Hello everyone! I would like to connect a Micrologix 1100 with Citect 7.5 via ABMLXEIP (updated to latest version). I tried everything and it is still not working. The Citect and the PLC are on the same subnet and the ping works fine. All the configuration is done as the manual says (I attach the pictures). I have one NIC card and is connected to the PLC. The role is setted to “Server and Control Client”. The kernel has this error: [ERROR] [CORE] [0x07fc] [IOServer] [(GLOBAL)] [ErrorLog()][errlog.cpp] [266 ] Error: Channel offline, cannot talk CINIT 0015 PORT1_BOARD1 IODev_1100 Error_in_CMD-2 16 Generic 000021 Driver 00000020 (0x00000014) Any help would be much appreciated! Thanks, Gustavo.
  19. Would someone be so kind as to document a method to clear a fault on a Micrologix 1000. Does one need programming cable and software or is there another method to clear a fault to see if it returns? regards.  
  20. communication

    i want to communicate ml1400/compact logix L24ER to simatic s7200 via ethernet.Please help me with it i am new to it and dont know how to do it.
  21. Hello, I am new to Scada Programming. I am using Citect scada V7.50. I have completed whole project, but I am unable to generate Excel report for Alarms generated during run time. Please help me for this issue. Thanks...
  22. I'm trying to connect a SMC EX-260 to a Allen Bradley Micrologix 1400 PLC so  I can run some valves with it. However, RsLogix 500 doesn't allow me to just setup a generic ethernet device like I would on RsLogix 5000. Is there a way I can communicate these devices together so I can use the SMC Valve system with my Micrologix?
  23. I'm a young Controls Engineer at an integration company, and I need assistance.   I have a client that has about 330 different alphanumeric product numbers broken down by length and width. The operator must be able to select the product number at the HMI to pass along to the robot we are integrating. Is there a way to be able to have the operator select the product number simply, without having to scroll over 300 items in a single control list. The HMI is not chosen yet, so it can be GE, Rockwell/AB, or Automation Direct, but we are using a AB ControlLogix Processor. Racking my brain and I have little VBA/Scripting experience.
  24. Hello all, this is my first post. I am using an AB Micrologix 1400 (1766-L32BXB Ser C FW 21). I was trying to generate a pulse train using the PTO instruction. I have modified PTOX funct. file. The ladder is just a simple XIO followed by PTO, (The Quick Start ladder from 1766-RM001). When I looked at the output waveform on my oscilloscope, I noticed that it wasn't a square wave. I decided to run it at several different frequencies to see how the wave form would change. At 10Hz i got a square wave. As I increased the frequency the falling edge became sloped and almost horizontal. Is this how the output should behave? The data sheet indicates a max frequency of 100kHz, but at frequencies over 150 Hz. The wave form looks like the output of SMPS. 
  25. Hi all, I have my own driver to communicate with a MicroLogix 1400. Please refer to the attached screenshot from Wireshark. 10.10.21.10 is my driver's host, and 192.168.1.192 is the ML1400. The startup sequence to establish a connection & session with the PLC is correct I believe: - In the grey highlight, client requests a connection to .192 via SYN and this is ack'd - A session is registered, and forward open is successful - There's a lot of stuff in green simply because I've also got an HTTP browser session open to the PLC to monitor its session table - In between, spaced 8 seconds apart, are my two attempts to keep the connection alive by sending a List Identity request (as a ping, if you like). These are highlighted in pale blue. - However, 16.5 seconds from the start of the grey highlight, and 16.4 seconds after sequence=115 ack=99, the controller sends back a [RST, ACK] and a callback from my socket code tells me that the session has been dropped. The connection timeout for the PLC is configured as either 30 or 60 seconds, so I don't see how that's relevant here when the reset is happening only 17 seconds after it was established ? However, presumably the PLC doesn't see the application-level "List Identity" request as a valid means of keeping the connection alive. What is the correct mechanism to use that the PLC will accept as a keep-alive ?