Search the Community

Showing results for tags 'Excel OPC Micrologix Value'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Found 83 results

  1. 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.
  2. SLC 500 and SMC Ex260

    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?
  3. 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.
  4. Square Wave Problem With Micrologix

    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. 
  5. 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...
  6. Hi all, I have my own driver to communicate with a MicroLogix 1400. Please refer to the attached screenshot from Wireshark. is my driver's host, and 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 ?
  7. sthilaire

    Does anyone have any idea how to set up an OPC server in FactoryTalk SE for Excel?  I'm trying to move data from a spread sheet to the PLC.  Got it working in excel now I'm trying to initiate the transfer from SE. 
  8. Hi there, As a software engineer, but a newbie to the Allen-Bradley world, sorry if this question doesn't make sense. I'm enhancing an existing driver by trying to add the ability to read/write structured and array data types - rather than just the elementary data types it supports right now. This following question is only in the context of SLC/500 & MicroLogix 1400. And I'm currently working on a Counter as a test case, but any solution obviously needs to take into account other structured (and array) data types. One of the requirements is that the user should be able to select a specific atomic item within a parent structure/array that they want to read/write. So, using the Counter as an example, they might want to define a field which holds just the value of the accumulator. I know that I can achieve this with a CIP command. I specify file type 87 for counter, file number as 5 (my test example happens to be the standard C5 data file of counters), and element is 0 (for the first counter in C5). Bit number is irrelevant so remains as zero. I ask CIP to return me 2 bytes of data (to hold just the accumulator word). Finally, I tell CIP that I want sub-element 2 (because the accumulator is Word 2 of the whole structure). Sure enough, the CIP response gives me exactly the 2-byte accumulator value I was expecting, nothing more, nothing less. Success. My question is this: I knew I had to specify the sub-element as 2; this happens to work for a Counter because of the way it is structured as 3 words. However, it implies that the value I specify for sub-element is ALWAYS measured in units of 16-bit words. Is this a universal truth (i.e. works for other structured types too ?), or does the size of a sub-element depend on other factors, such as the file type ?   Thank you in anticipation.
  9. Hello,   Target:  I'm looking to make an excel macro that will take an IP address and pull the components on that specific backplane. Pretty much how RSLinx Classic OEM does it, but it will save me a lot of time if I could automatically put the results into excel. Example: Enter IP "" into excel, run the macro, and have it fill in the components on the backplane below. 00, 1756-L73 LOGIX5573 01, 1756-EN2T 02, 1756-DNB 03, ... 04, ... Any help that could get me toward this would be amazing. I'm just not sure of the code that would do this.   Thank you, MalSmith21
  10. EEPROM PLC's

    I thought only PLC5's had EEPROM, but I was told MicroLogix PLC's also have an EEPROM that need to be burned to... What are all the PLC's that have EEPROM and require an EEPROM burn to prevent the program from being wiped in a power cycle?
  11. My project is to read an RFID tag (ascii) with a Micrologix 1400, send the string to a PC using Ethernet/IP, lookup and compare in an Excel spreadsheet, and send back data (probably an integer) for the plc to use to control direction. I have to scan and compare an RFID tag to a list of 1400 possible part numbers, at different locations (more than 1 plc). I want the several PLCs to go to a single PC to make it easy to update when changes occur (on a weekly basis). Has anyone done anything like this? I'm assuming there will have to be some kind of vb or c+ application involved.   Thanks,  CK
  12. Hi All, Am trying to communicate and make In-Sight bar code reader to trigger through MicroLogix 1100 with RSLogix 500.  Does any have any info as to the steps to follow. Most of the info I saw and have tried were for SLC processor In fact, I created the String file ST10:0  for the target device as was mentioned in one of the posts but when I complied it there was error saying that St10:0 was not supported by the module. Please see attached file. Any insight will be appreciated  
  13. Does anyone have any tips or tricks for generating UDT Templates from an excel spreadsheet? It says in the help files you can copy/paste from excel into the UDT Template, but it seems to only allow that cell by cell, instead of the whole table of data. This is painfully tedious when building larger interfaces. I've tried saving the spreadsheet in various formats (CSV, PRN, tab delimted txt) and I've tried various versions of RSLogix from 23 to 31. I can't seem to find any detailed info on how to do this. I've seen some other forum posts regarding using scripting to generate the XML to import the UDT, but I don't understand why I can't simply copy and paste the info in. Is this really that difficult? Any help would be greatly appreciated. Thanks Otto
  14. I know nothing about HMI's or Crimson software.  I'm in I.T. and we had to change the third octet in the IP address and gateway on all devices at our warehouse.  I extracted the file on one HMI, changed the ethernet info, and clicked send.  That HMI that runs a carpet machine works perfectly.  I went to the second carpet machine.  Extracted the file changed it's ethernet info, clicked send.  It came back with all ---- (dash's) instead of zeros, the carpet machine won't work.  I kept messing with the file trying different things, and inadvertently saved over the original extracted file!!!!!  So I thought I'd extract the file from the working carpet machine and loaded it on the second carpet machine.  I get the same issue, all ---- (dash's) on the HMI and you push any of the buttons on the front of the HMI and nothing works.  These are Allen Bradley MicroLogix 1500 running Crimson 2.0 HELP I don't know how to resolve this issue.  I would have thought both HMI's would have been the same!  HMI all dashes.eml HMI all dashes2.eml
  15. MicroLogix 1100 IP Addressing

    I have a micrologix 1100 PLC as well as a weintek HMI all connected through a network switch for them to communicate between each other, however I'm having an issue where the Micrologix Controller will not retain its IP address once I set it through Allen Bradleys BootP tool. I can set it through the tool and then go into RSlogix 500 and communicate with it and all that, but once the controller is turned off the IP address goes back to its factory setting of not showing an IP at all. Any suggestions/ ideas as to what I'm doing wrong?
  16. Stepper Motor Control

    can anybody Know how to control stepper motor using PLC
  17. RSLINX in excel

    Hi Guys! A have a problem with Excel and RS linx. I belive the communication is good. I just need a few tips, especially with excel. I have about 3000 dint value, and aI dont know how to put them in excel at once. Not one by one. THis is my first question. You can see the link: =RSLINX|MC!'Database_fifo[0].Motor_rpm, L1,C1' the next one is =RSLINX|MC!'Database_fifo[1].Motor_rpm, L1,C1' and =RSLINX|MC!'Database_fifo[2].Motor_rpm, L1,C1' and so on. I dont want to write the numbers like 3, 4 ,5 ...2560... So I hope you guys get it, sorry for the bad explanation. For this problem maybe exsiting some macro or something like that, I dont know. The second: there is some dint what is in decimal style, but acutall they are ascii, I know how solve that, with the char function, but I dont know how to collect it. Like on the picture, there is the numbers what I read from the plc, like 82 equal to R. But I want to see them in one cell. Like RKBF-355, I want them in a same cell. Unfortunaltely I cant solve it. At least until now, and I hope somebody know it by memory.    Thank you in advance!  
  18. Hey, I have a 1763 L16BBB...when I plug the 1762IF20F2 analog card in, I get a 0189h error code. Any help would be appreciated. Currently looking at doing a bootp on the plc to get ip
  19. Have a micrologix 1200R 1762-L40BWAR.  If anyone could help with providing the following information: Need a communication port with single receptacle that will mount through the door of electrical enclosure and then the communication cable (6 to 10') that will go from the com. port to the micrologix. Thanks
  20. Excel import

    Hi, i have excel file with 2 columns and cc 300 rows (saturation curve). How to import excel file in GX works 3 (R04CPU) and use data as two array variables [0..300]? I want to avoid manual writing around 600 values. Thanks  
  21. Does anyone have an example piece of ladder logic, created on a Micrologix 1200, using ASCII to READ and Write to a serial device?  I am building a ladder on a Micrologix 1200 that will send data to an old CNC once a certain ASCII instruction is received on the PLC.  For example, when the machine spits out an ASCII "1", the PLC will see the "1" and send out a three digit number depending on a sequence of discrete inputs.   Thank you,
  22. Hello, I'm new to PLC Programming, with just a simple course about the basics. I've got a micrologix 1400 PLC which seems to have had its program wiped when the battery was replaced. I've had the company that supplied the machine it runs send me the program for the PLC. However, I don't have any software to communicate with it, and download the program to the PLC. I was hoping some one here could help me out and direct me towards what I will need to do to get the new program installed on the PLC. Thank you 
  23. Dear Everyone can help     i have a batching system of about 12 materials and i need to generate a report for all batches in the day in runtime, i tried using SQL with Cicode but sometimes i can't find some material's data or to be Zeros. did any one here know a way to do that?? vijeo citect 7.4 thank you
  24. Cimplicity Auto Report Generation

    Dear All, I am having a problem with my cimplicity Auto Report Generation, When I Click on Generate Report, it shows "0 values collected" does anyone knows what's possibly could gone wrong here ??
  25. Hello I have a scenario that's been bugging me for some time now. The scenario consists of a Micrologix 1400 that I need to control it's output from modbus/tcp. In detail what I really need is to be able to manipulate the O0:0 through modbus/tcp. The PLC would be the master and I would be the slave that triggers the connection to the master. I'm using a Modbus-Client on my PC and that should be the slave. Any idea as to how I can manage that? Currently I can send data to the master but everything is "stored" on B10 and I have no idea how I could write directly on O0. Thanks a bunch guys. PS: I'm borderline noob.