beautypg.com

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

Page 85

background image

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