Archive for May, 2011

processing open office .ods files in perl

Thursday, May 26th, 2011

Have just spent the last couple of days trying to process a spreadsheet file created in openoffice using perl. The problem I had was deciding which CPAN module to use. A choice of one which did everything I wanted would have been ideal. Unfortunately I had the overwhelming choice of hundreds.

I finally settled for ODF::lpOD

Thanks to the following pages that pointed me in the right direction:,_read_and_update

PHP Upgrade for 5.3

Tuesday, May 10th, 2011

Busy updating websites so they work in PHP 5.3
a somewhat boring task:
change each MySQL login password so it is stored in the new format
and update any depreciated code:
replace split with preg_split
replace ereg with preg_match
and wait for them to come to term!
Or postpone the problem till PHP 6 by ignoring all depreciated warnings:
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
and do the job properly later…

PHP 5.3 depreciated functions