ale2fcp

ale2fcp converts ALE shot logs exported from Avid Media Composer to a batch list which can be imported into Final Cut Pro version 2 and later.
ale2fcp requires a few columns to be present in the ALE shot log to translate it correctly. These columns must be visible in Avids bin window when the ALE shot log is exported.
The required columns are:

Name
Start
End
Tape
Tracks

Besides these columns, you can include the following columns which will be translated to the FCP batch list.

ALE shot log	FCP batch list
Mark IN	In
Mark OUT	Out
DESCRIPT	Log Note
Take	Shot/Take
Scene	Scene

Finally, you can include up to four more columns of your choice. You set the column names in the preferences (menu item Preferences under menu Sebsky Tools) and they appear in FCPs browser in the columns Comments 1 - 4.

To convert an ALE shot log follow these steps:

Export an ALE shot log from Avid containing the clips and columns you need. Refer to your Avid User Guide for instructions about how to do this.
In Sebsky Tools, make sure that the preferences are set to generate a batch list that is readable by the version of FCP you're using.
Choose ale2fcp, either by clicking the ale2fcp icon in the toolbar or by clicking menu item ale2fcp under the menu Tools.
Select the ALE shot log you want to convert. A few options appear under the file selector. Set them to match your requirements and press convert.
When prompted save the batch file.

ale2fcp options:

Copy Clip Name to Label field - This option adds the complete, untruncated clip name to the Log Field. Useful if you want to alter the clip name using the following options.

Match QuickTime File names exported from Windows - This option is useful if you want to reconnect the batch list in FCP to QuickTime files exported from an Avid running the Windows OS. When QuickTime files are exported from these Avids, some characters in the file names gets changed, making reconnecting in FCP difficult. The option translates the characters in the ALE shot logs clip names to the ones used in the QuickTime file names.

Modify Clip Name - You can choose to truncate the clip name in the FCP batch list and optionally add a file extension. The number of characters the clip name is shortened to depends on the QuickTime Version setting in the preferences. This option can be used together with Batch Add TC; if you in FCP want to reconnect the batch list to QuickTime files exported from avid, this option changes the clip name to match the exported QuickTime files which makes reconnecting very easy and accurate.

24 fps timecode - This option lets you choose which timecode value should end up in the Media Start column in the FCP batch list. You can choose to either convert the timecode value of the usual start column from the ALE shot log or use the value from the TC 24 start column.