Data Collection > Automatic Data Collection
From A Textfile
Data Collection From A Textfile
This tutorial will demonstrate some of the
more advanced features of the W-Import component of AT Sigma SPC.
We will be using files in the
- Run Sigma SPC
- In windows, open the
following two windows: sigwin\samples\widata and
- Arrange the windows so they
are all visible. See below for example:
- In Sigma SPC: Open file
- In the status grid select the
first variable and press OK.
- Now we need to configure the
SPC file to be used with W-Import.
- Go to File > Utils >
- Select File > Setup...
- Click on the Select tab.
- Mark Manual Mode
- Set Acsii File Name to:
G5.TXT and DB Table to: G5.DB
- Click on Text tab.
- Set Time Stamp to Date, Time
(2 fields) and check Generate unique times (sec)
- Press OK.
- Click Go Import. The contents
of the text file was added to the control chart window.
You can click Go Import again to see the data added one
- Now, we are going to use
Scanning mode. In this mode W-Import will scan a whole
directory for files matching a pattern you select and
import them to a pre defined data base file. Once the
files are scanned, they are deleted to avoid scanning
- Go to Setup... in the
- Select Scanning mode. Set the
text path to sigwin\samples\widata\*.txt
- Click the Events tab.
- Check "Delete Input file
- Click OK and then Go Scan.
- All files ending with .txt in
the widata folder are now imported to the data base. In
this case it's only one file: G5.TXT. When W-Import is
done you can copy the G5.TXT file from the bak folder to
the widata folder and see how W-Import automatically
imports it again.
- Now copy 2.TXT from the bak
folder to widata. 2.TXT consists of the value 2, which is
so low it will make the control chart go out of control.
Notice how the control chart caption turns red.
- To restore the control chart
status copy 5.TXT from the bak folder into the widata
folder. The control chart is now back in control.
- Several files can be copied
at the same time to the folder specified for scanning and
all files will be added. For instance, try copying 5.TXT,
2.TXT and G5.TXT to widata.