Converting Microsoft Excel sheet (XLS file) to a Comma Separated file (CSV) is relatively very easy while using an Office product, but it could be a tedious task for programmers to do it in command line. The situation may arrive when you have a XLS file and you need to fill the database from it after formatting the data. Converting the XLS to CSV is the ideal way here as the CSV is the format that can easily be manipulated in any language, be it Shell, Perl, Ruby, Python or Java. In this post, we will see the best ways to convert the XLS file to CSV and we will also discuss the pro and cons of using these methods.
[Read more...]
How to convert XLS file to CSV in Command Line [Linux]
By | February 3, 2012 | Leave a Comment
How to Batch Convert Documents at the Command Line
By | September 16, 2011 | Leave a Comment
There comes a time when you need to convert one or more files to another format. Say, for example, you have a bunch of .rtf files that you want to turn into OpenDocument files. Chances are you don’t need to do that too often, but when the time comes, opening each file in a word processor and saving it can be a real chore.
If you use OpenOffice.org or LibreOffice, then you can save a lot of time by letting a command line utility called JODConverter do the work for you. Don’t let the fact that it’s a command line tool scare you. JODConverter is easy to use and fast. It’s also very effective.
Let’s take a look at how to use it.
[Read more...]
How to Play MP3s From The Linux Command Line
By | August 11, 2011 | 1 Comment
At first, this may sound pointless. After all, aren’t there dozens of perfectly good GUI music apps out there? Haven’t we all found something we like, or at least don’t hate? Perhaps that’s true, but how much happier would you be if your music app of choice used a whole lot less resources? Or what if you could type in a command on your laptop from anywhere, and have music start playing from the speakers on your desktop? If you’re in to pranks, that works just as well on a friend/co-worker’s computer. Today’s topic is mpg123, an app which can (among other things) make a great GUI-free media player.
[Read more...]
7 Linux Shell Tips For Increased Productivity
By | June 16, 2011 | 4 Comments
Love it or hate it, the command line is here to stay. Sure, there are new options emerging like TermKit but it’s unlikely that the command line will ever really go away. Those who take the time to master it can run productivity circles around their peers, but with the astonishing assortment of CLI tools available, where do you even begin? We’ve compiled a few of the most useful tools and tricks into this guide to help new users gain some new knowledge, and old pros learn some new tricks.
[Read more...]
Take Your To Do List to the Command Line with iKog
By | May 13, 2011 | Leave a Comment
I like a good GUI as much as the next person, but some things beg for a little more simplicity. One of those things is a to do list. Which is why I turn to the command line and a text file for mine.
Of the several command line to do applications out there in the Linux ecosystem, which one should you choose? That’s up to you to decide, but you might want to take a look at iKog. Short for it Keeps on growing, iKog is a Python script that helps you manage your tasks. If you’re into Getting Things Done (GTD for short, a popular method for personal organization), then it’s worth the time to check out iKog.
[Read more...]
Rip Your CDs At The Command Line
By | April 22, 2011 | Leave a Comment
Are you looking for a fast, efficient, and easy way to rip music from your CDs in Linux? Then look no further than the command line. Yes, you read that correctly. The command line.
For a variety of reasons, the Linux command line has a reputation for being difficult and unwieldy. In some cases, that’s true. But a script called ripit turns the command line into an excellent and deceptively simple environment for ripping CDs.
Let’s take a look at how ripit works.
[Read more...]
How To Fix Network Problems Using Command Line Tools In Windows 7
By | February 8, 2011 |
Solving a network problem can be hard and frustrating. While you can check your internet connection using the Windows Network Diagnostic tool, it is hardly enough to solve most problems. Sometime, you might have to troubleshoot via the hard way – the command line way.
There are several advantages to using th command line instead of the visual interface:
- We can check on individual item, and isolate those that are causing the problems.
- Command line tend to have more options so we can test the system deeply.
- We can use scripts to automate the process.
In this article, we will show you how to diagnose and fix network problems using the command line.
[Read more...]
gleeBox Lets You Navigate The Web Using Your Keyboard
By | January 12, 2011 |
There is no doubts about the usefulness of a mouse. It allows you to move around the screen faster and click on links that are located at the far corner of the screen. However, if you are used to the keyboard, there are times when you just hate to move your hand from the keyboard to the mouse. It is both troublesome and tiring. Won’t it be great if you can navigate the Web just by using your keyboard?
[Read more...]
Fetching Files with wget
By | December 23, 2010 |
Perhaps your X server has crashed. Or you’re working on a shell script. Or you’re SSHed into a headless server. For one reason or another, if you need to fetch a file and a web browser’s not an option, you might want to look into wget. If you’ve used the Linux shell much and worked with scripts or package installers, there’s a good chance you’ve seen wget in action. At the simplest level, it does just what the name implies and gets a file from the web (or FTP). Underneath that, though, is some clever functionality.
[Read more...]
10 Useful Tools, Websites And Tricks to Help You Master Linux Command
By | November 9, 2010 |
When it comes to Linux command, it is always a love and hate affair. Newbies tend to shun away from the command line as much as possible while the intermediate to expert users who are used to it will swear by it, and boost how much faster and more productive they have become due to the command line.
Regardless which camp you belong, as long as you are using Linux (doesn’t matter which distro), you are sure to hit the terminal and type some commands into it at some point of time. Why not embrace it and take the opportunity to learn something new?
Here are some websites, tools and tricks that you can make use of to learn Linux command line. This is in no way a comprehensive list, but will be a good start for those who wish to get started.
[Read more...]
