Newly Hired @ Oracle Egypt

Sorry for not posting from long time that was because I closed my last project, took a vacation, and at last joined Oracle Egypt from couple of days.

I am hired as Senior Sales Consultant for Webcenter Content, and I will try to dedicate more time for posting this year as I became part of Oracle family.

Oracle Database RAC configuration with UCM

If want to configure Oracle Database RAC with Oracle UCM, you will need only to change database connection string inside UCM configuration file (/config/config.cfg), also you can change the connection string using System Properties utility if you want.

The new UCM configurations are:

JdbcDriver=oracle.jdbc.driver.OracleDriver
JdbcConnectionString=jdbc:oracle:thin:@(description=(address_list=(address=(host=your.host1.name)(protocol=tcp)(port=123))(address=(host=your.host2.name)(protocol=tcp)(port=123))(load_balance=yes)(failover=yes))(connect_data=(service_name=service.name)))

START_SEARCH_INDEX

I've been asked a question from "Anirban Datta" from "Tata Consultancy Services" about separating indexing of content based on document types, which means during indexing we want to not index all documents, just some documents based on document types.

By default you cannot do this, but I think using customization we can do that, in UCM we have a service called "START_SEARCH_INDEX" that service is executing a java function called "buildSearchIndex", so If we redeveloped that function again for that service (using reverse engineering), we can make indexing based on document types.

I wish I was helpful for "Anirban Datta"

How to move Vault and Weblayout Directories???

Most of the time you want the vault and weblayout folders to exist in a storage server (for example on SAN storage). You can do that during installation of UCM, where you will be asked for the location of the Vault and Weblayout directories, but if you forgot to do that, no problem you can change the location of the two directories.

In the following lines, I will tell you how to change the location of the two directories:

First I will suppose that we have a shared directory on the file server in which we will move the vault and weblayout directories, let us suppose the shared directory named "\\stellent-share\"

1. Stop the content server
2. Stop the webserver
   
3. Move Vault and Weblayout directories to "\\stellent-share\"
4. Edit the following configuration files
   /bin/intradoc.cfg
   /admin/bin/intradoc.cfg
   and add the following entries
   VaultDir=d:/vault/
   WeblayoutDir=d:/weblayout/
   
5. In the currently used Web Server, change the location of the weblayout in the website settings
   
   Note: You need to create a mapped drive the new location of the weblayout directory (with win, use PUSHD command), which will be used with Web server settings
   
   If for example I mapped "//stellent-share/weblayout" to "Z:", in Apache the configurations will be
   
   
6. Restart the web server
7. Restart the content server

Don't forget you can do the

UCM Workshop in Nigeria

I am late in posting this photo for attendees of Oracle UCM Workshop in Nigeria and me, that is because I received it from a week and I was busy. I'd like to thank Rasaq Hanafi for sending that photo, he is not in this photo, but he was one of the attendees and I think he is one of the most active attendees in the workshop.

Site Studio 10gR4 tutorial

I am currently in the process of building Site Studio 10gR4 tutorial. I will try to help by giving you exact steps for building a complete website using most of Site Studio features. Actually I like the materials that I am using during my trainings for oracle partners which is based on Oracle University materials, and I will try to simulate them.

Egypt from WolframAlpha eyes

Actually I heard about WolframAlpha from my friend Amr Gawish from about month and he explained to me how it will be working, I also read different posts talking about it like Bex's and Billy's posts.

I know Wolfram Mathematica , where I was studying mathematics in faculty (Amr too), and I trust Wolfram because when mathematicians say that they can do something, they will do it :)

I searched for Egypt in WolframAlpha, and I got very good results, I think the best result that I can get, even - for me - better than Wikipedia because when I am searching for a country I want to get fast facts about it. But I think still it to be improved because I searched for other things and I didn't find them.

Well done, Keep on Wellfram.

Views & Resultsets

If you have a view and you want to use it within your code, I mean that you want to loop on the view data to display that data, - using IdocScript- you can get a resultset from that view, then loop on that resultset to display its data.

As an example for how to do that, let us assume that we have a view called view1

<$getViewValuesResultSet("view1", "", "")$>
<$loop SchemaData$>
<option><$dOption$></option>
<$endloop$>

PopUpCalendar component

