Change sequence of exported columns in List Applet

Change sequence of exported columns in List Applet

Siebel enables data to be exported to CSV/any character delimited files with a couple of clicks.

All you need to do is to select the menu option on the applet, and hit “Export” on a list applet.

siebel data export from applets

While exporting data you can choose to get only the columns visible on the UI, or the entire set of columns available in the list (but hidden in the background).

Types of List Columns

Technically there are three types of columns in a list applet -

  1. Visible columns
  2. Columns that are available to users, but hidden by default
  3. Columns hidden on the UI

(1) and (2) can be changed by the users.

You can rearrange columns, hide fields you don’t like and go all crazy if you want to. Siebel remembers all this and keeps the craziness intact even after you log off and log back in. This happens through user preferences that are saved on the server/remote client.

In Tools, you can see these columns in Applet Web Template Item.

applet web template item

All these fields come from the “List” object of the list applet. You have the option of providing an expression to selectively enable the fields on certain applications.

You may have more fields in the “List” object than you exposed through one or more Applet Web Template Item objects. These sit pretty in the background, and do not play any role in the UI. They do not even get “active” for any manipulations on active object through script or workflows.

list object in siebel applet

However, these fields get considered when user selects the “All” option to export data from a list applet.

You can use this property to hide all additional fields that you normally do not want to use, but want them to be available for an occasional export.

Although immensely helpful for power users, this creates an additional problem.

Arrange Columns in Export Using “All” Option

You select “Visible Columns” in the Export dialog, and you see the list columns exported to CSV file retaining the same order as you see in Siebel UI. But, “All” option does not respect this sequence.

rearrange columns in All export from Siebel

Users can easily change sequence in their favourite program, but tens or hundreds of fields will make this a pain. Even if your users are Excel (or Libre Office) wizards, this is an additional step that no one likes.

You can define this sequence, but surprisingly it is a hidden property in Siebel Tools.

Do this to unhide the property -

  1. Open Siebel Tools CFG (typically in [siebel tools install folder]\bin\enu\tools.cfg
  2. Locate “ClientConfigurationMode” parameter under [Siebel] section
  3. Change the parameter value to “All” instead of the default “Web”
    C:\Users\prash\Desktop\ClientConfigurationMode in Tools CFG.jpg

Now, restart Tools.

You will see additional properties exposed against the List Column¬†object. “Sequence” is one of them.

sequence in list applet

Set the sequence for all list columns in the order in which they should appear in the export.

Compile and see the magic happen.

Tags :
    Comments powered by Disqus

    Related Posts

    Has your industry embraced the cloud?

    In a recent post Gordon Ritter, founder and general partner at Emergence Capital, highlights the state of cloud adoption in industries.

    Read More

    Create Quick Data Entry Screens with Screen Flow

    The typical “CRM flows” work ok, but there’s always opportunities to make them efficient.

    Read More

    Accessing External Data from Salesforce.com

    You can do cool stuff using “External Objects” in force.com - namely, access the data from force.

    Read More