iFIX SCADA MS ACCESS
1. Create a folder named Database.
2. Inside the folder create an empty MS Office Access Database and save as Access 2000 Database with name plant. 3. Go to Control panel
Administrative Tools Data Sources (ODBC)
User DSN o
Add..
Microsoft Access Driver (*.mdb) (Double click) Data Source Name {pc100} Select..(click) o
Browse for the plant.mdb we created created earlier, select it and OK (click)
Click OK until all the opened windows are closed.
4. Open iFIX
5. Work Space -> Applications(Tab) -> SCU(Click) ->Configure(Tab) -> Alarms
Alarm ODBC service service (click) Status (Enable) Modify -> Configure
Database Type ( Browse)(Access) Browse)(Access)
Database Identi I dentifier fier ( Browse)(pc100) Browse)(pc100)
Create Table at Runtime if not found (Check)
Table name { ALMTBL} ALMTBL}
Column Configuration o
Tag Name (check)
o
Value(check)
o
Alarm status(check)
o
Date in(check)
o
Time in(check)
Click OK until all the opened windows are closed.
File -> Save -> Exit
6. Shutdown and Restart iFIX.
7. Create New Picture pic_datalm as shown
st
8. Double Click on 1 VisiconX Data control
Provider (tab) Microsoft OLE DB provider for ODBC Drivers (Select)
Database(tab) DSN Name (Browse)(pc100) Test connection (click)( Test Connection succeeded pop up should come)
Record Source(tab) Command Type(Browse) (SQL Command)
Enter SQL command
SELECT DISTINCT ALM_TAGNAME FROM ALMTBL
Click OK
st
9. Right Click on 1 VisiconX Combo Box
Configure Behavior (Tab)
ADO Records (Check)
Data Conversion (Object)
Data Source (Browse) o
Pictures (Tab) -> pic_datalm (select) -> vxData1(select) -> ADO Records(select) -> OK ( click)
nd
nd
rd
10. Similarly Configure 2 VisiconX Data control, 2 VisiconX Combo Box and 3
VisiconX Data control
nd
SQL command for 2 VisiconX Data control SELECT DISTINCT ALM_ALMSTATUS FROM ALMTBL
rd
SQL command for3 VisiconX Datacontrol SELECT *FROM ALMTBL WHERE (ALMTBL.ALM_TAGNAME = ‘QP1’) AND (ALMTBL.ALM_ALMSTATUS = ‘QP 2’)
Click OK
rd
11. Right Click on 3
VisiconX Datacontrol
Animation(click) -> Configure(click) -> Query (Tab) QP1 -> Ani mate(Check)
Data conversion -> Object(Select)
Data Source (Browse) o
Pictures (Tab) -> pic_datalm (select) -> vxCombo1(select) ->Text(select) -> OK ( click)
QP2 -> Animate (Check)
Data conversion -> Object(Select)
Data Source (Browse)
o
Pictures (Tab) -> pic_datalm (select) -> vxCombo1(select) ->Text(select) -> OK ( click)
Click OK
12. Right Click on VisiconX Grid control
Animation(click) -> Configure(click) ->Behavior (Tab) ADO Records -> Animate(Check)
Data conversion -> Object(Select)
Data Source (Browse) o
Pictures (Tab) -> pic_datalm (select) -> vxData3(select) ->ADO Records(select) -> OK ( click)
Click OK and save
13. Minimize iFIX
14. Open plant database in the Database folder 15. Create (tab) -> Table Design (click)
Enter the values Field Name {sqlname}, Data Type (Text)(Field size: 8) Field Name {sqlcmd}, Data Type (Text )(Field size: 255)
Save -> Table Name : {SQLLIB}
16. Create (tab) -> Table Design (click)
Enter the values Field Name {td}, Data Type (Date/Time) Field Name {Node}, Data Type ( Text )(Field size: 8) Field Name {tag}, Data Type (Text )(Field size: 15) Field Name {sqlname}, Data Type (Text )(Field size: 8) Field Name {fix_err}, Data Type (Text )(Field size: 100) Field Name {sql_err}, Data Type (Text )(Field size: 255) Field Name {prg_err}, Data Type (Text )(Field size: 100)
Save -> Table Name : {SQLERR}
17. Create (tab) -> Table Design (click)
Enter the values Field Name {dt_tm}, Data Type (Date/Time) Field Name {tagname}, Data Type (Text )(Field size: 8) Field Name {almstat}, Data Type (Text )(Field size: 10) Field Name {datval}, Data Type (Text )(Field size: 50)
Save -> Table Name : {FULLDAT}
18. Open SQLLIB Table
Enter the values Sqlname{PPSQL}, sqlcmd { I NSERT INTO FULLDAT(dt_tm,tagname,almstat,datval) VALUES (?,?,?,?); }
19. Save and Exit Access
20. Open iFIX Workspace -> Application (Tab) -> SCU (click)
Configure (tab) -> SQL Add..
Database Type (Browse) -> Access (select)
Database Identifier (Browse) -> pc100(select)
OK (select)
Configure SQL Task..
SQL Support -> Enable(check)
Database ID (Browse) -> pc100 (select)
Check whether SQL cmd Table is SQLLIB and Error log Table is SQLERR
Task sleep Interval {1}
Click OK until all the opened windows are closed.
File -> Save -> Exit
21. Open iFIX Database
Add one SQT block Tag name {SQT1} SQL Name {PPSQL} Database ID {PC100} Event Tag {A_IN1.F_CV} Save
Add one SQD block Tag name {SQD1} Enter the values for Tag Fields 1. TMDT 2. A_IN1.A_TAG 3. A_IN1.A_CUALM 4. A_IN1.F_CV 5. SAVE
Open SQT1 Next (Browse)(SQD1) Save
Similarly create SQT2,SQD2,SQT3 and SQD3 by changing 1 to 2 and 3 respectively.
22. Shutdown and Restart iFIX.
23. Open iFIX Workspace -> Application (Tab) -> Mission Control (click)
SQL (Tab) Start -> Start -> close
24. Create New Picture pic_fulldat same as pic_datalm
Repeat the procedure using the following sql commands st
For 1 VisiconX Data control
SELECT DISTINCT tagname FROM FULLDAT nd
For 2 VisiconX Data control
SELECT DISTINCT almstat FROM FULLDAT rd
For 3 VisiconX Data control
SELECT *FROM FULLDAT WHERE (FULLDAT.tagname = ‘QP1’) AND (FULLDAT.almstat = ‘QP2’)
25. From the Left side panel of iFIX select Historical Configuration and click on the + sign
Historical Assignment (Double Click) Node 1 (Double click)-> Group1 Configuration
Tag name (Browse) -> FIX:A_IN1.F_CV (OK) ->Add
Tag name (Browse) -> FIX:A_IN2.F_CV (OK) ->Add
Tag name (Browse) -> FIX:A_IN3.F_CV (OK) ->Add
Save Changes
26. In iFIX Workspace -> Application (Tab) -> Mission Control (click)
HTC (Tab) Start -> Start -> close
27. Create New Picture pic_history
Select a Standard chart from Tool box and place it in pic_history picture.
Double Click on the Standard Chart `General (Tab)
Highlight able (Check)
Selectable(Check)
Modifiable(Check)
Historial Update Rate {00:00:01}
Chart (Tab)
Pen List (Double click inside) (Browse) o
Historical (Tab) i. Hist -> FIX -> AIN1.F_CV -> OK (Click)
Similarly add Pen for AIN2.F_CV and AIN3.F_CV.
Click OK and Save
