Archive for June, 2009

VSTO Excel Control Performance

June 18, 2009 at 5:52 pm · Filed under Software ·Tagged , ,

I was creating a ComboBox in an Excel  spreadsheet, however when loading the spreadsheet from a file and creating dynamically the ComboBox was really slow.

Two things were added to increase performance:

  • When the file load starts the following command was added Globals.ThisAddIn.Application.ScreenUpdating = false; and when the load finishes the opposite Globals.ThisAddIn.Application.ScreenUpdating = true;
  • Creating the ComboBox I was adding its items one by one, instead the DataSource property of the ComboBox was used.

    • Still slow but it changed.

    Leave a Comment

    php installation

    June 13, 2009 at 3:49 am · Filed under Software

    These are things to verify when the installation of PHP is done in a Windows server using Apache.

  • Apache configuration : httpd.conf

    • Verify the following lines are in IfModule dir_module
    DirectoryIndex index.html index.php

    Verify the following exists, usually these lines are added when php is installed

    PHPIniDir “C:\\PHP\\”
    LoadModule php5_module “C:\\PHP\\php5apache2_2.dll”

  • mime.types

    • Verify that the php extension was added
    application/x-httpd-php php
    application/x-httpd-php-source phps
    application/x-httpd-php php
    application/x-httpd-php-source phps

    Leave a Comment

    Installing Trac

    June 10, 2009 at 5:15 am · Filed under Software ·Tagged , ,

    I’m trying to install Trac on Win2008 server but so far it has been a pain. Let’s see how it goes tonight.

    These are the instructions to follow: TracOnWindows

  • Download the geshi software and install it on c:\Python\Scripts\geshi, also download Genshi-0.5.1-py2.6-win32.egg
  • Download the setuptools and install in on c:\Python\Scripts\setuptools also download setuptools-0.6c9-py2.6.egg
  • Run python setup.py for the setuptools
  • That creates the easy-install files in the Python\Scripts directories
  • For some reason when running the easy-install.exe shows the error that the c:\Python26\python.exe can not be found. So since the python.exe application is my Path then I will use it instead of easy-install.exe. This is a bug in setuptools, see this thread to check for the progress of this bug
  • Go to the trac directory and run python setup.py install
  • Create the trac project directory in my case c:\project\trac and run the Script “python trac-admin-script.py c:\project\trac initenv” that will prompt some questions to initialize the environment.
  • After this is done run the Trac Web Server “python tracd-script.py –port 8000 c:\project\trac”
  • Now I can see the trac start page at http://127.0.0.1:8000/trac_prj

    • TODO Next

  • Configure IIS7 for trac
  • Create users and groups in trac
  • Fix the connection with SVN

    • I’m done for tonight.

    Leave a Comment