CRM App With Treeview and SQLite3 - Tkinter Projects 16

In this video I'll show you how to use the Treeview Widget in Tkinter to build this cool CRM Database app.
We'll use the Sqlite3 database for the project.
We'll be able to add records, update records, delete records, move records, search records, and more.
We'll also create a color changer tool that can modify the striped row colors in the treeview.
#tkinter #codemy #JohnElder
Timecodes
00:00:00​​ - Introduction
00:03:19 - CRM Treeview App
00:26:50 - Add Functionality
00:47:30 - Connect Treeview To Database
01:04:14 - Primary Key
01:15:20 - Update Record
01:24:42 - Add New Record
01:32:52 - Delete Single Record
01:40:56 - Delete All Records
01:52:05 - Delete Selected Record
02:07:15 - Color Chooser
02:19:55 - Search Database
02:33:59 - Color Config File
02:49:36 - Conclusion

[@TkinterPython]

▶ Watch TTKBootstrap Playlist ✅ FREE Tkinter Widget Book
bit.ly/3hphbwA bit.ly/3K4qlZC
▶ See More At: ✅ Subscribe To My TH-cam Channel:
Tkinter.com bit.ly/3Pk1By4
▶ MASSIVE TKINTER.COM DISCOUNT ✅ Join My Facebook Group:
30% off with coupon code: youtube bit.ly/2GFmOBz
▶ Get The Code For This Video ✅ Watch The 200 Video Tkinter Playlist
bit.ly/3LQklWT bit.ly/3HAqZOd

[@PascalChapier]

Many thanks for this video, I learned a lot.
If you are still looking for idea, you could add a sort function triggered when the user click in one treeview header:
- first click in one header sort the record according to the colume content in ascending direction,
- second click sort in descending direction and so on.
- Click in a different header cell will restart by ascending sort for the new column selected.
- The state is not preserved for the next program run.

[@Rulzan]

John, you're simply the best

[@TkinterPython]

thanks!

[@stevew9945]

excellent work, taught me a lot

[@TkinterPython]

Glad to hear it!

[@pablo20237]

Very excellent, thank you sir

[@TkinterPython]

Welcome!

[@bigrevkev55]

You are the man!

[@TkinterPython]

Thanks!

[@code-to-learn]

Awesome tutorial sir

[@TkinterPython]

Glad you enjoyed it!

[@biotyana945]

thanks in advance ❤

[@TkinterPython]

just define your treeview using ttkbootstrap, the rest is the same.

[@digitalmachine0101]

Good information

[@TkinterPython]

Thanks!

[@JoaoNeto-oj9cn]

This data editing solution is very good, thank you very much for sharing these solutions. However, when it comes to DateEntry in the ttkboostrap package I can't get it to work. The date field does not show the record date and keeps the default date. The same happens with cleaning this field to edit a new record. What solutions can you suggest to solve this problem?
Working dates in a database is not easy, at least for me.

[@sadyaz64]

Thanks

[@TkinterPython]

Welcome!

[@moris933]

Thanks, great job. If you want I have more ideas for this channel, for example some applications when we can mark a place on Google maps and put some description for example for delivery company or interest place and share online. What you think?

[@TkinterPython]

we'll see. :-)

[@makhlouflazhar24]

Thanks in advance,
I would like you to give us an example of extracting a PDF file from the database by exploiting data from the database

[@biotyana945]

can you do the same project with ttkbootstrap

[@TkinterPython]

As I said in the video...use the exact same code, just define the treeview like we did in last week's video where I discussed ttkbootstrap's treeview.

[@davidsbdavid7769]

Hi, good job. Is there a way to get the files used in the live?

[@TkinterPython]

huh?

[@tomkmb4120]

Is it possible to add numeric filtering to the columns in Tkinter?

[@TkinterPython]

Sure

[@tomkmb4120]

@@TkinterPython Is that covered in a specific video?

[@TkinterPython]

@@tomkmb4120 Not sure, it might be in this one somewhere, you can check the tkinter playlist on my codemy.com youtube channel

[@vladmakrov8394]

Nice job Sir. Thanks. Where can i find the source code?

[@TkinterPython]

pinned comment, as always

[@manfredbaum2510]

I do not find the code. Where is it. Excuse my bad english

[@Codemycom]

It is linked in the pinned comment.

[@lemartien25000]

Invalid column index ???? When running this code I got the following error: Invalid column index. This happens in the treeview column definition. is this a problem in python interpreter I should reinstall python? I have version 3.12

[@Codemycom]

No it's not a problem with python, you just messed up the code somewhere.

[@lemartien25000]

@@Codemycom import tkinter as tk
from tkinter import ttk
import sqlite3
def afficher_resultats_requete(table_name):
# Créer une fenêtre
fenetre = tk.Tk()
fenetre.title(f"Résultats de la requête pour la table {table_name}")
# Établir la connexion avec la base de données
conn = sqlite3.connect('agrements.db')
cursor = conn.cursor()
# Exécuter la requête SELECT *
cursor.execute(f"SELECT * FROM {table_name}")
rows = cursor.fetchall()
# Créer un Treeview
tree = ttk.Treeview(fenetre)
# Configurer la colonne cachée (d'index)
tree.column("#0", width=0, stretch=tk.NO) # Largeur à 0 pour la cacher
tree.heading("#0", text="", anchor=tk.W) # Texte vide pour la colonne cachée
# Configurer les colonnes en fonction du nom des colonnes dans le résultat de la requête
for col_name in cursor.description:
tree.heading(col_name[0], text=col_name[0])
tree.column(col_name[0], width=100)
# Insérer les données dans le Treeview
for row in rows:
tree.insert("", "end", values=row)
# Ajouter le Treeview à la fenêtre
tree.pack(expand=True, fill="both")
# Démarrer la boucle principale
fenetre.mainloop()
# Appeler la fonction pour afficher les résultats pour la table 'nom_table'
afficher_resultats_requete('nom_table')

[@TkinterPython]

I don't review code

[@ken4edwards]

where is the code?

[@TkinterPython]

In the pinned comment, as always.

[@ken4edwards]

Thanks, I did no know about pinded comments and I did not know I would have to click show more to find it.

[@MAH1MOUMA]

Thanks

[@TkinterPython]

Welcome!