0

IQANsimulate 7 Excel Integration for Automated Control

Mason Lieb 1 year ago in IQANsimulate updated by Gustav Widén (System support) 1 year ago 2

Included with the release of IQANsimulate 6 was an Excel .xlsm file that was set up to interface between Excel and IQANsimulate. This file was originally developed by Anders Båth. One of the aspects of this file was the reference in Excel VBA to the IQANsimulate .exe file which then directed Excel to the header file that includes the object definitions for the automated control.


With the release of IQANsimulate 7, it appears that this Excel file is no longer included. The biggest challenge I'm having at the moment with adapting the old file to IQANsimulate 7 is that the library reference seems to be tied to a Windows Registry value and I cannot easily identify how to remove the reference. This means that the Excel file is stuck referencing the IQANsimulate 6 library and therefore does not run IQANsimulate 7. I need some help getting this reference fixed.


The other issue is that the new installation location for IQANsimulate 7 is in the path C:\Users\[username]\AppData\Local\Programs\IQANsimulate 7 which means that if I am able to update the reference in Excel, it will be pointing to a path that only exists on my machine. I think this might break the ability to share the Excel file with others on my team and have them use it for their own unit testing.


I think the first challenge will be properly identifying the Windows Registry entries that need to be removed in order to unlink the reference to IQANsimulate 6. Then I can at least get the tool working on my computer. The challenge of shared usability will be next.

0

unexpected behviour using PositiveFlank(x) and Not(x)

Rick Yorke 1 year ago in IQANsimulate updated by Gustav Widén (System support) 1 year ago 3

Using IQAN6, we have encountered some unexpected behaviour when using a NOT condition with a Positive Flank condition. A solution has been found but curious as to if this behaviour is in the Simulation only or will the HW behave in the same manner. If this is the expected behaviour, how are these conditions handled at the system level?


Image 4460


0
Answered

IQAN ActiveX Controls:

Hard Amin 1 year ago in IQANsimulate updated by borislav stoychev 4 months ago 7

Hello, 

I am facing issues working with IQANSimulate control.xlsm file. I receive compilation error when I try to browse the project file. Is this due to incompatibility in IQAN Simulate version vs the reference the VBA uses ?

Image 4354

0

IQAN Simulate

Kanaille 2 years ago in IQANsimulate updated 2 years ago 1

Hello,

Is it intentional that I can't customize items in IQAN Simulate? I don't have a module to try out the application on hardware.

I can't find any explanation in the documentation.

0

screen shots save location

Ed Schippers 2 years ago in IQANsimulate 0

It would be nice if when you make a second screen shot, the save location is the same as the one you used before.

Now every time you make a screen shot you need to navigate to the save location you want to use.

0

Generic GPOUT and GFOUT Error

Deanne 3 years ago in IQANsimulate updated 3 years ago 4

I have a value of 0x1F4 (500 dec) being sent to a generic GPOUT.  I am getting an error and the value isn't being sent through to the parameter so I am wondering if I have set it up incorrectly.

Image 3545

0
Answered

Excel ActiveX control JPIN value

Mason Lieb 3 years ago in IQANsimulate updated by Gustav Widén (System support) 3 years ago 3

I'm working on developing a method of automating simulations based on the "IQANsimulate control.xlsm" excel file. This is the file included with the IQANsimulate installation and described in Chapter 5 of the user manual for external control. Generally, the file has been easy to work with but I cannot seem to directly control the value of a J1939 Parameter In (JPIN) channel from this Excel sheet.


Image 3478

For the above screenshot, the channel listed is set up in a simulation group with manual control. When running the simulation, the output reading for the channel does not change and returns status 201 (J1939 not available). Even if I set the status for the channel to be 64 (OK), I get a status message on the input side of J1939 not available.

To get around this, I can control the JPIN channel with another system input (like a digital input), but that requires that I modify the IQANdesign project and add additional inputs to the master module(s). Another potential method of controlling the JPIN value could be using the signal generator option, but then my question becomes can I set the values for this signal generator externally in the Excel sheet?

Basically, I want to know if/how I can control the JPIN values from this excel sheet or in general from an ActiveX/COM integration with IQANsimulate. Thanks!

0

No handshake reply from master module

Kudzanai Bhebhe 3 years ago in IQANsimulate updated by Gustav Widén (System support) 3 years ago 1

Hie guys..im back again...whenever i run my simulation my project doesnt show diplay pages and just gets stuck on the splash page...i get a no handshake reply from master module error in iQAN design..ive tried using a different version of iqan design and simulate (version 6.06) and it worked the first few hours of installation but now the error is back (failed to establish new communication session), ive also been restarting my machine with no win...kindly assist.

0

Some characters work in simulator but not MD4 display

Pierre Fagrell 3 years ago in IQANsimulate updated 3 years ago 2

The following characters show up on a label in the simulator but not on an MD4-7

0

Best way to capture live screen actions on MD4-7

toby 3 years ago in IQANsimulate 0

Just wondering what the best way to capture a demonstration of the functionality of the display is. Is there any way to mirror an MD4-7 display from a live system onto a computer or video stream or is my only option to set up a simulation? The main issue I have with the simulation option is that I have a multi-master system, which communicates over J1939 and there is a lot of data to link between the two to make a functional simulation, plus many of our functions would be difficult to demonstrate in a simulation since there are complicated relationships between multiple I/Os. Thanks