Information management report
I have installed & configured 800xA information Management and I want to collect process values each 1 hour and store it in Excel file using Data direct.
Any one can help
There is plenty of help in the IM Data Access and Reports Users Guide, please read it.
1) Use ABBGetOPCDA() function to populate the spreadsheet with data
2) Use Scheduler to execute the report
You may consider creating Property Logs with eg Basic History to do the primary logging and then use ABBGetOPCHDA() function to query data from logs instead of realtime data.
You can use the datadirect functions to read the hourly values from the system. Refer to the Information Management Data Access and reports document for details:3BUF001094-600, refer to section 2. This document gives full details on DataDirect, and its functions.
Further, Refer to the attachement which is a standard hourly report available in 800xA system, alternatively you can find this report in the scheduling structure/reports/hourly log. Save this report from 800xA system.
You will find a number of attachments with this response that may provide the details that you require. Included are two examples of how I applied this report.
Email me directly should you require further assistance.