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 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 (click) Status (Enable) Modify -> Configure Database Type (Browse)(Access) Database Identifier (Browse)(pc100) Create Table at Runtime if not found (Check) Table name { ALMTBL} Column Configuration o o Tag Name (check) Value(check) o o o Alarm status(check) Date in(check) 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 8. Double Click on 1st 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 9. Right Click on 1st 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) 10. Similarly Configure 2nd VisiconX Data control, 2nd VisiconX Combo Box and 3rd VisiconX Data control SQL command for 2nd VisiconX Data control SELECT DISTINCT ALM_ALMSTATUS FROM ALMTBL SQL command for3rd VisiconX Datacontrol SELECT *FROM ALMTBL WHERE (ALMTBL.ALM_TAGNAME = ‘QP1’) AND (ALMTBL.ALM_ALMSTATUS = ‘QP2’) Click OK 11. Right Click on 3rd VisiconX Datacontrol Animation(click) -> Configure(click) -> Query (Tab) QP1 -> Animate(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 { INSERT 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 For 1st VisiconX Data control SELECT DISTINCT tagname FROM FULLDAT For 2nd VisiconX Data control SELECT DISTINCT almstat FROM FULLDAT For 3rd 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