Repair - STS Systemtechnik Electronic GmbH

Go to content
Repairs Managing Database
Customer's Requirement:
Database for repairs to record and manage modules and devices.

The customer needs a database to record the deliveries as well as the backtracking of repairs and upgrades.
Project Scope:
  • Combining an existing Access application for recording deliveries and an existing Excel list of repairs
  • Backtracking of modules and devices
  • Integration of the repair management database into the existing orders database
  • Statistics module for deliverance and complaints
Development Environments / Software:
  • MySQL Community Server
  • Visual Studio 2017 C#
  • MySQL Visual Studio Plugin
  • MySQL Connector 5.2
  • Analysis of existing systems
  • Development of an over-all concept
  • Specification done in cooperation with hte customer (table definitions, GUI, outputs)
  • Setup of a MySQL servers for the database
  • Redesign of table definitions
  • Joining and defining the module and device numbers being used
  • Import of existing Access- and Excel-data through separate import program
  • Verification and launch together with the customer
© 2022 STS Systemtechnik Electronic GmbH
Data Protection                 GT&C                 Imprint
Back to content