Hierarchy in TKinter Treeview

I have been trying to create a Hierarchical TreeView with data from a database in Gtk but have been unsuccessful (https://stackoverflow.com/questions/76410276/creating-a-hierarchical-gtk-treestore-with-unkown-dataset-length). I discovered that in TKinter I can almost do what I want, but there are a couple of problems.

1. If a node has an identical value to another, Python throws up the following error:

    add_node(k, v, x)
  File "/home/bigbird/tvTk3.py", line 10, in add_node
    tree.insert(k, 1, i, text=i,values=[myList2[x][1]])
  File "/usr/lib/python3.10/tkinter/ttk.py", line 1361, in insert
    res = self.tk.call(self._w, "insert", parent, index,
_tkinter.TclError: Item Electric already exists

Is is possible to have nodes with the same name? And what do I change to avoid this?

2. I want the number associated with each value to be inserted in column 1 of the treeview. But the line values=[myList [1]] does not change with each new node. How do I get the associated number in the row?

Could somebody help me get this going? Thank you very much.

import tkinter as tk
from tkinter import ttk as ttk
myList = [['Board', 71], ['Book', 8], ['Breadboard', 6], ['Cables', 48], ['Capacitor', 9], ['Capacitor | Ceramic', 10], ['Capacitor | Electrolytic', 11], ['Circuits', 73], ['Circuits | 555 Timer', 77], ['Circuits | Audio', 76], ['Connector', 12], ['Connectors', 49], ['Drill', 54], ['Drill | Electric', 56], ['Drill | Manual', 55], ['Screwdriver', 32], ['Screwdriver | Electric', 58], ['Screwdriver | Manual', 57], ['Veraboard', 7], ['Wire', 35], ['Wire | Jumper', 36], ['Wire | Solid Core', 37], ['Wire | Stranded', 38]]
# MyList2 replaces ['Screwdriver | Electric', 58], ['Screwdriver | Manual', 57], of MyList with ['Screwdriver | Electrical', 58], ['Screwdriver | Hand', 57],
myList2 = [['Board', 71], ['Book', 8], ['Breadboard', 6], ['Cables', 48], ['Capacitor', 9], ['Capacitor | Ceramic', 10], ['Capacitor | Electrolytic', 11], ['Circuits', 73], ['Circuits | 555 Timer', 77], ['Circuits | Audio', 76], ['Connector', 12], ['Connectors', 49], ['Drill', 54], ['Drill | Electric', 56], ['Drill | Manual', 55], ['Screwdriver', 32], ['Screwdriver | Electrical', 58], ['Screwdriver | Hand', 57], ['Veraboard', 7], ['Wire', 35], ['Wire | Jumper', 36], ['Wire | Solid Core', 37], ['Wire | Stranded', 38]]
# /57036493/
def add_node(k, v,x):
for i, j in v.items():
tree.insert(k, 1, i, text=i,values=[myList[x][1]]) # MyList2 will work, MyList does not
if isinstance(j, dict):
add_node(i, j,x)
# /59767830/, /52971687/
tree = {}
for path in myList: # MyList2 will work, MyList does not
node = tree
for level in path[0].split(' | '):
if level:
node = node.setdefault(level, dict())
# /57036493/
hierarchy = tree
root = tk.Tk()
root.geometry("900x900")
tree = ttk.Treeview(root)
ttk.Style().configure('Treeview', rowheight=30)
tree["columns"] = ("one")
tree.column("one")
x=0
for k, v in hierarchy.items():
tree.insert("", 1, k, text=k, values=[myList[x][1]]) # MyList2 will work, MyList does not
add_node(k, v, x)
x+=1
tree.pack(expand=True, fill='both')
root.mainloop()

> Is is possible to have nodes with the same name?

I'm not sure what you mean by "name". Same text? Yes. Same id? No. Element identifiers must be unique. However, the id doesn't have to match the text that you see.

> And what do I change to avoid this?

The simple solution is to let tkinter compute the id for each element. For example, just omit the third positional parameter:

tree.insert(k, 1, text=i, values=[myList[x][1]])

If you need the id, the insert method returns it.

element_id = tree.insert(k, 1, text=i, values=[myList[x][1]])

I finally figured out the second problem I had (as Brian said, a completely separate issue). As the code below shows, keeping track of the current row correctly (called self.rowCounter) was necessary. I have tidied up the above messy code so it is clearer and the program is running correctly.

import tkinter as tk
from tkinter import ttk as ttk
class App:
# /57036493/
def add_node(self, rootNode, subNodes):
for i, j in subNodes.items():
self.rowCounter+=1
self.tree.insert(rootNode, 1, text=i, values=[self.myList[self.rowCounter][1]]) # /76427399/
if isinstance(j, dict):
self.add_node(i, j)
def __init__(self, root):
self.myList = [['Board', 71], ['Book', 8], ['Breadboard', 6],
['Cables', 48],['Capacitor', 9], ['Capacitor | Ceramic', 10],
['Capacitor | Electrolytic', 11], ['Circuits', 73],
['Circuits | 555 Timer', 77], ['Circuits | Audio', 76],
['Connector', 12], ['Connectors', 49], ['Drill', 54],
['Drill | Electric', 56], ['Drill | Manual', 55],
['Screwdriver', 32], ['Screwdriver | Electric', 58],
['Screwdriver | Manual', 57], ['Veraboard', 7],
['Wire', 35], ['Wire | Jumper', 36],
['Wire | Solid Core', 37], ['Wire | Stranded', 38]]
# Create Tree
self.tree = ttk.Treeview(root)
self.tree["columns"] = ("one")
self.tree.pack(expand=True, fill='both')
# Create a hierarchical dict - /59767830/, /52971687/
hierarchy = {}
for path in self.myList:
node = hierarchy
for level in path[0].split(' | '):
if level:
node = node.setdefault(level, dict())
# Insert Nodes on the tree # /57036493/
self.rowCounter=0
for rootNode, subNodes in hierarchy.items():
self.tree.insert("", 1, rootNode, text=rootNode, values=[self.myList[self.rowCounter][1]])
self.add_node(rootNode, subNodes)
self.rowCounter+=1
root = tk.Tk()
app = App(root)
root.mainloop()