Django Project - Code a CRM App Tutorial

Learn how to build a CRM (Customer Relationship Management) App with Django, Python, and MySQL.
The app will use MySQL for the database. We'll be able to Register, Log In, Log Out, Add Records, View Records, Update Records, and Delete Records.
✏️ Course created by John Elder. Check out his channel: / @codemycom
💻 Github Code: github.com/flatplanet/Django-CRM
🔗 MySQL Download: dev.mysql.com/downloads/insta...
⭐️ Contents ⭐️
0:00:00 Introduction
0:01:50 Installation and App Setup
0:06:45 MYSQL Configuration
0:13:18 Version Control Git and Github.com
0:18:14 Build Out The Basic App
0:28:46 Login Users
0:47:32 Logout Users
0:51:45 Register Users
1:15:00 Database Model
1:25:48 View Records On Website
1:31:01 Bootstrap Table
1:38:23 Individual Records
1:48:41 Bootstrap Card
1:56:51 Delete Record
2:01:05 Add New Records
2:12:10 Update Records
2:20:06 Push Code To Github
2:20:54 Conclusion
🎉 Thanks to our Champion and Sponsor supporters:
👾 Nattira Maneerat
👾 Heather Wcislo
👾 Serhiy Kalinets
👾 Erdeniz Unvan
👾 Justin Hual
👾 Agustín Kussrow
👾 Otis Morgan
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news

[@Codemycom]

Thanks for watching my video! For more Django courses check out my KZbin Channel: www.youtube.com/@codemycom/ Or My Website: Codemy.com

[@adhy612000151]

Thanks SIr!!!

[@Osegs]

Excellent tutorial and well structured but I have a few questions or maybe a few me things: It seems a behavior driven development was followed as no test was written. Also, in the urls, using "~/model/primary-key" can be easily exploited security wise (to access other records, they should not be able to access in most applications such as another user's profile). The W3schools Django tutorial talks about using slugs in place of primary keys but is there a different option to mitigate this?

[@anhtunguyenphan1666]

thanks for sharing

[@asonjaacademy6167]

o How do I host it Online?? I built it following all instructions

[@josueserrano6541]

I'm just starting with Django and completed this project in three days and I'm truly amazed about anything I learned. Thanks a lot.

[@njorogengotho880]

I have been learning Django for the last 3 weeks and made little progress then I came across this video, and live now is much sweeter and easy. The video is all I needed to understand everything that is required to learn Django. Salute all the from mama Africa (Kenya) ☺☺☺☺

[@cinemascope8847]

Awesome Tutorial ! Just love the way you connect the dots ❤

[@exoZelia]

10/10 tutorial! Didn't overexplain stuff, didn't underexplain. Very actionable and to the point. Also I skipped the MySQL and it wasn't an issue. Just a heads up for anyone else who doesn't care about that. PS Why do some people want to learn all this in some rapid 10 min video? Calm down, you're learning an entirely new skill, stop it.

[@pauloluyemi8586]

Your Django tutorial is awesome! I love it. Good job!👍 The way you explained some of the more complex concepts in Django was really easy to follow. I feel like I learned a lot from your tutorial. I hope you continue to create more tutorials like this one. It's clear you're a skilled teacher and I'm sure many others would benefit from your expertise.✌

[@ramzykaram296]

Always struggled with Django to have a wholistic view of the framework while having hands-on with code, and even revised some bootstrap along the way, literally one of the most educative videos ever.

[@Marcelo-ok3sl]

my name is marcelo, i'm watching your video here in Brazil. Today I finished your video. I learned a lot about django. Thank you very much.

[@stevendavie]

You had me at Hellow!!!!! I've done THAT every time over the last 20 YEARS! EVERY TIME!

[@SolutionsX7]

I just finished the Tutorial . Excellent!

[@coderfek]

Finally completed the project. Loved the walkthrough and explanations. Undoubtedly, one of the best Django tutorials available on KZbin!

[@franciscoalcala25]

How long did it take? did you so it on your own?

[@DarrylWaterhouse]

Very good job on what can be a difficult topic. There is just one thing concerning the models/migrations that I would have liked to have seen. When anyone registers and logs in, they can see all of the data (contacts/records) added by everyone else. Even in a demonstration as such, the records should be bound to an owner. It is not a complex topic and could have been covered in two/three minutes by the addition of the user in the model and the addition of a filter. This introduces the reader to relationships in a small but simple way. I am sure that the omission is an oversight but would have completed the short course for me. Again, very good job and love John's work. I have already recommended this course to several people. Thanks John!

[@flowerboy.t]

hello im trying to learn django. please where do you suggest i could learn it from.Thanks

[@elmosawy2865]

@@flowerboy.t Have u found an answer yet cus Im in the same boat

[@lefamofokeng8291]

@@elmosawy2865Do you wanna know about the filtering by user thing. Cause then I could help

[@marthawhite9962]

I followed step by step, it's been very interesting. I had to sort out the ssh key issue with github but it worked. Awsome. Thank you very much, I am considering getting the course.

[@cenotesdemexico]

Really, really Awesome!! You share nice vibes teaching.

[@exoZelia]

I usually have to skip ahead to see what we're even making. I'm glad you started with the end result, it's helpful to see where we're headed

[@zuberkhan-kn7iu]

Hello.. i need to know that, knowing all these which is shown in this video is enough to get a job ? I have completed basics of HTML, CSS, JS, python Django.

[@hotyeahsus8343]

Yeah for sure, my first job was @ a bank and they only asked for JS and Python proficiency, bonus points for C++ but you should be good to go@@zuberkhan-kn7iu

[@deepakreigns5775]

@@zuberkhan-kn7iu no

[@colarey]

Thank you John Elder for helping me learn Django! I love you soo much!!

[@solomonezra1253]

Let’s collaborate or connect and build something if you don’t mind

[@edbull4891]

John, as usual, EXCELLENT Thanks so much :)

