I am doing a project about power system and I want to input some user's data from excel. I want to make these data as a time series data as data from PI Data Achrive. I do not know how to realize it.
By the way, I want these data show up in the PI Processbook and changed as time change.
You can use PI RDBMS interface to get data from Excel to a tag in PI Data Archive. You will need to configure your Data Source Name (DSN) to work with Excel and write a query to collect your data from spreadsheet.
One of the columns in your Excel spreadsheet should be timestamp column.
We have a series of video on our YouTube learning channel about PI RDBMS interface here. Live Library user guide can be found here.
Once you get your data to PI DA, you can view it in any Visualization Client, including PI ProcessBook.
Thank you for your help. The thing is I do not install any software of PI Server and all I have are PI Datalink and PI Processbook. I think I do not have the authority to create a PI Interface or security trust.
Retrieving data ...