We have Ball Bar QC10. We use it to for checking of conditions/deviations from normal state of our CNC milling machines (mainly DECKEL MAHO and DMG Mori with Dialog 4, Dialog 11 and Sinumerik810) .We would like to create data base, connected to our ERP system, in which:
- to fill/describe all type deviations/defects of machines and which deviations are normal/admissible and which not ( same as tolerances of dimensions on the drawings);
- to enter each machine which we have and to upload results from check with ball bar to each machine with description/analysis of condition of machine;
- to can check condition of machine and to compare change of conditions during machine usage for long period of time;
- when machine conditions are out of normal deviations filled in to data base and machine defects will influence over its performance/ achieved quality of production ERP system to send notification to manager of Machines Maintenance Department, QA Manager, Production manager and Supervisors;
- to can fill inside information for urgent services of machines and to create a schedule for regular machine services/to create maintenance schedule for each machine and again ERP system to send notifications when should to be done prophylactic service of machines;
Our ERP system use Microsoft SQL.
Could you somebody help me with advice aand/or share experience and give me terms of references how to proceed.
Thank you in advance.