274
APPX
Appendix 5 CSV File Format
CSV file for engineering
The format of a CSV file for engineering is the same as that of a CSV file for object list which is regulated by the Institute of
Electrical Installation Engineers of Japan.
If a value outside the range is set, the data in the corresponding row will not be added and overwritten to a BACnet module.
*1 REAL type and INTEGER type are available for the Scale property of Accumulator objects.
When registering object data using a CSV file, set a value to the column No.35 as follows.
REAL type: Set a value as it is. (Example: 0.1, 100.0)
INTEGER type: Set a value in the format of '1.0e+N' or '1.0e-N' (N indicates an arbitrary integer value.).
'1.0e+2' indicates the square of 10 (100), and '1.0e-3' indicates the minus cube of 10 (-0.001).
Column
No.
Column
comment row
Description of data row Remarks
1 75 Object identifier ObjectIdentifier
2 77 Object name ObjectName
3 79 Object type ObjectType
4 -1 Instance number
5 117 Unit Units
6 65-1 Maximum current value MaxPresValue
7 69 Minimum current value MinPresValue
8 72 Notification type NotifyType
9 45 Upper limit HighLimit
10 59 Lower limit LowLimit
11 46 Inactive text InactiveText
12 4 Active text ActiveText
13 84 Polarity Polarity
14 43 File type FileType
15 42 File size FileSize
16 74 Number of state NumberOfState
17 110-1 State text 1 StateText[1]
18 110-2 State text 2 StateText[2]
19 110-3 State text 3 StateText[3]
20 110-4 State text 4 StateText[4]
21 110-5 State text 5 StateText[5]
22 110-6 State text 6 StateText[6]
23 110-7 State text 7 StateText[7]
24 110-8 State text 8 StateText[8]
25 110-9 State text 9 StateText[9]
26 110-10 State text 10 StateText[10]
27 17 Notification class NotificationClass
28 132-1 Log device object property 1 LogDeviceObjectProperty[ObjectID]
29 132-2 Log device object property 2 LogDeviceObjectProperty[PropertyID]
30 132-3 Log device object property 3 LogDeviceObjectProperty[ArrayIndex]
31 132-4 Log device object property 4 LogDeviceObjectProperty[DeviceID]
32 134 Log interval LogInterval
33 126 Buffer size BufferSize
34 65-2 Maximum current value of an Accumulator
object or maximum count value of a Keiryo
object
MaxPresValue/Maximum count value
35 187 Scale property of an Accumulator object
*1
or
weight of a Keiryo object
36 75-1 Referenced object 1
37 75-2 Referenced object 2
38 -2 Memo