2 toa5 ascii file format – Campbell Scientific CR9000X Measurement and Control System User Manual
Page 85

Section 2. Data Storage and Retrieval
2.4.2 TOA5 ASCII File Format
TOA5 data files are stored in a comma separated format. Header
information for each of the columns is included, along with field names and
units of measure if they are available. TOA5 file formats can be created
with or without Time Stamps and Record Numbers.
Figure 2.4-2 shows an example of a data file collected as TOA5 with time
stamps and record numbers. The Data file was collected using RTDAQ's
collection window.
"TOA5","LogName","CR9000X","1045","CR9000X.STD05","CPU:Data.C9X","2373","Temp"
"TIMESTAMP","RECORD","TRef","TC_Avg(1)","TC_Avg(2)","TC_Avg(3)","TC_Avg(4)"
"TS","RN","deg_C","deg_F","deg_F","deg_F","deg_F"
"","","Smp","Avg","Avg","Avg","Avg"
"2009-10-27 16:40:43.42",0,29.94,25.6,25.36,25.48,25.4
"2009-10-27 16:40:43.43",1,29.93,25.6,25.36,25.41,25.35
FIGURE 2.4-2. TOA5 with timestamps and record numbers
Figure 2.4-3 shows how the data from Figure 2.4-2 might look when
imported into a spreadsheet.
TOA5
LogName CR9000X 1045
CR9000X.STD.05 CPU:Data.C9X 2373
Temp
TIMESTAMP
RECORD TRef
TC_Avg(1) TC_Avg(2)
TC_Avg(3)
TC_Avg(4)
TS
RN
Deg_C
Deg_F
Deg_F
Deg_F
Deg_F
Smp
Avg
Avg
Avg
Avg
2009-10-27 16:40:43.42 0
29.94
25.6 25.36
25.48
25.4
2009-10-27 16:40:43.43 1
29.93
25.6 25.36
25.41
25.35
FIGURE 2.4-3. Spreadsheet of TOA5 with timestamps and record
numbers.
Figure 2.4-4 shows the same data table collected as TOA5 without Time
Stamps or Record Numbers.
"TOA5","LogName","CR9000X","1045","CR9000X.STD.05","CPU:Data.C9X","2373","Temp"
"TRef","TC_Avg(1)","TC_Avg(2)","TC_Avg(3)","TC_Avg(4)"
"Deg_C","Deg_F","Deg_F","Deg_F","Deg_F"
"Smp","Avg","Avg","Avg","Avg"
29.94,25.6,25.36,25.48,25.4
29.93,25.6,25.36,25.41,25.35
FIGURE 2.4-4. TOA5 without timestamps and record numbers
Figure 2.4-5 shows how the TOA5 data without Timestamps and Record
Numbers from Figure 2.4-4 might look when imported into a spreadsheet.
TOA5
LogName
CR9000X
1045
CR9000X.STD.05 CPU:DAT.C9X 2373
Temp
TRef
TC_Avg(1)
TC_Avg(2)
TC_Avg(3)
TC_Avg(4)
Deg_C
Deg_C
Deg_F
Deg_F
Deg_F
Smp
Smp
Avg
Avg
Avg
29.94
25.6 25.36 25.48 25.4
29.93
25.6 25.36 25.41 25.35
FIGURE 2.4-5. Spreadsheet of TOA5 without timestamps and
record numbers
2-13