Tools¶
This section contains answers to the most important questions about the different tools provided.
File Importer¶
- Where does my supplier file go?
Nowhere. The XLSX/XLS/CSV is parsed and reshaped entirely in your browser. Only the final CSV — which you can preview and download beforehand — is submitted to IATA MRO SmartHub.
- Why is my column mapping remembered next time?
Every manual mapping you make is written to a per-company synonym catalogue when you submit. On the next import the same source column names are auto-mapped without any action. Over time the catalogue converges to your suppliers’ vocabulary.
- Why is the mfr field derived from the filename?
Because supplier files rarely carry a clean manufacturer column. Deriving
mfrfromfilename + sheet nameguarantees every row has a stable, human-readable provenance token that survives all downstream processing.- My material list is empty even though the procurement tab has rows.
Rows with
qty ≤ 0are dropped from the material list (material lists are valuation inputs and require a positive quantity). The procurement tab keeps them because a supplier listing can legitimately advertise zero-quantity lines. Check theqtymapping in Step 3 and the raw values in the source file.- Can I combine sheets from different suppliers into one output?
Yes. Drop all files in Step 1 (or Add more files in Step 2), keep only the sheets you want in Step 2, and the mapping in Step 3 applies across the union. The
mfrcolumn keeps the per-sheet origin so you can trace every row back to its source.