smartit-flow
SmartIT-Flow
Project Goals & Target Audience
Welcome to Smart IT flow. Smart IT Flow is an IT issue tracking system and is aimed at IT staff and administrators responsible for managing and resolving IT issues in a form of a ticketing system. The ticketing system will enhance communication and collaboration among team members, making it easier to work together and with end users. We will prioritise transparency and visibility, ensuring that stakeholders and management alike have a clear view of the status of IT issues.
Smart IT Flow Data Modelling & Planning
Issue Table
This table will serve as the primary core of the system, and will contain all the information related to IT issues being tracked.
The Issue_ID will serve as a unique identifier for each issue, while the Issue_Description field allows for a detailed description of the issue. The Priority_Level and Category fields will help to classify and prioritise issues. The Contact_Number field will be implemented to allow for easy communication with the end user who reported the issue. The Date_Created and Due_Date fields will help with scheduling and monitoring of issue resolution timelines. Added fields such as status will be an important aspect of the system as it will indicate the current stage of the issue resolution while Resolution_Time will help to measure efficiency and response time. By including Assigned_Technician it will allow for efficient assignment of issues to IT staff, while Resolution_Notes will allow for detailed tracking of issue resolution steps and outcomes.
### Technician Table
This table will provide information about IT staff responsible for resolving issues.
Technician_ID will serve as an unique identifier, while First_Name and Last_Name will provide basic identification information. The email and phone_number fields will allow for easy communication with the technician, while the Status field will indicate the Technician’s availability or current workload.
### Category Table
This table will allow for efficient categorization and organisation of IT issues.
The Category_ID will serve as a unique identifier while Category_Name will provide a descriptive label for each category.
### Priority Table
This table will allow for efficient prioritisation of IT issues.
Priority_ID will serve as a unique identifier, while Priority_Name will provide a descriptive label for each priority level.
## Requirements
- The system should allow users to submit new issues with a description and enter in a contact number
- The system should assign a unique issue ID to each new issue.
- The system should specify each issue into category and priority level
- The system should allow users to view the status of their submitted issues.
- The system should allow technicians to view and manage issues assigned to them.
- The system should allow technicians to update the status of an issue and add resolution notes.
- The system should reporting capabilities, such as generating reports on issue resolution times and open issues by category or priority level.
- The system should be scalable and able to handle a large volume of issues.
## Expectations
- The ability to create new issues with unique IDs and store them in a spreadsheet.
- The ability to view and search exisiting issues by ID, status, category, or priority level.
- The ability to assign technicians to issues and track their progress.
- The ability to add resolution notes and mark issues as resolved.
- The ability to generate reports and statistics on the status of issues and the performance of technicians.
- The ability to send notifications to technicians or users when issues are updated or resolved.
- The system should be secure and protect user data including contact number and issue information.
- The system should be scalable and able to handle a growing number of issues and users.
Testing
I have tested the system and I produced the following results:
I decided to keep my system simple without being able to assign technicians, generate reports or send notifications to technicians.This is something I could work on in the future to improve this finalised IT management system. I tested in lint and recieved no errors.
Languages / Frameworks Used
- Python
- Gspread
- Google Auth
Deployment
The project was created by pushing relevant commits step by step to each section of the web page and was deployed using GitHub by the following steps.
*Navigate to the repository on github and click ‘Settings’. *Then select ‘Pages’ on the side navigation. *Select the ‘None’ dropdown, and then click ‘master’. *Click on the ‘Save’ button. *Now the website is now live on (https://rosg150498.github.io/smartit-flow/) *If any changes were required, they can be done, commited and pushed to GitHub and the changes will be updated