Export calculated field's formula, not value..

[spim]

Hi all,

It's my first time in here, and I used FMP for the 1st time 5 days ago...

I am gonna try not to waste your time and go straight to the point. Let's say I have this table :

I want to export in any format that can be parsed (text/csv/xml...) something like this :

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

<fields>

<field>

<name>FirstN</name>

<type>Text</type>

<options></options>

</field>

<field>

<name>LastN</name>

<type>Text</type>

<options></options>

</field>

<field>

<name>BDay</name>

<type>Number</type>

<options></options>

</field>

<field>

<name>BMonth</name>

<type>Number</type>

<options></options>

</field>

<field>

<name>BYear</name>

<type>Number</type>

<options></options>

</field>

<field>

<name>FullName</name>

<type>Calculation</type>

<options>FirstN & " " & LastN</options>

</field>

<field>

<name>BDate</name>

<type>Calculation</type>

<options>BDay & "/" & BMonth & "/" & BYear</options>

</field>

</fields>

Only the 2 last calculated fields really interest me, but I don't mind having more. Again, output can be any text format that can be parsed. Only showed XML because it appeared as a style in the fmforums box and I was curious to see how it would be formatted

In case you wonder why I don't just do it manually, I have just been given a huge, 450 fields in a single table FMP file to convert to MySQL... !!!

Thank you for taking the time to read! Thank you even more for taking the time to answer!!!

Spim!

[comment]

I don't think this is possible - unless you upgrade to the Advanced version, where you can produce a DDR:

http://www.filemaker.com/11help/html/fmpa_tools.24.5.html#1027855

[spim]

Hi there,

After a whole morning wasted, hundreds of copy-paste, thousands of clicks and a few macro to automate what could be automated, I did get everything I needed manually!

Thanks for your answer!

Spim