Asset Type Import

Bulk create or update asset type definitions (cooler and freezer models). Existing asset types are matched by Model Number + Manufacturer and updated in place.

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

Endpoint

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

UI access

• Playbook App: Master Data → Asset Types → Manage Data → Import

Columns

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

Column	Alias	Required	Type / Max Length	Validation	Notes
General Information
Asset Type	AssetType	Yes	String, max 100	Must be non-empty	Asset type name
Model Number	ModelNumber	Yes	String, max 270	Must be non-empty	Combined with Manufacturer to match existing records
Manufacturer	—	Yes	String, max 300	Must be non-empty	—
Door Handle Location	DoorHandleLocationType	Yes	String, max 200	Left, Right, Magnet (Top Mount), No Door, Bottom Mount	Case-insensitive
Capacity & Structure
No. Of Doors	Doors	No	Integer, ≥ 0	—	—
Shelves	—	No	Integer, ≥ 0	—	—
Columns	—	No	Integer, ≥ 0	—	—
Lifecycle
Life	—	No	Integer, ≥ 0	—	Expected lifespan (years or months per system config)
Warranty	—	No	Integer, ≥ 0	—	Warranty period (years or months per system config)
Physical Dimensions
Cabinet Height	CabinetHeight	No	Decimal	—	Height measurement
Cabinet Width	CabinetWidth	No	Decimal	—	Width measurement
Configuration
Temperature Offset	TemperatureOffset	No	Decimal, -5 to 5	-5 to 5	Temperature calibration adjustment
Integration
External Code	ExternalAssetTypeCode	No	String, max 200	—	Your internal system's identifier for this asset type. Used as an alternative match key — see Overview

Examples

CSV

Asset Type,Model Number,Manufacturer,Door Handle Location,No. Of Doors,Shelves,Columns,Life,Warranty,Cabinet Height,Cabinet Width,Temperature Offset,External Code
Vertical Cooler,VC-2000X,CoolTech Industries,Left,2,5,3,10,2,180.5,80.0,0.5,EXT-VC-2000X
Horizontal Freezer,HF-5000,FreezeCorp,No Door,1,3,2,8,1,150.0,120.0,-0.5,EXT-HF-5000

JSON

{
  "data": [
    {
      "AssetType": "Vertical Cooler",
      "ModelNumber": "VC-2000X",
      "Manufacturer": "CoolTech Industries",
      "DoorHandleLocationType": "Left",
      "Doors": 2,
      "Shelves": 5,
      "Columns": 3,
      "Life": 10,
      "Warranty": 2,
      "CabinetHeight": 180.5,
      "CabinetWidth": 80.0,
      "TemperatureOffset": 0.5,
      "ExternalAssetTypeCode": "EXT-VC-2000X"
    },
    {
      "AssetType": "Horizontal Freezer",
      "ModelNumber": "HF-5000",
      "Manufacturer": "FreezeCorp",
      "DoorHandleLocationType": "No Door",
      "Doors": 1,
      "Shelves": 3,
      "Columns": 2,
      "Life": 8,
      "Warranty": 1,
      "CabinetHeight": 150.0,
      "CabinetWidth": 120.0,
      "TemperatureOffset": -0.5,
      "ExternalAssetTypeCode": "EXT-HF-5000"
    }
  ]
}

API import

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

Replace asset-types.csv with asset-types.xlsx or asset-types.json as needed.

Response

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

Common errors

Error	Cause	Fix
Missing required field: Asset Type	Empty asset type name	Fill in Asset Type for every row
Missing required field: Model Number	Empty model number	Fill in Model Number for every row
Missing required field: Manufacturer	Empty manufacturer	Fill in Manufacturer for every row
Door Handle Location must be one of - Left, Right, Magnet, Top Mount, No Door, Bottom Mount	Invalid handle location	Use supported handle location values

---

For support, contact support@coolrgroup.com