Data from Excel to OPC
The situation is that we have this raw data of tank level from our customer in excel CSV format which is emailed to us everday. My problem is I want this raw data from excel to feed to our opc so we can use it in our system such as trends, monitoring etc. Is there a way to do this. We are using 800xA V5.0 SP2. Any recommendation is very much appreciated.
Thanks and best regards,
This wont work.( or rather works very badly )
The data you get is "old" - it was a sample taken at a particular time. Your excel values might have a timestamp on it, but OPC-DA cannot use that timestamp. OPC-DA applies it's own timestamp whenever the value changes, which would be whenever you happen to write from the CSV file down to the controller, which again is at a random time of day depending on when you receive the email. ( And anyway, you shouldnt be able to send an email to your 800xA system ;) )
Have a look at lab sample history logs - which use OPC-HDA ie History data. These might provide what you require.