Post thumbnail of Batch add users to the cc list for all components in the bugzilla database directly
24 November 2009
Continue reading Batch add users to the cc list for all components in the bugzilla database directly

Batch add users to the cc list for all components in the bugzilla database directly

If you want to add a user to all of the components in bugzilla, you don’t have to go through the gui. In fact, you can change just about anything in bugzilla by connecting to the database directly and modifying the tables. I find this much faster than repetitively navigating through the web front end. Connect to the database, match up user id’s to user names, figure out which components you want to modify, then update the component_cc table. Step-by-step.

Post thumbnail of Convert Excel spreadsheets to CSV in Linux without OpenOffice
25 September 2009
Continue reading Convert Excel spreadsheets to CSV in Linux without OpenOffice

Convert Excel spreadsheets to CSV in Linux without OpenOffice

I needed a batch converter to turn non-xml style Excel spreadsheets (all the older versions) into delimited text files. If you run it without supplying a sheet name, it will list all the sheets available. You can also optionally define a delimiter to use instead of the default comma. So here’s my code along with part of the xlrd module which I tweaked a little.

Post thumbnail of sha1sum mass checking for tampered files
22 April 2009
Continue reading sha1sum mass checking for tampered files

sha1sum mass checking for tampered files

You might want to do this to make sure a set of configuration files don’t get changed, or to figure out which files get changed when you build that random source code as root! (note to self: don’t make as root unless you have to, rpmbuild is bad enough!)

Share this:
  • Digg
  • Facebook
  • Reddit
  • LinkedIn
  • Google Bookmarks
Post thumbnail of Batch shrink your digital camera photo files
13 February 2009
Continue reading Batch shrink your digital camera photo files

Batch shrink your digital camera photo files

For those of you still loading your digital camera’s images into MSPAINT or paying hard earned $$$ for some crappy program just to shrink the size and quality to get normal file sizes that display easily and upload faster to your favorite photo sites:
Do it in 1 freaking command …

Share this:
  • Digg
  • Facebook
  • Reddit
  • LinkedIn
  • Google Bookmarks
Powered by Wordpress   |   Lunated designed by ZenVerse