AnsweredAssumed Answered

How to publish excel file through power shell command

Question asked by newfunda on Mar 15, 2018
Latest reply on Mar 19, 2018 by gregor

Hi,

 

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.

 

Regards,

Manish

Outcomes