Skip to main content

Read the validation result and correct invalid rows

Task
Module
General
Menu path
Yönetim › Araçlar › Veri Aktarımı › <object> › İçe Aktar › Kontrol sonucu (Administration › Tools › Data Import › <object> › Import › Validation result)
Screen route
/erp/data-import/{key}?job={id}
Required permission
Nesnenin görme izni
Prerequisites
  • Kontrol Et (Validate) has completed for the workbook.

The validation result states what will happen to each row; the message of an invalid row states the problem and the expected value. The example below was taken in the demo installation with an intentionally broken copy of the warehouse workbook (validation only).

Steps​

  1. Look at the counters next to the Kontrol sonucu (Validation result) heading. If the Hatalı (Invalid) count is greater than 0, the screen reads 'N satır hatalı. Dosyayı düzeltip yeniden kontrol edin ya da hatalı satırları atlayarak geri kalanını aktarın' (N rows are invalid. Correct the file and validate again, or import the rest while skipping the invalid rows).
    VerifyKontrol sonucuExpected: The Açılacak (To be created), Güncellenecek (To be updated), Değişmiyor (Unchanged), Hatalı (Invalid) counters and a per-sheet summary
    Validation result — failed rows and messages
    1. 1Failed row count
    2. 2Import skipping failed rows
    3. 3Create · Update · Unchanged · Failed
    4. 4Error message — with row and code
  2. The result table opens with the invalid rows (the Sonuç (Result) filter is Hatalı (Invalid)). Read the Sayfa (Sheet), Satır (Row; Excel row number), Kod (Code) and Açıklama (Description) columns of each row.
    VerifyAçıklamaValue: DepoTuru 'Soğuk Oda' tanınmadı: Genel, Hammadde, Karantina, Üretim, Mamul, Yedek Parça, Hurda.
  3. To see the records to be created and updated, select Hepsi (All) in the Sonuç (Result) filter. On a row to be updated, a cell that differs from the record appears yellow.
    SelectSonuçValue: Hepsi
  4. Open the workbook in Excel, correct the row named in the message and save. On the import screen, select the corrected workbook with Dosya Seç (Choose File) and click Kontrol Et (Validate) again.
    ClickKontrol EtExpected: Hatalı (Invalid) 0 — the Aktar (Import) button is enabled
Result
The workbook is error-free. Import the workbook.

Example: four results together​

SheetRowCodeResultDescription
Depolar5YEDEK-PARCAAçılacak (To be created)— (new warehouse)
Depolar6SOGUKHatalı (Invalid)DepoTuru 'Soğuk Oda' tanınmadı: Genel, Hammadde, Karantina, Üretim, Mamul, Yedek Parça, Hurda. (DepoTuru 'Soğuk Oda' was not recognized: …)
Lokasyonlar11MAMUL/RAF-M2Güncellenecek (To be updated)— (Ad changed)
Lokasyonlar13DEPO-X/RAF-1Hatalı (Invalid)'DEPO-X' kodlu depo bulunamadı — Depolar sayfasında ya da sistemde olmalı. (No warehouse with code 'DEPO-X' was found — it must be on the Depolar sheet or in the system.)
Lokasyonlar14MAMUL/RAF-M3Hatalı (Invalid)Ağırlık kapasitesi sıfırdan büyük olmalı; sınırsız için boş bırakın. (The weight capacity must be greater than zero; leave it empty for unlimited.)

The remaining 13 rows are Değişmiyor (Unchanged) (18 rows · To be created 1 · To be updated 1 · Unchanged 13 · Invalid 3).

What you need to know​

  • Satır (Row) is the row number in Excel (the header is row 1); make the correction directly in that row.
  • Kod (Code) is the sheet's matching key; a two-part key is joined with / (MAMUL/RAF-M2).
  • An invalid row writes nothing. Instead of correcting, you can also write the rest with Hatalıları Atlayarak Aktar (Import Skipping Invalid Rows); you then correct the skipped rows later and import the same workbook again — the rows already written then return Değişmiyor (Unchanged).
  • On the Ürün Aktarımı (Item Import) screen, a cell can be corrected in the result table; the correction is not written without validating again ("Düzeltmeler kontrol edilmedi — önce Kontrol Et." — The corrections have not been validated — Validate first.).
  • Object-specific messages are in the Common errors section of the object pages.