How to import Sony Cyber-Shot Video to iPhoto successfully

"I recently bought a new Sony Handycam to upload videos onto my Mac and the guys at Best Buy assured me it was Mac compatible. The driver that came with the camera has a Mac guide, but no apps for uploading.
iPhoto detects my camera and will import photos, but seems the videos are coming up as incompatible. Any ideas?"
From Forums.macrumors

Friends like above want to import video to iPhoto, is mainly because when go into Finder and pull them to copy, iMovie won't light up as an application to use. So just go to iPhoto way and manage to get to iMovie. Here is list of most common Sony Cyber-Shot camcorders for your reference:
Sony Cyber-shot DSC-TX100V
Sony Cyber-shot DSC-TX10
Sony Cyber-shot DSC-T110
Cyber-Shot DSC-HX9V
Sony Cyber-shot DSC-HX7V
Cyber-Shot WX-9
Sony Cyber-shot DSC-H70
Sony Cyber-shot DSC-WX10
Sony Cyber-shot DSC-WX9
Sony Cyber-shot DSC-W570
Sony Cyber-shot DSC-W560
Sony Cyber-shot DSC-W530
Sony Cyber-shot DSC-W510

Sony Cyber-Shot camcorders are new popular camcorders, the high-end series like Cyber-Shot DSC-HX9V, Cyber-Shot DSC-HX100v recording AVCHD 60i / 60p / MP4 / MPEG-4 AVC(H.264) video format and Dolby Digital (AC-3) / MPEG-4 AAC-LC, Audio Format. Middle-end Cyber-Shot like Cyber-Shot WX-9, Cyber-Shot W570 record AVI, MPEG-Motion format.

So the key work we should do is to convert Sony Cyber-Shot Video to iPhoto natively supported Mp4 , and we will useSony Cyber-Shot to iPhoto Converter for Mac to convert Sony Cyber-Shot AVCHD, Mp4, AVI, MPEG-Motion to iPhoto Mp4, then you can copy it to iMovie or sync to iPad, iPhone, Apple TV. Steps are as easy as following.

Tutorial of converting Sony Cyber-Shot Video to iPhoto (Lion included):
Step One: Import AVCHD Video to Mac AVCHD Converter
Firstly, you need to copy your AVCHD to Mac and launch AVCHD Converter for Mac, then click "Add File" to upload your AVCHD files to the program. Any AVCHD files from AVCHD camcorders are supported.
Step Two: Set Output Video Format for iPhoto.

Click "Profile" to open the Profile drop-up list to select H.264 or Mp4 as output video format for iPhoto.

Step Three: Convert Sony Cyber-Shot Video to iPhoto.
Click "Start" button to convert AVCHD files to iPhoto.

Related Guides
AVCHD to ThinkPad Tablet: convert AVCHD to ThinkPad Tablet on Mac