tag:blogger.com,1999:blog-92066661201479571122024-03-13T00:46:30.840-07:00Only SiebelEverything you need to know about Siebel...Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.comBlogger48125tag:blogger.com,1999:blog-9206666120147957112.post-35132498709420292762013-09-10T14:14:00.002-07:002013-09-10T14:15:41.610-07:00Constellation Resarch Webinar "Where You Stand with Siebel" on Sept. 18th<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Verdana,sans-serif;">
</span>
<div class="post-header">
</div>
<span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"><i>This free 45 minute webinar </i><i><span style="line-height: 13px;">will discuss what different directions Oracle Siebel professionals can take their Siebel implementation and their careers.</span></i>
</span></span>
<br />
<div style="background-color: white; color: #222222;">
<span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"><i><span style="line-height: 13px;"><br /></span></i></span></span></div>
<span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">
</span></span>
<div style="background-color: white; color: #222222;">
<span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">
Who: J. Bruce Daley, Vice President and Principal Analyst Constellation Research</span></span></div>
<span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">
</span></span>
<div style="background-color: white; color: #222222;">
<span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">
What: Webinar: "Where Do You Stand With Siebel”<span style="line-height: 13px;"></span></span></span></div>
<span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">
</span></span>
<div style="background-color: white; color: #222222;">
<span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">
When: Wednesday, <b>September 18</b>, 2013 at<span style="color: #333333; line-height: 13px;"> </span>9:30 a.m. US Pacific time</span></span></div>
<span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">
How: <a href="https://www3.gotomeeting.com/register/578393734" style="color: #1155cc;" target="_blank">https://www3.gotomeeting.com/<wbr></wbr>register/578393734</a></span></span><br />
<br />
<span style="font-family: Verdana,sans-serif;">Research and advisory firm <a href="http://www.constellationr.com/" target="_blank">Constellation Research</a> will hold a Webinar on <b><i><a href="http://www.brucedaley.com/siebelobserver/2013/09/webinar-where-you-stand-with-siebel.html" target="_blank">Where You Stand with Siebel</a></i></b>
on September 18th. The topic will be the different directions Oracle
Siebel customers, partners, and consultants can take their Siebel
implementation and their careers.</span>
<span style="font-family: Verdana,sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Verdana,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8QX-q_Awr7Htt2d0Eg6YCiLTHKbyTWF6BDTjno-eoT1Zh6vOrfamLXN56jsl8UAf2YExik0MJ5h6R5V1rSKgakvZh0KHwsYYhCUXuL1lMUfhS64kxHSeK0yAHrjXxh7fW47alA3Qo_mhX/s1600/constellation-research-logo.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8QX-q_Awr7Htt2d0Eg6YCiLTHKbyTWF6BDTjno-eoT1Zh6vOrfamLXN56jsl8UAf2YExik0MJ5h6R5V1rSKgakvZh0KHwsYYhCUXuL1lMUfhS64kxHSeK0yAHrjXxh7fW47alA3Qo_mhX/s1600/constellation-research-logo.jpg" /></a></span></div>
<span style="font-family: Verdana,sans-serif;">
<br />
<br />
This year marks the <a href="http://siebel-essentials.blogspot.com/2013/07/happy-birthday-siebel-systems.html" target="_blank">20th anniversary of Siebel technology</a>
and as a mature application it shows signs of both robustness and age.
With Oracle sending mixed messages about the product’s future, this
webinar helps people making a living with Siebel determine exactly where
they stand.<br />
<br />
"Clearly Siebel technology is not dead and plays an important role in
the IT infrastructure of many of our clients" noted R "Ray" Wang, CEO of
Constellation Research. "Figuring out exactly where Siebel fits into
the mix is challenging. We are pleased to be helping Siebel customers
meet this challenge."<br />
<br />
The webinar is based on the research paper "The State of Siebel in the
2013 Market: Different Strategies for Moving Siebel Implementations
Forward and Assessing Career Risk" that will be published next week by <a href="http://www.linkedin.com/in/brucedaley" target="_blank">J. Bruce Daley</a>, Vice President and Principal Analyst at Constellation Research.<br />
<br />
Daley was, for many years, the publisher of the <a href="http://www.siebelobserver.com/" target="_blank">Siebel Observer</a>,
the largest publication covering the CRM pioneer. Widely quoted in The
Wall Street Journal, The New York Times, The Financial Times, Daley also
founded the Enterprise Software Summit.<br />
<br />
Bruce's research helps Oracle Siebel customers understand the real
position Siebel technology holds in the market, why the conventional
wisdom about the product is often wrong, and what the trends driving the
misconceptions in the market. The report also offers pragmatic advice
for taking different Siebel implementations in different directions and
how they will impact different careers. The report will be available on
the Constellation website.<br />
<br />
<b>Webinar Information</b><br />
<br />
<u>When</u>: Wednesday, September 18, 2013 at:<br />
<br />
</span><br />
<ul>
<li><span style="font-family: Verdana,sans-serif;">9:30 a.m. US Pacific time</span></li>
<li><span style="font-family: Verdana,sans-serif;">10:30 a.m. US Mountain time</span></li>
<li><span style="font-family: Verdana,sans-serif;">11:30 a.m. US Central time</span></li>
<li><span style="font-family: Verdana,sans-serif;">12:30 a.m. US Eastern time</span></li>
<li><span style="font-family: Verdana,sans-serif;">17:30 UK time</span></li>
<li><span style="font-family: Verdana,sans-serif;">18:30 Central European time</span></li>
</ul>
<span style="font-family: Verdana,sans-serif;">
</span></div>
Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com1tag:blogger.com,1999:blog-9206666120147957112.post-31877202679201347332013-05-09T23:09:00.001-07:002013-06-01T00:15:09.291-07:00The Future of Siebel CRM: Community Poll - [Poll close date 24th May 2013]<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Verdana,sans-serif;">This year marks the 20th anniversary of the founding of <a href="http://en.wikipedia.org/wiki/Siebel_Systems" target="_blank">Siebel Systems</a>. After being acquired by Oracle in 2005, <b>Siebel CRM</b> and the successor of Siebel Analytics, <b>Oracle Business Intelligence,</b> are still flagship products. Thousands of IT professionals worldwide make a living from these two systems.</span><br />
<span style="font-family: Verdana,sans-serif;"><br /></span>
<span style="font-family: Verdana,sans-serif;">Siebel CRM itself has been on the market for 17 years, and in the Siebel community there is much excitement about Oracle's commitment to strengthen the product's position, for example by delivering the Open UI framework. At the same time, many people wonder <b>how many years Siebel has left</b>.</span><br />
<span style="font-family: Verdana,sans-serif;"><br /></span>
<span style="font-family: Verdana,sans-serif;">Always with our fingers on the pulse of the Siebel community, we - a group of dedicated Siebel bloggers* - are working together to conduct a poll to find out public opinion on that question.</span><br />
<span style="font-family: Verdana,sans-serif;"><br /></span>
<span style="font-family: Verdana,sans-serif;">If you want to cast your vote on the poll, you can do it right here. Alternatively you can use <a href="http://www.easypolls.net/poll.html?p=517ebd56e4b0bd1609c6acea" target="_blank">this link</a> to access the poll in a separate window or on a mobile device.</span><br />
<br />
<b><span style="font-family: Verdana,sans-serif;">[POLL CLOSED]</span></b><br />
<br />
<script src="http://www.easypolls.net/ext/scripts/emPoll.js?p=517ebd56e4b0bd1609c6acea" type="text/javascript"></script>
<span style="font-family: Verdana,sans-serif;"><br /></span>
<span style="font-family: Verdana,sans-serif;">Thanks for your vote<br />-Ryan</span><br />
<span style="font-family: Verdana,sans-serif;"><br /></span>
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">*The following blogs are hosting this poll:<br />(in alphabetical order)</span></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br /></span></span>
<span style="font-family: Verdana,sans-serif;"><a href="http://siebelish.blogspot.com/" target="_blank"><span style="font-size: x-small;">CRM Conundrum</span></a></span><br />
<span style="font-family: Verdana,sans-serif;"><a href="http://www.impossiblesiebel.com/" target="_blank"><span style="font-size: x-small;">Impossible Siebel</span></a></span><br />
<span style="font-family: Verdana,sans-serif;"><a href="http://www.ondemand-education.com/blog/" target="_blank"><span style="font-size: x-small;">On Demand Education</span></a></span><br />
<span style="font-family: Verdana,sans-serif;"><a href="http://siebel-essentials.blogspot.com/" target="_blank"><span style="font-size: x-small;">Siebel Essentials</span></a></span><br />
<span style="font-family: Verdana,sans-serif;"><a href="http://www.brucedaley.com/siebelobserver/" target="_blank"><span style="font-size: x-small;">Siebel Observer</span></a></span><br />
<span style="font-family: Verdana,sans-serif;"><a href="http://www.mroshaw.co.uk/OllerenshawIT/" target="_blank"><span style="font-size: x-small;">Siebel Tech Blog</span></a></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><a href="http://siebelunleashed.com/" target="_blank">Siebel Unleashed</a></span></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><a href="http://wentari.blogspot.com/" target="_blank">Wentari</a></span></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"></span></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"></span></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br /></span></span>
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">Did we miss your blog from this list? Do you want to participate? Then please contact Alex via <a href="https://twitter.com/siebel_ess" target="_blank">twitter</a> or <a href="https://plus.google.com/u/0/101106391252120435100/posts" target="_blank">Google+</a>.</span></span><br />
<br />
<b><span style="font-family: Verdana,sans-serif;">[Update]</span></b><br />
<div style="text-align: left;">
<span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">Its been a good two weeks of polling, the poll has now been closed. <a href="http://siebel-essentials.blogspot.in/2013/05/siebel-community-poll-thank-you.html" target="_blank">Thanks to all who participated</a>. We appreciate your comments. A detailed analysis of the results will be put out shortly.</span></span></div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com3tag:blogger.com,1999:blog-9206666120147957112.post-64773709617244095602013-04-07T07:48:00.000-07:002013-04-07T07:48:16.711-07:00Siebel Mobile Connected Apps - Side effects of custom toggle applets.<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Verdana, sans-serif;">We've been doing some development on the very new Siebel mobile connected apps</span>. <span style="font-family: Verdana, sans-serif;">The Siebel Mobile app is a huge and exciting addition to Siebel CRM. However, Just like all new products, you can expect some product defects in the initial version of the software.</span><br />
<br />
<span style="font-family: Verdana, sans-serif;">We will be updating this blog with all the bugs we come accross and their workarounds untill we have a permanent solution from Oracle.</span><br />
<br />
<span style="font-family: Verdana, sans-serif;"><b>Issue: Side effects of custom toggle applet in Siebel Mobile connected apps.</b></span><br />
<br />
<span style="font-family: Verdana, sans-serif;">Here is how you can reproduce the Issue -</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Create a toggle applet on a Form Applet to toggle on a particular LOV value. Lets say the LOV toggle Value is 'Retailer'</span><br />
<span style="font-family: Verdana, sans-serif;"><span style="text-align: left; width: 575px;"><br /><b>Issue 1 - (New Record renders the applet in Base Mode)</b></span></span><br />
<br />
<span style="font-family: Verdana, sans-serif;"><span style="text-align: left; width: 575px;">The applet opens in Base mode when the record context is the value (Retailer) used for the toggle in the list applet. However when you create a new record from
other types record, this does not happen.</span></span><br />
<span style="font-family: Verdana, sans-serif;"><span style="text-align: left; width: 575px;"><br /><b>Issue 2 - (Toggling back from the toggle applet, renders the applet in Base Mode)</b><br /><br />After you have selected the Toggle, and the toggle applet is active switch back to another LOV so the original applet loads. The
applet switches to Base mode instead of staying on Edit mode.</span></span><br />
<span style="font-family: Verdana, sans-serif;"><span style="text-align: left; width: 575px;"><br /><b>Issue 3 - (Applet switches to List Applet on New record instead of opening the entry form applet) - Happens only in iPhone Mode</b></span></span><br />
<span style="font-family: Verdana, sans-serif;"><span style="text-align: left; width: 575px;"><b> </b><br />Upon creating a new record the applet switches to List mode (without loosing context, which is Ok). You then have to tap on the record again to go to Detail mode to edit/ enter data</span> </span><br />
<br />
<b><span style="font-family: Verdana,sans-serif;">Workaround:</span></b><br />
<br />
<span style="font-family: Verdana,sans-serif;">The workaround to the above three issues would be to do away with the base mode completely, and have the applet render in Edit Mode at all times. You can do this by simply selecting the Applet Mode to Edit in the View web template items property.</span><br />
<span style="font-family: Verdana,sans-serif;"><br /></span>
<span style="font-family: Verdana,sans-serif;">Although, this is not the best approach to have a record editable at all times, especially when using a touch phone/pad. Its the only way that can keep the toggle from not breaking.</span><br />
<span style="font-family: Verdana,sans-serif;"><br /></span>
<span style="font-family: Verdana,sans-serif;">Any other workarounds are very welcome!</span><br />
<span style="font-family: Verdana,sans-serif;"><br /></span>
<span style="font-family: Verdana,sans-serif;">Cheers!</span></div>
Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-33582649483873891462013-01-15T03:28:00.001-08:002013-01-15T03:36:00.510-08:00How to time trigger workflows through command prompt<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Verdana, sans-serif;">If you have workflows in your CRM system that are required to be run everyday, but for some reason you are running them manually, this might be a good solution for you to save some time.</span><br />
<br />
<span style="font-family: Verdana, sans-serif;">This solution demonstrates how you can trigger your Siebel workflows at specific intervals of time on windows. For, Siebel environments on other operating systems, you will have to create a solution similar to this, the only difference being the batch file will have to be written in shell (for Linux/Unix) or the programming language that is supported by the OS.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><b>Step 1</b> - Write the batch file</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Copy the below code in a text file and save it with the .bat extension</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><span style="font-family: "Courier New",Courier,monospace;">::Set Localization </span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> setlocal</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">::Gets The Parameters and sets into Environment Variables</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> set GTYSRV=%1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> set ENTSRV=%2</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> set SIEBSRV=%3</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> set SIEBUSR=%4</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> set SIEBPWD=%5</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> </span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">chdir C:\sia81\siebsrvr\BIN</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> </span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> :: <b>The workflow process name</b></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> set wf=Test Workflow</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> set command=run task for comp WfProcMgr with ProcessName='%wf%'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> c:\sia81\siebsrvr\bin\srvrmgr /g %GTYSRV% /e %ENTSRV% /s %SIEBSRV% /u %SIEBUSR% /p %SIEBPWD% /c "%command%"</span></span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">This will connect to the siebel server via the command prompt and call the "Test Workflow" Workflow process.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><b>Step 2</b> - Schedule the batch file</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">The next step would be to schedule the workflow process to run at a certain interval in the day. </span><span style="font-family: Verdana, sans-serif;">On windows you will need to schedule
this through the Windows task scheduler. On Linux/Unix you will probably
have to use crontab.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><a href="http://www.hosting.com/support/windows-server-2008/create-a-scheduled-task-in-windows-server-2008" target="_blank">How to schedule a task in windows</a></span><br />
<br />
<span style="font-family: Verdana, sans-serif;"><a href="http://www.cyberciti.biz/faq/how-do-i-add-jobs-to-cron-under-linux-or-unix-oses/" target="_blank">How to schedule a task via Crontab</a> </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><b>Note:</b> You will have to add the following parameters in the Add Parameters section each separated by a space.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><span style="font-family: "Courier New",Courier,monospace;"><gtysrv> <</gtysrv></span><span style="font-family: "Courier New",Courier,monospace;">ENTSRV> <</span><span style="font-family: "Courier New",Courier,monospace;">SIEBSRV> <</span><span style="font-family: "Courier New",Courier,monospace;">SIEBUSR> <</span><span style="font-family: "Courier New",Courier,monospace;">SIEBPWD></span></span><br />
<br />
<span style="font-family: Verdana, sans-serif;"><span style="font-family: "Courier New",Courier,monospace;"><b>example:</b> Siebel81G siebelDev siebelDev sadmin sadmin@123 </span></span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com9tag:blogger.com,1999:blog-9206666120147957112.post-70212179524247458302012-09-11T09:08:00.001-07:002012-09-11T09:11:14.081-07:00How to Optimize Siebel Application Login Time<div dir="ltr" style="text-align: left;" trbidi="on">
Recently, we've had a lot of users complaining about the homepage taking too long to load. Why does the login page take long to load? What happens when the login page loads. Below are some of the tasks that Siebel performs while loading the application.<br />
<div style="font-family: inherit;">
<br /></div>
<div style="font-family: inherit;">
- Verifying Application Schema Version<br />
- Loading / validating State Models (checks whether or not the expiration date is greater than current date)<br />
- Verifying State Model values for transition<br />
- Loading / Validating Personalization rules and rule sets for each event on applets, Business Components, - - Business services and application<br />
- Loading / validating user profile data.<br />
- Loading / validating System preferences<br />
- Loading localized data (Phone format, date format, time zone, currency etc)<br />
- Loads user reporting hierarchy<br />
- Loads application view-responsibility data.<br />
- Message Broadcast (This can be inactivated by inactivating the Message broadcast bar)</div>
<div style="font-family: inherit;">
<br /></div>
<div style="font-family: inherit;">
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]--><!--[if !mso]><img src="//img2.blogblog.com/img/video_object.png" style="background-color: #b2b2b2; " class="BLOGGER-object-element tr_noresize tr_placeholder" id="ieooui" data-original-id="ieooui" />
<style>
st1\:*{behavior:url(#ieooui) }
</style>
<![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]-->
</div>
<div class="MsoNormal" style="font-family: inherit;">
<span style="color: black;">The reason behind such a behavior
is that some of the static data (localization, license keys etc) and SRF data
that are common to all business components are initialized for the object
manager process with the first task or user login request. It is this
initialization of tasks that causes the delay in service to the first user.</span></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMLL1nuozlfHW-jz6YyIwnLAi6MgQc-x7Y0jpIlIvxJeQGes995sQBXIyXf6D47EuMEoJH4AcdkQ0zOshjuwqrMwL9cl7ILa6Whc9ukwv1_Q0Cf7sjGObN2tlu2lTo9l1ib6CDD6WPhUq3/s1600/untitled.bmp" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="256" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMLL1nuozlfHW-jz6YyIwnLAi6MgQc-x7Y0jpIlIvxJeQGes995sQBXIyXf6D47EuMEoJH4AcdkQ0zOshjuwqrMwL9cl7ILa6Whc9ukwv1_Q0Cf7sjGObN2tlu2lTo9l1ib6CDD6WPhUq3/s400/untitled.bmp" width="400" /></a></div>
<div class="MsoNormal" style="font-family: inherit;">
</div>
<div class="MsoNormal" style="font-family: inherit;">
<span style="color: black;"></span></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<br />
<br />
Setting the “OM - PreLoad
SRF Data” (PreloadSRF) parameter to TRUE will trigger the loading of this
global data for the object manager process when it is initialized upon starting
the services<span style="color: black;">. Now the first login should be faster as
the burden of reading the static data is pushed to the component startup phase.</span></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<b><span style="color: black;">NOTE:</span></b><span style="color: black;"> After setting the parameter to TRUE, you must
recycle the services for the parameter value to take effect.</span></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit;">
<span style="color: black;">If setting the parameter at the enterprise
level, all the object managers in the environment will automatically inherit
the parameter value (unless an administrator has specifically set the value on
the lower object manager level). <br />
<br />
Also, if this parameter is set to be TRUE in conjunction with the MinMTServers
parameter, the static data will be loaded for the number of object manager
processes specified for the MinMTServers parameter when the component is
initialized. This way there will be no delay in service for a large volume of
users since the minimum required multi threaded object manager processes would
already be initialized.</span></div>
<div class="MsoNormal" style="font-family: inherit;">
<br /></div>
<div class="MsoNormal" style="font-family: inherit; text-align: left;">
<span style="color: black;">M.O.S Reference: </span><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]--><span style="color: black; font-family: "Times New Roman"; font-size: 12.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;"><a href="https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=244261169006295&id=476878.1&_afrWindowMode=0&_adf.ctrl-state=xiidzauav_128">Doc
ID - <span style="mso-bidi-font-weight: bold;">476878.1</span></a></span></div>
<div class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;">
</div>
</div>
Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-30073525164411807292012-06-04T02:51:00.001-07:002012-06-04T03:14:56.772-07:00How to Create a Parent with Multi Child Tabs on Aggregate Views<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="font-family: inherit;">
As the quote goes, "You cannot NOT have a user experience". User experience is one of the most important things in product design. I personally feel that Siebel's User Interface could be a lot better than what it is (but thanks to the new Innovation pack for 2012, with the Open UI I think Siebel is getting there).</div>
<div style="font-family: inherit;">
<br /></div>
<div style="font-family: inherit;">
Most users do not like drilling down on a record which then takes them to the detail view of a record and then navigating back to the parent record. What they usually ask for is, if they could have the tabs right on the main view of the screen. Something like this -</div>
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjx3wFknhTKCbZDO4Bio2DBLXFWff6qVWmmVE2uHme9NQ1g2oCsBoRNs-wHIe2Ps5vlmrMVD1XKwE_r2KtloU6J2H6ADmQTAasrcSKgfWZmpzOBGE_1o_xiKxJ2aaHInbMNbgjycNHF0yw/s1600/untitled11.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="165" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjx3wFknhTKCbZDO4Bio2DBLXFWff6qVWmmVE2uHme9NQ1g2oCsBoRNs-wHIe2Ps5vlmrMVD1XKwE_r2KtloU6J2H6ADmQTAasrcSKgfWZmpzOBGE_1o_xiKxJ2aaHInbMNbgjycNHF0yw/s400/untitled11.JPG" width="400" /></a><span style="font-family: Verdana,sans-serif;"> </span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div style="font-family: inherit;">
Some thought this was not possible but actually it is and requires just a web template change for the Aggregate views.</div>
<div style="font-family: inherit;">
<br /></div>
<div style="font-family: inherit;">
Change the Web Template of the view to either one of the following -</div>
<div style="font-family: inherit;">
<br /></div>
<div style="font-family: inherit;">
1. View Parent Multi Child With Tabs</div>
<div style="font-family: inherit;">
2. View Parent List With Tabs</div>
<div style="font-family: inherit;">
<br /></div>
<div style="font-family: inherit;">
Cheers! </div>
</div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com4tag:blogger.com,1999:blog-9206666120147957112.post-60249330879642593772012-05-31T08:15:00.002-07:002012-05-31T08:16:29.458-07:00Generate Quote using Narrative Reports in CRM On Demand<div dir="ltr" style="text-align: left;" trbidi="on">
Hey Guys,<br />
<br />
One thing we all think about is how to design a simple solution to a complicated requirement and so today lets see how to create a Narrative report for a 1:M relation. As you may know Narrative Report can be used only on one record. But, using a combination of reports, we can do the a LOT more!<br />
<br />
All we need to do is create 2 reports linked to each other and add them to a Dashboard. let me show you how.<br />
<br />
<u><b>Step 1:</b></u> Create a Opportunity Parent Report<br />
<br />
Using Opportunities Subject Area (Reporting or Real-Time) Add the fields you would like to use on the Opportunity Information Section of the Quote report.<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5aLii7f4mGdrFfBLWZ7tnBCJSujaWawmYW01ASCD-3CGDvoRJtMdHVXylGljhU-_I4-2zsdftllnhRNjWf5vFYDuMplwXnik16yGP-zlh1wlX8iRoFf8ORY2KV5SKWIqXfQjSPzIxa5qZ/s1600/OpportunityParent.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5aLii7f4mGdrFfBLWZ7tnBCJSujaWawmYW01ASCD-3CGDvoRJtMdHVXylGljhU-_I4-2zsdftllnhRNjWf5vFYDuMplwXnik16yGP-zlh1wlX8iRoFf8ORY2KV5SKWIqXfQjSPzIxa5qZ/s320/OpportunityParent.jpg" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
In <u>Step 2: Create Layout</u>, Add a Narrative View and use the this code<br />
<a href="https://www.dropbox.com/s/o40pfvq04fnyhd4/OpportunityParent.txt" target="_blank">Opportunity Parent Narrative View Code</a>. Make sure you use the @"Number" symbol in the right places, or the values would display against the wrong columns.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPgl_pL0OUlG-omqIz2LcaupnyUmmVdBEMBe0Xl-BjgtKSpBk39CC2W_M2Eu-P7Qe4McqJdul9f5Z24mvBbGB7L068k8WqHCEZYTkTlr0elStS4RVNA5NmCMja-rS9c4uvfquzJZnQDwm-/s1600/OpportunityParentNarrative.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="150" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPgl_pL0OUlG-omqIz2LcaupnyUmmVdBEMBe0Xl-BjgtKSpBk39CC2W_M2Eu-P7Qe4McqJdul9f5Z24mvBbGB7L068k8WqHCEZYTkTlr0elStS4RVNA5NmCMja-rS9c4uvfquzJZnQDwm-/s320/OpportunityParentNarrative.jpg" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
You'll notice that the values are not correct in this preview, don't
worry. since this report is not being filtered from the Prompt yet, the
right values do not appear.<br />
<br />
Save the report<br />
<br />
<u><b>Step 2:</b></u> Create a Opportunity Product Report<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxlQW1YiHScmIOaa2rYDEl8Hd6ZpX0DLB8A5NXZernwvDnMmPsmiyTSRnOdOIDM4a_KBIOSybi1u4YodpWJAfXsZv1aBbw-vJ7s7uzYZas5U1x2ToyS34xHtL7-sIp9msemMnAxHUCs_Qa/s1600/OpportunityParentProduct.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="114" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxlQW1YiHScmIOaa2rYDEl8Hd6ZpX0DLB8A5NXZernwvDnMmPsmiyTSRnOdOIDM4a_KBIOSybi1u4YodpWJAfXsZv1aBbw-vJ7s7uzYZas5U1x2ToyS34xHtL7-sIp9msemMnAxHUCs_Qa/s320/OpportunityParentProduct.jpg" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Using Opportunity Product Revenues Subject Area (Reporting or Real-Time) Add the fields you would like to use on the Product List.<br />
<b style="color: red;">Note</b> that I am filtering the contents of this report based on the results of the Opportunity Parent Report.<br />
In <u>Step 2: Create Layout</u>, Add a Table or Pivot Table (Whichever works for you) and a Narrative View and use the this code <a href="https://www.dropbox.com/s/p4ta15p0e00zowq/OpportunityParentProduct.txt" target="_blank">Opportunity Parent Product Narrative View Code</a>.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqkSHuo2LU9KhakAP1pVfSHK87ZXlDbblKZOk0IAxavLiSKvnXlrvf8KEbxT-HHtn0kCm4_nEpr284LnmVlMrE6YhvnbY88-vY33lE4JbvymEL_S0ChFYRRd6BTnnpLuhncfNtG2kLQyT0/s1600/OpportunityParentProductNarrative.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqkSHuo2LU9KhakAP1pVfSHK87ZXlDbblKZOk0IAxavLiSKvnXlrvf8KEbxT-HHtn0kCm4_nEpr284LnmVlMrE6YhvnbY88-vY33lE4JbvymEL_S0ChFYRRd6BTnnpLuhncfNtG2kLQyT0/s320/OpportunityParentProductNarrative.jpg" width="303" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
You'll notice that the values are not correct in this preview, don't worry. since this report is not being filtered from the parent yet, the right values do not appear. <br />
<br />
OK. Save the Report.<br />
<br />
<u><b>Step 3:</b></u> Create a Dashboard<br />
<br />
Create a New Dashboard and give it a name. In the Design Section add both the above reports.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIiK2Bv-nAm-ogCUBRgpuFIHgoOYuLfX_PlD8OY3p31jxhaVRObzcnsMqEp56PSp2GY-RVv6VrCiZ9Qt4QYRf3bbcqeXdYWtp5ReqGtckDX-QMCc4kWkfFVpNJhRISZL-BKkbnSZAkF9w8/s1600/DashboardDesign.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="137" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIiK2Bv-nAm-ogCUBRgpuFIHgoOYuLfX_PlD8OY3p31jxhaVRObzcnsMqEp56PSp2GY-RVv6VrCiZ9Qt4QYRf3bbcqeXdYWtp5ReqGtckDX-QMCc4kWkfFVpNJhRISZL-BKkbnSZAkF9w8/s320/DashboardDesign.jpg" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Save the Dashboard.<br />
<br />
<u><b>Step 4:</b></u> Create a Web Link (Last Step)<br />
<br />
Create a Web Link on Opportunity and in the URL text area, add the link to your Dashboard you created in Step 3. You can get the URL by Viewing the Source Code<br />
<br />
<b>Ex:</b> https://secure-ausomx<b>xxx</b>.crmondemand.com/OnDemand/user/analytics/saw.dll?Dashboard&PortalPath=%2fshared%2fCompany_XXXXX_Shared_Folder%2f_portal%<br />
2fOpportunityQuote+Report&Options=rfd&Action=Navigate&P0=1&P1=eq&P2=Opportunity%2E%22Opportunity%20ID%22&P3=<b>%%%Id%%%</b><br />
<br />
The <b>%%%Id%%% </b>will dynamically change on clicking the Web-Link from your Opportunity Detail Page and display the Opportunity and Opportunity Product Information on your Quote Report<b><br /></b><br />
<br />
Make sure you test the URL by Adding a Opportunity ID and running the URL in your browser.<br />
<br />
After creating the Web-Link, add it onto your Opportunity Layout.<br />
<br />
<br />
<u><b>Finally:</b></u> Let's see how this report works in reality.<br />
<br />
Goto any Opportunity that has at least One Product associated<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiJqu_FCak6Rep2lWSOQBoUw_QpyqZwXESUURJg0DmGAq7FD9DcXcSaEOUL703kAEZ40McN_4qKx00QMCU-9FQfgVdJiU3oZkOPhHOJnu4apNHSLkzpMWTm46gRF1xe9DuorXrGPGGpGLM/s1600/FrontEndOpportunity.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="147" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiJqu_FCak6Rep2lWSOQBoUw_QpyqZwXESUURJg0DmGAq7FD9DcXcSaEOUL703kAEZ40McN_4qKx00QMCU-9FQfgVdJiU3oZkOPhHOJnu4apNHSLkzpMWTm46gRF1xe9DuorXrGPGGpGLM/s320/FrontEndOpportunity.jpg" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Now click
the "Generate Quote" link that you added. You should now see your Opportunity and
Opportunity Product Information in a beautifully formatted Quote Report. <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIwJvr5aHXiys5k2yva7hm_8HgpSAZrNIi7naxrqG1BcnPYFOUCJ3ksX49AAw3yyk1FCiN6mn7dOSd49gRuBbLKP5Z_UwZr_6EcvoyCxjcW7LM4i-B3yI1RBwB0PF9tWBCiUYlsFh9WWTv/s1600/FinalQuoteQuote.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIwJvr5aHXiys5k2yva7hm_8HgpSAZrNIi7naxrqG1BcnPYFOUCJ3ksX49AAw3yyk1FCiN6mn7dOSd49gRuBbLKP5Z_UwZr_6EcvoyCxjcW7LM4i-B3yI1RBwB0PF9tWBCiUYlsFh9WWTv/s320/FinalQuoteQuote.jpg" width="264" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Now, it's time for you to go and impress your customers!<br />
<br />
If you have any questions about the post, feel free to add your comments!<br />
<br />
Cheers!<br />
Ryan</div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com4tag:blogger.com,1999:blog-9206666120147957112.post-89725518281627683172012-05-31T01:02:00.001-07:002012-05-31T07:52:22.967-07:00Automate Siebel EIM Mapping using SQL<div dir="ltr" style="text-align: left;" trbidi="on">
Hey Everybody,<br />
<br />
Hope you all are doing Great!<br />
<br />
It's been a long time since my last post, apologies for that! Anyway, I have decided to make up for that time and give you some great stuff!<br />
<br />
Recently, I had a LOT of people asking for a way to Automatically generate EIM Mappings. I have written a post previously called <a href="http://onlysiebel.blogspot.in/2009/09/generate-eim-mapping-using-sql-script.html" target="_blank">Generate EIM mapping using SQL Script</a>. However I made some new changes that will give you more information than before.<br />
<br />
So here are the updated versions for Oracle and MS SQL<br />
<br />
<u><b>Output Preview</b></u><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJJT1x0t2u_URcF6SeO7rzYkNJh1WWqYk1HytuESVODMlNo5noi2thk16fPyW2jUHhJ6qgJE9jaOaij1TqeXXu-3Fktcyof3V0VS27kpi6dd8tJSRLvNHceCNW7UQAoPBEOMNSoygXK23d/s1600/eim_mapping_output.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="150" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJJT1x0t2u_URcF6SeO7rzYkNJh1WWqYk1HytuESVODMlNo5noi2thk16fPyW2jUHhJ6qgJE9jaOaij1TqeXXu-3Fktcyof3V0VS27kpi6dd8tJSRLvNHceCNW7UQAoPBEOMNSoygXK23d/s400/eim_mapping_output.JPG" width="400" /></a></div>
<u><b><br /></b></u><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<u><b>Document Links </b></u>: Do what the document tells you are you're good!<br />
<br />
<a href="https://www.dropbox.com/s/6y2stzyqma1dp8k/Automate%20Siebel%20EIM%20Mapping%20using%20SQL_MSSQL.pdf" target="_blank">Automate Siebel EIM Mapping using SQL_MSSQL</a><br />
<a href="https://www.dropbox.com/s/pj2ol3i8jvve8g6/Automate%20Siebel%20EIM%20Mapping%20using%20SQLOracle.pdf" target="_blank">Automate Siebel EIM Mapping using SQL_Oracle</a><br />
<br />
Watch out for more interesting Stuff!<br />
<br />
<br />
Cheers!<br />
Ryan<br />
<br />
<br /></div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com4tag:blogger.com,1999:blog-9206666120147957112.post-6486126797024372032011-12-23T20:26:00.000-08:002011-12-23T20:52:59.974-08:00Happy Christmas and a Prosperous New Year<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;">I'm getting ready for my seasonal break today, so I wanted to take this opportunity to wish all my readers a <b>Very Happy Christmas!</b></span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;">Even if you don't celebrate the religious festival, I hope you enjoy the festive period. Thank you for reading at least some of my blog posts this year, and contributing to some very interesting requirements. I haven't been able to write something new lately, but you ca be sure of some pretty cool posts next year, Stay tuned!</span></div><div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/-PjPv2-uSYSc/TvVT4aqNe3I/AAAAAAAAAcQ/71dyN3P__dU/s1600/100218+merry+christmas+india.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-PjPv2-uSYSc/TvVT4aqNe3I/AAAAAAAAAcQ/71dyN3P__dU/s1600/100218+merry+christmas+india.jpg" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Verdana,sans-serif; font-size: small;">And, if you haven't noticed already...Its snowing :) </span><br />
<br />
<span style="font-family: Verdana,sans-serif; font-size: small;">Once again, we wish you an absolute cracker of a Christmas and a Great New Year, full of happiness!</span></div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-42751558442629117252011-09-08T02:08:00.000-07:002011-09-08T02:27:41.592-07:00Tips 'n Tricks for Oracle CRM On Demand<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: Verdana,sans-serif;">An excellent free book providing tips and tricks fro improving your Oracle CRM On Demand application. - by Mathieu Emanuelli and Joann Alejandro Bravo</div><div style="font-family: Verdana,sans-serif;"><br />
</div><table><tbody>
<tr><td><span style="font-family: "Calibri","sans-serif"; font-size: 11pt; line-height: 115%;"></span><br />
<div class="MsoNormal"></div><table><tbody>
<tr><td><a href="http://helponmyproject.com/TTOCOD/#/1/" style="border-style: none;"><img height="400" src="http://helponmyproject.com/TTOCOD/files/assets/pages/page0001_s.jpg" width="283" /></a></td><td></td></tr>
</tbody></table><br />
<table><tbody>
<tr><td></td><td></td></tr>
</tbody></table></td><td></td></tr>
</tbody></table><span style="font-family: Verdana,sans-serif;">Cheers!</span></div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-8684471335162713892011-08-26T06:00:00.000-07:002011-08-26T06:08:26.998-07:00Generating Data to UI mappings in Siebel just got easier!<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: Verdana,sans-serif;">This is one of those tasks which is fairly simple to do. However, can be very time consuming considering you have to generate a mapping for an entire/multiple repositories. </span><span style="font-family: Verdana,sans-serif;">We've all have had to do this at some point, not enjoying it one bit!</span><br />
<br />
<span style="font-family: Verdana,sans-serif;">Well, here is a code that will save you some time and your sanity :)</span>.<br />
<br />
<span style="font-family: Verdana,sans-serif;">The below code generates a screen to Applet, and an Applet to BC mapping which can be then exported to excel.</span><br />
<span style="font-family: Verdana,sans-serif;"><br />
</span><br />
<b><span style="font-family: Verdana,sans-serif;">Screen to Applet - </span></b><br />
<span style="font-family: Verdana,sans-serif;"><br />
</span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-family: "Courier New",Courier,monospace;">select scr.name "Screen Name"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,nvl(nvl(ptabi.tab_text, scri.viewbar_text), scr.viewbar_text) "Screen"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,scrv.sequence "View Seq"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,vw.name "View Name"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,vwi.title "View"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,vw.busobj_name "Business Object"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,vwti.item_num "Item Num"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,ap.name "Applet Name"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,api.title "Applet"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,ap.buscomp_name "Business Component"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">from siebel.s_repository rep</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_screen scr on scr.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_screen_intl scri on scri.screen_id = scr.row_id and scri.repository_id = rep.row_id and scri.name = 'ENU-STD'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_screen_view scrv on scrv.screen_id = scr.row_id and scrv.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_application appl on rep.row_id = appl.repository_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_page_tab ptab on ptab.application_id = appl.row_id and ptab.repository_id = rep.row_id and ptab.screen_name = scr.name</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_page_tab_intl ptabi on ptabi.page_tab_id = ptab.row_id and ptabi.repository_id = rep.row_id and ptabi.name = 'ENU-STD'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_view vw on vw.name = scrv.view_name and vw.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_view_intl vwi on vwi.view_id = vw.row_id and vwi.repository_id = rep.row_id and vwi.name = 'ENU-STD'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_view_web_tmpl vwt on vwt.view_id = vw.row_id and vwt.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_view_wtmpl_it vwti on vwti.view_web_tmpl_id = vwt.row_id and vwti.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_applet ap on ap.name = vwti.applet_name and ap.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_applet_intl api on api.applet_id = ap.row_id and api.repository_id = rep.row_id and api.name = 'ENU-STD'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">where rep.name = 'Siebel Repository'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and appl.name = 'Siebel Power Communications'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(rep.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(scr.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(scri.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(scrv.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(vw.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(vwi.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(vwt.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(vwti.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(ap.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(api.inactive_flg,'N') = 'N'</span><span style="font-family: "Courier New",Courier,monospace;"></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">union</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">select scr.name "Screen Name"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,nvl(nvl(ptabi.tab_text, scri.viewbar_text), scr.viewbar_text) "Screen"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,scrv.sequence "View Seq"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,vw.name "View Name"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,vwi.title "View"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,vw.busobj_name "Business Object"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,vwti.item_num "Item Num"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,apta.name "Applet Name"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,api.title "Applet"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,apta.buscomp_name "Business Component"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">from siebel.s_repository rep</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_screen scr on scr.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_screen_intl scri on scri.screen_id = scr.row_id and scri.repository_id = rep.row_id and scri.name = 'ENU-STD'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_screen_view scrv on scrv.screen_id = scr.row_id and scrv.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_application appl on rep.row_id = appl.repository_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_page_tab ptab on ptab.application_id = appl.row_id and ptab.repository_id = rep.row_id and ptab.screen_name = scr.name</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_page_tab_intl ptabi on ptabi.page_tab_id = ptab.row_id and ptabi.repository_id = rep.row_id and ptabi.name = 'ENU-STD'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_view vw on vw.name = scrv.view_name and vw.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_view_intl vwi on vwi.view_id = vw.row_id and vwi.repository_id = rep.row_id and vwi.name = 'ENU-STD'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_view_web_tmpl vwt on vwt.view_id = vw.row_id and vwt.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_view_wtmpl_it vwti on vwti.view_web_tmpl_id = vwt.row_id and vwti.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_applet ap on ap.name = vwti.applet_name and ap.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_applet_toggle apt on apt.applet_id = ap.row_id and apt.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_applet apta on apta.name = apt.applet_name and apta.repository_id = rep.row_id</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_applet_intl api on api.applet_id = apta.row_id and apta.repository_id = rep.row_id and api.name = 'ENU-STD'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">where rep.name = 'Siebel Repository'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and appl.name = 'Siebel Power Communications'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(rep.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(scr.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(scri.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(scrv.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(vw.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(vwi.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(vwt.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(vwti.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(ap.inactive_flg,'N') = 'N'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">and nvl(api.inactive_flg,'N') = 'N'</span><span style="font-family: "Courier New",Courier,monospace;"></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">order by "Screen"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,"View Seq"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,"View Name"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,"Item Num"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> ,"Applet Name"</span></span><br />
<br />
<div style="font-family: Verdana,sans-serif;"><b>Output looks like -</b></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnN-_2Psue7bfAu-bckLjLctgjtbaAu63Ap_iaQw8sMpviDjPDyomH4lKZBZ-pgNKVxtDM9B4X0fOQJV66S0gxrSRhCinHAcpxDjGTi3mjaZv8DUUnEcwXCmEBweC4o99UVAUYnKxmKtyi/s1600/1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="66" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnN-_2Psue7bfAu-bckLjLctgjtbaAu63Ap_iaQw8sMpviDjPDyomH4lKZBZ-pgNKVxtDM9B4X0fOQJV66S0gxrSRhCinHAcpxDjGTi3mjaZv8DUUnEcwXCmEBweC4o99UVAUYnKxmKtyi/s400/1.png" width="400" /></a></div><span style="font-family: Verdana,sans-serif;"><span style="font-family: "Courier New",Courier,monospace;"> </span></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-family: "Courier New",Courier,monospace;"> </span></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-family: "Courier New",Courier,monospace;"> </span></span><br />
<div style="font-family: Verdana,sans-serif;"><br />
<br />
<br />
<br />
<br />
<b>Applet to BC mapping - </b></div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><span style="font-family: "Courier New",Courier,monospace;">select "Applet Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"BC Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"BC Field"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Required"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Calculated"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Calculated Value"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Join Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Table"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Column"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Data Type"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Length"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Multi-valued"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"MV Link"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Pick List"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"LOV Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,min("Caption") "Caption"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Display Order"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">from (</span><br />
<span style="font-family: "Courier New",Courier,monospace;">select ap.name "Applet Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,bc.name "BC Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.name "BC Field"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.required "Required"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.calculated "Calculated"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.calcval "Calculated Value"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.join_name "Join Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,(case when fld.mvlink_name is null then nvl(nvl(jotab.name, fld.join_name), case when fld.calculated = 'Y' then null else bc.table_name end) else null end) "Table"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.col_name "Column"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.type "Data Type"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,(case when fld.prec_num is null then to_char(fld.textlen)</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> else to_char(fld.prec_num) || to_char(case when fld.scale is null or fld.scale = 0 then '' else ',' || fld.scale end)</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> end) "Length"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.multi_valued "Multi-valued"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.mvlink_name "MV Link"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,pl.name "Pick List"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,pl.type_value "LOV Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,coi.caption "Caption"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,co.sequence "Display Order"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">from siebel.s_control co</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_control_intl coi on coi.control_id = co.row_id and coi.name = 'ENU-STD'</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_applet ap on co.applet_id = ap.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_buscomp bc on ap.buscomp_name = bc.name</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_field fld on fld.name = co.field_name and fld.buscomp_id = bc.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_repository rep on bc.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_join jo on jo.buscomp_id = fld.buscomp_id and fld.join_name = jo.name</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_table jotab on jotab.name = jo.dest_tbl_name and jotab.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_picklist pl on fld.picklist_name = pl.name and pl.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;">where rep.name = 'Siebel Repository'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and ap.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and co.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and bc.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and fld.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(co.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(ap.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(bc.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(fld.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(rep.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(jo.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">union all</span><br />
<span style="font-family: "Courier New",Courier,monospace;">select ap.name "Applet Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,bc.name "BC Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.name "BC Field"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.required "Required"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.calculated "Calculated"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.calcval "Calculated Value"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.join_name "Join Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,(case when fld.mvlink_name is null then nvl(nvl(jotab.name, fld.join_name), case when fld.calculated = 'Y' then null else bc.table_name end) else null end) "Table"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.col_name "Column"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.type "Data Type"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,(case when fld.prec_num is null then to_char(fld.textlen)</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> else to_char(fld.prec_num) || to_char(case when fld.scale is null or fld.scale = 0 then '' else ',' || fld.scale end)</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> end) "Length"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.multi_valued "Multi-valued"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,fld.mvlink_name "MV Link"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,pl.name "Pick List"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,pl.type_value "LOV Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,coi.display_name "Caption"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,co.sequence "Display Order"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">from siebel.s_list li</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_applet ap on li.applet_id = ap.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_list_column co on co.list_id = li.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_list_col_intl coi on coi.list_column_id = co.row_id and coi.name = 'ENU-STD'</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_buscomp bc on ap.buscomp_name = bc.name</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_field fld on fld.name = co.field_name and fld.buscomp_id = bc.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> inner join siebel.s_repository rep on bc.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_join jo on jo.buscomp_id = fld.buscomp_id and fld.join_name = jo.name</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_table jotab on jotab.name = jo.dest_tbl_name and jotab.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> left outer join siebel.s_picklist pl on fld.picklist_name = pl.name and pl.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;">where rep.name = 'Siebel Repository'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and li.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and ap.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and co.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and bc.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and fld.repository_id = rep.row_id</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(li.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(co.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(ap.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(bc.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(fld.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(rep.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">and nvl(jo.inactive_flg,'N') = 'N'</span><br />
<span style="font-family: "Courier New",Courier,monospace;">)</span><br />
<span style="font-family: "Courier New",Courier,monospace;">group by "Applet Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"BC Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"BC Field"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Required"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Calculated"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Calculated Value"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Join Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Table"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Column"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Data Type"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Length"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Multi-valued"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"MV Link"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Pick List"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"LOV Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">,"Display Order"</span><br />
<span style="font-family: "Courier New",Courier,monospace;">order by "Applet Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,"BC Name"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,"MV Link" desc</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,"Table"</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> ,"Display Order"</span></div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><b>Output looks like -</b></div><div style="font-family: Verdana,sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMj0R3um_Pa4eYt0Wq1qFYdFNE3-Dx_DNiGMvgAjuPmE1Y5p8pvvX0v9gdo_7uub2hf7GSgX14j_ZUep0YCtWuUinB5ENLzzG1y1y-cTkpDoh5JUJ3WiM8ApYtaezE4pIuWMKzV1ZY6nB2/s1600/2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="76" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMj0R3um_Pa4eYt0Wq1qFYdFNE3-Dx_DNiGMvgAjuPmE1Y5p8pvvX0v9gdo_7uub2hf7GSgX14j_ZUep0YCtWuUinB5ENLzzG1y1y-cTkpDoh5JUJ3WiM8ApYtaezE4pIuWMKzV1ZY6nB2/s400/2.png" width="400" /></a><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
So there you go...you could later consolidate both to have a full UI to Data level mapping.<br />
<br />
Oh! Almost forgot, Your welcome ;)</div><div style="font-family: Verdana,sans-serif;"><br />
</div><span style="font-family: Verdana,sans-serif;"><span style="font-family: Verdana,sans-serif;">Cheers! </span></span></div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com1tag:blogger.com,1999:blog-9206666120147957112.post-81658933812151603052011-07-14T06:58:00.000-07:002011-07-15T05:04:03.476-07:00How to Integrate Google maps with Siebel for multiple addresses<span style="font-family: Verdana,sans-serif;">A few days back a client asked me if we could have Google maps integrated with their Siebel application, that would enable their reps to locate their contacts/accounts on Google maps, and find the best way to reach them based on their mode of commute. Initially, they had</span> <span style="font-family: Verdana,sans-serif;">planned to do this</span> <span style="font-family: Verdana,sans-serif;">for single addresses. However, I tried to convince them to go for multiple address selection.</span><br />
<div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">The key business driver here in my opinion would be that, the user can optimize his/her travel route based on the proximity of his/her reps, thus saving time and money. Google maps also offers a few more features like checking for traffic, avoiding tolls, taking highways etc.</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">Google maps is really cool, and integrating it with Siebel makes it cooler ;)</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">Really!! show me how?</div><br />
<span style="font-family: Verdana,sans-serif;"><b>Step 1:</b> The first step would be to get the Google map applet setup</span> <span style="font-family: Verdana,sans-serif;">on your Siebel application. There are many ways to do this. For this example lets go with <a href="http://wiki.oracle.com/page/Mashup+your+CRM+with+Google+maps+in+%3C+30+minutes">Mash-up your CRM with Google maps in < 30 minutes</a></span><a href="http://wiki.oracle.com/page/Mashup+your+CRM+with+Google+maps+in+%3C+30+minutes">.</a><br />
<br />
<span style="font-family: Verdana,sans-serif;"><b>Step 2:</b> Once you have this setup, just copy the below script on the contact/ account list applet or where ever you would like to have this integrated.</span><br />
<br />
<span style="font-family: Verdana,sans-serif;">The below script will automatically refresh your Google map to give you a route of your selected contact addresses and will plot A, B, C pins on the map. Alternatively, you could also use a button to invoke this script</span>.<br />
<br />
<div style="font-family: Verdana,sans-serif;"><b>Script -</b></div><br />
<a href="http://3.bp.blogspot.com/-AOBIGcdWI48/Th76gHgeGOI/AAAAAAAAAbM/fAvuYe0c7ls/s1600/script.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="640" src="http://3.bp.blogspot.com/-AOBIGcdWI48/Th76gHgeGOI/AAAAAAAAAbM/fAvuYe0c7ls/s640/script.png" width="490" /></a><b> </b><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div style="font-family: Verdana,sans-serif;"><b>Step 3:</b> Make sure you change the field names in the script to match your contact BC.<b> </b></div><div style="font-family: Verdana,sans-serif;"><b>Step 4:</b> Compile and test!</div><div style="font-family: Verdana,sans-serif;"><a href="http://1.bp.blogspot.com/-yYjwfmlCye4/Th743jxCxSI/AAAAAAAAAbE/j2e-mB-Ut3M/s1600/Script.bmp" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a></div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><div style="font-family: Verdana,sans-serif;">This is what map would look like</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://1.bp.blogspot.com/-1PpRZUW8_Ns/Th7kFFTi85I/AAAAAAAAAa0/Ugukx8VFTwM/s1600/Gmaps.bmp" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="256" src="http://1.bp.blogspot.com/-1PpRZUW8_Ns/Th7kFFTi85I/AAAAAAAAAa0/Ugukx8VFTwM/s400/Gmaps.bmp" width="400" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Almost forgot, Thanks to Benny and Alex for their post on <a href="http://siebel-essentials.blogspot.com/">Siebel Essentials</a><br />
<br />
Cheers!</div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com2Colaba, Mumbai, Maharashtra, India18.9037004 72.81314320000001318.887518900000003 72.797387200000017 18.9198819 72.828899200000009tag:blogger.com,1999:blog-9206666120147957112.post-29825633951559536922011-05-25T09:24:00.000-07:002011-05-30T03:15:34.526-07:00Multiple Email Validation Script in Siebel<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: Verdana,sans-serif;">This post is a result of my sheer frustration for not getting this right in a 100 tries. I had been trying to validate the email addresses being entered in Siebel. I tried a lot of ways to get it to work (Data Validation Manager, Runtime events, Configuration etc) but the darn thing would just not work. I had to ultimately resort to the "boo hoo"- Script!</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">I thought this would be useful for a lot of Siebel guys out there, will save you from all that frustration.(Checks/validates for a comma separated list of emails as well)</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><b>Code:</b></div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><span style="font-family: "Courier New",Courier,monospace;">function BusComp_PreWriteRecord ()</span><br />
<span style="font-family: "Courier New",Courier,monospace;">{</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> try</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> {</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> this.ActivateField("Email Address");</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> if (this.GetFieldValue("Email Address") != "")</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> {</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> var sEmail = this.GetFieldValue("Email Address");</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> var sPattern = /((\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*)*([, ])*)*/;</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> var isValid = sEmail.replace(sPattern,"Y");</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> if(isValid != "Y")</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> {</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> TheApplication().RaiseErrorText("Please enter a valid email address");</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> return (CancelOperation);</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> }</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> else</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> return (ContinueOperation);</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> }</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> else</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> return (ContinueOperation);</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> }</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> catch (e)</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> {</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> throw (e);</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> }</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> finally</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> {</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> sEmail = null;</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> sPattern = null;</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> isValid = null;</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> }</span><br />
<span style="font-family: "Courier New",Courier,monospace;">}</span></div><div style="font-family: Verdana,sans-serif;"><br />
And last but not least. I must give credit to this post which was the only one that actually worked for me.<span style="font-size: small;"> </span><br />
<a href="http://channel9.msdn.com/Forums/TechOff/250895-Regular-Expression-for-multiple-email-validation-using-the-RegularExpressionValidator-control"><span style="font-size: small;">Regular Expression for multiple email validation</span></a><br />
<h1 style="font-family: Verdana,sans-serif; font-weight: normal;"><span style="font-size: small;"><b>Tip:</b> It is advisable to try out string manipulation, validation scripts in a script simulator before coding it in Siebel. Saves you a lot of time and effort.(for eScript you could use the W3Schools JavaScript Simulator)</span></h1></div><div style="font-family: Verdana,sans-serif;">Cheers!</div></div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com2tag:blogger.com,1999:blog-9206666120147957112.post-14795231515811976312011-04-19T04:46:00.000-07:002011-05-30T03:16:27.304-07:00Siebel Power User - Part 1<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: Verdana,sans-serif;">Hey Folks,</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">Here is the first of the many Siebel power user series to come. Just recently discovered a few cool features in Siebel from an end user perspective.</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">Many a times the user is required to update multiple records of data based on a condition, that the user would normally not know how to execute simultaneously.</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">For instance, I recently had to update a few(not really) activities in Siebel under a condition where the activity had just one contact associated to it. How would an end user go about making this change?</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">Lets discuss two such "Good to knows" in the following scenario</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><b>The Requirement -</b></div><div style="font-family: Verdana,sans-serif;">Lets say you have to update the status of 100 or so activities which do not have more than one contact.</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><b>The Trick -</b></div><div style="font-family: Verdana,sans-serif;">Go to the Activities applet, and use the below query on the Contacts field</div><div style="font-family: Verdana,sans-serif;"><i><b>Count("Contact") > 1</b></i></div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><i><b>Note: Contact is the MVL used in the Contact MVG</b></i><br />
<br />
<i><b> </b></i></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT5a9Go65Fc1W8s2fpNgNCHFiuWYoF4WpJXIjVCgFn7mWlL4KFZA7hJrZfUmPwZUn4SbY3uF3yPY1I0qJ1ur-Xbcr_KAMfwmELy4ctsi-aKxtx6YLrWSKB7w4m7lUQeUzyXtQNQJ38_Lcj/s1600/pic+1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="87" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT5a9Go65Fc1W8s2fpNgNCHFiuWYoF4WpJXIjVCgFn7mWlL4KFZA7hJrZfUmPwZUn4SbY3uF3yPY1I0qJ1ur-Xbcr_KAMfwmELy4ctsi-aKxtx6YLrWSKB7w4m7lUQeUzyXtQNQJ38_Lcj/s400/pic+1.png" width="400" /></a></div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
<br />
This will give you all activities with more than one contact association.</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">Now, lets update the Type of the Activities to 'Call'</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">Select all records and click the Edit option in the application menu and select change records. Change records allows you to update a maximum of 4 fields of the same record simultaneously.</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyrfuP_sdwA4WFzAJMQQt4Jdy7YVPTspD1h0x9heKb18zXpgdiiOsAhxnDlXLMKY70Qa-M2o8hYVl9pjunlu8pRcp-EzkiWbEnpZ0_YC6Fv1ds70a-lLSwsYNuoLKJX4q4oOFS1vZJoGzr/s1600/pic+2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyrfuP_sdwA4WFzAJMQQt4Jdy7YVPTspD1h0x9heKb18zXpgdiiOsAhxnDlXLMKY70Qa-M2o8hYVl9pjunlu8pRcp-EzkiWbEnpZ0_YC6Fv1ds70a-lLSwsYNuoLKJX4q4oOFS1vZJoGzr/s1600/pic+2.png" /></a></div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
<br />
<br />
<br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">Select Type in Field 1 and change the value to 'Call Back'<br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgA09DuidfSgQgOUw72emqcl1644O3UU53KhBpwbAY1gKNFJBYtfF-9XKyDJu2s-Te54eLAChIkbyCyVhIMONiRYON7XA3lYAAGuvXCieXt_xb9fG75v_1F8Ogho-UCo4tDLKiHlzBCLxeq/s1600/pic+3.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="145" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgA09DuidfSgQgOUw72emqcl1644O3UU53KhBpwbAY1gKNFJBYtfF-9XKyDJu2s-Te54eLAChIkbyCyVhIMONiRYON7XA3lYAAGuvXCieXt_xb9fG75v_1F8Ogho-UCo4tDLKiHlzBCLxeq/s320/pic+3.png" width="320" /></a></div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
<br />
<br />
<br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">And there you go, you now have 15 more minutes to facebook ;)</div><div style="font-family: Verdana,sans-serif;"><br />
Please feel free to use the comments section for any feeback on this post, or if you would like to contribute to this series.<br />
<br />
</div><div style="font-family: Verdana,sans-serif;">Cheers!</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><br />
</div></div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-38919477653553915652011-01-18T07:40:00.000-08:002011-01-19T01:26:56.270-08:00Setting a Default Template in an Applet To Be Used With Send Email (F9)<span style="font-family: Verdana,sans-serif;">Hey Guys,</span><br />
<br />
<span style="font-family: Verdana;">Its been a while since my last post, apologies for the same. I have been trying to do too many things at the same time :P</span><br />
<br />
<span style="font-family: Verdana;">While doing some extensive research on Siebel's f9 send email functionality, I came across this cool feature.</span><br />
<br />
<span style="font-family: Verdana;">So if your business uses a common template to send out to its contacts from a specific applet, this feature could prove useful to you - saves you the effort of manually selecting the template.</span><br />
<br />
<span style="font-family: Verdana;">Here is how you can add a Default Email Template to your applet.</span><br />
<br />
<span style="font-family: Verdana;"><b>Step 1:</b> Query for the desired applet you want to set up the email template for.</span><br />
<br />
<span style="font-family: Verdana;"><b>Step 2:</b> Goto View > Windows > Properties Window.</span><br />
<br />
<span style="font-family: Verdana;"><b>NOTE:</b> If you are using Siebel versions prior to 8.x. You do not have to open the applet properties window. You should see it as part of the properties for the applet in OBLE.</span><br />
<br />
<span style="font-family: Verdana;"><b>Step 3:</b> In the Mail Template property enter the Email template name exactly the way it appears in the Siebel Client.</span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjCeT0FNHbZwWTgS4BcLluvhnWMOjZ6UzL5AAehTJkIF3pD-wSPv0HTvsNQN2DXo_RegUHcJxgppFe5qwwjVn1z3_8dgbGU8oFDlpIfb3ODG0-WLPLz8Yah94GMA63X7xN_himXHoR5m7I/s1600/untitled.bmp" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="300" n4="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjCeT0FNHbZwWTgS4BcLluvhnWMOjZ6UzL5AAehTJkIF3pD-wSPv0HTvsNQN2DXo_RegUHcJxgppFe5qwwjVn1z3_8dgbGU8oFDlpIfb3ODG0-WLPLz8Yah94GMA63X7xN_himXHoR5m7I/s400/untitled.bmp" width="400" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Verdana;"><b>Step 4:</b> Compile and test - Now when you are on the just modified applet and hit F9, you should see the template pre-populated in the template selection dialog.</span><br />
<br />
<i><span style="font-family: Verdana; font-size: small;"><b>Note:</b> </span><span style="font-family: Verdana,sans-serif; font-size: small;">Setting a default template for the Send Email command, as described above, overrides template visibility by channel. For example, if a template is specified as the default email template for Change Request applets, this same template will also be the default template for these applets for the fax channels (using the Send Fax command).</span></i><span style="font-family: Verdana;"> </span><br />
<br />
<span style="font-family: Verdana;">Cheers!</span>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-58494786023363172622010-10-29T02:41:00.000-07:002010-11-10T23:17:04.322-08:00Skype - Siebel Custom Integration<span style="font-family: Verdana,sans-serif;">Want to call one of your contacts/prospects in Siebel without a lot of manual effort? now you can...</span><br />
<span style="font-family: Verdana,sans-serif;">Here are a few simple steps of how you could integrate Skype with your siebel application.</span><br />
<br />
<span style="font-family: Verdana,sans-serif;">Thank you <b>Bernard</b> for sharing this</span>!<br />
<br />
<span style="font-family: Verdana,sans-serif;"><b>Configuration Steps</b> - (for this example I am going to use the contacts applet)</span><br />
<br />
<span style="font-family: Verdana,sans-serif;"><b>Step 1: </b></span><span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">Create a custom Business service called 'OS Skype Integration' and assign it to a locked project.</span></span></span></span></span><br />
<br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">place the below code in the PreCanInvokeMethod event of the Business Service</span></span></span></span></span><span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"> </span></span></span></span></span><br />
<br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"><span style="font-family: "Courier New",Courier,monospace;">function Service_PreCanInvokeMethod (MethodName, &CanInvoke)</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">{</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> if(MethodName == "GetField")</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> {</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> CanInvoke="TRUE";</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> return(CancelOperation);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> else if(MethodName == "TransformToSkype")</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> {</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> CanInvoke="TRUE";</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> return(CancelOperation);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> else</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> {</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> return(ContinueOperation);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">}</span></span></span></span></span></span><br />
<br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">place the below code in the PreInvokeMethod event of the Business Service</span></span></span></span></span><br />
<div style="font-family: "Courier New",Courier,monospace;">function Service_PreInvokeMethod (MethodName, Inputs, Outputs)<br />
{<br />
try<br />
{<br />
switch (MethodName) <br />
{<br />
case "GetField":<br />
this.GetField(Inputs, Outputs);<br />
return (CancelOperation);<br />
<br />
case "TransformToSkype":<br />
this.TransformToSkype(Inputs, Outputs);<br />
return (CancelOperation); <br />
<br />
default:<br />
return (ContinueOperation);<br />
}<br />
}<br />
catch(e)<br />
{<br />
TheApplication().RaiseErrorText(e.toString());<br />
}<br />
finally<br />
{<br />
}<br />
}<span style="font-family: Verdana,sans-serif;"> </span></div><span style="font-family: Verdana,sans-serif;">Now that the two methods are defined and ready for use, lets define the logic inside them</span><br />
<span style="font-family: Verdana,sans-serif;"><br />
</span><br />
<span style="font-family: Verdana,sans-serif;">Create two new functions as below -</span><br />
<br />
<span style="font-family: Verdana,sans-serif;"><b>GetField:</b> This method as you can see will get the properties set by the Browser script in the Contact List Applet and will make them available in the Input Property Set of the Business Service.</span><br />
<span style="font-family: Verdana,sans-serif;"><br />
</span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-family: "Courier New",Courier,monospace;">function GetField(Inputs, Outputs)</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">{</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var sfield = Inputs.GetProperty("fieldname");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var sId = Inputs.GetProperty("Id");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var boName = Inputs.GetProperty("boName");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var bcName = Inputs.GetProperty("bcName");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var bo = TheApplication().GetBusObject(boName);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var bc = bo.GetBusComp(bcName);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> bc.ClearToQuery();</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> bc.SetViewMode(AllView);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> bc.ActivateField(sfield);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> bc.SetSearchSpec("Id", sId);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> bc.ExecuteQuery(ForwardOnly);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> if (bc.FirstRecord())</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> { </span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var svalue = bc.GetFieldValue(sfield);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> Outputs.SetProperty("fieldvalue",svalue);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> else</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> {</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> Outputs.SetProperty("fieldvalue","");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">}</span></span><br />
<span style="font-family: Verdana,sans-serif;"><b> </b></span><br />
<span style="font-family: Verdana,sans-serif;"><b> TransformToSkype: </b>This method contains the main string used to make the call. The string includes the Skype exe path and teh Phone Number of the call recipient/Siebel Contact.</span><br />
<span style="font-family: Verdana,sans-serif;"><br />
</span><br />
<span style="font-family: Verdana,sans-serif;">So, the string being passed would look something like this <i>"C:\Progra~1\Skype\Phone\skype" /callto:+14152065351. </i>This string is passed to the browser script for execution.</span><br />
<br />
<span style="font-family: Verdana,sans-serif;"><b>NOTE 1:</b> The target customer base for the Client where I implemented this was for US only, thats why the '+1'. If you wish to make it more general you could check the Country of the contact and derive the country code based on that.</span><br />
<span style="font-family: Verdana,sans-serif;"> </span><br />
<span style="font-family: Verdana,sans-serif;"><b>NOTE 2:</b> You could also simply use '</span><span style="font-family: Verdana,sans-serif;"><i>callto:+14152065351</i></span><span style="font-family: Verdana,sans-serif;">' in the below script skiping an extra step(Step2 - Creating the LOV) - Thanks <b>Ranjith</b> for pointing that out.</span><br />
<span style="font-family: Verdana,sans-serif;"><b> </b></span><br />
<span style="font-family: Verdana,sans-serif;"> <span style="font-family: "Courier New",Courier,monospace;">function TransformToSkype(Inputs, Outputs)</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">{</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var sWorkphone = Inputs.GetProperty("PhoneNum");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var sFirst = sWorkphone.charAt(0);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var sSkypeNum="";</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var sLOVText = TheApplication().InvokeMethod("LookupValue","OS_SKYPE_PATH","Path");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> if(sFirst!="+")</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> {</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> sSkypeNum = "\"" + sLOVText + "\"" + " /callto:+1" + sWorkphone;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> else</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> {</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var sLast = "\n"</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var sSubstr = Clib.strstr(sWorkphone, sLast);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var sRtn = sWorkphone.replace(sSubstr, "");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> //sSkypeNum = "skype:" + sRtn + "?Call";</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> sSkypeNum = "\"" + sLOVText + "\"" + " /callto:" + sRtn;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> Outputs.SetProperty("SkypeNum",sSkypeNum);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">}</span><b><br />
</b></span><br />
<span style="font-family: Verdana,sans-serif;"><b> </b></span><br />
<span style="font-family: Verdana,sans-serif;"><b>Step2: </b></span><a href="http://download.oracle.com/docs/cd/E14004_01/books/ConfigApps/ConfigApps_LOVs3.html" id="aptureLink_leZUbsNlTj" style="font-family: Verdana,sans-serif;">Create an LOV</a><span style="font-family: Verdana,sans-serif;"> as seen in the below screenshot - This would contain the .exe path of Skype.</span><br />
<br />
<a href="http://apture.s3.amazonaws.com/0000012bf7681ff0dd13c64c007f000000000001.LOV.png" id="aptureLink_tmKMr8phT3" style="float: left; padding: 0px 6px;"><img height="82px" src="http://apture.s3.amazonaws.com/0000012bf7681ff0dd13c64c007f000000000001.LOV.png" style="border: 0px none;" title="LOV" width="451px" /></a><span style="font-family: Verdana,sans-serif;"> </span><br />
<span style="font-family: Verdana,sans-serif;"><b> </b></span><br />
<span style="font-family: Verdana,sans-serif;"><b></b></span><br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Verdana,sans-serif;"><b>Step 3</b>: Lock the 'Contact List Applet' and create three custom buttons as shown in the screenshot.(Note: The 'InvokeMethod property for the Skype buttons should be same as the ones in the script')</span><br />
<span style="font-family: Verdana,sans-serif;">Make sure the buttons are clickable by using the </span><a href="http://download.oracle.com/docs/cd/B40099_02/books/ToolsDevRef/ToolsDevRef_UserProps6.html" id="aptureLink_fmqgf07dZV" style="font-family: Verdana,sans-serif;">CanInvokeMethod</a><span style="font-family: Verdana,sans-serif;"> Applet User property.</span><br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><img height="90" src="http://apture.s3.amazonaws.com/0000012bf73a5d936f188118007f000000000001.Contact%20Applet.png" style="border: 0px none; margin-left: auto; margin-right: auto;" title="Contact Applet" width="400" /></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><br />
</td></tr>
</tbody></table><span style="font-family: Verdana,sans-serif;"> </span><br />
<span style="font-family: Verdana,sans-serif;"><b></b></span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Verdana,sans-serif;">You could also get more creative and use a 'Skype Toolbar' in Siebel. Like I have and call the business service from the Command Invoked. The Script would change in that case.(The Browser script from the applet would then be required on the Business Service)</span><br />
<span style="font-family: Verdana,sans-serif;"><b> </b></span><br />
<a href="http://apture.s3.amazonaws.com/0000012bf77431fd891b0b2f007f000000000001.Toolba2r.png" id="aptureLink_NTgdq37DrE" style="clear: left; display: block; float: left; margin-bottom: 1em; margin-right: 1em; margin-top: 0pt; padding: 0px 6px; text-align: center;"><img height="110px" src="http://apture.s3.amazonaws.com/0000012bf77431fd891b0b2f007f000000000001.Toolba2r.png" style="border: 0px none;" title="Toolba2r" width="452px" /></a><span style="font-family: Verdana,sans-serif;"><b> </b></span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Verdana,sans-serif;"><b>Step 4</b>: Place the below script in the browser script evet <i>Applet_PreInvokeMethod </i>of the contact list applet.</span><br />
<br />
<b><span style="font-size: x-small;"><i><span style="font-family: Verdana,sans-serif;">code:</span></i></span></b><br />
<span style="font-family: Verdana,sans-serif; font-size: small;"><span style="font-family: "Courier New",Courier,monospace;">function Applet_PreInvokeMethod (name, inputPropSet)</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">{</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> if(name=="Skype" || name=="SkypeCell" || name=="SkypeHome")</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> {</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> try</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> {</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var serv = theApplication().GetService("OS Skype Integration");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var inp = theApplication().NewPropertySet();</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var outs = theApplication().NewPropertySet();</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inp.SetProperty("Id", this.BusComp().GetFieldValue("Id"));</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> switch(name)</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> {</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> case "Skype":</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inp.SetProperty("fieldname","Work Phone #");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> break;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> case "SkypeCell":</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inp.SetProperty("fieldname","Cellular Phone #");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> break;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> case "SkypeHome":</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inp.SetProperty("fieldname","Home Phone #");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> break;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inp.SetProperty("boName", this.BusObject().Name());</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inp.SetProperty("bcName", this.BusComp().Name());</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> outs = serv.InvokeMethod("GetField",inp); </span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var svalue = outs.GetProperty("fieldvalue");</span><span style="font-family: "Courier New",Courier,monospace;"></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> </span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inp = null;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inp = theApplication().NewPropertySet();</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inp.SetProperty("PhoneNum",svalue);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> outs = null;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> outs = theApplication().NewPropertySet();</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> outs = serv.InvokeMethod("TransformToSkype",inp);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> svalue="";</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> svalue = outs.GetProperty("SkypeNum");</span><span style="font-family: "Courier New",Courier,monospace;"></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> </span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> //calls the ActiveXObject and passes the Skype exe path allong with the phone number of the contact</span></span><br />
<span style="font-family: Verdana,sans-serif; font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"> var wsh = new ActiveXObject("WScript.Shell");</span><span style="font-family: "Courier New",Courier,monospace;"></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> var oExec = wsh.Exec(svalue); </span><span style="font-family: "Courier New",Courier,monospace;"></span><span style="font-family: "Courier New",Courier,monospace;"></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> wsh=null;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> return ("CancelOperation");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> catch(e)</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> {</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> alert ("Error Applet_PreInvokeMethod : " + e.toString());</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> finally</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> {</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> inp=null;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> outs=null;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> serv=null;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> }</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> return ("ContinueOperation");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">}</span></span><br />
<br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">This script will call the 'OS Skype Integration' and pass the respective Phone numbers for transformation if required.</span></span></span></span></span><br />
<br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"><b>Step 5</b>: Since we are invoking the Business service from the browser level. The Business service will have to be registered as a client business sevice in the Application User Props</span></span></span></span></span><br />
<br />
<a href="http://apture.s3.amazonaws.com/0000012bf75fe18103d2e0f7007f000000000001.App%20User%20Prop.png" id="aptureLink_HTqSEgTffC" style="float: left; padding: 0px 6px;"><img height="202px" src="http://apture.s3.amazonaws.com/0000012bf75fe18103d2e0f7007f000000000001.App%20User%20Prop.png" style="border: 0px none;" title="App User Prop" width="469px" /></a><span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"> </span></span></span></span></span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"><b>Step 6: </b>Compile all objects you modified.</span></span></span></span></span><br />
<br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"><b>Step 7</b>: Compile the browser scripts by using </span></span></span></span></span><a href="http://download.oracle.com/docs/cd/E14004_01/books/ConfigApps/ConfigApps_Overview41.html" id="aptureLink_xsJNmZAgDc" style="font-family: Verdana,sans-serif;">Genb</a><span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"> or should I say </span></span></span></span></span><a href="http://www.impossiblesiebel.com/2010/10/ultra-browser-script-generator-2.html" id="aptureLink_WzjtBbYUDK" style="font-family: Verdana,sans-serif;">UltraGenB</a><span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">(A cool new utility created by </span></span></span></span></span><a href="http://twitter.com/ImposSiebel" id="aptureLink_UpTKDZq09k" style="font-family: Verdana,sans-serif;">Jason Le</a><span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"> of </span></span></span></span></span><span style="font-family: Verdana,sans-serif; font-size: small;"><a href="http://www.impossiblesiebel.com/" id="aptureLink_NRk2ssiPAF">Impossible Siebel</a></span><span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">)</span></span></span></span></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"><br />
</span></span></span></span></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">Query on any contact in the Contact List Applet and hit one of the buttons....and there you have it...TRING TRING!!!</span></span></span></span></span><br />
<a href="http://apture.s3.amazonaws.com/0000012bf77d68b125d9cac3007f000000000001.Call.png" id="aptureLink_jyZEoMMx49" style="clear: left; display: block; float: left; margin-bottom: 1em; margin-right: 1em; margin-top: 0pt; padding: 0px 6px; text-align: center;"><img height="358px" src="http://apture.s3.amazonaws.com/0000012bf77d68b125d9cac3007f000000000001.Call.png" style="border: 0px none;" title="Call" width="518px" /></a><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;">Happy Calling!!</span></span></span></span></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"><br />
</span></span></span></span></span><br />
<span style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: Verdana,sans-serif;"><br />
</span></span></span></span></span>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com2tag:blogger.com,1999:blog-9206666120147957112.post-20324613307352398062010-09-19T22:25:00.000-07:002010-10-18T00:09:10.795-07:00Launching iHelp with eScript<div style="font-family: Verdana,sans-serif;">Hey Folks,</div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;">I had a requirement with one of my clients to have a button on a Form Applet that opens the <a href="http://onlysiebel.blogspot.com/2010/02/how-do-icreate-ihelp.html" id="aptureLink_kN9Mel4fiH">iHelp</a>. <br />
<br />
"My Oracle Support" has a few SR's that are related, and I had tried various things including trapping the method calls that are triggered when clicking on the iHelp button on the Toolbar, then repeating them on my custom button but with no luck. <br />
<br />
Oracle support seems to confirm you can't Launch iHelp with Script in Siebel 7.7, but doesn't mention Siebel 8.1 (which probably means you can't do it!) <br />
<br />
This however is possible through script. You could use the below code on the button to toggle the iHelp from a custom button.</div><br />
<div style="font-family: Verdana,sans-serif;"><span style="font-size: small;"><b>Code:</b></span></div><br />
<div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">function WebApplet_PreInvokeMethod (MethodName)<br />
{</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"> if(MethodName == "LaunchiHelp")<br />
{<br />
var </span><span style="font-size: small;">oBS</span><span style="font-size: small;">= TheApplication().GetService("Task Assistant UI Service");<br />
var </span><span style="font-size: small;"> psInputs </span><span style="font-size: small;">= TheApplication().NewPropertySet();<br />
var </span><span style="font-size: small;">psOutputs </span><span style="font-size: small;">= TheApplication().NewPropertySet();<br />
</span><span style="font-size: small;">oBS</span><span style="font-size: small;">.InvokeMethod("ToggleiHelp",</span><span style="font-size: small;"> </span><span style="font-size: small;"> psInputs</span><span style="font-size: small;">,</span><span style="font-size: small;">psOutputs</span><span style="font-size: small;">);<br />
return (CancelOperation);<br />
}<br />
}</span></div><br />
<span style="font-family: Verdana,sans-serif;">Your custom button should now function exactly like the iHelp launch button on the toolbar.</span><br />
<br />
<span style="font-size: small;"><b style="font-family: Verdana,sans-serif;">Update </b><i><span style="font-family: Verdana,sans-serif;">(thanks to my colleague for sharing this)</span></i><b style="font-family: Verdana,sans-serif;"><br />
</b></span><br />
<br />
<div style="font-family: Verdana,sans-serif;">I have had to add an update to the code so that it looks like this: <br />
<br />
<div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">var psInputs = TheApplication().NewPropertySet();</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">var psOutputs = TheApplication().NewPropertySet();</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><b>psInputs.SetProperty("Command", "#14");</b> </span><span style="font-size: small;"><br />
</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">var oBS = TheApplication().GetService("Task Assistant UI Service");</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">oBS.InvokeMethod("ToggleiHelp", psInputs, psOutputs);</span> </div><br />
Without this parameter there are issues with opening / closing iHelp multiple time from different entities. It results in a Siebel crash and you have to log in again. With the command property it appears to work fine. <br />
<br />
Just a word of caution: this command number is likely to be different in different version of Siebel. It is 8.1.1.2 SIA [21215] ENU that I have this working for.</div><br />
<span style="font-family: Verdana,sans-serif;">Cheers!</span>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-51691419528768163582010-08-06T06:25:00.000-07:002010-08-09T01:57:32.655-07:00Get NASDAQ Market updates in Siebel<div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;">Like most of you Siebel lovers I too like to integrate anything and everything with Siebel. Here is an example of how you can get NASDAQ updates within your Siebel Application.</span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;">Here is how you do it!</span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;"><i><b>Steps:</b></i></span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;">1. Create an applet with a Single control.</span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;">2. Add the following code to your single control that you have in your applet.</span><br />
<span style="font-size: small;"><br />
</span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;"><b>Caption String Override: </b>(in frame src tags) <span style="font-size: x-small;">="tickerpanel.asp?COOKIE=S~MSFT~~|S~INTC~~|S~NWSA~~|S~QQQQ~~|S~CSCO~~|</span></span><br />
<span style="font-size: small;"><span style="font-size: x-small;">S~ATML~~|S~DELL~~|S~NVDA~~|S~RIMM~~|S~MU~~|I~IXIC|I~INDU|I~SPX" name="ticker" scrolling="no" frameborder=0 noresize marginwidth="0" marginheight="0" </span></span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;">3. place this applet in a view and your done!</span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;"></span><br />
<span style="font-size: small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhE_YDTCiK7twya-bXtkNk6m0cQSyPPzo3P4JfCQYwUQQS5a3ZKNSuGPahd-Sc5lF1v95cSJ5Opcihhs0N94kro0oTwj_im00wYoujZ8vX6SLTkRh8KR7SrLyL79Gim6-UUdUhEeVPm_6yC/s1600/Untitled+picture.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="120" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhE_YDTCiK7twya-bXtkNk6m0cQSyPPzo3P4JfCQYwUQQS5a3ZKNSuGPahd-Sc5lF1v95cSJ5Opcihhs0N94kro0oTwj_im00wYoujZ8vX6SLTkRh8KR7SrLyL79Gim6-UUdUhEeVPm_6yC/s400/Untitled+picture.png" width="400" /></a></span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;"> </span></div><div style="font-family: Arial,Helvetica,sans-serif;"><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-size: small;"> </span><br />
<span style="font-size: small;"> </span></div><div style="font-family: Arial,Helvetica,sans-serif;"><br />
<span style="font-size: small;">Stay tuned for a more advanced version of this post!</span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;">Cheers!</span></div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-34884180130341611822010-07-08T02:50:00.000-07:002010-07-08T23:51:50.591-07:00Create an HTML email in Oracle CRM On Demand<div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"></span></div><div style="font-family: "Trebuchet MS",sans-serif;"><meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta><meta content="Word.Document" name="ProgId"></meta><meta content="Microsoft Word
12" name="Generator"></meta><meta content="Microsoft Word 12" name="Originator"></meta><link href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml" rel="File-List"></link><link href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx" rel="themeData"></link><link href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="colorSchemeMapping"></link> <m:smallfrac m:val="off"> <m:dispdef> <m:lmargin m:val="0"> <m:rmargin m:val="0"> <m:defjc m:val="centerGroup"> <m:wrapindent m:val="1440"> <m:intlim m:val="subSup"> <m:narylim m:val="undOvr"> </m:narylim></m:intlim> </m:wrapindent><style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:1;
mso-generic-font-family:roman;
mso-font-format:other;
mso-font-pitch:variable;
mso-font-signature:0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1073750139 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoPapDefault
{mso-style-type:export-only;
margin-bottom:10.0pt;
line-height:115%;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style><span style="font-size: small;">Hey Folks,</span></m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac></div><div style="font-family: "Trebuchet MS",sans-serif;"><br />
</div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">For any business, It's very important to keep your customers happy at all times.You need to constantly keep them updated on how their service requests are being processes. Below is one such example</span><br />
<br />
<span style="font-size: small;">I recently came across a requirement in which my client wanted to have some functionality in which, when a new SR is created, a Service Representative should be able to generate a neatly formatted email with all the required information and send it across to a Customer, so they know that the SR is being looked into, something like a SR Acknowledgment.</span><br />
<br />
<span style="font-size: small;">Here's what I did for them!</span><br />
<br />
<i><b><span style="font-size: small;">Solution:</span></b></i><br />
<br />
<span style="font-size: small;"><b>Step 1: Build the Report</b></span><br />
<span style="font-size: small;">Create a Narrative Report that will contain all the required fields that is required to send out an email.</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhejxtI_3qHvXE5nQH29KRnKYrCo1prAGA_-QRooJK42aZ8x9S4gOuWQJkmiu3NeQXn8Hem1PxXPWvTaMIwb13JQ-YOLFR8KY9qhD5cLzPh_CrDfDHyjB17DQdb2bomoW-mFZmoJNdXfZdn/s1600/html_report_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="103" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhejxtI_3qHvXE5nQH29KRnKYrCo1prAGA_-QRooJK42aZ8x9S4gOuWQJkmiu3NeQXn8Hem1PxXPWvTaMIwb13JQ-YOLFR8KY9qhD5cLzPh_CrDfDHyjB17DQdb2bomoW-mFZmoJNdXfZdn/s400/html_report_1.png" width="400" /></a></div><span style="font-size: small;"> </span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-size: small;"> </span><br />
<span style="font-size: small;">In <b>Step 2</b> on the reports wizard add only a Narrative View</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrRFe73NXMxtk9YlzBPqyi9JBmNAQTg4QLuif6sjqJdbf1BQ802w61crWIMWOPF6M5avqFWWFn5yF8gmrLmf3ieuM_9SMZG17skI1a4ilrZeuwwEKm-plmWBiEAjQS7F1dGyAqvF-ZtL5E/s1600/html_report_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrRFe73NXMxtk9YlzBPqyi9JBmNAQTg4QLuif6sjqJdbf1BQ802w61crWIMWOPF6M5avqFWWFn5yF8gmrLmf3ieuM_9SMZG17skI1a4ilrZeuwwEKm-plmWBiEAjQS7F1dGyAqvF-ZtL5E/s640/html_report_2.png" width="440" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-size: small;">Save the report</span><br />
<span style="font-size: small;"><br />
</span><br />
<b><span style="font-size: small;">Step 2: Create a Weblink and add to the Layout</span></b><br />
<br />
<span style="font-size: small;">Create</span><b><span style="font-size: small;"> </span></b><span style="font-size: small;">a Weblink field in the Service Request Object.</span><br />
<span style="font-size: small;">Edit the weblink properties and add it to your report, note that we are passing the SR number as a parameter in the report, so we get details specific to this record only.</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgm63IVMNQSoLl9iIdVoVrHf6e0MEItn2-dYqGpPPyYVd-6c-huMxRqN0hw6txipA7hxGFz5Q5YUyR0D9HPbgg-TkzPKaBtCaXACke9zBlve2GfI_3LO4rz-92bJYyV21VGJjNMRjB7zPO5/s1600/html_report_3.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgm63IVMNQSoLl9iIdVoVrHf6e0MEItn2-dYqGpPPyYVd-6c-huMxRqN0hw6txipA7hxGFz5Q5YUyR0D9HPbgg-TkzPKaBtCaXACke9zBlve2GfI_3LO4rz-92bJYyV21VGJjNMRjB7zPO5/s400/html_report_3.png" width="400" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-size: small;">Add this weblink to the Layout assigned to your user role.</span><br />
<br />
<b><span style="font-size: small;">Step 3: View your changes</span></b><br />
<span style="font-size: small;">Create </span><b><span style="font-size: small;"> </span></b><span style="font-size: small;">a new SR record or view an existing SR record that has all the required fields you need to successfully send out the email. You should see the email weblink that we created in Step 2 above</span><br />
<span style="font-size: small;"><br />
</span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHkeiYZ5P-4gFaTsSRRd04H3yU1SY4i0ftv3IuQWmCtDXuJCi58PheiF3ePjTTIdaE2yBVnfG28QBetXe1Z-XP-Qqk5jA1N-Ci6kK5fPjZ-wJu9OWPCi9x4Fb07p0ZjH463HZKCrcZchBC/s1600/html_report_4.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHkeiYZ5P-4gFaTsSRRd04H3yU1SY4i0ftv3IuQWmCtDXuJCi58PheiF3ePjTTIdaE2yBVnfG28QBetXe1Z-XP-Qqk5jA1N-Ci6kK5fPjZ-wJu9OWPCi9x4Fb07p0ZjH463HZKCrcZchBC/s400/html_report_4.png" width="400" /></a></div><span style="font-size: small;"> </span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-size: small;">Click on the Weblink to launch the report. you will now see your neatly formatted email with all the required details.</span><br />
<span style="font-size: small;"><br />
</span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghVMyAWL3uzAO5RJLzcOGq7dXtdhQZd5ejX_o1L-eRdKgtGzARh8Xy92j4QmS-5ZbOEurLNJCDYnXfIW34TFNq62lq0OKQWiIHfmn01QLZBbtWyqMjbmnZtfK5ujB9nL1C4EvpURqAgf8x/s1600/html_report_5.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghVMyAWL3uzAO5RJLzcOGq7dXtdhQZd5ejX_o1L-eRdKgtGzARh8Xy92j4QmS-5ZbOEurLNJCDYnXfIW34TFNq62lq0OKQWiIHfmn01QLZBbtWyqMjbmnZtfK5ujB9nL1C4EvpURqAgf8x/s400/html_report_5.png" width="305" /></a></div><span style="font-size: small;"> </span><br />
<span style="font-size: small;"> </span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<b><span style="font-size: small;">Step 4: Add this in Outlook.</span></b><br />
<span style="font-size: small;">In your IE menu bar click File -> Send -> Page by E-mail...</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsJo1VA2UDbCymu81cKZuS9mc15g35FB0BATftV3lwp7qrCuW7kyYXoB8qLNWiR-d3PnNZ4cS8QucGFSUCvK63ptdIR6iurIel0PRM3bRDI0jzz3spOKOR_sRFtMOhI_-rhaQfuI4EI9Km/s1600/html_report_6.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsJo1VA2UDbCymu81cKZuS9mc15g35FB0BATftV3lwp7qrCuW7kyYXoB8qLNWiR-d3PnNZ4cS8QucGFSUCvK63ptdIR6iurIel0PRM3bRDI0jzz3spOKOR_sRFtMOhI_-rhaQfuI4EI9Km/s320/html_report_6.png" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<b><span style="font-size: small;"> </span></b><br />
<span style="font-size: small;">The above step will create new email in Outlook with your formatted report</span><span style="font-size: small;">.</span><b><span style="font-size: small;"><br />
</span></b><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCmNYtL9pVqHsL57wrm5NLVw5TD_7Ork_Fl9Ae-2qLIgrRuwtZSFQc6fVsqcizLKRVR1sDanWcuEDjTB8w4qxpBpdvZOAZKu4cVv7OaBoo0AuPDwuFd20I9TQqRlylLcmHPunMN9UUC9Uz/s1600/html_report_7.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCmNYtL9pVqHsL57wrm5NLVw5TD_7Ork_Fl9Ae-2qLIgrRuwtZSFQc6fVsqcizLKRVR1sDanWcuEDjTB8w4qxpBpdvZOAZKu4cVv7OaBoo0AuPDwuFd20I9TQqRlylLcmHPunMN9UUC9Uz/s640/html_report_7.png" width="436" /></a></div><br />
<br />
<span style="font-size: small;"> </span><b><span style="font-size: small;"><br />
</span></b><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">And you're ready to go! </span></div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"></span></div><div style="font-family: "Trebuchet MS",sans-serif;"><br />
</div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">Cheers! </span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgm63IVMNQSoLl9iIdVoVrHf6e0MEItn2-dYqGpPPyYVd-6c-huMxRqN0hw6txipA7hxGFz5Q5YUyR0D9HPbgg-TkzPKaBtCaXACke9zBlve2GfI_3LO4rz-92bJYyV21VGJjNMRjB7zPO5/s1600/html_report_3.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgm63IVMNQSoLl9iIdVoVrHf6e0MEItn2-dYqGpPPyYVd-6c-huMxRqN0hw6txipA7hxGFz5Q5YUyR0D9HPbgg-TkzPKaBtCaXACke9zBlve2GfI_3LO4rz-92bJYyV21VGJjNMRjB7zPO5/s1600/html_report_3.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgm63IVMNQSoLl9iIdVoVrHf6e0MEItn2-dYqGpPPyYVd-6c-huMxRqN0hw6txipA7hxGFz5Q5YUyR0D9HPbgg-TkzPKaBtCaXACke9zBlve2GfI_3LO4rz-92bJYyV21VGJjNMRjB7zPO5/s1600/html_report_3.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a></div><span style="font-size: small;"></span></div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-48832389258927256262010-05-24T00:23:00.000-07:002010-05-24T00:31:06.891-07:00Generate pdf report with Images in CRM On Demand<span style="font-family: Arial,Helvetica,sans-serif;">Hi,</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"> </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">I had a requirement where the client had to display their company Image on pdf when the report was downloaded, the Image I was referencing was on their Company Portal. unfortunately the pdf file wouldn't pick this image, it worked only for HTML downloads.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"> </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"></span><br />
<b><span style="font-family: Arial,Helvetica,sans-serif;">Here is how you do it!</span></b><br />
<span style="font-family: Arial,Helvetica,sans-serif;"> </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">You can get Images from websites into your pdf file, but this will include two extra clicks...<br />
<br />
Go to any report, click the “Printer Friendly” option, and select HTML.</span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"></span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp-evZF8W-Z-khJYFDH3D8EOdeK9yCokXyO-gCqe3Zm9vd8wSPvdbw6RC-hwsOFqoJxoWm7KGvMSasVN-oKUcBZ5vwV_Cxjg2NcTL80KSZVdM8LAnoyrpsxFAYAwEfNRC6WAuK4xihMhZk/s1600/printer_friendly.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp-evZF8W-Z-khJYFDH3D8EOdeK9yCokXyO-gCqe3Zm9vd8wSPvdbw6RC-hwsOFqoJxoWm7KGvMSasVN-oKUcBZ5vwV_Cxjg2NcTL80KSZVdM8LAnoyrpsxFAYAwEfNRC6WAuK4xihMhZk/s320/printer_friendly.png" /></a><br />
<span style="font-family: Arial,Helvetica,sans-serif;"> </span><br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">An HTML webpage will be generated for that report, now in that web page in the Menu bar, go to File and select Print…</span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTGGgMFCvgHBRo4df6FY_Uweuc1VAzwAdyiwMl9myOUjMC2ivvtkle6pgoUJi1ZeSs-1UbHdxgRx0-TMYGkI5ExftQ-w7mZrWUcqO_kQn56w7FzLxBwA4ucBE-mnimS2WiRz5jy3gxFR-U/s1600/menu_option.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTGGgMFCvgHBRo4df6FY_Uweuc1VAzwAdyiwMl9myOUjMC2ivvtkle6pgoUJi1ZeSs-1UbHdxgRx0-TMYGkI5ExftQ-w7mZrWUcqO_kQn56w7FzLxBwA4ucBE-mnimS2WiRz5jy3gxFR-U/s320/menu_option.png" /></a></div><span style="font-family: Arial,Helvetica,sans-serif;"><br />
</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br />
</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br />
</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br />
</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br />
</span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">The below popup screen will be displayed, select “Adobe PDF” and click Print.</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><br />
</span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgs2fIUIzdR9BB4OOQyIJLJf_3OsVXAQiKtXwmI7aqnve2MuYOqtZ9SLWhQCM_KxjHznmsEoecsLT4qDX5zKKy6Zb3k_PCCmZsLl32OLWGl0vtjEFy8f6x5GLE3Rx3vvwzUEUElJlLv71ys/s1600/open_print_box.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgs2fIUIzdR9BB4OOQyIJLJf_3OsVXAQiKtXwmI7aqnve2MuYOqtZ9SLWhQCM_KxjHznmsEoecsLT4qDX5zKKy6Zb3k_PCCmZsLl32OLWGl0vtjEFy8f6x5GLE3Rx3vvwzUEUElJlLv71ys/s320/open_print_box.png" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">After you click Print you will have to save the Report, the save as type is automatically set to PDF, enter the Name . </span><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYKDXtu6N3ZbyV-4Uc0VAfhaziaNgA1T-NrbwuqASWGq_CZhijNeeJqwRSEl6Yj71VRHePRTM0UO8zTOeRHIEh5ndZgJEQjD6GvkF-visNRS742IChTPyuIuVxqzjXfNb1SDmkoPerymQF/s1600/pdf1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYKDXtu6N3ZbyV-4Uc0VAfhaziaNgA1T-NrbwuqASWGq_CZhijNeeJqwRSEl6Yj71VRHePRTM0UO8zTOeRHIEh5ndZgJEQjD6GvkF-visNRS742IChTPyuIuVxqzjXfNb1SDmkoPerymQF/s320/pdf1.png" /></a><span style="font-family: Arial,Helvetica,sans-serif;"> </span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">And your pdf is generated will the Company logo.<br />
<br />
Cheers!<br />
</span>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-50050742211690165582010-05-14T00:28:00.000-07:002010-10-01T00:53:25.777-07:00Repository Script Extractor for Siebel versions > 7.7<span style="font-family: "Trebuchet MS",sans-serif;">Hey folks,</span><br />
<br />
<span style="font-family: "Trebuchet MS",sans-serif;"><b>Want to have a backup of all those cool and interesting scripts you wrote, but find it too taxing to manually copy each and every script in to a good readable format?</b></span><br />
<br />
<span style="font-family: "Trebuchet MS",sans-serif;">Here is a new tool the we have been working on. What it basically does is, it extracts the scripts based on a user given date or a prefix. Any scripts that were created or updated beyond the date will be exported into the excel sheet as well as in an HTML format just like the utility Oracle had introduced to extract scripts for versions 7.7 and earlier.</span><br />
<br />
<span style="font-family: "Trebuchet MS",sans-serif;">The tool connects to Siebel via the object layer and pulls out the information...</span><br />
<br />
<span style="font-family: "Trebuchet MS",sans-serif;">Here is a peak at what this tool looks like</span><br />
<span style="font-family: "Trebuchet MS",sans-serif;"> </span><br />
<span style="font-size: x-small;"><i><b><span style="font-family: "Trebuchet MS",sans-serif;">Main UI</span></b></i></span><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitd0yRoDO3psNDwC7u3b67MBrcfJfvwy2QU4pLqaTRBr1KrqgnblfVyHayIDFODaRlNRRVF-hpRpw85VyWN2Pm2oTzjCLuK19ttJwHml5FhdefIvMHleZIAmRT0g6EnSJ1YnTF5dP6kO4d/s1600/5-14-2010+12-54-09+PM.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="177" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitd0yRoDO3psNDwC7u3b67MBrcfJfvwy2QU4pLqaTRBr1KrqgnblfVyHayIDFODaRlNRRVF-hpRpw85VyWN2Pm2oTzjCLuK19ttJwHml5FhdefIvMHleZIAmRT0g6EnSJ1YnTF5dP6kO4d/s400/5-14-2010+12-54-09+PM.png" width="400" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-size: x-small;"><b><span style="font-family: "Trebuchet MS",sans-serif;">HTML Output</span></b></span><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHhvSDkf20pq1sdHkTGnhHZtpMdZhAJzMPG7gsXs9yQBN7WLVMVzIyPYoCh5ZzBhvDf-R9q6-IBirYeyWdxA96e75jan0lBn49PNEy-mWHGHhHM60B602AvIwdtCbtK4nzL4Onkk-qEogI/s1600/Script+Extractor+html+output.bmp" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHhvSDkf20pq1sdHkTGnhHZtpMdZhAJzMPG7gsXs9yQBN7WLVMVzIyPYoCh5ZzBhvDf-R9q6-IBirYeyWdxA96e75jan0lBn49PNEy-mWHGHhHM60B602AvIwdtCbtK4nzL4Onkk-qEogI/s400/Script+Extractor+html+output.bmp" width="400" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: "Trebuchet MS",sans-serif;">Click the below icon to download this cool tool..!</span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://rapidshare.com/files/394801853/Repository_Script_Extractor_v10.0.rar.html" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFVRt88Nhl7eXHb5qDhMADJBSrG49eiDBntY4JvJc_lbasK3mX4-Zj8qUzWocabcokvMqUBrap8SOlJVHLT_awskECQ_0FXF8M-XpMx0NrlXbvwI2d3ucjrqN0SWDC-ipK8TI48GXZiqPz/s1600/smallicons_sprites.png" /></a></div><br />
<span style="font-family: "Trebuchet MS",sans-serif;"> </span><br />
<br />
<br />
<br />
<span style="font-family: "Trebuchet MS",sans-serif;">Cheers! </span>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com6tag:blogger.com,1999:blog-9206666120147957112.post-51403396144627452772010-04-11T22:50:00.000-07:002010-05-13T00:28:11.273-07:00Siebel CRM Market Statistics<div style="font-family: "Trebuchet MS",sans-serif;">Hey Folks,</div><div style="font-family: "Trebuchet MS",sans-serif;"><br />
</div><div style="font-family: "Trebuchet MS",sans-serif;">A few graphs I'd like to share about Siebel CRM and its demand in the market.</div><div style="font-family: "Trebuchet MS",sans-serif;"><br />
</div><span style="font-family: "Trebuchet MS",sans-serif;"> </span><b>Siebel World Wide Demand</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://sheet.zoho.com/publicgraphs/417126000000088075.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="381" src="http://sheet.zoho.com/publicgraphs/417126000000088075.png" width="400" /></a></div><a href="http://sheet.zoho.com/publicgraphs/417126000000088075.png"></a><br />
<a href="http://sheet.zoho.com/publicgraphs/417126000000088075.png"></a><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<b>Siebel – Favourite Cities</b><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://sheet.zoho.com/publicgraphs/417126000000071083.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="296" src="http://sheet.zoho.com/publicgraphs/417126000000071083.png" width="400" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<b>Siebel Salary Comparison</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://sheet.zoho.com/publicgraphs/417126000000070041.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="400" src="http://sheet.zoho.com/publicgraphs/417126000000070041.png" width="390" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<b> Siebel – Skills based demand trend</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://sheet.zoho.com/publicgraphs/417126000000077027.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="135" src="http://sheet.zoho.com/publicgraphs/417126000000077027.png" width="400" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: "Trebuchet MS",sans-serif;">So for those of you who are not so sure on which area in siebel to pick up, this could give you a heads up...</span><br />
<br />
<b><a href="http://jobgraphs.com/siebel/">Some More Graphs </a></b><br />
<b><br />
</b><br />
<b>Cheers!</b>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com1tag:blogger.com,1999:blog-9206666120147957112.post-33729324389147251402010-04-08T06:12:00.000-07:002010-05-13T00:27:47.541-07:00The Siebel Blackbook<iframe frameborder="0" height="500" scrolling="no" src="http://books.google.co.in/books?id=ywdQv021We8C&lpg=PA361&dq=Siebel%20CRM&lr&pg=PA15&output=embed" style="border: 0px none;" width="500"></iframe>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-42261651532603458792010-03-24T06:21:00.000-07:002010-05-13T00:27:08.253-07:00Oracle CRM On Demand and Google Talk<div style="font-family: "Trebuchet MS",sans-serif;"><meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta><meta content="Word.Document" name="ProgId"></meta><meta content="Microsoft Word 12" name="Generator"></meta><meta content="Microsoft
Word 12" name="Originator"></meta><link href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml" rel="File-List"></link><link href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx" rel="themeData"></link><link href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="colorSchemeMapping"></link> <span style="font-size: small;"><m:smallfrac m:val="off"> <m:dispdef> <m:lmargin m:val="0"> <m:rmargin m:val="0"> <m:defjc m:val="centerGroup"> <m:wrapindent m:val="1440"> <m:intlim m:val="subSup"> <m:narylim m:val="undOvr"> </m:narylim></m:intlim> </m:wrapindent><style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;
mso-font-charset:2;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:0 268435456 0 0 -2147483648 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:1;
mso-generic-font-family:roman;
mso-font-format:other;
mso-font-pitch:variable;
mso-font-signature:0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1073750139 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoPapDefault
{mso-style-type:export-only;
margin-bottom:10.0pt;
line-height:115%;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style> </m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac></span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">Hey Guys,</span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">If you are a Google Talk user, you may be aware that there is a link that allows you to sign into your Google account and chat with your contacts without the GTalk setup installation.</span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><br />
<span style="font-size: small;">We are about to use this cool feature in Oracle CRM On Demand to help Service Reps to chat with customers to resolve their queries.</span></div><br />
<div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">This feature may also be available for other messengers (yahoo, rediffmail, windows live), but let’s talk about Google for now.</span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><o:p> </o:p><b> </b></span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><b>Step 1: </b> </span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">Navigate to Admin---Application Customization---Global Web Applets. </span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">Create a New Web applet and Fill in the below. You may also choose to have this on the Homepage according to your requirement.</span></div><br />
<div class="separator" style="clear: both; font-family: "Trebuchet MS",sans-serif; text-align: center;"><span style="font-size: small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjghsB86bLVydZHHgXHvFdsSrV8D197TOk2Tar2SElUIl7radGqWCBBXv0d0zOmCFE8wdNuVIlwTKn6Ed1MCtYb2gjhKbx0uf7xplyowz5uY5Hl4uSYDmORvj_LxHIlVvLLyqkflF5mHoql/s1600/blog_1.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjghsB86bLVydZHHgXHvFdsSrV8D197TOk2Tar2SElUIl7radGqWCBBXv0d0zOmCFE8wdNuVIlwTKn6Ed1MCtYb2gjhKbx0uf7xplyowz5uY5Hl4uSYDmORvj_LxHIlVvLLyqkflF5mHoql/s400/blog_1.JPG" width="400" /></a></span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span><br />
<span style="font-size: small;"><br />
</span><br />
<span style="font-size: small;"><br />
</span></div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"> </span></div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"> </span></div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Trebuchet MS",sans-serif;"><meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta><meta content="Word.Document" name="ProgId"></meta><meta content="Microsoft Word 12" name="Generator"></meta><meta content="Microsoft Word 12" name="Originator"></meta><link href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml" rel="File-List"></link><link href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx" rel="themeData"></link><link href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="colorSchemeMapping"></link> <span style="font-size: small;"><m:smallfrac m:val="off"> <m:dispdef> <m:lmargin m:val="0"> <m:rmargin m:val="0"> <m:defjc m:val="centerGroup"> <m:wrapindent m:val="1440"> <m:intlim m:val="subSup"> <m:narylim m:val="undOvr"> </m:narylim></m:intlim> </m:wrapindent><style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;
mso-font-charset:2;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:0 268435456 0 0 -2147483648 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:1;
mso-generic-font-family:roman;
mso-font-format:other;
mso-font-pitch:variable;
mso-font-signature:0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1073750139 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
a:link, span.MsoHyperlink
{mso-style-noshow:yes;
mso-style-priority:99;
color:blue;
mso-themecolor:hyperlink;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-noshow:yes;
mso-style-priority:99;
color:purple;
mso-themecolor:followedhyperlink;
text-decoration:underline;
text-underline:single;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoPapDefault
{mso-style-type:export-only;
margin-bottom:10.0pt;
line-height:115%;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style> </m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac></span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">URL: <a href="http://talkgadget.google.com/talkgadget/popout">http://talkgadget.google.com/talkgadget/popout</a>?</span></div><br />
<div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><b>Step 2: </b>Add the Custom Web Applet to your <b>Action bar</b> for the ‘My Setup---Personal Layout---Action Bar Layout’ Global link.</span><br />
<br />
</div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAlHnTYX0gK4Ppm45dcdKTP11vNgcm5CfRN5syDdEilR9sPlfo9UbDb0J7Z28UwLkIFbqNVVGCjgz1zN2s6pXvbJS5VpzCbm8JQWhyphenhyphenp6cXFe3V8s9t6-RxNVkTTl2kjWNrA8hneE8GYk9Z/s1600/blog_2.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="237" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAlHnTYX0gK4Ppm45dcdKTP11vNgcm5CfRN5syDdEilR9sPlfo9UbDb0J7Z28UwLkIFbqNVVGCjgz1zN2s6pXvbJS5VpzCbm8JQWhyphenhyphenp6cXFe3V8s9t6-RxNVkTTl2kjWNrA8hneE8GYk9Z/s400/blog_2.JPG" width="400" /></a></div><span style="font-size: small;"><br />
</span></div><div class="separator" style="clear: both; font-family: "Trebuchet MS",sans-serif; text-align: center;"><span style="font-size: small;"></span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"> </span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta><meta content="Word.Document" name="ProgId"></meta><meta content="Microsoft Word 12" name="Generator"></meta><meta content="Microsoft Word 12" name="Originator"></meta><link href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml" rel="File-List"></link><link href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx" rel="themeData"></link> <span style="font-size: small;"><m:smallfrac m:val="off"> <m:dispdef> <m:lmargin m:val="0"> <m:rmargin m:val="0"> <m:defjc m:val="centerGroup"> <m:wrapindent m:val="1440"> <m:intlim m:val="subSup"> <m:narylim m:val="undOvr"> </m:narylim></m:intlim> </m:wrapindent><style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:1;
mso-generic-font-family:roman;
mso-font-format:other;
mso-font-pitch:variable;
mso-font-signature:0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1073750139 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoPapDefault
{mso-style-type:export-only;
margin-bottom:10.0pt;
line-height:115%;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
</style></m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac></span>
<span style="font-size: small;"><m:smallfrac m:val="off"><m:dispdef><m:lmargin m:val="0"><m:rmargin m:val="0"><m:defjc m:val="centerGroup"><style>
</style></m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac></span>
<span style="font-size: small;"><m:smallfrac m:val="off"><m:dispdef><m:lmargin m:val="0"><m:rmargin m:val="0"><m:defjc m:val="centerGroup"><style>
</style></m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac></span>
</div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"></span>
<span style="font-size: small;">You should now see the Custom
Web applet on your Action Bar.</span>
<div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">
</span></div><div class="MsoNormal" style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">Finally, <b>Sign
in</b> to your Google Account by clicking the sign in link and enjoy!</span><span style="font-size: small;"> </span>
<span style="font-size: small;">Cheers! </span> </div></div><div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"> </span><span style="font-size: small;">
</span></div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com0tag:blogger.com,1999:blog-9206666120147957112.post-71431696728258497792010-03-03T04:15:00.000-08:002010-10-01T00:53:25.779-07:00Repository Data Retriever© v1.0<div style="font-family: "Trebuchet MS",sans-serif;">Hey Folks, </div><div style="font-family: "Trebuchet MS",sans-serif;"><br />
</div><div style="font-family: "Trebuchet MS",sans-serif;">Here is an excel spreadsheet I had been working for the past couple weeks. It has been designed to export all the newly created and modified objects beyond a particular user given date. </div><div style="font-family: "Trebuchet MS",sans-serif;"><br />
</div><div style="font-family: "Trebuchet MS",sans-serif;"><b>Special features include - </b></div><div style="font-family: "Trebuchet MS",sans-serif;">- Works on <b>Sample/ Local and Server</b>. </div><div style="font-family: "Trebuchet MS",sans-serif;">- <b>Cool UI features</b> to minimize user effort (Object Explorer, date Chooser, Select File Dialogbox) </div><div style="font-family: "Trebuchet MS",sans-serif;">- <b>Process Status section</b>. This is so the user is not prompted everytime unless a critical error has occured or user intervention is really required. </div><div style="font-family: "Trebuchet MS",sans-serif;">- Data is exported in an <b>easily readable format</b> </div><div style="font-family: "Trebuchet MS",sans-serif;">- Can be very well used for Upgrades to analyze the amount of Repository Customization<br />
<br />
<b><i>Interface Detail:</i></b><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdLq84iiq1aMEYnT_6F4qP5qUkDacvLRq9bxAgrvHUjkRpLIj2zP1vmiGy6iFRbDicAPO7eu5UilkMJwDtohjYY86TKYvqpTS7ydFIb1Csp_wiaPoLYNOtkwIGVhDt2aL0eYxzY0YbQ4yq/s1600-h/2-3-2010+5-55-12+PM.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="152" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdLq84iiq1aMEYnT_6F4qP5qUkDacvLRq9bxAgrvHUjkRpLIj2zP1vmiGy6iFRbDicAPO7eu5UilkMJwDtohjYY86TKYvqpTS7ydFIb1Csp_wiaPoLYNOtkwIGVhDt2aL0eYxzY0YbQ4yq/s400/2-3-2010+5-55-12+PM.png" width="400" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<i>Screen prints of the tool -</i><br />
<br />
<i><span style="font-size: x-small;">Main Page -</span></i><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsIc88JxCj255NUU8EO0FFc_X323PdssVsaJLgQkhd3XYfJAlQsgUt9fq-tG0l-Gozi3pnd7khlETY0VIWbigGjKaQaHD2WEJSNdqrUcLrkDdhYHdKFU55j73omfzxj1jvRqGl2L8Z7-E6/s1600-h/RDR.bmp" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="327" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsIc88JxCj255NUU8EO0FFc_X323PdssVsaJLgQkhd3XYfJAlQsgUt9fq-tG0l-Gozi3pnd7khlETY0VIWbigGjKaQaHD2WEJSNdqrUcLrkDdhYHdKFU55j73omfzxj1jvRqGl2L8Z7-E6/s400/RDR.bmp" width="400" /></a></div><br />
<br />
</div><div style="font-family: "Trebuchet MS",sans-serif;"><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<i><span style="font-size: x-small;">Exported Objects View -</span></i><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihkQwWkoUU3BJZ7F4cm2RmcqYApu1A6b3yKNJ3HZmeGS7P1NklCn7K5tnuTWhd5Rnualeefcqm1xj-UEJwV3TrkQWCrCf8Q3-a9MG_4zLIkCIQkqPgUpku4bTb0CjfoETq81R27Jp4AEaz/s1600-h/untitled45.bmp" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihkQwWkoUU3BJZ7F4cm2RmcqYApu1A6b3yKNJ3HZmeGS7P1NklCn7K5tnuTWhd5Rnualeefcqm1xj-UEJwV3TrkQWCrCf8Q3-a9MG_4zLIkCIQkqPgUpku4bTb0CjfoETq81R27Jp4AEaz/s400/untitled45.bmp" width="400" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Click on the below icon to download the Repository Data Retriever (limited downloads). <br />
<br />
<a href="http://rapidshare.com/files/358320075/Repository_Data_Retriever___v1.0.rar" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5398402481711788258" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFVRt88Nhl7eXHb5qDhMADJBSrG49eiDBntY4JvJc_lbasK3mX4-Zj8qUzWocabcokvMqUBrap8SOlJVHLT_awskECQ_0FXF8M-XpMx0NrlXbvwI2d3ucjrqN0SWDC-ipK8TI48GXZiqPz/s320/smallicons_sprites.png" style="cursor: pointer; height: 80px; width: 75px;" /></a> <br />
<br />
<br />
<div style="font-family: "Trebuchet MS",sans-serif;">Cheers! </div></div>Anonymoushttp://www.blogger.com/profile/08606758309722963924noreply@blogger.com3