View Full Version : FX40 batch edit's
09-17-2008, 10:25 PM
I am trimming some fat on a pig. I have been doing some batch edits and have run into a problem with illegal characters. I cannot do a search on these points because they will not show. I have tried using the wildcard "$" but this doesn't work. I have also tried truncating the point so that it will find a majority of them and that is ineffective as well. Any ideas?
09-17-2008, 10:38 PM
just ignore them
09-17-2008, 10:40 PM
09-17-2008, 10:42 PM
09-17-2008, 10:43 PM
Hahaha, leave my thread alone poser.
09-17-2008, 10:56 PM
how quickly we forget
09-17-2008, 10:58 PM
09-18-2008, 04:42 AM
Just deport them illegals ;)
Highlight "all" the point with the spaces, *, &, $, etc.
Right click and select re-name, replace the whatever with something "or" replace for instance a space, with no space.
09-18-2008, 04:47 AM
Here is something else for ya, this will help you finger out the wild cards ;)
09-18-2008, 12:24 PM
I have like 6000 points. hehehe. that would take an eternity.
09-18-2008, 12:26 PM
table is sweet though. thanks.
09-18-2008, 02:17 PM
Any example of string you're looking to modify ?
We learned the hard way too, since then we only use underscores instead of spaces/hyphens.
The only $20 I want to see from now on is in my pocket :D
09-18-2008, 02:29 PM
no doubt, so you just bit the bullet and trudged through it?
I think we renamed them by selecting multiple items (per folder group)
If I'm not mistaken you should be able to replace say AHU$20* with AHU_*, or something like that. Show us some examples of your point naming scheme and we'll figure it out.
09-18-2008, 02:49 PM
using bql query builder batch edit and pointing to (custom)control, abstactproxyextension to disable unused points such as %DAT-SP%. typing in parent.name
do you need to keep the proxy points at all?
When I had to trim the fat on the pig before, I searched for the point container, then use the remove slot button. The proxy points are slots of the container that they are in.
This effectively deletes the proxy point, instead of disabling it.
If you really just need to disable the extension on multiple points, this is how I do it with Lon (I'm not sure what the custom point type is for jci networks)
Find in LonNetwork, Of type: (Custom Type), lonworks, LonProxyExt
parent.displayName like Bldg300*
The bql statement ends up looking like:
station:|slot:/Drivers/LonNetwork|bql:select * from lonworks:LonProxyExt where parent.DisplayName like 'Bldg300*'
then just click Edit Slot, Property: Enabled, New Value: false
09-18-2008, 08:52 PM
I don't believe that you cannot BQL components that are already in the station database.
"DAT-SP" is a display name, its real name is "DAT$2dSP".
09-19-2008, 05:03 AM
It might be best in the long run to just re-name your points in bulk as previously suggested, remember that although you now have that secret de-coder table I posted, the others that will be using the batch editor may not understand this ;)
The point naming with all the $2d, etc. stuff can end up being very confusing for the end user, as a lot of that stuff carries over to alarms, histories, etc.
Just makes for a sloppy job and something for the customer to ***** about :p
09-19-2008, 10:41 PM
yeah, i think i will have to go through re-naming the points. Any conversion in addition with the points mucks up the search. I will just have to stop bout every 3 hours and let my eyes uncross.hehehe. thanks for the input.
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.