Help with File Dialog Express VI while saving an Excel File

[Jalashwa]

Hi Everyone,

Greetings !

I am making a VI to record data from a  Eurotherm Temperature Controller and saving the data into a excel file. The user needs to select the location of the file and the file name. I have been using a lot of options for this task finally I seem to be having a stable VI for it. However,  I do not understand something about this VI.

Whenever I run this VI I get two dialog boxes to select a file. One is for opening (which doesnt have any effect on the VI execution) and the other is for saving the excel. 

I don't have any clue as to why I am having both these dialog boxes. 

Could someone please help me understand the reason for particular behaviour and suggest ways to eliminate them.

I have attached the VI and the snapshot as well. 

Looking forward to your help as always.

Kind Regards,

Jalashwa

[GerdW]

Hi Jalashwa,

I don't have any clue as to why I am having both these dialog boxes.

But you created this VI - and made all those settings in the ExpressVIs!

Check the settings for the WriteMeasurementData-ExpressVI: you did enable the file dialog explicitely…

[weeksmr]

Hi Jalashwa,

Attached is revised version of your VI.

I noticed a couple of things, you don't need to have 2 different calls to establish your desired file name and location. Only make this call one time when you want to save your data.

Also, if you are wanting to save all of your data, you need to use a mechanism to store that data into memory until you are ready to save it to disk. I used an append to array function with a shift register. There is also an option in the attached VI to save all of your data or just the last acquired waveform.

Hope this helps.

Mike

[JÞB]

---

@thinkGerdW wrote:

Hi Jalashwa,

 Think "Dataflow"

I don't have any clue as to why I am having both these dialog boxes.

But you created this VI - and made all those settings in the ExpressVIs!

Check the settings for the WriteMeasurementData-ExpressVI: you did enable the file dialog explicitely…

---

And, those settings conflict.  What where you thinking? "Run as fast as possible" , a 100mSec duration and a 1000 mSec wait in the outer loop?  That won't work even after you provide some data dependency between the two express vis

Hold it! the first express vi REQUIRES you to select a new file.  what does the next one do if the file exists?  It wouldn't want you to "Rename the existing File" would it?

Spoiler

Yup, oh snap! it does!

So, are you laughing yet?  - Or is this more of a "Next-day funny" moment?

[Jalashwa]

Hi Mike,

Thanks for your help.

However, I could not open the VI as I run LabVIEW 13 and your VI was made in LabVIEW 16.

Could you resend the VI for LV 13 please  

BR,

Jalashwa

[Jalashwa]

Hi Gerd,

I use LabVIEW which is in German, a language am not very proficient in so I miss out on somethings

I did try some of the setting but did not achieve what I wanted. 

Thanks a lot for your help 🙂

[GerdW]

Hi Jalashwa,

well, I also use the German LabVIEW version… 😄

(You will find the English LabVIEW help on NI's website so you could read the help in two languages! ;))

This is (a part of) the config dialog for WriteMeasurementData ExpressVI:

The red marked boolean input dis-/enables the file dialog of the WriteMeasurement-ExpressVI. You enabled the file dialog - and then wondered about the second file dialog…

[weeksmr · Accepted solution]

Hi Jalashwa,

You're welcome, glad to help.

Please see the attached file, saved in LV2013 (let me know if you are unable to open it).

Thanks.

Mike

[Jalashwa]

Thanks a lot Mike 

[weeksmr]

Hi Jalashwa,

You're welcome, glad that we were able to help you.

Thanks.

Mike