Hiya,
I'm having a pretty strange problem with one of my datables.
Here is the syntax...
DataTable(Yearmaxmin,True,365)
DataInterval (0,1,Day,10)
Sample (1,clk(9),fp2)
Maximum (1,AirTempF,FP2,False,True)
Minimum (1,AirTempF,FP2,False,True)
EndTable
Now when I collect the data from this table I am getting this.. (viewing with Notepad)
"TOA5","Sew_Profiler","CR1000","19179","CR1000.Std.15","CPU:SEW_Profiler2.CR1","18810","Yearmaxmin"
"TIMESTAMP","RECORD","clk","AirTempF_Max","AirTempF_TMx","AirTempF_Min","AirTempF_TMn"
"TS","RN","","Deg F","Deg F","Deg F","Deg F"
"","","Smp","Max","TMx","Min","TMn"
"2010-11-19 00:00:00",0,322,46.1,"2010-11-18 12:44:27",41.62,"2010-11-18 22:47:18"
However on this datatable which is set up the same way
DataTable(MaxMin,True,24)
DataInterval (0,1,Hr,10)
Sample (1,clk(9),fp2)
Maximum (1,AirTempF,FP2,False,True)
Minimum (1,AirTempF,FP2,False,True)
EndTable
I get this type of output (which is the output I desire)
101,2010,320,000,0,319,57.31,1634,24,48.06,2327,27
101,2010,321,000,0,320,53.8,1236,27,47.45,231,42
101,2010,321,1200,0,321,50.02,1122,33,47.94,1200,0
101,2010,321,1200,0,321,50.02,1122,33,47.94,1200,0
101,2010,321,1300,0,321,48.74,1248,45,47.02,1222,30
101,2010,321,1400,0,321,48.4,1300,33,46.68,1359,48
101,2010,321,1500,0,321,46.16,1413,57,44.77,1459,57
101,2010,321,1600,0,321,44.82,1500,18,44.07,1531,6
101,2010,321,1700,0,321,44.75,1657,15,43.68,1633,57
Any ideas as to what might be happening?
Thanks for any help
The format of data files written as a result of collecting data from CR1000 tables is governed by the "Output Format" field in the setup screen and is set on a per-table basis. You need to select the "Array Compatible CSV" option for each table that you want to output this format.
Thanks jtrauntvein,
I went through all of my data tables and set them to "Array Compatible CSV" formate.
Question though...will this take effect immediately or do I need to do something after I set this option?
Thanks for the help.
The changes that you made will be applied for any data that is collected after you applied the changes. It will not collect the format of data that has already been collected.