Repository Analyser – Development Update

April 26, 2012 By 2 Comments

When I find a spare moment, I’ve been working away on my C# Repository Analyser tool. I’ve re-jigged the UI a little and added a new piece of functionality that can be used as part of your configuration management processes – Change Log. This process will parse the Siebel Repository, via Siebel Business Objects, and pull out all changes made after the date specified on the form. This gives you an immediate view of who has changed what objects, in order to validate the objects that you’re about to deploy against those you have planned to change as part of your solution design process:

Connect

Connect
◄ Back
Picture 1 of 3

There are also a number of small changes:

  • New app layout with a ‘Connect’ page to specify Siebel server login details
  • New ‘Change Log’ functionality to show all objects changed since a given date, by type
  • New option to export change results to XML
  • New reference counts for the script count functionality, showing standard script volumes in 7.8, 8.1 and 8.2 vanilla installations

And coming up soon:

  • Script Search function to search across all script in the repository, without the pain of the ‘Find in Repository’ functionality in Tools
  • Script Problem Finder function to identify memory leaks, return in finally and other common eScript errors
  • Config Problem Finder function to identify common configuration errors, such as missing ‘Link Spec’ properties and use of ‘Force Active’ field in Join specifications
  • And more!

Keep you eyes peeled for an official release very soon!

 

VN:F [1.9.17_1161]
Rating: 9.0/10 (1 vote cast)
Filed Under: Configuration, eScript, Siebel, Upgrade, Utilities Tagged With: , , ,

Repository Analyser – Source Code

April 18, 2012 By Leave a Comment

My Repository Analyser tool uses some cool code to connect directly to the Siebel Server object manager instance, via C#. It also does some neat things using the Repository BC’s which underly Siebel Tools.

In the spirit of sharing, I want to make the source code available to you all under the GPL – you can download the source code here,

As with all the source that I’ve released, I’d really love to hear from anyone who has made some awesome app or solved some crazy problem  with the code – it’s there for you to use but I’d really appreciate hearing where it’s being applied.

I’ve been doing some really interesting things with this idea, building a set of useful tools and functions – I’ll keep you posted as and when I develop and release new functionality.

VN:F [1.9.17_1161]
Rating: 10.0/10 (1 vote cast)
Filed Under: Siebel, Utilities Tagged With: ,

Siebel Repository Analyser

April 3, 2012 By 4 Comments

I’m still enjoying messing around with C# and Siebel at the moment. Today, I created a tool to analyse the quantity of Browser and Server Script across objects in the Siebel Repository. The tool uses the Siebel COM Data Control to connect directly to a Siebel Server Object Manager – much better than messing around with Dedicated Web Clients! The tool uses the Repository Business Components themselves to analyse the Repository content – there is no direct SQL involved here at all. The idea will be to build this in to a multi purpose analysis tool, that will do more than just count lines of code. Functionality such as performance analysis, memory leak monitoring and exception checking are all in the pipeline.

Anyway, for now I’ve made the tool available for download here. I’m in the process of cleaning up the source code and, as soon as I’m done, I’ll make this available too.

I’d be very interested to hear from readers as to the volumes of script in their implementation. A prize is up for grabs for the first to post evidence of a ‘zero script’ implementation – I’m that confident that no such thing exists! :)

VN:F [1.9.17_1161]
Rating: 0.0/10 (0 votes cast)
Filed Under: eScript, Siebel, Technology, Utilities Tagged With: , , ,

Siebel Spooler in C#

February 21, 2012 By Leave a Comment

A comment from Ranjith prompted me to dig out an old application that I wrote a long while back. It uses the Siebel Mobile Web Client Automation Server control to allow you to dynamically enable and disable spooling from the active Dedicated Web Client session.

SQL Tagging, as provided in Siebel 8, kind of negates some of the need for this type of tool as it’s now pretty easy to see where dodgy SQL is being generated. However, it’s still useful for determining memory leak type issues and the source will also go some way to demonstrating how to use COM from within C# to attach to a running Dedicated Web Client instance.

It really is as simple as including a reference to siebel.exe and then using:

TWSiebelLib.SiebelWebApplication siebelApp = new TWSiebelLib.SiebelWebApplication();

The tool can be found here and the full source code here. You’ll need to run the tool ‘As Administrator’ in order to connect to the Siebel application. You’ll need to do the same with the Visual Studio shortcut too, if you wish to debug the code. Finally, you’ll need to download the Microsoft API Code Pack for Visual Studio if you want to compile the code.

As usual, the source is being distributed under the GNU General Public License.

Please feel free to comment below.

VN:F [1.9.17_1161]
Rating: 0.0/10 (0 votes cast)
Filed Under: Siebel, Technology, Utilities Tagged With: , ,

Siebel COM – a simple LOV loader tool

February 17, 2012 By Leave a Comment

In keeping with my theme of developing useful tools that work with my day to day Siebel tasks, I’ve decided to make available the code to a really useful, and simple, Excel based tool. It’s a spreadsheet that allows you to bulk load and update LOV values in a Siebel environment.

The tool uses the Siebel COM Data Control, which allows the code to connect directly to the Siebel object manager via SISNAPI – there is no requirement to have a Dedicated Web Client running in order to use the functionality. You’ll need a Dedicated Web Client installed in order for the spreadsheet to reference the appropriate DLL and you’ll need to have enabled the COM Data Server as part of the Siebel Server installation process. You can control to which environment you connect via the parameters on the main page.

The code to connect and close the connection to Siebel may prove useful to those of you looking to build similar tools of your own. You can also use what’s there to see how to process spreadsheet records to import via the Siebel objects and how to manipulate Siebel objects based on rows in the spreadsheet.

PLEASE NOTE that I’m making this code available out of the kindness of my own heart, under the GNU General Public License. I can not and will not be held responsible for any loss or damage caused by incorrect use of the tools that I provide free of charge. Pointed at the wrong environment, the tool gives you power to make significant and potentially unwanted changes to data. Be warned!

You can download it here and feedback any comments or suggestions via the comments box below.

VN:F [1.9.17_1161]
Rating: 10.0/10 (2 votes cast)
Filed Under: Siebel, Utilities Tagged With: ,
Next Page »