kaare_t

MrPLC Member
  • Content count

    2123
  • Joined

  • Last visited

Everything posted by kaare_t

  1. Accessing specific bits in a word.

    You are correct that "." are limited to specific addressing only. The way "around" it is to define variables in global lists and then use the variable name (you can assign a labelname the address D100.1 for example).
  2. Modbus TCP/IP iQ-R series

    As Gambit states, it's not possible to use ModbusTCP Server (slave) in the R-CPU as of now. But if you must have it the way you are describing it (Q = Client/Master and R = Server/Slave), then you have to add some components in order to communicate between them. I would do the following if you "must" do it your way: If you already purchased the R-CPU, then also order an Ethernet card RJ71EN71. Alternatively if you haven't purchased the CPU yet, just replace R04 with R04EN (which has 2 built-in extra Ethernet port that can be configured with CCLinkIE Field. Buy a Modbus Server (slave) <-> CCLinkIE Field gateway to convert between Modbus telegrams and CCLinkIE Field network; https://www.anybus.com/products/gateway-index/anybus-xgateway/detail/anybus-x-gateway-cc-link-ie-field-slave---modbus-tcp-server Hopefully you haven't purchased the CPU yet, since you can just select the R04EN CPU with 2 extra built-in Ethernet ports which can be configured as CCLinkIE Field ports (or regular Ethernet ports).
  3. Mitsubishi Servo(Current Data Problem)

    So you have not set ANY other parameters in the amplifier, and you're using DIO for positioning data, can you disconnect IO from the amplifier, and just use MR Configurator. Boot the amplifier and turn some revolutions, monitor the value, reboot the amplifier and see if the value is stored. This is normally very easy, just connect the battery and set parameter: Absolute positioning is working
  4. Mitsubishi Servo(Current Data Problem)

    We cannot see any picture(s)...
  5. Mitsubishi Servo(Current Data Problem)

    Which parameter(s) did you change, and to which value, to enable absolute positioning?
  6. FX5U EVAL instruction

    No problem, glad you got it working. As a side note: Something must be completely wrong with FW v1.046. The first thing I checked was if there was any changes for the EVAL regarding FW, but the manual states that all float instructions are available from the first FW version from Mitsu, so obviously something very strange going on with FW v1.046. Thank you for the update and solution!
  7. FX5U EVAL instruction

    I meant exactly what you are suggesting; FMOVP K0 D7900 K30... I looked through the manuals and I cannot find anything related to versioning regarding the EVAL instruction so basically you should be good to go. As mentioned, I don't have a FX5 where I am now, but if no one else can test it, I can get my hands on one this weekend I think. In the meantime, I noticed you are using double-quotes for the strings ("). Could you try using single-quotes (') instead? So instead of: $MOVP "123" D7900 use $MOVP '123' D7900 Also: Does the code run fine in simulation mode on your computer? Is it only after downloading to the PLC you are getting problems? Which version of GW3 are you running?
  8. FX5U EVAL instruction

    Are you sure you are clearing all the areas in the "from" field (D7900 ->)? And you are sure that nothing is overwriting anything in these areas? I don't have a CPU where I am now, but simulating it works fine. As a test, try to use pulse instructions only, to know that nothing is overwriting anything elsewhere (external comms?): FMOVP K0 D7900 K30 $MOVP "123" D7900 EVALP D7900 D7940 RST M721 Only run M721 and see. If it works doing the above, we know that something is modifying/adding data to D7900-D7929 somewhere causing the EVAL instruction to complain.
  9. Report Builder 3.0 with SQL Express/FTView SE

    OK, so I've been giving this some thought, and I must say I'm a bit in the dark exactly what you want to achieve by getting the data "inline" like you describe. Maybe you could also describe what your "final goal" is, just to make my understanding better, and to shed some light on possible routes? I mean; the output you are referring to in the pictures is just the raw output right? In your report application you can organize and adjust where you want the data placed? What I'm trying to point out is that I'm pretty sure you want to do the UI logic in the View application instead of in the SQL query? Anyway, I've created a query you can use for your question, but please post more information if you can and we'll try to help you accomplish your goal in the "correct way. See code below, works for MS SQL Express server. You can copy-paste this code into your SQL Management Studio to be able to run the query if you want to test (you might have to adjust the DB names etc). -- Creates a temporary timestamp value (and sets it to NULL in my test) -> Set it to the correct value in your application query DECLARE @stamp AS DateTime SET @stamp = NULL; -- Creates a temporary table that we will use to insert into - note that these are the columns you want DECLARE @tmpTable AS TABLE ( ValDateTime datetime, Val1 float, Val2 float, Val3 float, Val4 float, Val5 float, Str1 nvarchar(82), Str2 nvarchar(82), Str3 nvarchar(82) ) -- Inserts into the temporary table INSERT INTO @tmpTable(ValDateTime, Val1, Val2, Val3, Val4, Val5, Str1, Str2, Str3) VALUES ((SELECT TOP (1) DateAndTime FROM FloatTable WHERE DateAndTime LIKE @stamp), (SELECT Val FROM FloatTable WHERE TagIndex = 1 AND DateAndTime LIKE @stamp), (SELECT Val From FloatTable WHERE TagIndex = 2 AND DateAndTime LIKE @stamp), (SELECT Val From FloatTable WHERE TagIndex = 3 AND DateAndTime LIKE @stamp), (SELECT Val From FloatTable WHERE TagIndex = 4 AND DateAndTime LIKE @stamp), (SELECT Val From FloatTable WHERE TagIndex = 5 AND DateAndTime LIKE @stamp), (SELECT Val From StringTable WHERE TagIndex = 1 AND DateAndTime LIKE @stamp), (SELECT Val From StringTable WHERE TagIndex = 2 AND DateAndTime LIKE @stamp), (SELECT Val From StringTable WHERE TagIndex = 3 AND DateAndTime LIKE @stamp)) -- In the end, just use a SELECT * from the temp table to select all columns SELECT * FROM @tmpTable   Gives the following result (note that in my DB I only created the columns with NULL value in the datetime column. Top line is headers, and bottom line is data. ValDateTime Val1 Val2 Val3 Val4 Val5 Str1 Str2 Str3 NULL 1 2 3 4 5 String 1 String 2 String 3  
  10. Report Builder 3.0 with SQL Express/FTView SE

    Understood! I will get back to you but I need to do some investigation first... I'll let you know.
  11. Did fx3g 485bd supports modbus comn

    Oh, sorry about that. I now see what the topic starter meant. Thanks @Inntele
  12. program efficiency

    Probably because the compiler generates temp vars to map data. In other words, the compiler makes use of variables to compile the code into IL for execution. The FB can be with, or without macrocode which indicates if it is placed inline or as a "subroutine". It's hard to explain your exact issue without seeing the code with and without modifications.
  13. Report Builder 3.0 with SQL Express/FTView SE

    I see, so what you're saying is that you want to replace TagIndex with a name of some sort, to represent the device or the actual equipment? Then, you want to show them kind of "in-line" one after the other? So for example: TimeDate | Variable1 | Variable2 | Variable3 If that's the case, were closer to a solution. Could you also post how your tables are structured? I see you have a JOIN in your first post, so obviously you have at least two tables. Do you have more than those two (for this scenario), or is it just float/string tables each containing a correct datetime?
  14. Report Builder 3.0 with SQL Express/FTView SE

    I'm not sure what you need help with here, would you please explain what it is you want to read out from your tables? I get that you have one table for string values and one table for float values, but instead of explaining what is not working, could you explain what you are trying to accomplish? Maybe that helps my understanding?
  15. error : es:01802007

    What does the error text say? Could you post a screenshot of the error message?
  16. please need help

    Answered here: http://forums.mrplc.com/index.php?/topic/34720-please-need-help/
  17. please need help

    Which software are you using? If you have the possibility to implement functionblocks then Mitsubishi already have these available for FX2N together with BD cards.
  18. Did fx3g 485bd supports modbus comn

    Yes, FX3G supports ModbusRTU using ADPRW.
  19. EIP Data Clearing

    The above codeline will, as explained in comment: Always move 211words from G10000+ into D2000+. So the problem here is that the local buffer in the EIP isn't cleared after it's read. You need to find a way (probably a bit in a BFM or something) that clears the input area of the EIP, AFTER you've successfully read the data. The sequence should be something like this: Scan bc Store bc in EIP Notify Q03 (can be done by a bit, or by looking at new data available) Transfer data from EIP to Q03 Clear EIP buffer area Ready for next data Alternatively, if speed is of essence and you want to avoid clearing the EIP buffer you can probably find a buffer in EIP that indicates the length in bytes that are currently received. Use that length variable instead of K211 in your BMOV instruction. Note that the variable is probably in 'byte' units so you'll have to do some calculations that way.
  20. FR S520S inverter reverse frequency problem

    How are you controlling STF/STR signals? Are they digital? And also, you are sending an analog signal for the frequency setpoint, or are you using a potmeter? Please let us know your complete setup.
  21. mitsubhishi serial drivers

    Already discussing this topic here: http://forums.mrplc.com/index.php?/topic/34407-mitsubhishi-serial-drivers/
  22. mitsubhishi serial drivers

    It's almost impossible to help you with this little information. The Q06UDEH CPU doesn't have a serial port, so the nextgen2000 obviously doesn't convert the serial CPU-port protocol to Ethernet... Can you be more specific with what equipment you currently have, and also where everything is connected? What is your purpose of "installing the serial driver directly"? What is it that you want to do? What does the system do today?
  23. GX Works2 Q Series TCP issues

    Could you also take a screenshot of the 'Open' settings for the Ethernet card (where you assign IP/Port/Application to the appropriate connections for the Ethernet card (Network Parameter -> Ethernet / CC IE / MELSECNET -> Open Setting). Are you trying to use the same connection number for both send and receive data? The Ethernet card needs one connection number per send and/or receive. This essentially means that you need to e.g. use connection number 1 for receiving data, and connection number 2 for sending data. You also need to specify if you are actually sending or receiving data on a given connection number.
  24. GX Works 2

    Already discussing this here: http://forums.mrplc.com/index.php?/topic/34314-gx-works-2/
  25. GX Works 2

    I agree with @Ron_S, what is it that you want to accomplish with this?