Search the Community

Showing results for tags 'mitsubishi excel'.

  • 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 373 results

  1. Hi all. Long time reader, first time poster. I am tasked to make a couple of module specific function blocks for communication between our Mitsubishi PLC (GX IEC Developer 7.04) and a B&R remote IO over Profibus. A number of these blocks would then be used, depending on the RIO setup. Reading should be straight forward, just read X amount of words, starting from address Y. Writing is trickier as Mitsubishi prefers 16/32 bit Data whereas B&R batches Data in bytes! As I have several output modules in the RIO. I need to send my info "chained" together. Example: Module 1: 2 Bytes Module 2: 3 Bytes Module 3: 2 Bytes Totals: 7 bytes or 4 words. Sending the first word is no problem. Neither is the next two words (I will just have 1 empty byte at the end of the third word). But then the info to the third module should start in the middle of the third word. Any idea how I could solve this? Experimental: At the moment the blocks have inputs (bits), which are stored to a bit-array inside the block and then linked to an output. My idea at the moment is to merge all module-wise output bit arrays to one big bit array, converting that to INT and sending it off to the Profibus address. But I have not yet found a way to merge the arrays and shift them so all data is where it should be. Above example: ARRAY [0..15] OF BOOL + ARRAY [0..23] OF BOOL + ARRAY [0..15] OF BOOL Totals: ARRAY [0..63] OF BOOL or [0..71] counting the spare byte. Converted to 8 Words and forwarded through Profibus. Thank you in advance.

  2. FX5U

    Ikhsan M posted a topic in Mitsubishi

    Halo, i have question and asking for help. my factory use mitsubishi plc type fx5u. can anyone help me how to setting everything that make motor servo can run. PLC : FX5U Ampli Servo : MR-J4-70A Thank you for helping me.
  3. I got it too.
  4. Hardware & software HMI - Beijer iX T12B / iX Developer 2.10PLC - Mitsubishi FX5U / GX Works3Error HMI shows "Controller 1: Comm err station 0". i.e., The HMI isn't getting a response from the PLC. IP addresses are all correct and ping (and can be programmed) OK. The HMI software PLC comms configuration has a "port" setting - see below. I can't find anything comparable on the the Mitsubishi software. Does anyone know what insight I'm missing here? iX Developer is configured as shown below: Note the port setting above. I can't find any documentation on what the PLC is expecting or what's special about 1025. The PLC is setup as below with GX Works3: Anyone got any ideas how to get the two talking? Many thanks.
  5. HI there guys need some help with a project i have on the go, I am having trouble saving multiple blocks as one recipe. I am using a E1043 with a total of 10 blocks each one has a value that has to be saved all into one recipe. I have assigned all the required blocks with the recipe directories. I understand the use of the save and load functions but this seems to only allow for one block been saved (the block with the save icon in it ). I have read alot of the manuals and help tutorials and cannot figure out what is needed to be able to do this if at all possible. Any help is much appreciated and thanks in advance :)
  6. How To Implement Modbus TCP Protocol Using VBA with Excel We will use Visual Basic for Applications (VBA) to communicate to a PLC using Modbus TCP protocol. Reading ten registers in the PLC and displaying a bar graph in Excel. Previously we have used VB6 to communicate Modbus TCP. The following steps will be done:1.Explain Modbus TCP protocol2.Install OstroSoft Winsock Component– Winsock API Calls for communication on network3.Develop the Excel and VBA application (Microsoft Excel 2010)4.Communicate to the PLC and sample code (Do-More Simulator)Read the rest of the post... How To Implement Modbus TCP Protocol Using VBA with Excel Here is a blog post that I thought was good to share. Let me know what you think. Garry http://www.accautomation.ca
  7. Hi All Was wondering if anyone could help i've setup an OPC Server ok and can read all the tags from my PLC. Now i need to write to some of the tags so the warehouse can input production requirements. Has anyone done this or any idea on how to do this. Any help would be great. Cheers Chris
  8. Software: GX Works3 I'm really struggling to understand GX Works online / offline operation. (I know they've been consistent in how this works for the past ten years - but it's consistently bad!) I can't find how to work in offline mode. I powered off the PLC and the software keeps trying to connect. I've cleared the PLC memory and am trying to download the complete program to an FX5U. (I was able to do it earlier. I'm still able to communicate with PLC over Ethernet.) I'm getting:Unable to write target file because it is the following status. (sic) - Unconverted - Converted function block does not exist in FB file. - Converted function block does not exist in FUN file. - Unconverted module label. There are no red items in the navigation tree. There are no errors after a Rebuild All command. What do I need to do to figure out what the problem is? Many thanks.
  9. I'm trying to use CX-Server to pull data from my Omron CJ2H PLC directly into Excel. I'm able to pull a single element into excel, but when I try to pull more than one element, I get a huge strand of numbers. Is there a way that I can set up a single point in DDE Manager that'll hold all the elements that I need, then in excel have a formula that will pull out specific memory elements. Specifically I'm trying to pull data from D7200-D7399, and put each element into a separate cell it in a chart that ranges from B3-K22 This is what the formula looks like when I copy a point into excel =CDMDDE|'C:\Users\... ....cdm'!'\New Point 1' I didnt know if I could put something at the end of each string to call out specific elements, but I keep getting "#BadPoint" =CDMDDE|'C:\Users\... ....cdm'!'\New Point 1'!'D7200' =CDMDDE|'C:\Users\... ....cdm'!'\New Point 1'!'D7201' ... =CDMDDE|'C:\Users\... ....cdm'!'\New Point 1'!'D7399' Any help would be great

  10. Mitsubishi GOT password crack

    maniniyot posted a topic in Mitsubishi

    Dear sirs I Need to upgrade an old HMI unit (F900 series) to GOT 1000 series But it has a password and the maintenance personel have no idea ,the machine by the way is almost 20 years old and the manuals are also missing.... Is there a specific software for cracking the password ? thanks in advance

  11. Mitsubishi PLC Unit FX2N Problem

    franzwave posted a topic in Other PLCs

    fx2n-48mr-001 problem. Prog E flashes.Run and BAT. V no light only the Power LED lits..any idea of this error code . what's the possible solution. .tnx
  12. I am trying to set up communications between a Mitsubishi master profibus module and a Mentor dc drive using an SM Profibus DP-V1 module.. I am using GX configurator DP to set up the communications using the SM Profibus DP-V1 GSD file, but no matter what configuration I used on the master and slave setup i still have an alarm on the QJ71PB92V stating that the SM Profibus DP-V1 is transmitting a diagnostic message and the comms is shutting down. When I interrogate the SM Profibus DP-V1 I cant find any errors or messages. ANY IDEAS ON THE CORRECT SETUP?
  13. Hi, again. (I'm getting good support!) Every time I write to PLC it is switched out of run mode. I use Remote Operation to try to switch back to run mode but I get blinking P.RUN indication and blinking RUN light on PLC. I have to cycle the power to get back to run mode. Can I switch to run remotely?
  14. https://plus.google.com/u/0/collection/oCtiX To be continued...
  15. Dear experts, I used this forum for help analyzing our PLC setup in the warehouse in 2013 and feedback from the experts here was very helpful. I would like to offer an engagement as freelancer on our project since we need to cut-out a system which runs out of maintenance in Dec 2016. Please see attachment for details and very happy to receive any questions. I hope this is not against the forum rules as I couldn't find a suitable forum "job offers". Kind regards, Gunter Senior PLC Engineer Japan.pdf

  16. RS5000

    Shiner posted a topic in Allen Bradley / Rockwell Automation

    Hello all, I am trying to get around a lot of manual inputting by exporting a routine and opening it using excel, but looking at the file that excel shows I have a couple fundamental questions 1. when excel opens it and "creates a schema', can I save this in a format that will allow me to import it back into the program? 2. Since I am mapping data using add on instructions, the table excel has created becomes quote complex, with no clear point of reference to where my Input tags are going to go. We are doing this because someone thought it would be a good idea to put a SCADA based control platform over the top of an AB control system, so we have to exchange thousands of points of data back and forth with their system. I created the mapping AOI blocks to be able to manage the file structure a little better in the routines, but that still leaves me with copy and paste thousands of tags into the AOIs. Has anyone developed a good way to create logic, or modify logic using excel? While I can hold my own with utilizing the RS5000 platform, my excel experience is limited. The processor is a 1756-L75 Thanks
  17. I am trying to find a way to do a "batch monitor of Global Labels" in Mitsubishi GX Works2 Software. I can monitor Device/Buffer Memory Batch but can't find a way to monitor all Global Label's status online? Can anybody help me on this?
  18. Dear Sirs/Madams, I am studying to connect between GOT1565 and Microcomputer/PC via RS232 However, I only see the documentation for GT-A900 and GT-F900 So, I'm wan to ask you: Can GT1565 connect with Microcomputer/PC via RS232? Who did it? can you help me? Thanks so much!

  19. Programming Error using QJ71C24N

    Husanto posted a topic in Mitsubishi

    Hi All, I have problem about programming serial module Mitsubishi PLC using QJ71C24N. If I unconnect the cable from the module and connect again it show SIO error and the communication become lost or not sending data again. so i have to restart the PLC to make it normal again. Any other solution for solve this error without restart the PLC? Thanks Husanto

  20. Non-volatile memory GX Works2

    williamj posted a topic in Mitsubishi

    Hi all, Im trying to figure out how to create non-volatile memory tags in GX Works 2 (using a FX3U controller), so that the values stored in the D registers won't keep zeroing out every time the controller powers down. Does anyone have any helpful tips on how this is done? Thanks

  21. Mitsubishi QJ71PB92V and Balluff BNI PBS-507-000-Z011

    semenyuk.serg@gmail.com posted a topic in Mitsubishi

    Hi all! I need advice. I have Mitsubishi Q02UCPU with profibus module QJ71PB92V. I try to connect communication module from Balluff BNI PBS-507-000-Z011 via Profubus without success. Everytime I connect module, I see diagnostic alarm "The parameter transmitted by the master is incorrect". All settings were made by default. QJ71PB92V has 0 adress and Balluff BNI PBS-507-000-Z01 has 11. I connected this module to the Siemens CPU-315 and it is work correct. From this forum I see it is common error. What will be the next step to check or solve the problem? I am not profficient in Profibus networks, so I will be appreciate for any help!

  22. Help with carwash / FX3

    jrrice72 posted a topic in Mitsubishi

    Can anyone help with a carwash program? I am currently a student and having a very hard time getting this to work. I am using GX2 software. Any help would be greatly appreciated. Jeff
  23. Dear experts, I have been trying to flash parameter to QD75MH1 module from PLC. Every time I monitor the servo via GX-configurator QP, I find 0 error, 0 warning but in the history tab it shows "start not possible(108)". But when I did it by flashing the parameter by GX-Configurator QP(Specially invalidating forced stop option" it works fine and servo motor jogs. can anyone help me to write the forced stop value from PLC program?