Skip to content

Application to get all data from Excel Sheets and show it in a user friendly way

Notifications You must be signed in to change notification settings

manoellvitor/tests-tracking

Repository files navigation

Tests Tracking

Better than Spreadsheets

Description

This web application was created to address a critical business challenge I encountered during my previous employment. At the time, our team relied on spreadsheets to store and manage test results. This approach lacked automation and made it difficult to track our progress over time or retrieve specific test results. As a solution, I developed this application using modern web technologies to enable easy and automated storage, search, and retrieval of test results. With this tool, businesses can better manage their test results, evaluate their team's performance, and drive improvements across the board.

Features

  • Individual page for each kind of hardware tested.
  • PIE Chart with total hardware tested.
  • BAR Chart with number of FAILURES and PASSES for each kind of hardware.
  • Search option by serial number.
  • Option to Export to Excel sheet.
  • Sorte data from a range of Date.

Tech Stack

  • [NodeJS] - Node.js is an open-source server environment.
  • [Twitter Bootstrap] - great UI boilerplate for modern web apps.
  • [Express] - fast node.js network app framework.
  • [SQLite] - SQLite is a database engine written in the C programming language.
  • [Sequelize] - Sequelize is a modern TypeScript and Node.js ORM for Oracle, Postgres, MySQL, MariaDB, SQLite and SQL Server, and more.
  • [EJS] - Embedded JavaScript templating.

DEMO

2-tests-tracking-2022-12-01_10.11.25.mp4

Installation

This application requires Node.js v10+ and .ENV (See .env.example file) Variables to run.

Install the dependencies and devDependencies and start the server.

cd tests-tracking
npm i
node start

License

MIT

Free Software, Hell Yeah!

About

Application to get all data from Excel Sheets and show it in a user friendly way

Resources

Stars

Watchers

Forks

Packages

No packages published