Search the Community

Showing results for tags 'Excel OPC Micrologix Value'.

  • Search By Tags

    Type tags separated by commas.

  • Search By Author

Content Type

Find results in...

Find results that...


Date Created

Last Updated

Filter by number of...

Found 99 results

  1. sthilaire

    dsthilaire posted a topic in Allen Bradley / Rockwell Automation

    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. 
  2. 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.
  3. 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 "111.111.111.111" into excel, run the macro, and have it fill in the components on the backplane below. 111.111.111.111 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
  4. 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?
  5. 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
  6. 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  
  7. 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
  8. 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
  9. 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?
  10. can anybody Know how to control stepper motor using PLC
  11. 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!  
  12. 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 online...no ip
  13. 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

  14. Excel import

    Luka0204 posted a topic in Mitsubishi

    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  
  15. 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,
  16. 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 
  17. 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

  18. Cimplicity Auto Report Generation

    MD SULTAN ALAM posted a topic in GE

    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 ??
  19. 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. 
  20. Hi my problem may have a simple solution but i cant work it out. I need to use the Divide function but it wont let me use a decimal point in either Source A or Source B. Is there a way to use a decimal point in Logix 500 Math instructions? Im using an AB Micrologix 1400 PLC. Can you only use math instructions with whole numbers? is there a way around this? Thanks James
  21. Hi my problem may have a simple solution but i cant work it out. I need to use the Divide function but it wont let me use a decimal point in either Source A or Source B. Is there a way to use a decimal point in Logix 500 Math instructions? Im using an AB Micrologix 1400 PLC. Can you only use math instructions with whole numbers? is there a way around this? Thanks James

  22. Communication

    ivan da silva posted a topic in Allen Bradley / Rockwell Automation

    good evening. Someone can give tips on how to configure and physical the application with the following items: Advanced Interface Converters (AIC +), PanelView800 2711R-T7T A and MicroLogix 1500 Programmable Controllers My doubts are about the configuration of the communication, and I have doubts about the physical environment and protocol to be used.  
  23. Hi Guys! I have a problem with data collection. I use RS Logix 5000 software. I need to collect 11 int value. The sampling frequency is about 2 or 3 second. I tried to make an array but I faild, because I dont find what is correct for my task. I need about 5000 sample each of int value. Anybody have any idea about this problem ? If I have the datas then I have to exporting to an excel table . Thank you if anyone can help me.   T
  24. Hello :I'm the creator of an Android HMI app,  I recently added Ethernet/IP connectivity with MicroLogix and SLC AB PLCs, but I have only been able to test it with a MicroLogix 1100.I'm really not sure if it works with SLC or with other MicroLogix models.If someone could try it, I would appreciate it. To access the test, from the Android device, open this https://play.google.com/apps/testing/com.suppanel.suppanel on the web browser and install the Beta version.On the application you have to open the "EIP MicroLogic SLC Test" panel that contains some instructions. Thank you very much !
  25. I currently have certain amount of Recipe data located in form of Excel file on to a PC with static IP address. Is there a way to get that data inside the Nj501 without using an SQL server as I currently have NJ501-1300 which doesn't support SQL. I am okay to send data to the SD card I currently have on NJ PLC as it is easy to get data from SD card to the NJ501.  If there is any example code or a link that helps me create i would be helpful. Thanks in advance. FYI: I am currently using NB10 HMI with NJ PLC.