Dear experts,

I have a rather interesting problem, here is some technical background:

 I have S120 siemens drive together with PLC and HMI unified comfort panel. I am using it at the university and the goal is to create laboratory exercise for students. I have a program, that controls motor connected to S120 and measures actual speed. The goal is to visualize measured actual speed of the motor in the HMI panel and also to export it into csv file and store it to flash disc that is put to the HMI. This alone would not be problem and I know how to do it. 

The problem is, that when I use data logging and the trace functionality of the HMI, it can only save the tag once per 500 ms. That is waaaay too long for our measurement. I need to measure at least once every 100 ms, even better would be once every 50 ms.

My solution was to create my own program, that saves actual speed in array of [100] lreals (100 because it fits the time of the measurement) and array of [100] time in DB in PLC. This program works and these data are great and usable. The problem is, that it feels like, there is no possibility to export these two arrays into csv file and save it to the flash disc in HMI. There shouldn't be problem sending these arrays from PLC to HMI (I hope). But I do not know how to create and export CSV file with these data. 

Is there possibility to use scripts, that are inside of HMI maybe?
I know it could most likely be done with OPC UA, however I do not have PC with OPC UA nor OPC UA license.
Some topics on this forum suggest VB scripts in HMI, however I do not have them in my Tia portal so I asume, they are also viable only with licence?

Or is there any other way to do this?

Thank you very much for any replies.

Thank you for your suggestion! I will try it on Monday when I am in the laboratory again. I have one question though, what functionality do I use to export this tag to USB as CSV? Is there some function that I am unaware of? 

Thank you very much for your reply!

0_Einstein

Create an HMI tag for the array of 100 LREAL data points.

Put that array on a screen with a drop down where the array index is selected by the activating the drop-down.  This will cause the HMI to request the array data from the PLC and have it in the HMI memory.

Now, drag it off screen so it is not visible (this may generate a warning during compile, but you can ignore it).

Now, you can export tag to USB as CSV.

This is not tested nor applicable to every HMI, but should work.

It may need to be modified if LREAL are not allowed on your HMI.  You can bring them into an array of DWORD and let the interpretation be left for handling after using the CSV - possibly in a PC in a spreadsheet application perhaps.

AutoGen_5985376

Dear experts,

I have a rather interesting problem, here is some technical background:

 I have S120 siemens drive together with PLC and HMI unified comfort panel. I am using it at the university and the goal is to create laboratory exercise for students. I have a program, that controls motor connected to S120 and measures actual speed. The goal is to visualize measured actual speed of the motor in the HMI panel and also to export it into csv file and store it to flash disc that is put to the HMI. This alone would not be problem and I know how to do it. 

The problem is, that when I use data logging and the trace functionality of the HMI, it can only save the tag once per 500 ms. That is waaaay too long for our measurement. I need to measure at least once every 100 ms, even better would be once every 50 ms.

My solution was to create my own program, that saves actual speed in array of [100] lreals (100 because it fits the time of the measurement) and array of [100] time in DB in PLC. This program works and these data are great and usable. The problem is, that it feels like, there is no possibility to export these two arrays into csv file and save it to the flash disc in HMI. There shouldn't be problem sending these arrays from PLC to HMI (I hope). But I do not know how to create and export CSV file with these data. 

Is there possibility to use scripts, that are inside of HMI maybe?
I know it could most likely be done with OPC UA, however I do not have PC with OPC UA nor OPC UA license.
Some topics on this forum suggest VB scripts in HMI, however I do not have them in my Tia portal so I asume, they are also viable only with licence?

Or is there any other way to do this?

Thank you very much for any replies.

Jacob

 

Hello AutoGen_5985376

for general help in JAvascripting  you should have a look at this FAQ Chapter 5.8:

https://support.industry.siemens.com/cs/de/en/view/109758536

Bye Murof

 Thank you for the link. I am trying to make it work, but so far the biggest problem for me is the part where you say:

 "Put that array on a screen with a drop down where the array index is selected by the activating the drop-down.  This will cause the HMI to request the array data from the PLC and have it in the HMI memory.

Now, drag it off screen so it is not visible (this may generate awarningduring compile, but you can ignore it)."

