Parts matching in data imports

[Jorropo]

Hello ever since v1.0.0 I no longer understand how to match parts when importing an XLSX or CSV to a BOM or PO.

In the mapping step I select a column like Supplier Part Number with a value like ADS54J60IRMP for the Supplier Part mapping.
Then in the next step I get:

Row contains errors:
part: Incorrect type. Expected pk value, received str.

in the row index column.

In the Supplier Part column I have:

supplierpart: ADS54J60IRMP

In red text.

I am expecting it to match the supplier part with the exact same on the supplier of that PO.

---

I have the same issue with BOMs altho here it's with parts rather than supplier parts.

---

Using Inventree v1.1.11.

[SchrodingersGat]

The 1.0.0 release included a full rewrite of the importer framework, so there are differences.

Primarily, only "pk" (primary key) values can be used as the source of referencing when importing data rows. This means that you need to know the PK values at time of import.

Note that there is an open PR to provide import lookup by other fields: #11288

[Jorropo]

A pk lookup isn't great for me since I am not creating the files I am trying to import (it's export from my suppliers).
I guess I could use a script to convert the files but sounds like pain.

A quick skim at #11288 this looks like it implements the feature I need thanks. 🙂

[gunstr]

A workaround I use is to pre-process the file with a script using the Python Module where I add an Inventree pk column to each row in the BoM file, then the import works as a charm.