Its Live !! Open Live Writer now works with Blogger !

 

The OpenLiveWriter project has just released a new version, it now works with blogger !  I am using it to write this post as well. Download the new version from the site and run the installer. During the installation, choose Google Blogger as your account type if you want to use it with Blogger.

 

The installer will prompt you to sign in, and will open up the authentication page on your browser.

 

Once you grant access in the browser, return to the installer to finish.

Awesome ! It works, and the interface is pretty much the same as Live Writer (though I found the tags option missing).

Hearty thank you to the good folk at the OpenLiveWriter project !!

TqHS1NPaDNSYmLsCMucq

Siebel and Stackoverflow woes

 

Ok, we are nearing the end of another year, and there's one more month till Christmas. I have now fully moved out of Siebel, and embraced the new family of Oracle Fusion cloud applications. But I do keep track of what happens in the Siebel world. If things finally start to fix themselves (that would be a big miracle), Siebel might make a come back. I am a member of various forums where they track Siebel queries, and one of them is stackoverflow. In some of my previous organizations, I could not even access this site, due to firewall restrictions, but time and again the resources on the site have helped my own project problems. Though I have not yet asked any question on the site, just answered other's queries, and read what other's have left there. I have not asked direct questions because I want to solve my problems in my own capacity, Maybe its my ego, but I won't put up my requirement on the page and wait for some one else to solve it for me at no cost at all.

But that hasn't stopped others. And following the questions on the site gives you a good idea of what issues other Siebel developers are struggling with. At the moment of writing, these are the stats on the Siebel tag at stackoverflow.

Two years ago, there was a lot of activity around this tag, people were actively asking for and receiving help, the range of topics was wide. Here is a screenshot of the site from the waybackmachine from the start of this year.

Yep, back then, all questions were answered and there was more activity. But now the tag attracts weird questions mainly from css and jquery , because Siebel now uses OpenUI. There appears to be a bunch of noobs with only some basic Siebel training, who visit the site to mainly put up their own requirements, then wait patiently for someone else to solve it for them.

Like this guy:

Or this classical one which is a link issue, and  which is even documented supportweb.

Clearly, the Siebel pool of resources is decreasing in size. And its the same trend everywhere. Well, Siebel was always closed technology, at times the only place you could get help was on the Siebel support centre, specially about 10 years ago.

Others too have noticed the decline of activity on IT Toolbox and have created a new Siebel page on Slack.  Good old Neel of SiebelUnleashed fame too has abandoned ship. In a very candid and frank interview, he clearly speaks out the writing which has been on the wall for years.

 

"Siebel jobs are going to be there for a long time but unfortunately I don't see many new implementation of Siebel."

"People are sticking to Siebel either because they are heavily invested or they believe other products don't offer what they need."

 

So I am still (and thousands more) waiting for that miracle to bring Siebel consultants back in demand.

Anyway, back to Stackoverflow. I was pondering on these questions when I ran into a fantastic article about how stackoverflow may be the best and worst part of programming today. According to their stats, only 27% of question remain unanswered.

 

How to get Windows 7 Weather Gadget to work again

 

The weather here in Bangalore, India is acting funny again. Rain destroyed the city for the last three days, and just when the met department predicted more rain for two more weeks, it stopped raining. It is now bright and sunny (and dusty).  You have to depend on Google weather to find out the predictions for the coming days. When Windows 7 shipped, they had this cool new thing called Windows Live, and the sidebar, which had gadgets. And the weather gadget was my favourite, it would just stay there un-intruding your  work but tell you the weather outside. About two years ago, Microsoft killed the weather gadget's service, because they wanted to focus on stupid Windows 8 and 10…and this meant killing the ecosystem of 7. The weather gadget stopped workings, and simply showed the error : "Service not Available".

Here is how you can get it working again.

Step 1. You have to replace the cache file for the weather gadget with an older one. Download this file.

Step 2. On your Windows 7 machine, go to [\AppData\Local\Microsoft\Windows Live\Services\Cache]. Delete/Backup the  Config.xml file present there with the one in the downloaded zip file.

Step 3. Now go to the desktop and drag the Weather gadget back into the desktop

Thats it !

Now the default location will be New York. And changing the location from the gadget wont work. To change the location to your own, you will need these additional steps.

