Jump to content
Sign in to follow this  
Bhuban

Export Data from FileMaker to csv with field names on first row

Recommended Posts

Hi,

I am new to file maker. I am trying to migrate data from File Maker 6 Table to a csv file.

I am using Export Records -> choosing the csv file as file type and saving all the fields.

When I go to the csv file, I am not able to get the equivalent field names at the top row. Is there an option that needs to checked to get the field names included in the csv file.

Please help.

Thanks,

Bhuban

Share this post


Link to post
Share on other sites

Check out this in your Online Help: (Copy and paste this)

Contents > Saving, importing, and exporting data > [color:blue]Supported import/export file formats

For information about the different File Formats, and what you can expect when using the one.

HTH

Lee

Share this post


Link to post
Share on other sites

Hi,

Thanks for the quick reply.

The link talks about the format in which I would be getting the csv data. But, it does not say anything about the inclusion of field names in the first row along with the data.

Is there any way I can get the field names in csv file.

Thanks,

Bhuban

Share this post


Link to post
Share on other sites

Merge format

.mer

Good export format for creating form letters in a word processor.

Format retains field names.

Share this post


Link to post
Share on other sites

I'm not sure that you went to the correct section, you have to look for the title I used in Blue above. Note, the file cut off the one that Fenton mentioned. However, you should review ALL of the Formats listed, as it will help you today, and in the Future with your imports and exports.

HTH

Lee

2007-11-23_1117.png

Share this post


Link to post
Share on other sites

Thank you for the reply.

I went to the correct section. The only difference is that I should have looked at all the formats. I only looked at csv format and it did not list that it will be including the field names.

As mensioned by Fenton, .mer file will do the job for me as it has the same structure as the csv file with the header present at the top. I will try it out and update the post.

Thanks again,

Bhuban

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.