[Robert Esmonde]

Thanks Shane.

Everything, Canon 5D and Canon XHA1, is already in 25FPS ProRes in FCP.

Can I just feed my captured 5D ProRes footage into Compressor and modify the dimensions to HDV to make multiclip-compatible ProRes files?

[Robert Esmonde]

Thanks Bob.

I’ll try that again, but I think that’s the method I used to get the info in my current Batch List export. I did set handles to zero.

What I really need is to get the two timecode figures at the end of the EDL line below ‘FROM CLIP NAME:’ into my final spreadsheet. These appear to be the timecodes for the ‘In’ and ‘Out’ in the master programme. At the moment they appear as ‘Not Set’ in the ‘In/Out’ columns of the FCP Browser.

Seems like I need a different program (application) to extract this info from the EDL.

As you can see, the EDL has all of the shots sequentially ordered by the timecodes of those ‘In’ and ‘Out’ timecodes, allowing me to work my way down through the programme shot content. But FCP’s Browser orders shots alphabetically by ‘Clip Name’.

As I said in an earlier post, even if I could get this timecode info into FCP, I’m not sure if it could/would order it in similar timecode order. And, even if FCP could do it, I don’t know if the resulting Batch List export could then display in timecode order in e.g. Excel or some such spreadsheet.

Lots of questions, I’m afraid.

Thanks again for all the help.

Robert.

[Robert Esmonde]

Hello,

Have I reached a dead end with this problem?

Or can anyone see where I’m going wrong from the screenshots?

Thanks,

Robert.

[Robert Esmonde]

In case it helps explain my earlier post better I’m uploading screen images showing:

1. My EDL text file

2. After Import to FCP

3. The spreadsheet resulting from Batch List export from FCP

Thanks,
Robert.

[Robert Esmonde]

Thanks to all who offered help – I’ve got some good news and some bad news.

I’ve tried the FCP EDL import and Batch List export. I renamed that output file with the .txt suffix and it opened fine in Apple’s Numbers spreadsheet with apparently all of the FCP column headings and data replicated.

However in the process there were two problems –

1) I lost my timecode information for the finished programme. It’s in the EDL text file but not in FCP’s Master Clips Folder list after the Import, so missing from the Batch List export too. I have Name, Duration, In, Out, Media Start, Media End, and lots of other columns I’m not that interested in. But no sign of the Programme Timecodes that were in the EDL.

I do have In and Out columns after the Duration Column but they are full of ‘Not Set’ information for all of the shots except for some Rostrum Graphics. I’m guessing that this is where the Programme In/Out timecodes should be, but for some reason they have not made the journey across from the EDL to FCP.

2) The resulting spreadsheet is ordered alphabetically by the Source Clip name given by the programme editor. That could prove useful when I need to see the total durations from e.g. archive sources, but I would also need to have the content in programme timecode sequence. Even if there is a way to get that programme timecode from the EDL via FCP to the Batch List export, I’m not sure if Numbers, or Excel, or whatever application I use for the spreadsheet, will be capable of ordering the sequences by programme timecode.

I’m hoping someone can suggest a method of getting the programme timecode into FCP and then ordering the resultant spreadsheet by that timecode.

Thanks again for all the help – as you will have gathered by now, I’m new to all this and was really struggling until I got the above suggestions.

And thanks Joe for that tip on the Microsoft Office for Mac deal. I’ll check it out.

Robert

[Robert Esmonde]

Thanks for that confirmation Andreas.

That’s really encouraging. I’m going to try it later today, so fingers crossed.

Regards,

Robert.

[Robert Esmonde]

Thanks very much Bob.

Yes, you’re right, I’m afraid, about the Notes in the EDL. But your suggestion about FCP sounds good. I’ll give it a try and see how I get on.

Regards,

Robert.