The Car Manufacturer Survey Python terminal is designed for the collection of survey data to be easily input to a google sheet document.
Click Here to go to the live website.
- The user follows the instructions printed at the top of the terminal. Entering the 10 numbers separated by comma's from the survey results.
- The terminal runs and gives updates and feedback to the user that their input is valid and that its updating the sheet and finally when the sheet has updated successfully.
- Once the terminal has updated the sheet and verified to the user it was successful, it prints the current survey totals.
- The google sheet is updated with the data and returns the totals with a SUM within the sheet at the top.
- Instructions to the user.
- Feedback and updates while running.
- Prints current totals after each data input.
- Has a loop at the end that asks if the user wants to enter more data (restarts) or not (ends all functions)
- Survey sheet selection for multiple surveys. This is why there are f strings in the current code for "scoreboard" sheet.
- Python 3 - coding language.
- API - google sheet API.
- Git - Version control by utilizing the Gitpod terminal to add and commit to Git then Push to GitHub.
- Git Hub - stores the project code and hosts the website.
- Visual Code Studio - system used to write code via Git
- Paint 3D - to create the logo and edit screenshots for the README.md
- Heroku - for hosting the python code and downloading requirements.
- Pep8 - testing code.
The project was deployed to Heroku via GitHub by:
- Logging Into Heroku, selecting my project, going to the settings page and adding the two required build packs (python) (nodejs).
- Going to deploy, selecting deployment method as GitHub and typing in the GitHub repository name.
- Finally you can select deploy branch to manually deploy or select automatic deployment (allows Heroku to rebuild the project after each push to GitHub.
- Log in to GitHub and locate the [GitHub Repository](https://github.com/)
- Under the repository name, click "Clone or download".
- To clone the repository using HTTPS, under "Clone with HTTPS", copy the link.
- Open Git Bash
- Change the current working directory to the location where you want the cloned directory to be made.
- Type `git clone`, and then paste the URL you copied in Step 3.
- Press Enter. Your local clone will be created.
- Create a new Heroku app and follow the steps in Heroku deployment above.
Click Here for retrieve pictures and more detailed explanations of the above process.
- Given invalid input such as letters and incorrect amount of data, both resulting in a succesful error message.
- Tested in the Code Institute Heroku terminal and my local terminal.
- Pep8 picked up a random blank line in a """ message """. Fix - deleted the blank line.
- Pep8 also picked up a print statement with an unused f string inside. Fix - remove f string from print statement.
- Microsoft Visual Studio internal validator showed me that a "from" and "import" were not used but in the code. Fix - deleted said "from" and "import" then tested code again with no errors.
- So far through my testing I have not identified any more known bugs after my fixes. There is however a potential problem if the survey input is submitted over 100 times. The totals will only update 100 times unless you modify the SUM in the google sheet directly.
- My Mentor for her feedback.
- Code Institute for thier deployment terminal template from GitHub
- Code Institute's Love_sandwiches walkthrough provided a very clear idea on how to create a data entry project. GitHub Link
- Gathered information and troubleshooting from Stackoverflow