YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

Sending Values from xls to PI Collective Options · View
Ana-Maria
#1 Posted : Thursday, October 13, 2011 2:47:49 PM
Rank: Member
Groups: Member

Joined: 10/1/2008
Posts: 22
Location: Romania
I have a list of tags , for which I am using a xls file with some coding to send values to PI Server. So far so good.
But what if I have HA PI servers: sever 1 primary and server 2 secondary. Any advice how should I send from xls values to both servers.

Thanks a lot!
Sponsor  
 

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.
Shem
#2 Posted : Friday, October 14, 2011 5:57:42 AM
Rank: Member
Groups: Member

Joined: 5/5/2011
Posts: 22
Location: Moscow
Hi, Ana-Maria!
How you send values in PI server? If you use VBA, then server name is written in programme code.
Ana-Maria
#3 Posted : Friday, October 14, 2011 8:53:36 AM
Rank: Member
Groups: Member

Joined: 10/1/2008
Posts: 22
Location: Romania
Yes am sending values using VBA.And yes I am mentioning the name of the server, but is the name of the PI Colective let's say server 1. but under this I have primary and secondary. Primary has the same name as the PI colective (1) and secondary has different name (2). So when I am running the macro it send only to the primary , even if force xls to be connected to secondary.
RJK Solutions
#4 Posted : Friday, October 14, 2011 9:16:12 AM
Rank: Administration

Groups: Administration

Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
Couple of options.
1. You wait for PI SDK 1.4 where PI SDK can communicate with the PI Buffer Subsystem, which fans the data to all members of a PI Collective.
2. You have to add some code to switch PI Collective members are writing to the Primary and repeat the same tasks on the Secondary - there is an overhead to using "Switch Member".
3. Use the PI UFL interface with the PI Buffer Subsystem and change the spreadsheet to produce CSV files that are processed by UFL.
Principal Consultant
Real-Time Data Management @ Wipro Technologies
Ana-Maria
#5 Posted : Friday, October 14, 2011 9:52:56 AM
Rank: Member
Groups: Member

Joined: 10/1/2008
Posts: 22
Location: Romania
Thanks a lot. I will try option 2. Also once PI SDK 1.4. will be release will be easier;OSI told me that this will happen this year, do you know which month?
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.