Step 4. Open up your task manager ( Ctrl + Shift + Esc) , and kill the sidebar.exe app.

Step 5. On your Windows 7 machine, go to [AppData\Local\Microsoft\Windows Sidebar]. Delete/Backup the Settings.ini file there

Step 6. Open up the Settings.ini file in a text editor and change the code of WeatherLocationCode to the code of the place you want to see.

Step 7. You can get the code from Weather.com. Just to there and search for the place, and take the code from the generated URL.

For instance, the code for Bangalore is INXX0012.

Step 8. Save the Settings.ini file.

Step 9. Open task manager again. And go to File -> New Task -> and run sidebar.exe.

Voila !

 

Have fun !

OpenUI lead to other frameworks from competitors

 

Three years ago people were talking about the end of the world, which know seems like a joke. But people in the Siebel business were talking more about the advent of OpenUI, and how the new UI layer will transform the Siebel landscape. Well, it was a case of too little to late. Siebel projects are now at their lowest ebb. Most Indian IT companies have changed their business models to either discontinue their Siebel practice, or to diminish and merge them with other CRM practices. There are upgrade and support projects , but greenfield implementation projects are the rarest lot.

But it turns out Oracle's launching of the ridiculously-difficult-to-implement OpenUI lead to similar offerings from other players in the industry.  Today I learnt about how SalesForcedotCom released their lightning system to allow for better UI designs for mobile and other portable form factors. Lightning uses opensource technologies like javascript ,css and HTML5, and the look and feel looks eerily similar to OpenUI.

OpenUI also lead SAP to release a new UI layer for their systems, which they are calling OpenUI5 ! Same open standards and direct coding system, I watched a few videos on SAP's OpenUI5, and the framework requires tonnes of coding to get the layout up and running.

SAP has launchen OpenUI5 as a repo on github, and are welcoming contributions from the public to take ti forward .Both these frameworks talk about being responsive and faster than their earlier UIs, and require tonnes of lines of code to bring up even the simplest UIs, like Siebel OpenUI. Clearly Siebel is leading the innovation in this regard, and its good to see others picking up.

babun - the best Unix shell for Windows

 

Sometimes the best way to use a computer is via its command line. This is particularly true for developers, there are times when even the best IDE wont' do. And its then that you realize that the best command line shell is the one on Unix. Window's command support is weak and an afterthought. In the on-premise model of enterprise software development, most companies use Unix or its variant for the production systems, due its much better stability, but also lower cost. There is nothing like grepping through entire log files to find culprit code in the system. cleartext.blogspot.com

The Unix/Linux shell has over 160 commands, and different distributions can have extra packages. This gives a developer on Unix limitless power on the commandline, using simple chaining, it is possible to solve the problem at hand without having to download any extra program. But things are bleak on the Windows front, where all you can do is dir and findstr. Sure the bat files have some more power, but there are still a lot missing.  I wondered if there was a way to get a working Unix like shell on the Windows system which can access the Windows filesystem but still do its magic. cleartext.blogspot.com

And I stumbled upon babun. If you are a developer like me, babun is the only shell you will need on Windows. It is a simple installable exe shell which accepts all unix commands, and then runs them on Windows. You don't have to set it up like cygwin. It does not even need administrator rights to install, and installs silently. After installation it creates a simple shortcut on the desktop, and runs a full xterm color interface.

And the shell understands  every standard Unix command, the usual grep, sort, wc,head , tail are all supported along with pipes. It periodically on startup, checks for updates. cleartext.blogspot.com

Installation of software on Unix is the biggest roadblock even today, and babun makes it easy to install anything easily. The installer is called pact.

But the best part is that it can access your native Windows disks, so you get the best of both worlds. cleartext.blogspot.com

So now you can have all your Unix power in Windows ! cleartext.blogspot.com

cleartext.blogspot.com

Excel turns 30 !

 

One of the most popular and widely used software utility, the backbone of countless projects ,graphs, and computations, turned 30. No, this is not about JAVA or any other programming language. I am talking of Microsoft's gift to the modern software engineer: MS Excel. According to Wikipedia, Microsoft released the first version of Excel for the Macintosh on September 30, 1985, and the first Windows version was 2.05 (to synchronize with the Macintosh version 2.2) in November 1987. The reason they released it first for Mac was due to the huge popularity of Lotus 123, the king of spreadsheets at that time. Gradually though, Excel has worked its way up and today is the default spreadsheet application of choice.

