Time Stamp

[vasgeo]

Hi Jeff,

Thanks for answering me.I really appreciate that!

I’ve got an error saying “NI-488: Command requires GPIB Controller to be Controller-In-Charge” in Scan form string in the xl to time part. And the x axis still doesn’t display the correct time. I don’t know what is happening here, but that code you sent me doesn’t display correctly the line on the xy graph (even though everything you said make perfect sense) . In fact it doesn’t display anything at all. I’ve replaced your code (XL to Tome) with other one and it shows the table and some lines on the xy graph, but still not right. However, when I wired the waveform graph after Index Array  (subarray) appears to display the line correctly (did it just to check).Would you look at my code when you have time? I’m pretty confused. What I did wrong? 

[vasgeo]

This is the error that I'm getting.

[Dennis_Knutson]

A graph will not display the x axis correctly because your data has problems. There's a row with 0 for a time and the time increments up, goes backwards, increments up, etc. Just wire column 0 as a numeric to a regular graph. What did you do? Combine data from different files?

[JÞB]

LET US SEE ..... Excel keeps time as fractional days since epoch.  I can see the 86400 seconds times the integer portion of the value scanned + offset working.  What is with the lower scan from string that is scanning the digits BEHIND the decimal and treating them as integer days as well?

Scan the value to float (the second scan has no decimal place- you removed it with the first scan so you cast 99.888 to 99 and 888.  the 888 has greater value)

[vasgeo]

Hi Dennis,

I didn’t combine data from different files. That is the original file. The rows with 0 for time exist because the system (in the Lab we have proprietary reactor for growing Gallium and Indium Nitrides. The csv files come from another LabVIEW program controlling the reactor) stopped several times abruptly for other reasons. However, I’ve got uninterrupted scv files where the same problem exists.  And, yes, the time increments up, goes backwards, increments up, etc., I also noticed that. Don’t know what caused it. But when I converted it to time everything is ok but I’m still having problems displaying it on the x axis.

[Dennis_Knutson]

Everything is OK and you are having display problems. One or the other. Desribe in detail what the problem might be. With the bugs in the data, your data will obviously not display 'correctly'. It will certainly not look at all like the graph with the raw data and no timestamp info. In order for that to happen, your timestamp would have to consistently increment with each row.

You have bugs in the program doing the recording. Really should consider fixing that first.

[Ben]

---

@Dennis Knutson wrote:

Everything is OK and you are having display problems. One or the other. Desribe in detail what the problem might be. With the bugs in the data, your data will obviously not display 'correctly'. It will certainly not look at all like the graph with the raw data and no timestamp info. In order for that to happen, your timestamp would have to consistently increment with each row.

You have bugs in the program doing the recording. Really should consider fixing that first.

---

You left out the phrase "garbage in garbage out."

Ben

[vasgeo]

Ooops, I lied. The converted time is not OK. But still I have the same problem with files containing correct order of timestamps.

[Dennis_Knutson]

Post one of these files with correct time stamps and your current VI that shows the problem. Do this by running the VI and then selecting Edit>Make Current Value Default. Save the VI before attaching.

[vasgeo]

Hi Dennis,

Yes, you were right! The problem is in the program doing the record of the timestamp. Everything works perfect now with the correct timestamp. I have forgotten several times to use the function that switches off the headers while working with the correct timestamp. Pretty stupid, eh? I think I definitely need a break.

Now I have to find out how to do multi-plots.

Thanks for the help!!!

I really appreciate that!

Happy holidays!