my timestamps are wrong when exporting waveform to excel

[shoemakesmusic]

i am trying to export waveform data using the "export waveform to spreadsheet.vi" and i want to know how to get the correct timestamps with it.  The timestamps that do show up in excel are the default "1903 01/01".  My graph, however, is showing the current date and time.  IF anyone could help, that would be great!


thanks!

[Christian Mergl]

Hi,

I allready tried it out now without problems. I started the vi, saved the file (test.xcl), opened with excel and had the actual date and time!

Could it be that your computer time is not correct?

Christian

[chrisger]

hi there

make sure that the spreadsheet file shows the correct timestamps. then you should try to set the format of the first column in excel to a user format something like "TT.MM.JJJJ hh:mm:ss,000" before opening the file. 

[shoemakesmusic]

thanks for the reply.  my computer time is correct.  i am using a local variable of the graph and connecting that to the export.vi
what did you use?

[Christian Mergl]

I tried the example "export waveform to spreadsheet.vi" without any changes and everything works fine!

Christian

[Dennis_Knutson]

While using a local variable might be bad style, the only problem might be if you had a race condition and you are reading the local variable before it is written to. What is generating the waveform data? If you set a breakpoint and step into the Export Waveform function, is the data correct on the front panel or is the timestamp information missing there? Could you post an image of the block diagram and one of the files you've exported?

[shoemakesmusic]

i am also trying to use the "historical data to spreadsheet file.vi" for waveforms that are in citadel but that is also producing the same result. 

[chrisger]

hi there

please post some lines from the files you created

[Tunde]

Can you post the code?

Thanks

T.A.

[NathanT]

What happens when you try the "export waveform to spreadsheet.vi"

Thanks,

Nathan