Its surprising that even the most die-hard fans of Excel do not know of this little bit of trivia, and Excel continues to be the downtrodden, faithful servant it has always been. Excel's history is really colorful, they started with copying off the features of Lotus 1-2-3, but then started adding features of their own, adding a mountain of functions to VBA, its automation script tool, and even changed the file format multiple times to incorporate new features. Today, it is even available on the cloud, and Google too has taken a few ideas for their Google sheets system. But what had set Excel apart is the Recalc feature, instead of re-computing the values of every formula cell, Excel smartly re-calculates only the values of cells required, nothing more. The original project team members reveal that this was done for optimization and speed, but only a handful of people knew the exact underlying workings.

My first tryst with Excel  was in circa 1993. We had to learn computer applications in school, and Lotus 1-2-3 was the software of choice, both in offices, as well as in school curriculums. I quickly figured out that Lotus 1-2-3 had this nifty macro system, which could be used to write quick and small functions to automate tasks. It was difficult to write the macro code, I remember one had to use the '=' key to access macro functions. But someone had installed MS Excel on the school machine assigned to me, and I found what I thought was the newer and improved version of Lotus. It had mouse support and had more colors for its graphs, and was faster. Way faster. It was fun to use, and easy to learn. Even in my wildest dreams, I could not foresee that this little piece of software would end up being the main part of my day-to-day work as a Software Engineer. I have built various tools during my work on Siebel and BIP using VBA macros, and maintain project information and even my loan and finance details on good ol Excel. Who would have thought that a simple idea of maintaining data in rows and columns would be the best way to start out any project.

Fusion HCM: Integration woes

 

Looks like Oracle does not want customers/consultants to integrate other applications to its new fusion cloud based applications. There is close to NO documentation available on Oracle SupportWeb about setting up and invoking webservices, the only information available is on some Oracle blogs, and even they don't cover the full extent of APIs. Some Oracle champs have shared information on using REST services of some Oracle cloud apps, but it is clear that each of Oracle's cloud offerings have a different topology and architecture driving the integrations. I have been playing around with the Fusion HCM webservices for some time now, and I have to say that Oracle definitely needs to work on their documentation.

All of Oracle's cloud apps are following a standard approach: they will not (read cannot) consume a WSDL of another system, but they expose a WSDL/REST service of their own, which has to be invoked from outside to get the integrations working.

Consider the Fusion HCM Wsdl, the location of which has to be taken from Oracle repository. Using the get/find methods in the WSDL proved easy, but using the create/update methods proved to be a different challenge.

Problem 1: Every element in the WSDL is optional !. Check out the CreateWorker service, which is meant to be used to create the employee records in the HCM system. Usually the XSD/WSDL gives a good understanding of the structure of the system's data model, the required fields are marked so the end system has an idea of what fields to send to create a record. In  Oracle's Fusion HCM wsdl, every element is marked as optional, even the name elements. This means the developer/consultant has to have an in-depth knowledge of the HCM system to start using the wsdls. cleartext.blogspot.com

Really, Oracle ? cleartext.blogspot.com

Problem 2: No useful/meaningful validation me ssages. As soon as one starts triggering the methods of the HCM wsdl, the errors come back. Or, shall we say, NO errors come back. Looks like Oracle developers have not handled every exception properly.

WTF is  "JBO-29000: Unexpected exception caught: java.lang.NullPointerException, msg=null: null" supposed to mean ?

cleartext.blogspot.com

Problem 3: No documentation whatsoever. Oracle has two kind of cloud applications running now. One is the group of apps they have acquired, like Taleo, Rightnow CX etc…The other are cloud applications built by Oracle from ground up, from square one. For the former group of apps, the original developers have , thankfully, provided considerable documentation of the APIs. But for Oracle's own offerings, they have decided that less is better, and there is no detail documentation of the APIs. On these new cloud applications, the APIs are the only way to interact with the system, in traditional On-Premise systems, you could always have access to the application, filesystem and even database.

 

cleartext.blogspot.com