I have developed this based on the tutorial of https://github.com/flatplanet/Django-CRM. Django-CRUD-demo is a CRM dashboard built with Django and MySQL. It allows users to perform CRUD (Create, Read, Update, Delete) operations on data stored in a MySQL database.
- Edit data: Edit any data from the table.
- Add data: Add single data or bulk data.
- Retrieve data: Retrieve data in bulk by querying any field.
- User login: User login is timed and the timer is displayed on the webpage.
- Clone this repository to your local machine.
- Install the required dependencies by running
pip install -r requirements.txt. - Set up a MySQL database and update the
DATABASESsetting insettings.pywith your database credentials. - Run
python manage.py migrateto create the necessary database tables. - Start the development server by running
python manage.py runserver.
Once the development server is running, you can access the CRM dashboard by visiting http://localhost:8000 in your web browser. Log in with your username and password to access the dashboard and start using the CRUD features.
Here we have included screenshots for this website's different page.
-
Login Page: This is the login page for the CRM dashboard. Users can enter their username and password to log in and access the dashboard.
-
Registration Page: This is the registration page for the CRM dashboard. New users can create an account by entering their information and clicking the "Register" button.
-
Dashboard Page: This is the main page of the CRM dashboard. Users can view and manage their data from this page.
-
Showing Single Page: This page displays a single record from the database. Users can view the details of the record and perform actions such as editing or deleting the record.
-
Updating Single Page: This page allows users to update a single record in the database. Users can edit the fields of the record and save their changes.
-
Addition of Single Record: This page allows users to add a new record to the database. Users can enter the details of the new record and save it to the database.
-
Addition of Bulk Record with Excel: This page allows users to add multiple records to the database at once by uploading an Excel file. Users can select an Excel file containing their data and upload it to add the records to the database.
-
Download all Records in Excel: This page allows users to download all records from the database in an Excel file. Users can click the "Download" button to download an Excel file containing all of their data.
-
Download any Record in Excel: This page allows users to download specific records from the database in an Excel file. Users can enter a query to search for records and download an Excel file containing the matching records.