[@tejassuryanarayanamudragad8701]

This is really a lovely video for any one who want to learn django. Thank you soo much for super cool explanation

[@heerbrahmbhatt6917]

Just completed the project! It was fun!

[@justinrader3890]

Great course, and awesome instructor!

[@adhy612000151]

Thanks Sir! Learn as Completely as i be your student! much much thank you!

[@aboobala5248]

Simple, straight to the point, and insightful. Thank you C🧡demy!

[@jack_rose1997]

This is what we get when Walter white start teaching django 😂.

[@Codemycom]

Ha!

[@ramiths8171]

Not every bald guy is Walter white 😂

[@rishi9637]

Jessie do not use my script Jessie

[@rishi9637]

Waltuh

[@mulyadimustamin6377]

Lol

[@alicealice9719]

Thank you so much! I completed this project today. You are a great teacher. Could you make a Rust or GoLang project?

[@luis.AlvarezGo]

00:04 Learn to build a CRM application using Django, Python, and MySQL 05:02 Install and set up MySQL database in Django 16:19 Changed the name of Master Branch to Main 21:27 Created a web page with Django and Bootstrap 31:10 Create login and logout URLs 36:02 Create a login form 46:55 Implementing registration form 52:02 Create a registration page and form 1:03:01 Passwords should be secure and meet certain criteria 1:08:25 Successfully registered 1:19:19 You can create a database model in Django without knowing SQL 1:24:46 Displaying records on the website 1:36:33 Designing a web page with tables and borders 1:42:20 Create a record.html page with customer records. 1:55:13 The code implements a delete button to delete records in Django 2:01:04 Create an add record page with a form in Django 2:13:42 Update record functionality added. 2:19:21 This video is about creating a basic CRUD application using Django.

[@_LilacRoses]

I finally completed this project and I'm so happy. I just wanted to say a huge thank you, this video is excellent, you're a great teacher and for someone new to Django like myself, you made everything so clear and it made perfect sense - not to mention you're pretty funny so never got boring to follow along. Will look to subscribe to whatever you're doing over at Codemy and look forward to more content from you. Will also probably watch back a lot of your older videos, since I'm new to the channel. Would love too see a video on how to Dockerise a Django app as I'd love to do that next with this project.

[@elmosawy2865]

Hey there. Im new to Django and was wondering if this is a good video to watch to learn Django from scratch.

[@franciscoalcala25]

how long did it take to complete? I want to create my own crm but I am unsure how long it will take

[@Daniel3Levi]

Thank you so much!💌

[@bassethoundgang2800]

Great video. I really learned a lot. Easy to follow. Access to your code was helpful too. Much appreciated on this flat planet LOL

[@luv_._23]

THANKYOU ❣️

[@danieldejager1847]

