Wednesday, November 30, 2005

Move Putty's stored data to a new Windows computer

To move putty's setting from one machine to another, use regedit to export a reg file of HKEY_CURRENT_USER\Software\SimonTatham\PuTTY, and install it on a new machine.

FileMaker via ODBC Performance Problems

When Cristóbal was updating fields in Batch Line Items.fp5 (a FileMaker DB) via ODBC, each field update was taking about 30 seconds. A small part of the problem was the calculated fields, and if you ever need to maximize performance, you might want to look to see if it’s possible to remove them.
However, the big performance culprits were 2x summary fields, which accounted for about 93% of the slowdown. He was able to remove one field, since SNR indicated that it was totally unused. The other he converted to a global field, and introduced a “recalculate” button on the layout where the field was used – the button called a script to recalculate the field in accordance with the old summary field definition.
With around a half a dozen calculated fields, the updates took about 2 seconds, which is too slow, but fast enough for our needs.

Direct Link to Blogger Article

If you need to link to a particular article in Blogger, surf to the blog in FireFox, right click, select “Web Developer” (this assumes you have it installed), “Information”, and “View Link Info”. There, you will be able to see all the direct links on the page.

Friday, November 25, 2005

ActiveSync - "Combine or Replace" Dialog

Just had a case (after a power outage) where we got a strange dialog from the Desktop PC running active sync:

The following information type on your mobile device has items that have not been syncronized with this computer before. "combine or replace" information type: files

Combine the items on my device with the items on this computer.
Replace the items on my device with the items on this computer.
Do not syncronize this information type at this time

Not really sure what happened, but it appears as if the file that coordinates the sync got messed up. Best article I read on it was at http://www.pocketpcfaq.com/raj/Combine-Replace.html, reproduced here in case the link eventually disappears:

ActiveSync - "Combine or Replace" Dialog
By Raj Pillai, Copyright 2003-2004
Version 1.24 Revised 5/11/2004

Click to Visit Pocket PC Talk

Introduction:

Every Pocket PC user encounters the Combine or Replace dialog box as shown below at some point of time although the Information Type might differ. The information below tries to explain why this dialog box is prompted and the scenario's when this dialog box can appear.



Why Does This Dialog Appear?

When you connect your Pocket PC for synchronization purpose ActiveSync compares the data on the Desktop and the device using something called as "store identifiers" along with time-stamps to determine if the information type has changed. If the identifiers do not match, then it tries to re-establish the mapping between the Desktop and the Pocket PC by displaying the above dialog box.

What Do The Options Indicate?

The "Information Type:" will list the type of information that ActiveSync has not mapped. The three options are self explanatory.

*

The 1st option will simply combine all the information (Pocket PC + Computer) on both the devices.
*

The 2nd option will copy all the information from the Computer to the Pocket PC. It will replace all the information stored on the Pocket PC.
*

The 3rd option does not synchronize the listed information types.

There is no option which will replace the data on your computer with the Pocket PC data. The closest way of doing it would be to use the 1st option and combine the data.

Why Did The Dialog Appear?

Lets take a look at the scenarios where this dialog box will appear:

*

When you synchronize your Pocket PC with data for the first time.
*

When you delete a partnership on the Desktop without deleting the information on the device, and then reconnects the device to create a new partnership.
*

When you try to synchronize with a different Outlook profile for the first time.
*

When you move the location of the default Outlook ".pst" file after establishing a partnership.
*

When you synchronize with two computers and perform a replace operation on one computer, and then synchronizes the device with a second computer.
*

When you synchronize after restoring the Pocket PC data from a backup file.
*

When you delete the repl.dat file, which stores the partnership information. This file can be found in the ActiveSync Profiles directory. The default path in Windows XP would be:

C:\Documents and Settings\<>>\Application Data\Microsoft\ActiveSync\Profiles\<<>>

The Combine or Replace Dialog Appears Every Time I Synchronize:

