Graphic Builder Text Copy from excel
Is it possible to copy and paste text from excel or notepad in graphic builder pages. As I have a lot tagnames and descriptions. Is there a way to do it some easy way or I will have to type everything manually.
Voted best answer
I think you already finished the task but here is what I have done for a similar case lately:
We were requested to display quite a lot of alarm and status indications read from a sub unit via comms on graphics. Instead of typing all individually, I created an NLS resource aspect and imported all the descriptions via an xml file (just typed a couple of samples in the aspect and exported to find out the format required to import). There is a late binding function that allows you to call any NLS text from an NLS source. By using that and naming every NLS text with a combination of byte and bit numbers, it was very easy to display all text on graphics with the help of a graphic element.
I am aware late binding functions are not recommended but I am talking about around 600 signals :).
You can cut/paste pretty much any text between excel, notepad, excel etc and PG2 graphic element properties. You can also cut/paste expression in the PG2 expression builder.
You say you want to cut/paste "Tag Names" and "Descriptions". Are these not already in your controller and available as "Name" and "Description" properties via OPC ?
In our case, we had a list of signals with DB, byte and bit addresses from a siemens system. I attached the excel file that I used to create the lines for the xml file to import, and the xml file itself. This xml then be imported to the NLS aspect through the XML tab in its configuration window. Be aware that some characters are not allowed.
Also in the snapshots you can see the utilization of the late binding function (NLSTextFromIdent) used to fetch the NLS text according to the 3 input properties of the graphic element: DB, Byte and Bit.
I hope the attachements are clear enough, and please do not hesitate any further questions.