excellent resource - I would recommended that you provide links to formal documentation for those that require a deeper sense of understanding of concepts/ commands etc.

[@idrees9674]

This was beneficial to me, thanks! I didn't get how the 'user' object that you used in 'user.is_authenticated' is passed to the html page, I recon it belongs to the admin and somehow django passes it behind the scenes

[@guspersonalchannel]

Done! Excellent video. I mirrored every step in an Ubuntu VM running on VirtualBox on my laptop.

[@sohelqureshi4183]

It's nice course django 🎉🎉🎉🎉

[@RobMapes]

Your videos are great! By the way, I have a Codemy membership...

[@joseluizdurigon8893]

Dude, free code camp is insane!!!!

[@MarioDanielCarugno]

Great course ! Helped me to understand. One question that sticks in my mind is, what's really the difference between coding all that stuff vs just using the admin interface, which could be configured as I understand. Is it just a matter of preference or there are reasons to code CRUDs by hand ?

[@user-tx7ht5kt5k]

Thanks man!!

[@learningwithfahad]

Super useful!!! Thanks a ton!! It would be great if you can do something more complex (like social media websites) for starters. There are already several social media tutorials but they are pretty fast-paced and assume advanced knowledge.

[@SamirPegado]

Very cool explanation

[@hugoruffo7674]

Anyone else having problems to install mysql into the venv? For some weird reason the installation just blows up in the middle... Anyway, watche the tutorial and its just amazing. thanks a lot for sharing the knowlodge!

[@sarmadrafique426]

Perfect Timing

[@TheLummen.]

Serial Copy-Paster ! Thank yo though. Very useful video to learn CRUD operations in django.

[@muhannadalulaby8727]

How would you go about connecting the database if it was hosted rather than it being on local host? And can you maybe show how would the process would change if one wants to develop from within a docker container ? Thanks in advance

[@loc5706]

Love it. Can you do one with htmx and tailwind. Also, to complete the crud, good to have search feature.

[@mehranaliyari9866]

My problem is that when I call my management folder, it says that there is no such folder. I searched Stackoverflow and found the answer, but it was for Linux, I don't know how to fix the answer in Windows. I have this issue in other parts of the program, but when I look, the other parts are also formed. Please help me, what he wrote seems to be not path correct, I could not translate the codes to windows cmd codes

[@pungushe]

Many thanks for the video

[@Codemycom]

welcome!

[@RiteshSingh_MZP]

Thank you so much.

[@EIStudent]

Dang! I wish this was for windows. I can probably hobble through figuring it out with windows. It looks like a great tutorial though.

[@Tussu17]

Which one is more convenient to create django form, CreateView or forms.ModelForm? When to use which one?

[@Zeeshantariqpkn]

Completed and able to redesiging with bootstrap theme

[@alexandertsikhun7733]

Hi! When you update recod in tag h1 must be instead

[@FORTE2PRODUCTION]

Awesome 👏🏿

[@Zeeshantariqpkn]

Completed

[@SBogati65]

Thank you very much

[@lakshmankashyap4690]

I have error this AttributeError: 'SignUpForm' object has no attribute 'cleaned_date'

[@monicameduri9692]

Great tutorial. Thanks! BTW does Mary Smith really exist?

[@abrahems]

Nice to add an "else" for form.is_valid() else: messages.success(request, "Somethings went wrong") return render(request, 'register.html', {'form': form}) so we will be able to get a message in case there is a rigestration issues

[@ulugbeknurjonov5226]

Thank you for tutorial? Please can you also make same tutor crm but work with HTMX with django or DRF or FastApi?

[@HeartOfTech-cw5kz]

Completed 🌟🚀

[@ssm2015_ita]

Hi you guys have any plan to make a complete tutorial on JAVA GUI ?

[@tfxobrien]

Can I run this on Ubuntu 22.04 with current mysql? Was okay until I ran first migration. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 111 Server version: 8.0.34-0ubuntu0.22.04.1 (Ubuntu)

[@AjayKumar-fd9mv]

Thanks

[@harikag398]

Hi I have a doubt. Can you please let me know is there any code on sql server database connection.

[@iliandili]

Question: why did he put all functionalities under one app website?

[@markestrada1703]

Definitely recommend setting up global git config so you don't actually run all those commands for each new project

[@muhammaduzairrajput9810]

The tutorial was Awesome and understandable but the Update functionality is not working properly, because it is generating another record in to the database

