• Apple Final Cut Pro Legacy

  Converting Premiere Batch Import Data

  Posted by Buddamint on August 6, 2007 at 4:59 pm

  have a question;

  I have batch lists from Premiere Pro in .CSV format with the timecode written as following;

  00;00;16;15 00;00;39;03

  semi colons are used by Premiere, where FCP needs colons (00:00:16:15). Does anyone know how exactly to reformat these in a spreadsheet ? I’ve tried reformatting in OpenOffice… no luck yet.

  thanks.

  Buddamint replied 18 years, 9 months ago 3 Members · 5 Replies
• 5 Replies

• 

  Stace Carter

  August 6, 2007 at 5:15 pm

  I do this all the time in Excel, just Find and Replace (CTRL+F or perhaps Apple+F).

  You may even be able to do this in one of the various text editors.

  Be careful on how you save out the resulting file though – one little extra space at the beginning or end can wig out your editing app.

  Good luck,
  S
• 

  Buddamint

  August 6, 2007 at 5:20 pm

  thanks !
• 

  David Heidelberger

  August 6, 2007 at 5:27 pm

  Also, be sure to keep the final semi-colon before the frame number, otherwise Final Cut will probably think you’re doing NDF TC.
• 

  Buddamint

  August 6, 2007 at 8:56 pm

  Thanks.

  Here is an example of the file–

  Name Media Start Media End Reel
  S10 01 00:31:16:14 00:33:02:09 tape 18

  The columns are seperated with tabs. It was saved as .csv and I changed it to .txt manually to import. It looks correct as per page 301 of the FCP manual, but FCP is still giving errors about not matching headers.
• 

  Buddamint

  August 8, 2007 at 4:30 am

  just so anyone doesn’t pull their hair out doing this…

  you have to export the batch as .csv from premiere. then go into a spreadsheet, reformat the headers as shown earlier. then save it as tab delimited (not comma seperated). then, reopen it in a word processor and save it as encrypted text– simple text files do not import.

Reply to this Discussion! Login or Sign Up