Greetings everybody,

I'm trying to establish a DDE communication between Monitor Pro 7.2 and Excel 2003.

I'm configuring Monitor Pro as a DDE server, I added a new Task in the "configuration explorer" under "System" with these parameters:
- Flag: FSR
- Task Name: FLDDESRV
- Path: /bin/flddesrv

Now for the Excel part:
In the formula of one of the cells I should this DDE address:

=FLNAME.FLUSER|RTDB!'tag_name'

It's all stated in "TaskConfigurationReferenceGuide.pdf"

My question is what Does FNAME and FLUSER refers to?
I believe that FLNAME is my application name (e.g. MyStarterApp),

Is it correct?
And what is FLUSER?

any help is appreciated.

Thanks in advance

 

Hi,

The right syntax in any Excel's cell is:
flapp1.shareusr|RTDB!'TagName'

For example:
a) flapp1.shareusr|RTDB!DATETIME
b) flapp1.shareusr|RTDB!SECTIME

You must use the value of the Monitor Pro environmental variables FLNAME and FLUSER.

FYI...

FLAPP = defines the full path, including the drive
name, of the directory containing your application files.

FLNAME = defines the name of the application to
start, which points to the real-time database.

FLUSER = defines the logical user name.

You will find more information in "ExternalConnectivityGuide.pdf" and "FundamentalsGuide.pdf".

Important Tip: you must have an available CAL in order to read data from MPro server via DDE, OPC, OLE, etc.

Best regards.

Saludos.

Gustavo A. Valero P.
BIConsulting C.A.
Valencia - Venezuela
[email protected]

 

Thanks a lot Mr.Gustavo,

And my apologies for this late reply!

Well, I tried all you mentioned and stil not working...

One thing I don't understand:
(( Important Tip: you must have an available CAL in order to read data from MPro server via DDE, OPC, OLE, etc.))

What is CAL ?!

 

Ok, I found it in the manual
CAL = Client Access License

Does that mean that I should purchase an additional Client license to be able to send data to Excel using DDE ?!

Thanks

 

Yes, you must do it if you have already used your purchased CALs.

The CALs are concurrent so you can install as many clients or external applications accessing MPro server (Client Builder, XML/OPC/DDE) as you want but only the number of purchased CALs will communicate to server.

The server knows the amount of licensed CALs and control the access to its data blocking or not other connections.

I have a DDE app demo if you are interested in learning more.

Best regards.

Saludos.

Gustavo A. Valero P.
BIConsulting C.A.
Valencia - Venezuela
[email protected]

 

Yes, You are very True.

In our application, There are some advanced analysis required and also plotting in XY graphs is required which can't be done in any SCADA package.

I used LabView as an OPC client that takes its data from USDataServer.

We have only two licenses for two client builders (on different machines)

When LabView is started before one of the client builders, When starting the second Builder, It tells me "There are no avilable license"

And when the two builders are started then LabView, LabView coudn't update its data using OPC connection anymore!

That was a tough lesson!
Anyway, I thought of a solution:
Client Builder (VBA) writes two a File continously and LabView reads it. It's working great.
I don't like these too custom solutions, But we had a problem and had to solve it.

And many thanks for your valuble info.

Sure, It'll be very nice, As I'm trying to master Monitor Pro.

Thanks

 

((I have a DDE app demo if you are interested in learning more.))

Sure, It'll be very nice, As I'm trying to master Monitor Pro.

The forum doesn't support attachments, Right?

Here's my email:

[email protected]

Thanks

 

Making an OPC connection to a Monitor Pro (FactoryLink) server costs 1 license. :-(
The licenses are counted per IP address, so if you have LabView running on the same Pc as the Client Builder, then it should share the same license as the CB.

Anyway, what kind of XY graph do you need to display? May be able to help you with an active-x which you can use in a CB mimic...