I am attempting to load an amount of data from flat csv files into my PI data archive. I have had some success with using some SDK functions in VBA through Excel but the loading is quite slow with this solution.
I thought that using UFL may be a better way, but I have not used UFL before. So, I viewed the relevant OSI YouTube videos on the use of UFL and believe I have a basic understanding of how it works and how to configure it. However, I have not been able to find a way to do specifically what I want to do in the training videos or in PI Square. I have also reviewed all the UFL example .ini files and example data files provided with my UFL interface and haven't found a similar format example, so it makes me fear it cannot be done.
Perhaps asking the question may yield results for me and others who may have this question.
My data is in comma delimited text files of the general format:
*Generally Irrelevant Header Information*
DateTime, Tagname1, Tagname2, ..., TagnameN
Date and Time, TagValue1, TagValue2, ..., TagValueN
Viewed in a spreadsheet it looks like this
DateTime Tag_Name1 Tag_Name2 Tag_Name 3 ...
01-26-2017 12:34:56 100 1500.2 3.1415
01-26-2017 12:34:57 101 1500.5 3.2000
And so on.
Is there a way to configure UFL to read this file and import point data to the appropriate points at the specified timestamps? I have searched all around and have not figured this out yet. I'd really appreciate knowing whether it can be done and maybe a link to an example if it is possible. Knowing it isn't possible would be disappointing, but just as useful.
Thanks in advance!