Alphabetizing the Profiles list in UCM

AlphabetizedProfiles.jpg
Normally when you create your Check In and Search Profiles in UCM, the order in which they are displayed are in the order you created them in.

But some folks have asked if it's possible to alphabetize the list of Profiles so that it's easier to pick out a specific profile.

One quick way is to alphabetize the entire UCM menu. Jason Stortz over at Redstone Content Solutions wrote a terrific component that does just that. He's made available on his blog. I must admit, I'm so used to the alphabetized version of the UCM menus...it's hard for me to go back to the standard version.

But if you want to only alphabetize the profile menus themselves, then there is a file you can modify to do so. The profiles are defined in the file [ucm dir]/data/profiles/document/dpprofiles.hda. If you open that in a text editor, you'll see that the profile entries are part of the DocumentProfiles result set.

profiles_hda.jpg
A quick note about .hda format.... for result sets, the first line indicates the name of the resultset such as @ResultSet DocumentProfiles. The next line indicates the number of data elements in the resultset (and thus the number of lines that make up each result set entry), in this case 4. The next set of lines define each element in the result set, in this case dpName, dpDescription, dpTriggerValue, dpDisplayLabel. And then the following lines after that are the data values themselves.

So what you can do is simply move around the sets of data in the result set to match the order that you want. But be careful... you want to make sure you don't delete or add extra lines as the resultset is very sensitive to the number of lines.

After you make your changes and save the file, you'll need to restart the server to clear it's cached settings of the profiles.

Comments:

Editing the hda file is the quickest & easiest way, but few times will you ever hear Metalink folks advocate that you edit raw hda files directly. Another approach is to use the Config Migration Utility to build a bundle containing your profiles. After verifying the integrity of the bundle, delete your profiles. Next, use CMU to restore your profiles, one by one, in the order in which you wish them to appear. I prefer the edit technique myself, but CMU provides some additional "warm-fuzzies", since you have the profiles backed up, and you're using Oracle-provided tools. By the way, before editing a raw hda file, you always make a backup copy of it, don't you? :-) Don

Posted by Don Glascock on December 01, 2009 at 08:23 AM CST #

Hey Don, yeah, just like modifying any system file it's probably a good idea to make a backup. Support is a bit skittish about it because the .hda format is so sensitive to its formatting. An extra line break in an .hda file may cause the whole server to fail to start. One thing that I've used internally here is a nice utility that one of our trainers wrote a while ago for reading/writing .hda files in Excel. It parses the file into separate sheets and makes them easier to read. I've posted a copy of it
here
. As with other samples on the site, this is offered as-is with no formal support.
The idea of using CMU to rebuild the list is a great one. Using CMU just as a general configuration "backup" utility I think is a good idea too.

Posted by kyle.hatlestad on December 01, 2009 at 11:41 PM CST #

Thanks for the great tool! Don

Posted by Don Glascock on December 17, 2009 at 07:27 AM CST #

Hi Kyle, I tried out this tool on my ucm 10g and it worked perfectly, but when I tried it out on my ecm 11g, nothing happened, my profiles stayed in the same order they were when I created them. Is this tool only for 10g? If so, is there an 11g equivalent?

Posted by Lahya Shingenge on October 25, 2010 at 06:56 PM CDT #

Hello Lahya, Are you referring to the method of modifying the dpprofiles.hda file or Jason Stortz's Alphabetize Menus component? I tried the dpprofiles.hda file and it worked for me in 11g. If you were referring to Jason's component, you'll need to contact him about any updates to it for 11g. His blog is at Core Content Only. Thanks, -Kyle

Posted by kyle.hatlestad on October 25, 2010 at 11:52 PM CDT #

Hello Kyle, I'm talking about the Excel utility. I edited the dpprofiles.hda files for both 10g and 11g, after I refreshed my browser, the 10g menus were re-ordered alphabetically but the 11g menus stayed the same. Regards, -Lahya

Posted by Lahya Shingenge on October 26, 2010 at 12:03 AM CDT #

Hello Lahya, I think you're referring to two different things. I don't have any mention of the Excel utility in this post. Are you speaking about the Managing users en masse post? In regards to this topic and handling the Profiles order, you'll need to restart UCM 11g after making the change to the dpprofiles.hda file. It is being cached by the server, so a restart should clear it. Thanks, -Kyle

Posted by kyle.hatlestad on October 26, 2010 at 01:24 AM CDT #

Hello Kyle, I'm referring to the post from December 2, 2009, which reads as follows: "kyle.hatlestad Author Profile Page: Hey Don, yeah, just like modifying any system file it's probably a good idea to make a backup. Support is a bit skittish about it because the .hda format is so sensitive to its formatting. An extra line break in an .hda file may cause the whole server to fail to start. One thing that I've used internally here is a nice utility that one of our trainers wrote a while ago for reading/writing .hda files in Excel. It parses the file into separate sheets and makes them easier to read. I've posted a copy of it here. As with other samples on the site, this is offered as-is with no formal support. The idea of using CMU to rebuild the list is a great one. Using CMU just as a general configuration "backup" utility I think is a good idea too" I downloaded the utility mentioned in that post and used it to modify both 10g and 11g dpprofiles.hda. Anyways, after I restarted my 11g the profile menu was alphabetized. Thank you very much Regards, Lahya

Posted by Lahya Shingenge on October 26, 2010 at 02:32 AM CDT #

Hi Kyle,

We have a wizard like custom check-in page. It is a single page which is
divided into sections and we use jquery to hide and show. The problem is
one of the fields in the check-in page is to select document profile.
How can we populate fields based on the document profile selected without refreshing the whole page ?

We are thinking of setting dpTriggerValue when someone chooses a profile
through a xProfileTrigger drop down. The important thing is we are trying to avoid full page reload (for seamless activity).

We hope <$include std_document_checkin_fields$> will get the desired fields.

Thanks,
Sunil

Posted by Sunil Ravinder on March 12, 2013 at 06:19 PM CDT #

Hello Sunil,

This will be difficult to achieve because the profile rules are evaluated at the time the page (and service) are executed. To avoid a whole page refresh, you'll need to execute the service through AJAX and use the response (in XML or JSON if desired) to then evaluate and show/hide the fields you need to.

Thanks
-Kyle

Posted by Kyle Hatlestad on March 20, 2013 at 10:25 AM CDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Kyle Hatlestad is a Solution Architect in the WebCenter Architecture group (A-Team) who works with WebCenter Content and other products in the WebCenter & Fusion Middleware portfolios. The WebCenter A-Team blog can be found at: https://blogs.oracle.com/ ateam_webcenter/

Search

Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today