hi
in my work, we have to engrave numbers on our parts via Laser. the whole process to load the correct numbers from an inside use program to the laser machine took about 6 steps.
1, open the program -> enter the job number and load the numbers
2, copy the first number from the list
3, insert inside an excel document and auto-increment by dragging down
4, copy all new generated numbers to new txt file
5, open the laser and point the directory where the txt file is stored (changes every time)
6, manage the process in separate excel files that are stored in many folders (create for each part number an excel file and put inside the date, amount of parts, ... and other info)
you can imagine how many times they did mistakes and engraved parts with the same numbers or wrong numbers which means that a very long process of creating the parts like CNC machining, QC, coating, etc. was wasted for a very stupid mistake in the last stage before the part can be assembled and sent to the customer. very expensive mistakes!
so i created a b4j app that does everything automatically and everything is stored in a sqlite db file. the app creates at the same time the txt file and also stored all data (like what they did in the excel file)
from 6 steps we went to 2 steps down and minimized the possibilities to make mistakes by the employees.
creating such an app is not hard BUT in this case I also needed to update the inside used program so we are updated on all sides. the program is a web application so I use a lot JS to read/write data to the web app.
This shows how powerful b4x is and how it can make our daily life simpler.
now they want me to create more software solutions for other problems in our company
(i need to mention that my main job is CNC programmer so i have enough to do in my job now i need to work harder, was that a good move for me)
in my work, we have to engrave numbers on our parts via Laser. the whole process to load the correct numbers from an inside use program to the laser machine took about 6 steps.
1, open the program -> enter the job number and load the numbers
2, copy the first number from the list
3, insert inside an excel document and auto-increment by dragging down
4, copy all new generated numbers to new txt file
5, open the laser and point the directory where the txt file is stored (changes every time)
6, manage the process in separate excel files that are stored in many folders (create for each part number an excel file and put inside the date, amount of parts, ... and other info)
you can imagine how many times they did mistakes and engraved parts with the same numbers or wrong numbers which means that a very long process of creating the parts like CNC machining, QC, coating, etc. was wasted for a very stupid mistake in the last stage before the part can be assembled and sent to the customer. very expensive mistakes!
so i created a b4j app that does everything automatically and everything is stored in a sqlite db file. the app creates at the same time the txt file and also stored all data (like what they did in the excel file)
from 6 steps we went to 2 steps down and minimized the possibilities to make mistakes by the employees.
creating such an app is not hard BUT in this case I also needed to update the inside used program so we are updated on all sides. the program is a web application so I use a lot JS to read/write data to the web app.
This shows how powerful b4x is and how it can make our daily life simpler.
now they want me to create more software solutions for other problems in our company
(i need to mention that my main job is CNC programmer so i have enough to do in my job now i need to work harder, was that a good move for me
)
