LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Data saving with time

Solved!
Go to solution

Hello, 

I am trying to save time with data in MS excel sheet. I am using "File I/O > Write to measurement file" option. But can't succeed. I have attached a picture of setting. Any suggestion would be appreciated. 

0 Kudos
Message 1 of 16
(3,606 Views)

Hi Milon,

 

I am using "File I/O > Write to measurement file" option. But can't succeed.

Where are you trying to save "time with data"? All you do is using a tmestamp for filename creation…

I guess you want to have a column with timestamps in your Excel sheet!?

 

Any suggestion would be appreciated. 

Do you know the problem with using ExpressVIs? (Apart from DDT wires?)

They only support exactly the functionality they are made for!

When you want to achieve goals with functions not included in ExpressVIs you need to get rid of those ExpressVIs and create your own tool…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
Message 2 of 16
(3,603 Views)

Hello Mr. GerdW,

Greetings. Sorry for my poor explanation. Yes I want a column with timestamps along with data column in my excel sheet. Is it possible using 'write to measurement file.VI'?

 

If not, I have attached another picture here related with data saving with time. But can't understand instructions, specially 3 and 4.

0 Kudos
Message 3 of 16
(3,594 Views)

Hi milon,

 

Item 3+4 are used to create a valid filename ( in a complicated way), but still that example only isesthe timestamp for filename creation.

 

No, you will not reach your goal using that ExpressVI...

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
Message 4 of 16
(3,566 Views)

Hi Mr. GerdW,

Would you please suggest any simple way to do it (data with time)? 

0 Kudos
Message 5 of 16
(3,538 Views)

Hi Milon,

 

here you go:

check.png

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
Message 6 of 16
(3,528 Views)

Actually, the express vi can be configured to add a time column and even supports changing the time format

Capture.PNG

 

And the novice that wrote that example did not know that Format Date Time has a format specifier input

Close.png

%y - Year within century (0-99)

%j - Julian date (0-366)

%H - Hour (0-23)

%M - Minute (0-60)

No special characters!

 


"Should be" isn't "Is" -Jay
Message 7 of 16
(3,522 Views)

Hi Jeff,

 

thanks for your correction.

(Maybe I should lower my bias against ExpressVIs to notice their capabilities…)

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
Message 8 of 16
(3,519 Views)

@GerdW wrote:

Hi Jeff,

 

thanks for your correction.

(Maybe I should lower my bias against ExpressVIs to notice their capabilities…)


I wouldn't want you to lower your bias.  The Write Measurement File Express vi still uses the dreaded DDT and hides a whole lot of configuration information that can't be debugged from a *.jpg


"Should be" isn't "Is" -Jay
Message 9 of 16
(3,516 Views)

Express VI's are only there for those 2 hour LabVIEW classes sales pitches to show managers and other non programmers how you can "just throw something together" in LabVIEW without knowing anything.

 

But in real world applications Express VI's fail more often than not. 

========================
=== Engineer Ambiguously ===
========================
Message 10 of 16
(3,504 Views)