Export CSV with fieldname (label name)

[Guru Salem]

Hi Everyone - I would like to export the filemaker records with the fieldname(labelname). anybody have idea ?

[Wim Decorte]

Use the Merge (mer) export format.  It is CSV with field names as the first row.

[Guru Salem]

thanks for the response - But I need the CSV file with the label name. not mer file. Since i need to import that CSV file to other database. 

 

Is that any possibility to make the CSV file with label name. 

[Lee Smith]

The .mer file export includes the field names. see here

 

http://fmhelp.filemaker.com/fmphelp_13/en/html/import_export.17.28.html#1029514

[Guru Salem]

Thanks Lee - I have difficulty to use .mer file when I import with third party database which I'm using -  So that, I need CSV file with label name

[comment]

I have difficulty to use .mer file when I import with third party database which I'm using

 

You will have the same difficulty using a .csv file  with field names - because a .mer file is a .csv file with field names.

[Lee Smith]

Thanks Lee - I have difficulty to use .mer file when I import with third party database which I'm using -  So that, I need CSV file with label name

 

Why don’t you describe what's not working for you, start by Providing us with what you are trying to do, and what is not working. 

[Guru Salem]

Finally, there is no possibility to add fieldname in CSV file. But you want to know that what I'm working !

 

Let me tel you - I have only option to send filemaker records as CSV file to dot net team where they can do some programming. Because dot net team are not aware about .mer format and they dont have class files or sample code to extract records from .mer file records.

 

Hope it make sense.   

[Lee Smith]

Why don’t you just change the file extension from .mer to .csv?

[Kris M]

+ 1 to Lee

Why don’t you just change the file extension from .mer to .csv?

 

The other option is to export as csv and write an external script or dot net code to prepend the col names that you want to the csv.

[Wim Decorte]

 to dot net team where they can do some programming. 

 

You may want to check out www.fmdotnet.org and let the .Net developers read data directly from FMS instead of sending them files.

[Lee Smith]

Hi Wim,

 

Wouldn’t that require a copy of FileMaker?

 

If they had a copy of FileMaker, why wouldn’t Gurusamy just send them a copy of the file or a Snapshot?

[Wim Decorte]

No, it does not require a copy of FM.  I talks directly to FMS...

It's a standard .NET 2.0 DLL file that the .Net guys would include in their project.  The DLL takes care of the communication to FMS and parsing the returned data into a standard .Net DataSet.

[Lee Smith]

Hi Wim,

 

Thanks for the reply.

 

I learn something today. Learning make’s it worth it to get up in the morning.

[Guru Salem]

Many thanks for response and support.

 

Actually I will send the CSV file weekly once. not everyday. and Dot net developers have some restriction to import from other files and they want only CSV file. thats the only reason i'm stick with this CSV. anyway, ill look forward to work with dot net team.