So you dont have to warry about your data and nothing will be lost. There is no dependency on the HistData utility or the Wonderware InTouch HMI software.Įasily export InTouch historical data within two steps:Īll the raw data in Lgh files can be exported and no data will be lost. ITHistExporter can open and read lgh files effortlessly through an easy and intuitive user interface that gives plant operators, engineers, and managers the ability to query one or more InTouch tags for a given time frame and then export the results into a CSV file.
#Wonderware intouch 10 history data export code
Now, we released a stand-alone utility that allows you to export your existing InTouch history data and you don’t have to write any code for it.Ĭommonly referred to as “lgh files” by those familiar with the Wonderware InTouch Human Machine Interface (HMI) software, these daily historical log files contain data for InTouch HMI tags which are typically only accessible using the Wonderware HistData Utility, Wonderware InTouch trending tools, or by migrating the data to Wonderware Historian. Hope this helps.Usually, exporting data from InTouch historical data is not an easy thing. Here is the continuous loop Macro that I used to continually copy and paste the values in my historian workbook.Īpplication.OnTime Now + TimeValue("00:05:00"), "Macro1"Īll this does is call Macro1 every 5 minutes. Then you could print your reports every 15 minutes or do like I did and create a large table that stored the values. Perhaps you could use dde to pull the info from wonderware into excel or from your ddeserver into excel. I am positive that you can build something that will suit your needs. The only thing that would slow down the system, was when excel would autosave the historian workbook every 30 minutes. I did all of this on old pentium II machines and they had no problem running all of these programs. I also used dde to pull the information from excel into wonderware and display it. I essentially had an open ended loop that would copy and paste the values every five minutes. I then used a macro to essentially copy and paste the values every 5 minutes. I then linked the calculated values to the historian workbook which in turn also updated every 10 seconds. I used a modbus ddeserver to pull the information into my excel calculations workbook, where it updated every 10 seconds based on the settings in the ddeserver. I performed all calculations in one Excel Workbook, stored them all in another Excel workbook, and displayed all the calculated points on Wonderware. I used Wonderware and Excel to create a power plant monitoring system. You can achieve want you want or at least something similar. RE: Wonderware to Excel pmover (Mechanical) 16 Sep 03 16:41 My question is is there a way to write a macro that this can take place without having to be proficient in Visual Basic or another language.any help would be appreciated. Should I just have a macro that runs when the spreadsheet is open and have wonderware open the spreadsheet at the given times for the transfer? This seems like a lot of opening and closing of excel and I am trying to limit the amount of extra programs opening and closing due to using up the computer memory for extra functions. I am having trouble getting excel to do this. I also need the data to be entered in consecutive lines on the spreadsheet depending on what time it is. I have tried to create a macro in VBA to do this but Excel will not export the data more than one time on a time basis. CSV file but I need to move the data to the report every 15 minutes. I am able to export the data from wonderware to a. I am creating a wonderware application and I need to create some reports. I may be in the wrong place, excuse me if I am.