Showing posts with label Utilities. Show all posts
Showing posts with label Utilities. Show all posts

Thursday, August 23, 2018

xmlstarlet & xidel, xml parsing from the command line

 

For xml parsing from the command line, xmlstartlet and xidel require the ‘-‘ switch at the end to read from stdin. This has to be used during piping

 

curl http://gist.bbldtl.int:9000/ema/HUBQ1\?page\=log\&message_id\=52285748 | xidel -e '//pre' -   

image

 

 

Or:

curl http://gist.bbldtl.int:9000/ema/HUBQ1\?page\=log\&message_id\=52285748 | xmllint --format --xpath '//pre' - 

 

image

xidel removes the enclosing tags by default. So that’s better.

Wednesday, August 24, 2016

Oracle JET

 

Oracle has released the training videos of their new Java Toolkit, Oracle JET. They are calling it a MOOC, or Massive Open Online Course.

Monday, July 11, 2016

SQLFiddle (for Oracle) is broken. Try Oracle Live SQL

 

BI Publisher reporting work involves a lot of SQL. And often (in the Oracle world) one needs a quick way to try an Oracle function in a quick sandbox like system. For  long time, I have been using SQLFiddle, which provides a simple browser UI to create schema and run SQLs on them. But for many months now, the Oracle support on SQLFiddle has been broken. And I was looking for alternatives.

Turns out, Oracle themselves provides an excellent replacement tool to create schemas and run SQLs. Free for anyone who has an oracle.com login. That includes all customers and vendors working on their products. cleartext.blogspot.com

Go to Oracle Live SQL. The SQL worksheet page there can be used to run any SQLs, and its on a 12c DB server. cleartext.blogspot.com

 

image

There is a simple schema designer to create schema. Or you can also use standard DDL functions. Turns out , this is actually a simple Apex application. cleartext.blogspot.com

 

image

cleartext.blogspot.com

Friday, November 6, 2015

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

image

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.

image

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.

image

Step 8. Save the Settings.ini file.

tmpD9B0

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

Voila !

 

Have fun !

Tuesday, October 6, 2015

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.

image

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

tmp902A

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.

tmpF4D7

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

tmp811F

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

tmpA247

cleartext.blogspot.com

Wednesday, September 30, 2015

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.

history-of-excel-time-line

Tuesday, April 28, 2015

Cloudworld Mumbai - 2015

 

Oracle recently held a CloudWorld session in Mumbai to further market and push their cloud services. Looks like they are very keen on getting enterprises to move to the Cloud for their operations, the days of on-premise installations are numbered.

Here are the slides presented at this session.

 

Oracle CloudWorld

Oracle CloudWorld
Mumbai- 7th April 2015

Welcome and Opening Remarks
Shailender Kumar, Managing Director, Oracle India
Oracle Keynote: Modern Business Modern Cloud
Shawn Price, Senior Vice President, Oracle Cloud Go-to-Market and Product Business Groups, Oracle USA
Sponsor Keynote: Wipro
Sreenath AV, Vice President and Global Head - Oracle Practice, Wipro
Customer Leader Keynote
K. V. Srinivasan, Chief Executive Officer, Reliance Commercial Finance

TRANSFORM MARKETING

shadow

download-icon
The New Digital Dialogue
Abe Smith, VP Emerging Markets, Oracle Marketing Cloud, Oracle USA

download-icon
2015 Annual Outlook: What to Expect in Data Driven Marketing & Advertising
Shelly Singh, COO & Director, DMAi and Vatsal Asher CEO & Director, DMAi

download-icon
Simple steps to lead nurturing success; Gain maximum rewards for your business
Will Griffith, Senior Director Marketing Cloud, Oracle APAC

MODERNIZE SALES

shadow

download-icon
Modern Sales in the Cloud
Atul Tuli, Senior Director - CX, Oracle APAC

download-icon
Sales Performance Perfected
Caesar Peter, Senior Director - CX Applications, Oracle APAC

download-icon
Customer Showcase: Reliance Commercial Finance
Shashi Ravulapaty, Senior Vice President and Chief Technology Officer, Reliance Commercial Finance

download-icon
Driving Higher Sales Productivity with Mobile Technology
Sanjiv Mahesh, Regional SC Director, Oracle India

download-icon
Close Bigger Deals Faster with CPQ Cloud
Virginia Lo, Senior Director - CX Applications, Oracle APAC

MODERNIZE CUSTOMER SERVICE

shadow

download-icon
The Path to Modern Customer Service
Brian Curran, Vice President Customer Experience Strategy and Design, Oracle USA

download-icon
How to Differentiate Your Brand with Modern Service
YS Lee, Director Service Cloud, Oracle APAC

download-icon
Modern Contact Centers with solution showcase
YS Lee, Director Service Cloud, Oracle APAC and Abhay Kacker, Principal Sales Consultant, Oracle India

download-icon
Outsmart the Competition with the Right Social Customer Service Strategy
Atul Tuli, Senior Director - CX, Oracle APAC

download-icon
Improving Service Engagements
Merlyn Gordon, Director Customer Experience Strategy and Design

MODERNIZE HR

shadow

download-icon
Modern HR in the Cloud with Customer Showcase
Anand Subbaraman, Vice President, HCM Product Strategy, Oracle USA and Arvind Sivaramakrishnan, CIO, Apollo Hospitals

download-icon
Why Building a Talent-Centric Strategy Is Critical for Your Business
Kristina Webb, Senior Director, HCM Transformation HCM Applications, Oracle APAC

download-icon
Is Your Organization Able to Make Data-Driven Decisions?
Neeraj Narang, Principal Solutions Consultant – HCM

download-icon
The Benefits of Bringing Social into Your Workplace
Kristina Webb, Senior Director, HCM Transformation HCM Applications, Oracle APAC

MODERNIZE THE BACK OFFICE

shadow

download-icon
Transform your Business with a modern ERP
Hirak Kayal, Product Management India and PPM/JAPAC, Oracle

download-icon
Accelerate Your Planning Process and Customer Showcase
Shridar Jayakumar, Program Director - EPM, BI & Exalytics, Oracle APAC

download-icon
Equip Finance with Insight and Efficiency
Rajesh Ramdas, Director Applications, Oracle India

download-icon
Empower Modern Project Management with Customer Showcase
Hirak Kayal, Product Management India and PPM/JAPAC, Oracle

download-icon
Improving Returns on Innovation
Rathinakumar Vaidyanathan, Director, Supply Chain Solutions Consulting, Oracle Asia Pacific

download-icon
Emerging Best Practices in Distribution and Logistics
Sunil Kumar, Solutions Director, Oracle India

INNOVATE MORE

shadow

download-icon
Innovate with Oracle's Public Cloud Platform and Infrastructure Services
Ravi Pinto, Director Product Management, Oracle India

download-icon
Rapidly Build and Deploy Rich Applications with Oracle Cloud PaaS
Sudershan Singh, Principal Product Manager, Oracle India

download-icon
Streamline Collaboration Across Your Organization with Oracle Documents
Praveen Balakrishnan, Principal Sales Consultant, Oracle India

download-icon
Unlocking the Power of Business Analytics in Oracle Cloud
Shridar Jayakumar, Program Director - EPM, BI & Exalytics, Oracle APAC

download-icon
Deliver World-Class Smartphone and Tablet Applications with Oracle Mobile
Ravi Pinto, Director Product Management, Oracle India

download-icon
Tame the Cloud Integration Beast
Krishnaprem Bhatia, Senior Principal Product Manager, Oracle India