Cleaning up Facebook “Friend” list

I created my Facebook account in 2007, when Facebook was slowly making its trend in this side of the world. And then I made the worst mistake – adding anyone.

[JIRA] Dev – Where are OSWorkflow Transition Screens?

Found a piece that isn’t well documented. But as usual, I’m explaining my steps and then the solution. It’s no real big deal anyway. 🙂

JIRA project migration with Google Spreadsheets

JIRA to JIRA project migration — most of the time this has been a headache when it comes to customer negotiations and compromises.

Wunderlist Today wallpaper for Ubuntu

Wunderlist again. Currently this is the only Microsoft thing that I use – apart of Windows servers involved in my DevOps job.

[JIRA] Delete projects from XML backup using Python

[Experimental]

If you are a JIRA system administrator, have you ever come across the requirement of partially exporting JIRA into XML – probably for importing individual projects into another JIRA instance?

Password trainer software

I screwed it up again.

I logged into one of my e-mail accounts from a shared computer owned by someone else. This is something I never do (unless there’s a top urgency) because I fear keyloggers. So now, time has come to change the passwords. Next factor of two factor authentication will keep me protected, but still need to fix the first factor.

[JIRA] Bulk deleting pojects like a boss!

These days I’m working on a JIRA project which may require working with XML backups and project import tool. The JIRA instance I’m currently working on has over one million issues in thousands of projects (including defunct) – that collectively make the XML backup gigantic.

Have you ever come across the situation where you want to delete some of the projects in JIRA to reduce the size of XML backup? Well, here’s a quick script that I wrote. However, it requires the Adaptavist ScriptRunner add-on which is no longer free. 😦

[JIRA] Finding issues that contain LucidChart diagrams

One of the coolest JIRA add-ons you could find in the market is LucidChart. LucidChart is an easy-to-use diagramming software. However, once you start using it in your JIRA, it stores diagrams in it’s own way.

Oracle:: Drop all tables in a single shot

If you are into software development, you may have wanted to drop all tables of an Oracle database schema in a single shot. How do you do it? Here’s how I do it with a simple PL/SQL procedure.

begin
for i in (select * from tabs) loop
execute immediate ('drop table ' || i.table_name || ' cascade constraints');
end loop;
end;
/

‘tabs’ is actually an in-built view in Oracle. As explained in the follwing forum post, this PL/SQL block affects only the logged in user’s (schema) tables only.
https://community.oracle.com/message/10359255#10359255

LAMPP, what happened?

Yesterday evening I and one of my friends were testing a software project. It is a web application and he has tested it with XAMPP on Winows. He wanted to try it out on Apache/ Linux too. So he came to me (I’m a one of famous Linux-only guy around the campus 😉 ) and asked me to help.

I have a dual boot system with both Fedora 11 and Ubuntu 9.04 installed. First I put everything in LAMPP (on Ubuntu) and tested.

Yes, we’ve found some bugs with character case issues plus one fatal error with the TCPDF module when generating PDFs. The problem was with memory allocation and as the browser showed it was an error in tcpdf/unicode_data.php.

Then I put everything in Apache which came by default with Fedora DVD, and tested. Viola! The PDF generation problem was not there!!

I’m still wandering how it could be… same Apache-PHP-MySQL.

Anybody have an idea of what’s the problem here?