Database application for in-store registering of warranty and service/repair processes in general. It enables store staff to keep an organized log of the products left for repair by costumers, their route during the process and the communications made. Processes that require special attention, for instance because of a delay in delivery or while waiting for an answer from the costumer, are highlighted in the main list, in order to allow proper intervention by the staff team.

1. Login window:

2. The overall aspect of the aplication (repairs list with message board, repair details and message/event details windows):

3. Data insertion forms (new stock product repair, new shipment):

4. Data insertion forms (new costumer product repair, new contact):

This application is being developed in Python 3.6+ and tkinter, after and original idea by Márcio Araújo. Before usage, you will need to install some external packages (pip install -r requirements.txt).

Development and testing has been done only on Mac, however it should be pretty straightforward to make a few adaptations to make it run in Windows or Linux. The visual interface has been tweaked to match as much as possible Mac native applications, so at least the toolbars will certainly look a bit awkward in other plaforms. In older operating systems, some Unicode icons or emojis may not be correctly displayed. In Mac, it's highly recomendable to use ActiveTCL 8.5.18, as stated in Python language release documentation, in order to ensure compatibility and stability for tkinter in macOS.

At this time, it is possible to configure some of the application's parameters (window dimensions and location, reducing animation for slower machines, database file location – only supporting a local sqlite database currently!), by changing the constants defined in the service/global_setup.py module.

Before running the application for the first time, you will need to initialize the database. During this early development stage, the module service/db_local_admin.py can be executed directly, in order to generate a small sample database, populated with fake data.

To run the application, you just need to execute the module service/service.py with Python 3.6 or later. The default user is npk with the password ... (yeah, no one in the entire world would ever come up with such a strong and safe password).

This application is in an early stage of development and is still not suited for production. Almost everything in the database backend is either still missing or only partly implemented.

If you know something about programming and want to help, please feel free to open an issue and let us know.