XLS → model mapping
The catalog sheet is UnknownSheet1 — one row per asset, with all
description text already concatenated into the Kvalitativní ukazatele
columns. The remaining numbered sheets (10, 11, …, 70) duplicate the
same rows but split the description across many empty-keyed rows; they
are not used by the importer.
| XLS column (Czech) | Model field (MedicalAsset) | Notes |
|---|---|---|
| V sestavě | in_assembly (bool) | |
| PČV | pcv (str, unique) | Business key. First 2 digits = category code. |
| Preferováno | preferred (bool) | |
| Název | name | |
| Typ | type_designation | Model / manufacturer type designation. |
| Rozměr | dimensions | |
| Dodavatel | supplier | |
| Cena bez DPH | price_excl_vat | CZK. |
| DPH v % | vat_rate | |
| DPH v Kč | vat_amount | |
| Cena celkem | price_incl_vat | |
| Mj | unit | Default ks (pieces). |
| Cena zahran. | foreign_price | |
| Cena mon. | installation_price_excl_vat | |
| DPH mon. v % | installation_vat_rate | |
| DPH mon. v Kč | installation_vat_amount | |
| Cena celkem mon. | installation_price_incl_vat | |
| Cena zahraniční mon. | installation_foreign_price | |
| Dodavatel mon. | installation_supplier | |
| Výrobce | manufacturer | |
| Energie | requires_power (bool) | |
| Zakreslovat | draw_on_plan (bool) | Whether the item appears on drawings. |
| Cena ze zah. | price_from_abroad (bool) | |
| Cena mon. v cizí měně | installation_in_foreign_currency (bool) | |
| Č. sk. přísl. | accessory_group_number | |
| Pořadové číslo | sort_order (int) | Often 0 — not meaningful. |
| Aktualizace | source_updated_at (date) | D.M.YYYY in UnknownSheet1. |
| Pev. inst. | fixed_installation (bool) | |
| Název skupiny přísl. | accessory_group_name | |
| Id katalogu | catalog_id (int) | Internal id in the source app. |
| Pracovní poznámka | working_notes | |
| Doplněk názvu | name_supplement | |
| Kvalitativní ukazatele | qualitative_indicators | Two columns share this header — see caveats. |
| Kvalitativní ukazatele (2nd) | qualitative_indicators_alt | |
| Číslo mont. výkresu | install_drawing_number | |
| Rozměr AJ | dimensions_en | |
| Rozměr RJ | dimensions_ru | |
| Rozměr SK | dimensions_sk |
Category is derived: category = AssetCategory(code=pcv[:2]). The codes
match the numeric sheet names in the xls.