Bulk Add Byline with airSlate SignNow

Bulk add byline

we're already creating event frames using pi event frames generator and linking those event frames to mixers and heaters in line one we would like to take this event frame structure for line one in pi event frames interface manager and quickly duplicate it for line two we can do this by using the new bulk editor feature a few notes before we start i did add line one as a primary referenced element at the parent level and recreated my event frames this way in pi system explorer we'll quickly be able to see which event frames were created for line one and which ones were created for line two also all of the trigger tags already exist for line two i'm going to start by exporting the existing configuration to csv file by using the new bulk editor feature if i just click export csv i'll save it as exported let me go ahead and open this file in excel and here we have the file opened up in excel if you look at each column you can start to see the same structure that we saw in pi event frames interface manager here's that name parent level it's the procedure level factory one template underneath that is mixer one with parent level as its parent same thing with mixer two and heater one then here are those sub badges the heater element one and heater element two that are part of heater one so what we essentially need to do is copy these cells rows 2 through 7 make duplicates of them and then edit them so they have the appropriate attribute pi tag references etc let me go ahead and start by copying those by selecting rows two through seven right clicking copy then i'm going to go ahead and paste those and then i'm not going to make any edits to rows two through seven because those are the ex that's the existing structure for line one that i don't want to change so we're gonna only be editing eight through thirteen and let me go ahead and expand all of my columns and we're just going to go through with them one by one and make our edits and to make this easier i'm going to make these a different color i'm going to need a different name for my parent level so i'm going to call this parent level line 2. however the parts of the structure underneath it i want to use the same names but again for these to be able to find the correct parent i'm going to have to rename these as well we're going to be using the exact same templates and no changes to these other settings here now for my active point tags i need to change these for line two so they point to the correct tags so i'm just going to do that manually for each of these for the active point tag and if you want to use excel tricks where you select cells and do find and replace that's fine but i'm just going to do this all manually for this video the tag behavior is no different and then here we have a column related to the names that are going to be used for the event frames so once again i already have tags that exist for these names so i'm just going to manually edit each of these so that i use the equivalent from line two and then this last one is a static name so it just is hard coded in and then my referenced elements so i have referenced elements for my line number and also for my mixers in line two and let's see what other changes we have here that i need to make i have some pi point data references here for some attributes so this is going to be the l2 product l2 mix 1 l2 mix 2 and l2 heater 1. and then it keeps going on into the next set of attributes i'm going to manually change these as well and we've got just a couple more here and at that point it looks like everything is updated i'm going to export this to csv file and then we're going to head back to pi event frames interface manager and import that file here i have my file as csv format that i edited in excel so i save that as a csv and copied it back to my interface machine and in pi event frames interface manager in the bulk editor i'm going to say import csv i'm going to select that edited file and click open now if i go to the event frame structure you can see the changes that we made here's the parent level line two with mixers and heaters under it quickly i'll just take a look at a few things if i go to additional settings you can see the primary referenced element has been selected there under the mixers you can see the tag names have been updated to say l2 same thing with heater i'll click save settings then stop and start the interface to let it do the default recovery for line two i'm going to let that run for just a minute or two and then we will head to pi system explorer to take a look at the event frames created this was the previous search you can see that there were only event frames for line one that were showing up let's do a new search click ok and now you can see that there are event frames for both line 1 and line 2. you should now be familiar with using the bulk editor feature