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 mfr from filename + sheet name guarantees 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 0 are 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 the qty mapping 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 mfr column keeps the per-sheet origin so you can trace every row back to its source.