Symbolic String Locator

As an addendum to my previous post here i publish a mini symbolic string locator. It can help you to identify at what all places any particular symbolic string is being used. As a part of beta release it searches only at the Applet(List + Control) level. It is available in Downloads section also.

This can be of real help in scenario when you are asked to modify any existing symbolic string value and you have to look at objects to compile. The advantage of this tool is you don't have to open any sort of siebel client on your machine while running it. Only you have to remember the DSN name, the one given in the CFG for local client. It takes two parameter as input.

Local DSN = The DSN name of your siebel local client and Username/Password.

Symbolic String = The symbolic string to search.

The Objects sheet gives you flexibility to search the limited objects. The output for each object type is captured in respective object sheet.  If it errors out after giving correct DSN name make sure you have selected "Microsoft ActiveX Data Objects Library"  in your excel references. Once again valuable inputs/suggestions/comments are always welcome.

Happy Crunching!!

Symbolic String Compilation

Issues are multifaceted. They can teach and piss you off at the same time.

Recently we faced a simple-cum-silly issue while changing the symbolic string. I have modified the string value of existing string but to my surprise the new value was not getting reflected in the applet. It is only after the compilation of Applet,where this symbolic string is being used, changes were reflected. This is because objects may store the string name rather reference.

Ideally the compilation of symbolic string should have sufficed but unfortunately we have to compile all the underline objects where it is being used in order to confirm the change.


This gives rise to bigger question how to know at what all places any particular Symbolic String is being used. Repository search can aid but again it can force you to wait for ages. I am in process of creating a tool which will take any Symbolic String as Input and will list all the objects where it is being used. Hope to put for global audience for comments soon.

Happy Crunching!!