INTRODUCTION
This is a very simple script that I did for a friend. It can be used to quickly generate blogrolls.
Input: csv file with blog author names and blog links
Output: OPML file that can be imported into many blogging/blogrolling software and websites (e.g. wordpress, blogrolling.com, etc)
Usage:
shantz-csv-to-opml.pl <input file in csv format> <output opml filename>
Input File Format:
Each line should be like this:
<Name of Author>,<bloglink>,<bloglink>…
e.g.
Shantanu Goel, http://tech.shantanugoel.com, http://blog.shantanugoel.com
There can be any number of blogs for any author, if blogs are more than one, then multiple entries for that author will be made in opml file each indexed with increasing number like Shantanu Goel 1, Shantanu Goel 2, etc
Version History:
0.1 – Initial Version
[...] shantz-csv-to-opml [...]
Hello There, this looks perfect for what i am trying to accomplish, but my lack of PERL knowledge is proving to be barrier.
Can I run this script on my local MAc OSx machine? Or a web server?
Where do I specify the input .csv file?
Thanks, Malcolm
malcolm, you can run it on your local machine as well as web server. Only pre-requisite is that perl should be installed on the system. You have to specify the input as well as output file names on the command line itself after the script name as mentioned in the article. e.g., if you input file is myinput.csv and output is myoutput.opml, then you have to run “shantz-csv-to-opml.pl myinput.csv myoutput.opml” without the quotes.
Hi, I need so much this script…. but the link is broken.. Can you help me? Thank you very much
@webinki: I’ve fixed the link. Please download again.
Hi Shantanu,
I am hoping to use your Perl script to conver a CSV file to an OPML file in order to load all my exisiting links into my new WordPress database.
The CSV file contains
Title, Description, URL
for all the websites that my current website links to.
Could your Perl script be used for this?
Best Wishes, Dave