If you are synchronizing with only "one computer" and this dialog appears everytime you synchronize, then you might need to recreate the partnership. Due to some kind of corruption the store identifiers might getting affected at every synchronization and therefore are not able to map themselves correctly.

To delete a partnership:

1. Disconnect the Pocket PC from the computer.
2. In ActiveSync -> File -> Delete Partnership. Select whether you want to delete your synchronization folder as well.
3. Connect the device and follow the onscreen instructions to setup a new partnership.

If you are synchronizing with "two computers" and the dialog appears on a regular basis, then it appears that for some reason, the store identifiers for the selected information types is getting affected when you synchronize with the second desktop PC and therefore the first computer is unable to match the identifiers when it compares and pops up the Combine or Replace dialog.

Although the Combine option creates duplicates, as far as I know ActiveSync version 3.7.1 checks for duplicate entries as well and prompts you whether you would like to remove or keep them. But in some scenarios it is unable to identify the duplicates since the identifiers are different. If you have a lot of duplicate entries, then I recommend you use the free Outlook Duplicate Remover utility, written by Fr. Simon Rundell. It is available for download at the following site:

http://www.slipstick.com/addins/contacts.htm#dupes

You could verify if the problem is caused due to synchronization with a secondary PC by first synchronizing with either of your computer and then before synchronizing with the second computer, create a new Contact/ Appointment on your device and another set on your Desktop (all having different name or else a conflict will occur) and see if you are displayed the dialog. In this scenario the information will get updated automatically on both the devices without the C/R dialog since the store identifiers have not been affected.

In such a scenario, delete both the partnerships on the computer and form a new partnership. You could try the following approach:

Before you leave work, synchronize your Pocket PC and after synchronization is successful delete the partnership. Go to your home PC. Delete the partnership on the home PC as well before connecting. Now connect and then create a new partnership and you might be prompted with the Combine or Replace dialog once select combine since you want the data on your Pocket PC to reflect on your home computer as well. Once this is done, repeat the steps to create a new partnership on your work PC.

This information should help you understand the possible causes and how you could go about solving the recurring Combine or Replace dialog that appears whenever you try to synchronize with your computer.

Thursday, November 10, 2005

Getting CVS Commit emails from ModWest

- Download CVS spam from http://www.badgers-in-foil.co.uk/projects/cvsspam/
- Upload the file to your CVS folder
- With the shell, decompress the tarball with tar -zxvf cvsspam???.tar.gz
- Rename the resulting folder "cvsspam"
- cd /cvs/CVSROOT
- chmod 777 commitinfo
- vi commitinfo, and add the line
ALL /usr/bin/ruby /cvs/cvsspam/record_lastdir.rb
- save the change
- chmod 444 commitinfo
- chmod 777 loginfo
- vi loginfo, and add the line
ALL /usr/bin/ruby /cvs/cvsspam/collect_diffs.rb --to me@mydomain.com %{sVv}
- save the loginfo
- chmod 444 loginfo
- make the directory /cvs/cvsspam/
- mv /cvs/cvsspam/cvsspam.conf /cvs/cvsspam
- ModWest's sendmail does not accept the -io option (see http://www.modwest.com/help/kb10-124.html) used by cvsspam. Remove the option from /cvs/cvsspam/cvsspam.rb
- To add more people to the send list, check the /cvs/cvsspam/cvsspam.conf file

Monday, November 07, 2005

phpMyAdmin Direct Link

While searching for something faster than phpMyAdmin for my daily MySQL work, I found a documented trick for going directly to a specific db /table.

If your usual phpMyAdmin URL is e.g. http://127.0.0.1/mysql/, and you want to go directly to table "hours", you would type http://127.0.0.1/mysql/index.php?db=hours. If you want to go to the table "bob" in "hours", then http://127.0.0.1/mysql/index.php?db=hours&table=bob.

Now, anyone have any suggestions for free, fast alternatives to phpMyAdmin for working with local DBs in Windows?