|
|
Rank: Advanced Member
Groups: Member
Joined: 12/3/2009
Posts: 49
Location: Germany/Pennsylvania
|
Ok, we're back at the starting point. As I wrote earlier, I found no simple solution.
The Exceltrend is more or less the same COM object as in ProcBook.
There are some ways to solve this:
-You use excel charts for trending (there is more functionality, but then you will lose all benefits of the PITrend )
-You develop your own Trend object (.NET of course).
-You extend the functionality of the existing COM trend object.
or you use the method you describe in the 1st post (set up a trace for this vertical line, this time as excel data)
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 9/3/2009
Posts: 32
Location: Massachusetts, USA
|
I guess I won't be doing it using the Excel Chart for obvious reasons of not loosing PI Trend functionalities.
I have sent an email to the OSISoft techsupport. Hopefully they will reply soon.
Thanks for your inputs Mike.
I will post it here once I get an email from OSI.
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 309
Location: Cheshire, United Kingdom.
|
kapilrakh wrote:@RJK
The trend is already there on the excel sheet. It would be great to manipulate an existing trend instead of inserting a new one everytime.
When you add a trend and a trace , we basically have 4 objects on the sheet. Those are,
ExcelTrendWizard1_Sheet1
PITrend1_Sheet1
PIExcelData1_Sheet1
PIArchiveData1_Sheet1
Using these existing objects solving this problem would be an ideal solution. All you need to do is change a couple of lines in the example code I posted. Rather than adding the object, set the variable to the OleObject that represts the Trend and the ExcelData container. Then on the trend, clear any existing datasourceenvironments, configure your ExcelData using AddQuerySpecs method then add the ExcelData as a DataSoruceEnvironment for the Trend. Should find a few minutes spare in the morning to post the code for what I mean.  OSISoft PI System SpecialistsPI Consultancy on PI Systems, Analysis Framework, PI custom developments and all things PI.
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 309
Location: Cheshire, United Kingdom.
|
Kapil, let's not forget about vCampus too if you want some OSI input in to what you are doing. OSISoft PI System SpecialistsPI Consultancy on PI Systems, Analysis Framework, PI custom developments and all things PI.
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 12/3/2009
Posts: 49
Location: Germany/Pennsylvania
|
|
|
|
|
Guest
|
