Work Centers import
/erp/data-import/work-centerserp-manufacturing-work-centers.view (görme, kontrol) · .import + .create + .edit (aktarma)The stations where production takes place (machine, labor). The operations of routings are linked to a work center — this workbook is loaded before Rotalar (Routings). The Bireysel Kapasiteler (Individual Capacities) sheet carries the work center's identical named units (machines); the work center's capacity count is derived from the active units. The file does not delete units.
Workbook sheets
| Sheet | Matching (record key) | What it writes |
|---|---|---|
| İş Merkezleri (Work Centers) | Kod | The work center master record. If the code exists it is updated; otherwise it is created. |
| Bireysel Kapasiteler (Individual Capacities) | Kod | The work center's named units — identical machines. If work center code + Kod exists it is updated; otherwise it is created; the file does not delete. The capacity count is derived from the active units. |
Columns
The tables are generated from the same source as the system's Alan Kılavuzu (Field Guide) tab. If a column with
Required: Yes is left empty, the row becomes Hatalı (Invalid). All cells are read as text; Evet/Hayır
(Yes/No) columns accept no other value, and in a column with a list of allowed values the spelling must match the
list.
İş Merkezleri (Work Centers)
The work center master record. If the code exists it is updated; otherwise it is created. Matching: Kod.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
Kod | Yes | The work center code — converted to uppercase. | KAYNAKHANE |
Ad | Yes | The work center name. The same name (including spelling differences) is not created twice. | Kaynakhane |
Tur | No | Empty = İşçilik (Labor) (for a new record). | Makine (Machine) · İşçilik (Labor) · Diğer (Other) |
Aciklama | No | Free-text description. | |
Sira | No | Order in the list (whole number). | 10 |
Durum | No | Empty = Aktif (Active). | Aktif · Pasif |
UstIsMerkeziKodu | No | The code of the parent work center — empty = root. It can come later in the same file; a new link is made to an active work center. | TALASLI |
Bireysel Kapasiteler (Individual Capacities)
The work center's named units — identical machines. If work center code + Kod exists it is updated; otherwise it is
created; the file does not delete. The capacity count is derived from the active units. Matching: Kod.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
IsMerkeziKodu | Yes | The code of the individual capacity's work center — it can be on the İş Merkezleri sheet of the same file. | CNC-01 |
Kod | Yes | The individual capacity's code — unique within the work center, converted to uppercase. | CNC-1 |
Ad | Yes | The individual capacity's name. | CNC Torna 1 — Haas ST-20 |
Sira | No | Order (whole number); empty = 0 (for a new record) or the existing value. | 10 |
Durum | No | Empty = Aktif (Active) (for a new record) or the existing value. | Aktif · Pasif |
In the demo package
03-is-merkezleri.xlsx: 13 work centers. Kontrol Et (Validate) in the demo installation: 13 rows · Hatalı
(Invalid) 0.
Common errors
The messages are the same as the text in the system's Kontrol sonucu (Validation result) table (… is the
variable part).
| Message | Cause and solution |
|---|---|
| Tur '…' tanınmadı: … (Tur '…' was not recognized: …) | Enter one of the allowed values given in the message. |
| Durum Aktif ya da Pasif olmalı. (Durum must be Aktif or Pasif.) | Enter Aktif or Pasif. |
| Üst iş merkezi '…' bulunamadı. (Parent work center '…' was not found.) | Create the parent work center earlier in the same workbook, or correct the code. |