Auto-channel creation via FRF files

With the Flat-File Reading Format (FRF), use the EndpointUOMID. FRF is a comma-separated value (CSV) format. For available UOM IDs, see the Units of measurement matrix on page 1.

The following example creates Watt-hours Received (Wh r). Note that the FRF table's ChannelID column must contain the value "DEVICE_ID:Wh r" and the ChannelIDType column must contain the value "EndpointUOMID".

ChannelID,ChannelIDType,MarketType,EndTime,DataValue,IntervalLength,WARNING,FAILED,ESTIMATED,DELETED,MISSING,POWER,EDITED
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 0:00,362.544,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 1:00,620.663,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 2:00,350.544,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 3:00,760.555,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 4:00,270.427,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 5:00,140.524,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 6:00,320.531,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 7:00,910.573,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 8:00,460.58,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 9:00,580.584,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 10:00,650.594,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 11:00,140.545,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 12:00,930.383,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 13:00,350.374,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 14:00,240.392,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 15:00,770.424,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 16:00,280.333,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 17:00,910.352,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 18:00,240.288,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 19:00,460.298,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 20:00,450.24,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 21:00,970.216,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 22:00,430.277,60,0,0,0,0,0,0,0
DEVICE_ID:Wh r,EndpointUOMID,Electric,5/26/2015 23:00,910.274,60,0,0,0,0,0,0,0

Note: After creating or editing an FRF import file as an Excel spreadsheet, be sure to save the data import file as a .csv file.