12-14-2011 12:03 AM
Hello. I came here for advice on on how to store data. What I am trying to do is take the data aquired by my DAQ, and store all it in a table as it's aquired in an organized way(3-columns, with a time stamp.) So far, I've looked at the Write to Text .vi and Write to Spreadsheet, along various other .vis I've found here, and I haven't been able to answer my problem. Using Write to text, I've been able to save things to text and append future data to them, but I ran in to the problem of not knowing how to append commas to keep it organized and give time(I would love for the data to look like the file Write to Text churns out.)
I haven't been able to run Write to spreadsheet yet, as until recently, I haven't been able to get rid of all the errors preventing from running, and I can't test it right now, though I would prefer to have everything in a text format, as the comp I use lacks Excel.
Solved! Go to Solution.
12-14-2011 12:36 AM
HI,
To format the data what you have in your array, you can use array to spread sheet string vi to convert the data in array to a text format... check this vi
12-14-2011 12:48 AM
same vi down converted as it s in 2011..
12-14-2011 01:15 PM
Thank you. It works really well now. This is what my new and improved VI looks like now. My only issue is that sometimes, there's a jolt that pushes the y in to the millions range while everything after it is single digits. I'm thinking it might be related to me turning on the DAQ too quickly, as sometimes when I wait a few seconds after turning the DAQ on before turning on the VI, I don't have this problem. I also uploaded the text file created too, if that helps.
12-14-2011 03:05 PM
Sorry, I can't find the eidt post function, but I'm trying to use multiple counting channels rather than just one. Is there a way to do that with one DAQ?
12-15-2011 01:00 AM
As a first thought what i feel is the DAQ is not closing properly before the next run as a result there will be a junk value in the beginning..
what you can try is flush the channel data before every start or after initialisation a bit of delay before scanning the data also would help...
and aslo there will be an option to select the range of channel i guess..
please ignore the above comments if thats wrong..(sorry in advance....)
12-15-2011 09:28 PM
No need to apologize. You're the one helping, after all. I just wanted to know if there was anything I could put in the .vi to prevent it.
Well, in addition to that I have another problem. For my experiment, I was told that having three channels would be best, so I copied the DAQ 3 times with each corresponing to a different channel, for more results.
What I want it to do is make the .vi so that counters corresponding to counters 2 and 3 correspond to channels 1 and 2 by default, rather than 0.
I'll upload the .vi and some screenshots, to make sure I'm doing things right.