[@bannybheemireddy3904]

Hello My code is not Raising Alert even though The Both passwords are not matching i don't know that what is the issue

[@josephjohnson4761]

Did html change since this video came out? I cant have input tags without labels.

[@ytdavide]

I notice that the search field is missing 😊

[@yeyintaung9837]

awesome

[@scootergirl3662]

At 46:00, I got a MultiValueDictKeyError Looking at the Django documentation this happens when a key is missing. From my end it looks like I have to handle the error but it looks like you didn’t have to What version of Django are you using? I am using 4.1.7

[@Kofikitiabi]

got the same error did you manage to fix it?

[@diegomartin6332]

It's probably because in the line: "request.POST ['username']" or "request.POST ['password']", the keys 'username' or 'password' didn't match with the form input name. request.POST ['username'] is the value of and request.POST ['password'] is the value of . It doesn't matter the input type. I hope I have helped and I have not been late :D

[@mahadebd]

It's a freshers friendly project

[@kamilunai605]

i just start lerning python and django, and still not everything is clear to me but man, when i see this folder structure: "dcrm>dcrm>dcrm" i just want screem,

[@nekonovii]

Please, make a course for NUENDО/CUBASE SOFTWARE. This is like FL Studio, but much professional...for producers... Thanks in advance!

[@joshuaroberts3987]

cant figure out why when i input a new user under records group it says record object(1) rather than the name? please help

[@alicek9660]

can someome help me set up mysql its not printing "all done" i tried watcging videos but it still didnt work

[@syedrizvi3006]

Anyone else not having the alerts show up when logging in and out. Like I can see those alerts on the Django admin site but not on the webpage

[@ggff2269]

You should load messages on your templates using : {% if messages%} {% for messages in messages%} {messages} {% endfor %} {% endif %}

[@zuberkhan-kn7iu]

when i try to commit my django project i am getting this warning "warning: LF will be replaced by CRLF | GIT". any suggestions?

[@coderfek]

Make a .gitignore file in the same folder. You won't get any error after that

[@user-zj8sr9gm8i]

just let it run, give it time. it will update, the CRLF is more secure.

[@ondra7754]

I have a problem with command django-admin says that is not recognized

[@TheAlexdn]

We go to learning Python...😊

[@asonjaacademy6167]

So How do I host it Online?? I built it following all instructions

[@Tux0xFF]

having worked with laravel, i would say this is around 80% similar, also with Rails

[@tancodes]

please also tell how we can host these crm

[@chhayakumari9453]

How can I login to admin page of django My username nd password is showing incorrect

[@akogepayo]

I am assuming this is applicable to the PostgreSQL backend.

[@manny7662]

Absolutely it's really easy to do.

[@jakeermogal391]

i have follwed through whole video , i found one error in your code what is that 'while Authenticating a form check those password=password1 instead of password1=password1' . Have a look!!

[@user-zj8sr9gm8i]

its because password=password1; creating a new variable password which will use the password1

[@saranm.s4058]

I am getting an error while installing mysql! Can some body help

[@chhayakumari9453]

I m getting er in MySQL connectivity python mydb.py is not running please help

[@ashwin8785]

Bootstrap table

[@PANDURANG99]

have you use azure Auth

[@tbg1170]

Walter white is cooking django

[@SonusVolvebatur]

superelder!

[@marcscherzer]

1:13:02 Why did copying that line solve the error?

[@marcocubedo1825]

solo encuentro problemas, modulos no encontrados, esto o aquello no instalado, despues de instalar solo errores, buen material pero lamentablemente no puedo resolver error tras error, no hay mas info en internet para resolver y al resolver algo sale otro y vuele al mismo error. me gusta python pero hasta ahora solo ha sido 80% del tiempo resolviendo errores

[@robin2080]

If you're running this on a Windows machine with python version of 3.9 or greater skip the MySQL for your own sake.

[@Kofikitiabi]

$ python -m venv virt Error: Command '['C:\\django_CRM\\virt\\Scripts\\python.exe', '-Im', 'ensurepip', '--upgrade', '--default-pip']' returned non-zero exit status 1. can anyone help with what this error means please?

[@karthikp6266]

👍

[@chhayakumari9453]

I am unable to login at admin pannel

[@JohnSmith952]

Template does not exist at \home.html?

[@jamjam3337]

👏👍