I have been using PCs/notebook for a pretty long time. When I was in school (in the 1980s), to transfer files between two PCs, I had to copy the file onto a floppy drive, then use the other PC to read the floppy drive. That was obviously a major pain if there are a lot [...]
Category Archives: work
Upgrading from Python 2.5 to Python 2.5.4
I was hesitant to upgrade from Python 2.5 to 2.5.4 on because upgrades usually break something. I tested it first on a desktop. The default upgrade installed to a C:\Python25 directory and a lot of things broke. Python scripts that worked before stopped working. easy_install would not work because it could not find Python.exe. This [...]
Also posted in python, wow Leave a comment
Vim compiled with Python 2.5
You might want Vim compiled with +python if you’re trying to get Vim’s wonderful omnicomplete to work. The gvim.exe at vim.org does not have +python for 2.5. You can get a python 2.5 build at Yong Wei’s site. Now omnicomplete works for me !!Read more python,work articles
Also posted in python Leave a comment
Scheduling Python scripts as Scheduled Tasks
When scheduling python scripts as Scheduled Tasks in Windows, take note that although you specify the script with arguments eg : kl_ofm.py -g -v When the scheduled task runs, it runs as kl_ofm.py without the arguments. The above is something to take note of when scheduling Python scripts. One option around this is to [...]
Also posted in python Leave a comment
Running Scheduled Tasks from the command line
The command is schtasks /run /tn <taskname> However the taskname must not contain ‘.’. If it does, rename it C:\1\python>schtasks /RUN /TN “kl_obo_uploader.py”ERROR: The parameter is incorrect. After renaming, C:\1\python>schtasks /RUN /TN kl_obo_uploaderSUCCESS: Attempted to run the scheduled task “kl_obo_uploader”.Read more work articles
Posted in work 2 Comments
Python programming with Excel, how to overcome COM_error from the makepy generated python file
import win32com.client xl = win32com.client.Dispatch(‘Excel.Application’)wb = xl.Workbooks(‘Book1′)ws = wb.Worksheets(‘Sheet1′)cell = ws.Range(‘A1′)cell.SetValue(arg1 = ‘test entry in Excel’) Above is a very simple python script to write something in Excel. To run the above, you need Mark Hammond’s pywin32 to generate the PythonCOM package. Read O’Reilly’s Python Programming on Win32 for more information on what PythonCOM packages [...]
Finding the last query in Oracle Applications
1.) Goto Help2.) Click on Diagnostics3.) Then Examine4.) In the first field (block) enter SYSTEM5.) For Field enter LAST_QUERY6.) Then click on Values7.) You will see last queryRead more oracle,work articles
Also posted in oracle Leave a comment
installing pycrypto on windows with easy_install
If you have been hitting this error: error: Setup script exited with error: Python was built with Visual Studio 2003; extensions must be built with a compiler than can generate compatible binaries.Visual Studio 2003 was not found on this system. If you have Cygwin installed,you can try compiling with MingW32, by passing “-c mingw32″ to [...]
Also posted in leisure Leave a comment
Import Palm Desktop data into Outlook
My situation – I wanted to import my Palm Desktop data to Outlook. There is an offering by chapura that does this but it costs some $. I found out this free alternative which will do it. The experience I had with exporting Palm data to comma delimited files or tab delimited files were not [...]