I was creating a custom checkin page using IdocScript, and in that template I had a metadata field of type date. So I discovered that I need a pop-up calendar, where the user will not care about formating dates.

In Content Server, I found that there are a component called PopUpCalendar which adds pop-up calendars to checkin and search pages. So I said, I should use the same calendar object to give to my custom checkin page the same look and feel.

Note: This component is taken fromYahoo Developer Network, you can find there a lot of useful javascript objects, and part of the content server scripts are taken from there.

So to use that component in your template, do the following

1- If you will use it for custom checkin template, add the following include
<$include std_checkin_html_head_declarations$>

2- If you will use it for custom search template, add the following include
<$include std_query_html_head_declarations$>

3- Now I will assume that we have a metadata field called xPublishDate and we want to have a popup calendar for that field

<input id="xPublishDate" name="xPublishDate" size="20" maxlength="30" value="" type="text" READONLY>
<a href="javascript:pucToggleCalendar('xPublishDate')" style="vertical-align: middle;">
<img style="cursor: pointer; vertical-align: middle;" src="<$HttpWebRoot$>images/PopUpCalendar/calendar.png" border="0" width="20" height="19">
</a>
<script type="text/javascript">
pucCreateCalendar({ id: "xPublishDate", caption: "Publish Date"}, "xPublishDate");
</script>
<div id="puc_panel_xPublishDate_div" style="display: none;">
<div class="hd">Publish Date</div>
<div class="bd">
<div id="puc_calendar_xPublishDate_div"></div>
</div>
</div>

Avoid ExtranetLook Component

The first time I used ExtranetLook component, I liked it, because of the log-in screen, and log-out functionality. But later I discovered that this component is not compatible with other UCM components, as an example this component sometimes you will not be allowed you to log-into the Content Server using Site Studio designer, another example you will not be able to index scanned into the content server using Dynamic Converter.

I don't know why Oracle is releasing that component, and in general why they are releasing incomplete components???

I recommend anyone to not use ExtranetLook component.

I cannot create a WebDAV Folder

I was trying to create a WebDAV folder where I have UCM installed and Desk-Top-Integration suite installed too. I didn't install UCM on that environment, just I installed DIS and some other components, suddenly discovered I cannot create a WebDAV folder.

I tried to find the problem, but I didn't find any where I checked folder_g component and it's working, DIS installed correctly, CS is working, and Folder configurations is absolutely correct. So I asked myself what's the problem, after thinking I said that the installation of CS is not done correctly, something is missing.

So I begun in taking a look at CS installation. I discovered that there are two web-filters in IIS and they are referring to the same ISAPI filter file. That is the problem WebDAV tries to use both on the filters.

Please install Oracle Content Server correctly or don't install it at all.

I am AIIM professional member

Twitter wolrd but we miss it in Egypt

Tiwtter is not well-known here in Egypt and in Middle East in general, but I know everything about twitter even I am member in twitter.com and I wish it will be popular here in Egypt too because I like it so much.

Take a look at that funny slides about twitter, you will like it

Funny Twitter Cartoons

View more presentations from guest91e6d3.

Lawrence Ellison

I was reading "The World's billionaires" list inside forbes and I discovered that Bill Gates becomes #1 in the list again, and I've been surprised when I saw Lawrence Ellison becomes #4 in the list. In some words that means IT giants are still standing and they are still making money.

I quote the following from forbes

Net Worth:$22.5 bil
Fortune:self made
Source:Oracle
Age:64
Country Of Citizenship:United States
Residence:Redwood City, California
Industry:Software
Education:University of Illinois, Drop Out,
Marital Status:married, 2 children

Database titan continues to engulf the competition; Oracle has racked up 49 acquisitions in the past 4 years. Bought BEA Systems for $8.5 billion last year. Still sitting on $7 billion in cash. Revenues up 11% to $10.9 billion in the six months ended November 30; profits also up 11% to $2.4 billion. Stock down 25% in past 12 months. Invested $125 million in Web software outfit Netsuite; took public in 2007, stock has fallen 80% since. His shares still worth $300 million. Chicago native studied physics at U. of Chicago, didn't graduate. Started Oracle in 1977. Public 1986, a day before Microsoft. Owns 453-foot Rising Sun; built a smaller leisure boat because superyacht is hard to park. Squabbling in court with Swiss boating billionaire Ernesto Bertarelli over terms of next America's Cup. Recently unveiled hulking 90-foot trimaran he intends to use to win it.

