Export records with field names on the top row

[kfok]

Is it possible to export records to a .csv or .tab file with field

names on the top row?

[danjacoby]

No.

But you can export as a DBF file, and that puts the fieldnames in the top row.

[CobaltSky]

Hello kfok,

I suggest that you choose the export file format which is named 'Merge' on the format option drop-down list.

The resulting export file will indeed be .csv format with field names in the header row - exactly what you're looking for!

[kfok]

I exported records from both the main file and related file to a merge file and I found that the field name of the related file will be in this format "Relationship:Field name". Is it possible to get rid of the "Relationship:" from the field name?

[CobaltSky]

Hi,

From the perspective of the file you're exporting from, that *is* the field name, so that's how FileMaker includes it.

One way to get around this is to create appropriately named 'mirror' fields (ie unstored calcs that directly reference the related field) and export from those instead. You'll get the same content in the export file, but a different field name (of your choosing) in the header.

...or alternatively, if you have access to a plug-in such as Troi File from Troi Automatisering or File Toolbox from Waves in Motion, you could simply script the export along with a substitution to remove the relationsh name from the header within a single script pass.