It seems I am not able to do that, maybe I am just dumb. I created the Array of 100 Lreal (by making ocnnection from PLC). Now I am trying to put it on screen with the dropdown (I dragged it from tedails view into the screen), but Tia says, that my tag is invalid datatype (Screenshot in attachment).

Other than this, I tried making CSV file with JS function write and I was sucesfull, so I hope once I get this going, it will be working.

Thank you for your help once again.

0_Einstein

https://www.youtube.com/watch?v=wFXAXEadgzM

AutoGen_5985376

Ok, thank you for suggestion. I will try it on Monday when I am in a laboratory where I have the testbed. I have one question though, what functionality do I use to export this tag to USB as CSV?

Thank you very much!

 So I managed to make it as multiplexed tag. It works in a way... When I add it to the screen and change the index tag, that is assigned to it, then I can access different values inside the array deppending on the value of the index tag. However it doesnt seem to be too convenient... Since I need to write all 100 values of the array inside the CSV file. 

But when I try to access the array for example in read instruction:

something = Tags("Setpoint_data[Index_dat]").Read();

It doesnt let me. I have to put inside the Read instruction only Something = Tags("Setpoint_data"); and along with that change index_dat with write instruction...

Is there any other better way, there must be better way right?

Also, is there any good way to see what your js code is doing realtime? So you can debugg it?

Thank you for answers.

Hello AutoGen_5985376

you cannot do this like you try.

Just use the tagname of the multiplex tag in the script. then set the index tag of your multiplextag to change theindex. (use an interal Tag for the index no PLC tag!).

If you have a busy system or you use big datatypes (I have done this a lot of time with big UDTs) then it could be that you have to insert a little wait time in the script (only a few ms) to give the sysem time that the value of the multiplex tag can change.

But with an array of only 100 single tags you can also use an "array of" datatype in HMI here you can access thevalues with index in script also and you can read and write the whole array, so you would not have to care about value change (all aray items will be readed or written on block)

And here are some informtion to trace and debug:

https://support.industry.siemens.com/cs/de/en/view/109777593

https://support.industry.siemens.com/cs/de/en/view/109779192

Bye Murof

 Hello,

so I tried making it like you said. I made internal tag called Index_dat, which i used as index for the multiplextag. However, when I use the write() function to change the value of this tag, it does change the index tag, but I still read the same data in my for loop, where I am trying to read all 100 values one by one. Its like if the index tag changed, but the system still thinks it didn't change, because when I try to read all 100 values, they are all the same, which they should not be.. :(

I am using easy for loop:

akt_rychl_array[i] = Tags("Akt_rychl_Data").Read();   // this saves actual speed into internal hmi array

cas_osa_array[i] = Tags("Casova_osa_Data").Read().toString();  //// this saves time of measurement into internal hmi array

Later I just use function WriteFile to export these 3 internal arrays into CSV to USB stick. All 3 of these multiplexed tags have the same Index tag called Index_dat.

It is weird, because when the tag Index was in connection with PLC tag and not internal tag, it did change from where it was reading the values, its just that since acquision time is 100ms, it usually wrote 5 same values into array[0] to [4] then changed and wrote same value to array[5] - [9] and so on. Now there is same value from [0-100] like it didnt change the place, from which the value is read. However I see that the index is changing, because I have IO field which shows value of Index, and I clearly see, that when I run my script, that the Index goes from start value 0 to finish value 100...

Do you have any ideas what to do ? Maybe I could try to put that wait time you talked about? But I do not know how to do it. And more so, I have a feeling, it will not help..

In zip file there are pictures of the tags that are set.

Thank you for your responses, they keep my hopes alive.

Murof

Hello AutoGen_5985376

you cannot do this like you try.

Just use the tagname of the multiplex tag in the script. then set the index tag of your multiplextag to change theindex. (use an interal Tag for the index no PLC tag!).

If you have a busy system or you use big datatypes (I have done this a lot of time with big UDTs) then it could be that you have to insert a little wait time in the script (only a few ms) to give the sysem time that the value of the multiplex tag can change.

But with an array of only 100 single tags you can also use an "array of" datatype in HMI here you can access thevalues with index in script also and you can read and write the whole array, so you would not have to care about value change (all aray items will be readed or written on block)

And here are some informtion to trace and debug:

https://support.industry.siemens.com/cs/de/en/view/109777593

https://support.industry.siemens.com/cs/de/en/view/109779192

Bye Murof