Our full technical support staff does not monitor this forum. If you need assistance from a member of our staff, please submit your question from the Ask a Question page.


Log in or register to post/reply in the forum.

Datatable problems

SEWESA Nov 19, 2010 05:56 PM

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

jtrauntvein Nov 19, 2010 09:00 PM

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.

SEWESA Nov 22, 2010 06:23 PM

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.

jtrauntvein Nov 22, 2010 07:26 PM

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.

Log in or register to post/reply in the forum.