Author Archive
Read Office 2007 files with Office XP, 2000, 2003
Download details: Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats
By installing the Compatibility Pack in addition to Microsoft Office 2000, Office XP, or Office 2003, you will be able to open, edit, and save files using the file formats new to Word, Excel, and PowerPoint 2007. The Compatibility Pack can also [...]
Not happy with CompanionLink for Google
When I was looking for a software to synchronize my Palm information with Google Calendar, I found CompanionLink for Google.
I could not find any review for CompanionLink for Google but bought it anyway because there were not many alternatives available.
It has given me many problems.
Some of them are - my Palm and Google records [...]
Automatically log everybody out from GP
One of my gripes about Microsoft Dynamics GP deployed on citrix is that it’s very easy for users to leave their GP session running when they leave citrix.
Users often think they have exited GP when they close the citrix window.
The problem with this is that the GP sessions take up license seats and if somebody [...]
After upgrade Wordpress, get xmlrpc invalid response error
If anything has gone wrong the first thing to do is go through all the steps in our extended upgrade instructions. That page also has information about some of the most common problems we see.
Upgrading WordPress « WordPress Codex
I recently upgraded Wordpress manually following the instructions at Upgrading WordPress « WordPress Codex. Soon after, [...]
Guido’s Google App Engine application
..Guido van Rossum announced today that he open sourced the code for Code Review, a Google AppEngine app he released last week
Agile Testing: Guido open sources Code Review app running on GAPE
Technorati tags: python, google, app, engine, guido
Free Django hosting
Google App Engine comes bundled with the popular Django python framework.
For an idea of Django hosting prices, visit http://www.webfaction.com/services/hosting.
Python hosting is rare and pricey (compared to PHP hosting).
Before Google App Engine, if you wanted to run Django on Bluehost, you have to be ready to do quite a bit of work and bluehost tells you [...]
Introducing Google App Engine - hosted web applications on Python
Most hosting companies support PHP web applications but few support Python web applications.
Google just launched Google App Engine - a hosted environment that uses Python and YAML and it even offers a no-risk free start-up pack.
During this preview period, applications are limited to 500MB of storage, 200M megacycles of CPU per day, and 10GB bandwidth [...]
How to get explain plan output with rows in trace files
alter session set sql_trace=true
Run the sql(s)
disconnect
Note step 3, disconnect, not turn trace off.
Read more here:
Hi Tom, sometimes when I run the TKPROF (ALTER SESSION SET SQL_TRACE=TRUE), the explain plan don’t appear in the output file. Why this can happen? Thanks.
and we said…
The explain plan should never appear in the tkprof. In order to get the [...]
related posts gotcha when changing wordpress theme
For those who are using the related posts Wordpress plugin, when you switch to a new Wordpress theme, you might find that the related posts have gone.
When you switch to a new theme in Wordpress, remember to include these lines in single.php
1: <?php if (function_exists(’related_posts’)) { ?> <div class=”related”> <h3>Related Posts</h3> <ul><?php [...]
datemode meaning in xldate_as_tuple(xldate, datemode)
To decide which datemode to use, first check this (refer picture) in the Excel workbook that you are extracting data from with python.
If 1904 date system is checked, use datemode 1, otherwise, use datemode 0.
Background:
To extract data easily from Excel workbooks, use pyExcelerator.
Excel stores date as floating numbers. To convert the number to Gregorian [...]