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

Creating Notifications En Masse ? Options · View
ThePIman
#1 Posted : Tuesday, January 12, 2010 12:02:41 PM
Rank: Advanced Member
Groups: Member

Joined: 5/14/2009
Posts: 30
Location: UK
I've got 500 tags that each want notifications for 5 states (High High, High, Normal, Low, Low Low).
Each tag has a different subject and constant value for every combination of tag and state because we're not using Standard Content or Trigger Input. They gave too much text for SMS messages.
Trigger values are all over the place, different for each combination.

The way I have it now is:
Element for each tag - 1-1 linked to PI server just for snapshot value.
5 Notifications linked to that 1 element (called HH, H, N, L, LL) with unique constant and subject messages.



OSI say there's no tool to create notifications en masse, but I'm thinking someone must have had an issue like this before. It might be possible with ANSDK but I'm not a programmer :(
I mean, how are you expected to add a whole site of 50000+ tags to Notifications if there's no tool to help.

Any ideas ?

.
Sponsor  
 
RJK Solutions
#2 Posted : Tuesday, January 12, 2010 1:41:41 PM
Rank: Administration

Groups: Administration

Joined: 6/20/2008
Posts: 458
Location: Cheshire, United Kingdom.
Are you saying that you want a spreadsheet that has your definition of the alarms and that spreadsheet should somehow be able to be run against an AF server running Notifications so they are all created without getting RSI?



OSIsoft PI System Specialists
PI consultancy on PI Systems, PISDK, AFSDK, OLEDB etc and PI custom developments. Well pretty much anything to do with PI!


ThePIman
#3 Posted : Tuesday, January 12, 2010 2:29:26 PM
Rank: Advanced Member
Groups: Member

Joined: 5/14/2009
Posts: 30
Location: UK
Hiya,

That would be an ideal solution.
I've hand-balled about 100 tags in so far with a mixture of 2 and 3 notifications each, but still have ~1800 notifications to go. My finger tips on my left hand are bleeding with all the ctrlC/ctrlV presses. My fingers on my right hand are stuck in a permanent cupped position from holding the mouse, and my wrists are about to break.
One benefit though is that I can now take things out of the oven without gloves or a cloth because the skin on my right fingers are as hard as steel.
Smile

.
ThePIman
#4 Posted : Friday, January 15, 2010 9:32:35 PM
Rank: Advanced Member
Groups: Member

Joined: 5/14/2009
Posts: 30
Location: UK
No worries with this now. I've tried and failed to do it with Excel, but it looks like MS Word is going to come to the rescue.

Export a notification as xml without all the unique IDs etc,
chop off the header and save as txt,
load it into Word as a letter and use mail merge linked to a table with all the required combinations (notification name, trigger, submissions, subject etc),
add the header back,
import the xml into Notifications.

I tried exporting and importing multiple notifications with manually edited xml files and it looks like it works.

There are two strings in the export that look like ID numbers (eg GUID) but I checked them with OSI and if the elements are using the same attribute (in this case just Pipoint.value) then these values can stay the same for every notification.

Can't test it properly 'till Monday because I was just playing with it on the train home tonight, but it seems solid. I'll let you know the results soon.

.
ThePIman
#5 Posted : Tuesday, January 19, 2010 8:30:36 AM
Rank: Advanced Member
Groups: Member

Joined: 5/14/2009
Posts: 30
Location: UK
Export as XML.
Mail merge in Word.
Import to Notifications.
Gas mark 4 for 30 minutes.
Done !




Just have to create the conditions manually because it can get messy with lots of unique ID numbers in the xml.

.
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.