As my app is constantly gaining more and more functions, more parameters are becoming necessary to control these. But some of you may have already created a huge number of cable trays and this results in a problem. The newly-born parameters are not working in the old catalog parts. This happens because their catalog (or SQL for that matter) entry does not contain the new parameter. So if you change it, nothing happens.
Of course this is not a problem for the brand new parts, but as I have already told you, there is a workaround here.
But first of all: very special thanks to Christian Wincziers, he helped me a great deal in perfecting my app (it will never be perfect, but it might be better now, than one-year-before).
Basically what we need to do:
- open the catalog file with an SQL editor
- find the column which contains the geometric info of all the parts in the catalog
- add the new parameter to this column for the parts where this new parameter is not working
- it can be done for multiple lines at once with a little bit of coding which I show you below
Please check the below video, how to handle this problem in details:
The code I was using:
UPDATE
[EngineeringItems]
SET
[ContentGeometryParamDefinition] = REPLACE ([ContentGeometryParamDefinition], ',FB=40', ',FB=40.0')
WHERE
[PartFamilyLongDesc] = ''"
Would you like to check my app?
Check it on the Autodesk App store: