Factory Asset Import

Bulk create or update factory assets with their associated smart devices. Designed for factory-level asset registration before deployment to outlets.

See Overview for authentication, file formats, response structure, and import order.

Endpoint

POST https://portal.coolrgroup.com/Controllers/Import.ashx?type=FactoryAsset

UI access

• Portal: Asset Management → Factory Assets → Select Import Type: "Factory Asset"

Columns

Formats: .csv, .xlsx / .xls, .json — Download template

Column	Alias	Required	Type / Max Length	Validation	Notes
Asset serial number	AssetSerialNumber	Yes	String, max 200	Must be non-empty	Unique identifier for the asset
Asset Type	AssetType	Yes	String, max 200	Must match an existing Asset Type	Asset Type must be created first
Smart Device serial	SmartDeviceSerialNumber	Yes	String, max 200	Must be non-empty	Serial number of the linked smart device
Outlet Code	LocationCode	No	String, max 50	Must match an existing outlet	Pre-assigns asset to an outlet on import
Tag Number	TagNumber	No	String, max 200	—	Reference tag number

Examples

CSV

Asset serial number,Asset Type,Smart Device serial,Outlet Code,Tag Number
SN123456789,Vertical Cooler,SD-987654321,NYC-001,TAG-001
SN123456790,Horizontal Freezer,SD-987654322,,TAG-002

JSON

{
  "data": [
    {
      "AssetSerialNumber": "SN123456789",
      "AssetType": "Vertical Cooler",
      "SmartDeviceSerialNumber": "SD-987654321",
      "LocationCode": "NYC-001",
      "TagNumber": "TAG-001"
    },
    {
      "AssetSerialNumber": "SN123456790",
      "AssetType": "Horizontal Freezer",
      "SmartDeviceSerialNumber": "SD-987654322",
      "TagNumber": "TAG-002"
    }
  ]
}

API import

curl -X POST 'https://portal.coolrgroup.com/Controllers/Import.ashx?type=FactoryAsset' \
  -H 'Cookie: .ASPXAUTH=your-auth-token' \
  -F 'file=@factory-assets.csv'

Replace factory-assets.csv with factory-assets.xlsx or factory-assets.json as needed.

Response

See Overview - Response format for response structure and error handling.

Common errors

Error	Cause	Fix
Missing required field: Asset serial number	Empty asset serial number	Fill in Asset serial number for every row
Missing required field: Asset Type	Empty asset type	Fill in Asset Type for every row
Missing required field: Smart Device serial	Empty smart device serial	Fill in Smart Device serial for every row
Asset Type '[name]' not found in system	Asset Type doesn't exist	Create the Asset Type first via Asset Type Import
Outlet Code '[code]' not found	Outlet doesn't exist	Create the outlet first via Outlet Import

---

For support, contact support@coolrgroup.com