Dont know how to make two fields

[snekkis]

Enclosed is a file which I made because I have to batch eight hours of video footage. I am making a small program to generate a batch list I import into Final Cut Pro for easier batch capture.

So far I'm finished except that the final text export file I'm going to use, I have to edit two places. As you see in the enclosed text files, Batchlist1.txt misses the heading which the edited batchlist2.txt has, which are Media Start and Media End. It is the Calculation field that is generated this way in the tab separated file format. I need to replace the the two SMTP values of zeros with what you see in the batchlist2.txt.

It won't take me long to alter this later when I open it, but I would like to make it perfect before free distribution, and that it would not be needed for others that would like this utility.

Snekkis

BLC.zip

[Fenton]

Here is one way to do it, using XSL; which allows you to specify what you get, in this case field labels in a header row. It is not possible to export tab-separated text from FileMaker with a header row, without going through some kind of conniptions.

The enclosed .xsl file is fairly generic. It should work with most any FileMaker file.

It would also be possible to export without the header row, then use AppleScript or command line to write the header. I've included a script using AppleScript.

I guess a first question would be, "Does Final Cut Pro really need the header?"

ExporttabwFieldNames2.zip

[snekkis]

Thanks a lot for your help! I have downloaded the files and will look into them for certain.

Yes, FCP must have the headers or else it will not import.

Snekkis