Export Format

[chilluk]

I have a client that uses FM to record some events info. She wants to export that data, so I can then process the file using a PHP page and throw it into a MySQL db behind their website.

I have a problem - the file that FM is producing is proving a nightmare to process. It is tab delimited text, but only seems to contain a line feed char as the record delimiter (ASCII char 13). All the PHP functions seem to want a full carriage return / line feed pair. When you view the file in any Windows text editor it is all in one big block as you might expect.

Are there any other options that my user can invoke to produce the file in a different format. I am a total novice in FM I am afraid

Cheers.

[Fitch]

If you're going to open it in a text editor anyway, just use the text editor to search and replace the line endings. Or you could modify your PHP script to deal with it, I imagine. Or you could do the export on a Windows machine. Or use a FileMaker plugin such as Troi File. Or try a different format such as HTML or XML.

[BobWeaver]

Just to be precise, the ASCII character 13 is a carriage return. So, the character that is missing is the linefeed.

There is a way to do the export from Filemaker using some calculated fields and scripting I posted a sample file here.

[kenneth2k1]

I have been looking into XML, and there is an example of how to export from a FM database to MySQL. I guess by using a stylesheet.

http://filemaker.com/xml/xslt_library.html

This XML stuff looks very useful.

[BobWeaver]

Yes, I guess XML is very powerful. I'm going to have to spend some time learning about it.

[kenneth2k1]

'Tis all Greek to me.

But then again so is everything when you are learning.

Ken