Inbound Refinery & OpenOffice on linux

I installed Inbound Refinery on Linux, and I want PDF conversion to be enabled, so I installed PDF Converter component and OpenOffice component. I did this using Inbound Refinery installation guide and PDF Converter installation guide. I did the installation successfully but I got an error during conversion.

The error says “The refinery's post converted queue stated that Content ID: 'TESTWORDDOC' converted successfully but the converted files could not be found”, I tried to find a solution and I reviewed the instllation guides, Intreadoc_User group, and Oracle MetaLink mutiple-times but I dind't find anything I did wrongly. After a lot of attempts I discovered that OpenOffice on linux should be strated using "Super User"

so I used that command to start OpenOffice

>sudo soffice "-accept=socket,port=8100;urp;"

Wow, "Renault's Championship Formula One Team Powered by Oracle CM"

Wow, Renault's Championship Formula One Team Powered by Oracle Content Management.



Renault's Championship Formula One Team needs to use and process data in nearly 100,000 documents, and this documents shared across 2 factories and 2 mobile teams. Also The team needs to access documents containing car designs, technical specifications, testing data, and race data; these documents stored in different locations and applications like shared drives, local drives, intranet, and also may be stored on emails.

The team wants to be able to search inside documents, tracking modifications (by creating version for every modification), and secure access to secret documents like car designs and race related information using Oracle Information Rights Management which encrypt documents and track every access trial.

Why did the team choose Oracle Content Management solutions (UCM & IRM)?

• Ease of use
• Rapid development
• Ability of access from multiple locations
• Support metadata search
• FullText search
• version control
• Single and unified repository
• Advanced access control using Oracle Information Rights Management

By luck I have read this success story, and I wish it will be helpful for you, and give you more confidence with UCM capabilities.

Gartner: MarketScope for WCM

Gartner Said, "The WCM market commands revenue of approximately $750 million. With an estimated compound annual growth rate (CAGR) of 15% between 2007 and 2012, it is growing faster than the overall ECM market."


You can see Oracle has been evaluated positive, and in the report MarketScope for Web Content Management, Oracle has been recommended for shortlisting with the leading best-of-breed equivalents.

Also, Gartner Said, "The trend for increased outlay on WCM is strongest in Europe, the Middle East, Africa and Asia/Pacific."

As we know WCM is part of ECM market, and as I am Oracle UCM developer, I like WCM module (Site Studio). But in middle east sales are focusing on other ECM solutions and especially Document Management, and I wish they can focus on selling WCM solutions which is very valuable for big organizations.

Green ECM

Green Technology, I like this word and I am glad because I am working in ECM field that supports green technology concept by default. Implementing document management solutions in your organization will move your company steps toward green initiatives, this by reducing as an example the consumption of electricity and paper.

When you implement document management solution, you want your organization

• become paperless and removing paper bottlenecks
  this will reduce trees cutting, usage of oil, and emissions of carbon
  
• reduce paper storage
  this will save space, that would require energy consumption for heating, lighting, and humidity control
  
• centralize paper management and accessibility
  this will allow accessibility of documents from any location, which will reduce paper printing, and number of employees who are commuting to an office (which will save oil)
  

Do you know

• 1 tree makes 16.67 reams of copy paper or 8,333.3 sheets
• 1 ream (500 sheets) uses 6% of a tree

Document management will not only save money to your organization but also will help your organization to become green organization.

As I am Oracle Universal Content Management guru, I recommend you to try to Oracle Content Management Green Calculator

What's ECM?

What Is ECM?

From: norwiz,
4 days ago

What Is ECM?

View SlideShare presentation or Upload your own. (tags: management' web)

The presentation provides you with an overview of Enterprise Content Management, and related concepts such as document management, collaboration, workflow, electronic records management, and web content management.

SlideShare Link

I am Oracle Connected

I am Oracle connected, what about you!

If you want to be connected with Oracle experts, I recommend you to join Oracle Mix community. It is like Linked In, but you can become connected with anyone of Oracle employees, and that connections will help you in taking decisions faster, and get up-to-date products information.

I hope you can catch me there, find me by my name Hisham Galal.