PC Remote Control – LabVIEW

This application was developed to remotely control 36 machines on production floor. Before we had to go to each machine and manually do actions like setting new parameters files or changing product table. In just few clicks we can update all machines and it saves us a lot of time that we spent before doing this manually.

This application has two parts:

TCP Server on client machine – this application is waiting for command that server sent, inside I have implemented several functions that we use often. Also it has option to call a .BAT (batch file) so it gives us some flexibility. When command is executed result is sent to control panel (pass/fail).

TCP Control Panel – This is user interface that allows user to select command and machines that he wants to control. It works based on TCP/IP communication and its sending string command with parameters to selected clients. It also indicates if sent was successfully and if result is pass or fail.

C# LabVIEW 64bit SQL Database Toolkit

Example of my C# code for db connectivity, because LV 64bits don’t support DB toolkit I had to write .NET dll. DLL was developed in C# and it uses .net 4.0. It has Connect,Query,UpdateInsertDelete,Close functions. Query will read data to string array, update,insert,delete will output number of affected rows, close connection will just close it.

Here is example of usage:

LabView SQL DB






What is second most important ingredient for perfect manufacturing testing PIE? Yes it’s good tool for analysis of first ingredient (data from production floor). I have spent some time writing tools to check cpk/box plot, now its time to merge it into one. On screen shoot below you can see that we have Test/Step Name and time frame passed from caller. VI is reading data for specified measurement and then analysis is done to calculate CPK, trend and BOX Plot where we can see how each of machines are measuring our test. This last tool can help us determine which machine has to be repaired or adjusted. Analysis is done in few seconds, this way we are saving lots of time, and we can predict machine breakdown.