[Mick Kalber] “I have downloaded XDCAM transfer from Sony.”
Did you download the XDCAM Transfer standalone application form Sony, or the XDCAM Log & Transfer plugin for Final Cut Pro? They are two separate things. Sony used to make two standalone applications called XDCAM Transfer and Clip Browser. They were both replaced by a newer application called XDCAM Browser that combines both of their functionality.
If you want to import the footage directly into FCP using Log & Transfer, then you’ll need to install the XDCAM EX plugin for Final Cut Pro.
If that’s not working, give XDCAM Browser a try and see if that helps. If not, you may need to look into other utilities designed to recover footage from incomplete or corrupted card structures. Others on those forum are more knowledgable about those tools and can point you in the right direction.
Good luck!