Bulk import equipment¶
Upload your whole equipment register from a spreadsheet.
Who can do this: Superadmin Branch Admin Internal biomeds
Steps¶
- Go to Inventory → Bulk Upload (direct link).
- Select Download Template and fill it in — one row per item.
- Upload the file and select Upload & Import.
Limits: .csv, .xls or .xlsx, up to 10 MB and 1,000 rows per file.
Template columns¶
| Column | Notes |
|---|---|
department |
Must match a department name (or alias) in your facility. |
location |
Room / ward. |
name, brand, model, category, type |
type is medical or non-medical. |
serial_no |
Must be unique. |
asset_tag_number |
Optional. |
supplier, maintenance_plan |
Plan: in-house, under-contract, under-placement, medevice. |
purchase_date, installation_date, first_used_date, last_service_date |
Dates. |
service_frequency |
Months between PPM visits. |
equipment_lifespan_years, equipment_cost, estimated_weekly_usetime_hrs |
Numbers. |
status |
up / operational / working (or blank) = up; down / not working = down. |
If the import fails¶
The import is all or nothing: if any row has an error, nothing is imported and you see a list of errors by row. Fix them and upload again.
| Error | Fix |
|---|---|
| Unknown department | Add it under Departments & locations or correct the spelling. |
| Duplicate serial number | Each serial must be unique — in the file and against existing equipment. |
| Too many rows / file too large | Split into files of ≤ 1,000 rows. |
On success you'll see "Successfully imported N new equipment". Next: print QR stickers.