Your problem is nothing to do with XMLs/EDLs. Final Cut can’t use the MP4s in the BPAV file structure natively, so you have 2 options here. One is cheap and quick, the other slow and free.
Free option – download the Sony XDCam transfer tool, and use it to encode all the material to ProRes. Make sure the filenames are the same as your project filenames, and relink to the new media. You may have a few errors (potential for reel names to be off, etc) but it should go OK.
Quick option – use Calibrated Softwares XDCam plug-in, that enables FCP to work with MP4 files. I’m using this to reconnect media from someone editing roughcuts on Premiere as we speak. It’s been fine, more or less, with the odd clip that it hasn’t been able to link to in the timeline – the media is in the browser but the TL doesn’t make the connection. I always get a reference movie from the editor so I can eye-match any shots that don’t translate, but I’ve only had three or four in a fair number of sequences, so I’m happy with the workflow.
I don’t know how the latter option would work with Color – I will be Media Managing the edit to a ProRes project with handles when it’s time to send off to be onlined & graded, so you may wish to try beforehand and see if Color accepts the files as is…
_________________________________
Before you criticise a man, walk a mile in his shoes.
Then when you do criticise him, you’ll be a mile away. And have his shoes.
*the artist formally known as Jaymags*