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	—
Orientation Type	ChestCoolerType	Yes	String, max 200	Horizontal or Vertical	Case-insensitive
Door Handle Location	DoorHandleLocationType	Yes	String, max 200	Left, Right, Magnet, Shelf, or Under Shelf	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,Orientation Type,Door Handle Location,No. Of Doors,Shelves,Columns,Life,Warranty,Cabinet Height,Cabinet Width,Temperature Offset,External Code
Vertical Cooler,VC-2000X,CoolTech Industries,Vertical,Left,2,5,3,10,2,180.5,80.0,0.5,EXT-VC-2000X
Horizontal Freezer,HF-5000,FreezeCorp,Horizontal,Shelf,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",
      "ChestCoolerType": "Vertical",
      "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",
      "ChestCoolerType": "Horizontal",
      "DoorHandleLocationType": "Shelf",
      "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
Orientation Type must be either 'Horizontal' or 'Vertical'	Invalid orientation value	Use only Horizontal or Vertical
Door Handle Location must be one of - Left, Right, Magnet, Shelf, Under Shelf	Invalid handle location	Use only: Left, Right, Magnet, Shelf, Under Shelf

---

For support, contact support@coolrgroup.com