YesAX V3.1.2 - Software User Manual - 第206页

15 -2 SPC Data Logg ing All the inspection recipes, from all the AXI machines in the facility, report to a single SPC_Data table. One record represents one defect. A board with 5 defec ts on 3 parts will have 5 records w…

SPC Data Logging 15-1

15 - SPC Data Logging

15.1 Inspection Data

AXI/AOI is the best tool to gather product quality data. It is a powerful process control tool.

YesAX software can log inspection data into a database via ODBC (Open Database

Connectivity). Two main tables and a few supporting tables are created. The two main tables are:

SPC_Data, and Defect List. The Defect List data comes from the defect.ini file which lists all

the defects.

In the SPC_Data table the following fields are logged:

SystemID

AXI machine that did the inspection.

Inspector

The log-in user name.

Assy

Inspection Recipe. Usually the assembly name.

Work order number.

IDate

Date and time of the inspection

Serial Number of the board.

RefID

Reference ID

Ref2

Additional reference information.

DefectCode

Defect Code

PartTotal

Total number of parts inspected.

MarkTotal

Total number of markings inspected

LeadTotal

Total number of lead banks inspected

SolderTotal

Total number of solders inspected

BrdCount

Board Count (0 or 1)

PartFail

Part failed (0 or 1)

MarkFail

Mark failed (0 or 1)

LeadFail

Lead failed (0 or 1)

SolderFail

Solder failed (0 or 1)

IspTime

Time in seconds spent during inspection

RDate

The date and time of the defect review. (Can be different from IDate if

reviewed offline.)

ReviewTime

Time in seconds spent during the review

Reviewer

The log-in user that did the defect review. (Can be different from

Inspector if reviewed offline.)

Custom1

User defined custom field 1.

Custom2

User defined custom field 2.

RecType

Record type: I-Inspect, R-Review, W-Rework, IR –Inspect and Review.

Side

T for Top side, B for bottom side

False Call, 1 or 0

Reworked

Rework completed, 1 or 0

Part number

Pkg

Package

BrdFail

Board failed (0 or 1)

15-2 SPC Data Logging

All the inspection recipes, from all the AXI machines in the facility, report to a single SPC_Data

table. One record represents one defect. A board with 5 defects on 3 parts will have 5 records

with identical SystemID, Inspector, Recipe, WO and IDate fields. A board with no defects will

still have one record with the RefID and DefectCode fields blank. The fields which hold 0 or 1

are summed to make up the final reports. A board that has 5 failures will have one record with

BrdCount equal to 1 and the rest with BrdCount equal to 0. This way the 5 failures will only be

accredited to one board.

The SN field records the serial number of the board. In the case of a panelized recipe, if the user

chooses to have one serial number per panel (Block Skip Enabled but Block SN disabled), then

the SN would be a concatenation of the panel serial number and the Block ID. For example, the

serial number is Board-001, the SN for the master block would be Board-001-0, the SN for the

second block would be Board-001-2, etc. If each block has a unique barcode (and Block SN is

enabled) then the SN field will contain the serial number (Barcode) for each block.

By default the software creates the database files in MS Access 2000 format in the name of

YesDB.mdb, in the folder C:\AOI_Data\SPC_DataLog\. When there is more than one station

generating SPC data, have all stations send data to a single database. Use the ODBC data source

administrator to set up the database. The ODBC data source administrator is accessed via

Control Panel\Administrative Tools\Data Source (ODBC).

SPC Data Logging 15-3

Nordson YESTECH provides a sample MS Access file, SPCReportSample.mdb, to illustrate

the type of information AXI users can extract from the data generated by the AXI machines. You

can use the sample database as the starting point to develop your own custom reporting system.

The sample database carries no copyright and is distributed in open source form. The Sample

database plus a write-up describing its usage can be found on the Installation CD in the

document folder under the name SPCReportSample2.zip.

In addition to logging data into a MS Access database, you can also write the SPC data to an

ASCII text file/files. To turn on the feature, edit the YesAX.ini file and change:

[ODBC_Report]

TextOut=1

TextFolder=C:\Aoi_Data\SPC_DataLog ;folder for the text files

The software put the exact content of the SPC_Data table into one file called SPC_Data.txt.

15.2 Using MS SQL Server

MS SQL Server can be used instead of MS Access for database management. There are some

parameter changes needed in the YesAX.ini file, [ODBC_Report] section.

UseSQLServer=1

Server=

Address=

UID=

PWD=

WinNTMode=

UseNamedPipe=

UseSQLServer is set to 1 to enable software to write data to SQL Server instead of MS Access.

Before dumping data to SQL server, set up SQL Server either locally or on a remote machine.

SQL database name (default)

YesDb

SQL Server name

Server

SQL Server local server, default value

(local)

SQL Server computer name

Address

SQL Server User ID

UID

SQL Server Current Password

PWD

If software cannot connect to the specified SQL Server “YesDb”, it will automatically switch

back to Access database.

Server/Address: set to the name of computer or IP address of computer that has SQL Server

installed. If the server is stored locally, then it should be set to “(local)”.

UID: set to the user ID of the SQL Server.