Export to CMX3600 format

[tv_kid]

Has anybody tried exporting to a CMX3600 format? It is a combination of headers, tabs and carriage returns, used for AVID editing software.

Just thought I'd ask before I plough ahead and try to work it out myself.

[Lee Smith]

No.

However, have you check out the different [color:blue]formats that can be [color:black]exported? Look up [color:blue]File Format in your [color:blue]Online help, and there is a complete description of what you can expect using any of the export formats.

HTH

Lee

[Fenton]

Unfortunately the tab-separated format doesn't allow a header row (they really should, as it's pretty commonly asked for). You can do this fairly easily with an xml export, using an xsl stylesheet. For simple tabbed with header:

<?xml version="1.0" encoding="utf-8"?>



xmlns:fm="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fm" >



	



		

			

				

				

					

					

			

			

		

		

		

			

			

			

				

				

					

						

					

					

						

					

					

					

					

			

				

[tv_kid]

Thanks for your advice guys. I've knocked up a script to set up the required data in a text field, and then just export the text field. However, I'm going to mess about with it a bit more, as theoretically it could get to the point where the maximimum field limit size is reached if it's a large list.

[Fenton]

You know the text size limit for a field has gone up dramatically since FileMaker 6? For 7/8:

Text: Up to 1 billion characters per field per repetition