Simply, I am creating 8 collumns of data from a 8 channels on a DAQ and saving them to a tab delineated transposed file. I need to creat a preceding 9th collumn that is contains timestamps of every row. I also need to creat collumn headers and a title above the collumns. I wasn't sure how to search for this, but from what I did search, I couldn't find anything. If there is something that explains this well, please let me know. I am just learning this program for my internship and need to learn it very fast to get up to speed with the group.
Thanks for the post and I hope your well today.
When using a DAQ you should be able to acquire a waveform. The wavefrom data type includes timing and the data. Then you could just include as another signal for when you write to the file. Have you got any example code you could post? - I would like to know more about how your saving to file to help answer your question.
However, some links:
How Do I Include a Time Stamp in a File Using the Write To Measurement File.vi
Writes time stamp and headers as a comment into the file.
Hope this helps, and I look forward to hear from you soon.
My experiment is hooked up to a computer that doesn't have internet, and this computer in my office doesn't have LabView. It's all very sensible! So, I can't view the file in that link. Could you email it to me? How can I send you my file?
Why would you convert the dynamic data from the DAQ Assistant to a 2D DBL and use the Write to Spreadsheet File? You are throwing away all of the time information and column headers. Use Write to Measurement File if you are going to use the DAQ Assistant Express VI.
Your use of the Write to Spreadsheet function is also incorrect. Wiring a Date/Time string to the format input does not make any sense.
p.s. You also want to be a bit more carefule about which forum you post to. You posted to the Digital I/O board and your question has nothing to do with that. You would have been better posting such a generic question to the LabVIEW board.
Apologies. I didn't actually specify a group; I just filled out a form and it put it in this forum.
As for the date/time string attached to the spreadsheet, that must be just a left over from things I was trying to do that didn't work. So are you saying if I use the write to measurement file, it will accomplish my goals?
I am going to try the Write to Measurement file function as well as the other mentioned and see what results they produce in a minute,
As for the title, I would simply like to produce some type of comment/string at the top of each set of data that says, in this case, which seal I am testing. This means I would want a prompt to the user as to what the seal type is at the beginning of each run which would then be placed in that title. Does that make sense?
I have tried the Write To Measurement file and it works just fine I think, except that I can't figure out how to label the headers with more than 'untitled' and 'x-label'. I need to be able to use comments on them, but I can't get that to work. I tried cacantenated strings, but it keeps giving me an error.
Any idea how? I checked the forum and someone posted a small picture, but I am new to this and do no understand how to use the information. Could you explain how to accomplish this tasks, perhaps with a picture of the diagram?
Do you wish this label to be the first line of the header? If that's the case, the easiest way may be use one of the low level file write functions after the lvm file has been created. You don't have a lot of options of customizing the Write to Measurement File. It's designed for beginners even if you do manage to modify the source code, the file couldn't be read by the Read From Measurement File. Instead of inserting a label in the header, could you distinctly name the file itself?
On the other hand, you've gotten some help in your other thread on how to use the Write to Spreadsheet File. With this and some other low level functions, you can create the file in any format that you want. It's a matter of using an easy to use function with limited options or writing your own code with unlimited options.