Can I manually save data from an excel spreadsheet into the PI archive?
If you have PI DataLink installed, then a file called "piexam32.xls" is included in the %pihome%\Excel\ directory. That example sheet comes with VBA code that writes values to the PI server. From there, you could edit the spreadsheet and the code accordingly to fit your needs.
On a broader scale, there's actually an ongoing conversation on this PI Square thread that you may be interested in joining. Some entries in that thread describe a few more options than just the one I mention, and you could add your use case to the conversation if you would like.
Thank you Kelsey.
This is helpful, but my problem is that I have a LOT of data to enter and this tool is too slow and is limited as to the amount of lines it will handle at one time. This particular task involves 11 data points and close to 8M total events. Most of which would likely be compressed but the tool still needs to process.
My other problem is that I am not so tech savvy that I could run with the ipconfig or the RDBMS etc.
I like the discussion about reviving the spreadsheet interface addin for excel… that would be right up my alley!
I will do some more research/learning on ipconfig.
Thanks for the input,
Sr. Manager Operations Projects
100 Arboretum Drive, Suite 310
Portsmouth, NH 03801
Tel 603 929 3211
Cell 603 918 9701
Completely understandable. As seen in the other thread about the spreadsheet interface, we have a ton of different ways to accomplish this, all of which work but none of which are zero to done in five seconds.
I think you're on a good track with piconfig; RDBMS would probably be the most configuration of any of the options but it comes with quite a boost in functionality. If none of that functionality applies to your case then it's more trouble than it's worth. UFL may be a more user friendly option than piconfig, but of course it comes with the baggage of needing to be installed (and potentially purchased) as an interface, configured, and then set to run. PIconfig has a learning curve, but will probably be the quickest route to just get it done.
If you have questions about any of this, or run into problems with scripts that you're writing, I would encourage you to call into our techsupport phone line and we can help you out more directly at that time.
On a more general note, I would also encourage you to utilize our new enhancement request public portal called UserVoice. When I get a chance this afternoon I will look over the existing enhancements to see whether this request exists, and in what forms, but in the meantime if you would like to add it yourself or vote for/comment on anything you see, then we would really appreciate the customer feedback.
10-4. Thanks again.
This is a minor note; ipconfig is different from piconfig. Ipconfig is a Windows command line tool for looking up your computer's MAC address, IP address, and other related networking information. Piconfig is a command line tool from OSIsoft for reading and writing to the PI Data Archive's database tools. I just wanted to mention this in order to clear up confusion for future readers.
Ha! Very observant!
Just a typo but thanks for making sure.
PIconfig and OPC HDA are the hardest things to type in an autocorrected text box
it always assumes you mean ipconfig and OPC HAD; it can be such a struggle to type them correctly.
Retrieving data ...