I have excel file ready with me but now instead of opening the file and selecting the server and database, I want to do this using Power Shell command.
Steps to do are:
1. Import OSISoft PI SDK in order to call the PI commands
2. Set variables for PI server and database
3. Read the excel file
4. Run Publish command in Create Only mode
5. Save and report if any issue found in excel data
6. Show success status to user
Kindly help me achieve this task, I was searching the internet but couldn't find related topics, hope someone here can help here. Kudos! to real developers.