Importing BOM to assembly, error

[martin323232]

Hello,

how do I upload a bom in csv format in the new ui. I get error, 'Incorrect type. Expected pk value, received str.' in columt component.

On version 1.1.5

[martin323232]

Found an old closed issue that have the same problem I have, #9382
Create a python script from AI that will search database for IPN number and find PK, then add it to Kicad bom file.

import csv
import os
import tkinter as tk
from tkinter import filedialog, messagebox
from inventree.api import InvenTreeAPI
from inventree.part import Part

# Optional drag-and-drop support
try:
    from tkinterdnd2 import DND_FILES, TkinterDnD
    DND_AVAILABLE = True
except ImportError:
    DND_AVAILABLE = False

api = InvenTreeAPI(
    "http://your-inventree-server.com/api/",
    username="your_username",
    password="your_password"

api = InvenTreeAPI(SERVER_ADDRESS, username=MY_USERNAME, password=MY_PASSWORD)

def get_part_pk(ipn):
    results = Part.list(api, IPN=ipn)
    if not results:
        return None
    return results[0].pk

def process_bom(input_file):
    base, ext = os.path.splitext(input_file)
    output_file = base + "_pk" + ext

    with open(input_file, newline='', encoding="utf-8") as infile:
        reader = csv.DictReader(infile)
        # Insert 'pk' as the second column
        fieldnames = [reader.fieldnames[0], "pk"] + reader.fieldnames[1:]
        rows = []

        for row in reader:
            ipn = row.get("IPN")
            if ipn:
                pk = get_part_pk(ipn)
                row["pk"] = pk if pk is not None else "NOT_FOUND"
            else:
                row["pk"] = ""
            rows.append(row)

    with open(output_file, "w", newline='', encoding="utf-8") as outfile:
        writer = csv.DictWriter(outfile, fieldnames=fieldnames)
        writer.writeheader()
        for row in rows:
            # Ensure pk is placed correctly in the dict
            ordered_row = {fn: row.get(fn, "") for fn in fieldnames}
            writer.writerow(ordered_row)

    return output_file

def handle_file(file_path):
    try:
        output_file = process_bom(file_path)
        messagebox.showinfo("Success", f"New file created:\n{output_file}")
    except Exception as e:
        messagebox.showerror("Error", str(e))

def select_file():
    file_path = filedialog.askopenfilename(
        title="Select BOM CSV",
        filetypes=[("CSV files", "*.csv")]
    )
    if file_path:
        handle_file(file_path)

# Build GUI
if DND_AVAILABLE:
    root = TkinterDnD.Tk()
else:
    root = tk.Tk()

root.title("BOM PK Updater")

label = tk.Label(root, text="Select a BOM CSV file to process")
label.pack(pady=10)

button = tk.Button(root, text="Select CSV File", command=select_file)
button.pack(pady=20)

if DND_AVAILABLE:
    label2 = tk.Label(root, text="Or drag a CSV file here")
    label2.pack(pady=10)

    def drop(event):
        file_path = event.data.strip("{}")  # handle spaces in path
        handle_file(file_path)

    root.drop_target_register(DND_FILES)
    root.dnd_bind('<<Drop>>', drop)

root.geometry("350x200")
root.mainloop()

[SchrodingersGat]

Currently the importer requires the "primary key" for any related models to be directly provided in the file. There are some ideas to improve on this:

• [FR] Add IPN as matching field for BoM import #9248
• [Importer] Natural Key Support #7574

However these have not been developed / funded yet