Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

export data with Titles for field

 
   Database Help (Home) -> FileMaker RSS
Next:  HotPar '09 Call For Papers Deadline Approaching  
Author Message
Didier_V

External


Since: Oct 06, 2008
Posts: 3



(Msg. 1) Posted: Mon Oct 06, 2008 3:25 pm
Post subject: export data with Titles for field
Archived from groups: comp>databases>filemaker (more info?)

Hi,

I would like export data but with TITLES for fields (format *.csv)

Ex.

Last_Name First_Name

AAAA SSS
BBBB RTR
CCCC TTT

Is it possible and if yes, how ?

Thank you for your help

 >> Stay informed about: export data with Titles for field 
Back to top
Login to vote
Lynn Allen

External


Since: Jan 10, 2008
Posts: 63



(Msg. 2) Posted: Mon Oct 06, 2008 3:25 pm
Post subject: Re: export data with Titles for field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On 2008-10-06 11:30:26 -0700, "Didier_V" <do_not_answer.RemoveThis@yahoo.com> said:

> Hi,
>
> I would like export data but with TITLES for fields (format *.csv)
>
> Ex.
>
> Last_Name First_Name
>
> AAAA SSS
> BBBB RTR
> CCCC TTT
>
> Is it possible and if yes, how ?
>
> Thank you for your help

The "merge" format is a csv, with the field names in the first record.
--
Lynn Allen
--
www.semiotics.com
Member Filemaker Business Alliance
Long Beach, CA

 >> Stay informed about: export data with Titles for field 
Back to top
Login to vote
Helpful Harry

External


Since: Jun 23, 2003
Posts: 405



(Msg. 3) Posted: Mon Oct 06, 2008 4:25 pm
Post subject: Re: export data with Titles for field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <48ea5943$1_3@news.bluewin.ch>, "Didier_V"
<do_not_answer RemoveThis @yahoo.com> wrote:

> Hi,
>
> I would like export data but with TITLES for fields (format *.csv)
>
> Ex.
>
> Last_Name First_Name
>
> AAAA SSS
> BBBB RTR
> CCCC TTT
>
> Is it possible and if yes, how ?
>
> Thank you for your help

You don't say what version of FileMaker, but try exporting as a "Merge"
format file (use the filename extension .csv).

A Merge file is exactly the same as CSV, but does include the Field
names as the first row (although any spaces in the Field names are
converted to _ characters).

Since CSV is Comma Separated Values, you files will look like this when
opened in a tetx editor or word processor:

"Last_Name","First_Name"
"AAAA","SSS"
"BBBB","RTR"
"CCCC","TTT"

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
 >> Stay informed about: export data with Titles for field 
Back to top
Login to vote
Christoph Kaufmann

External


Since: Jun 21, 2008
Posts: 12



(Msg. 4) Posted: Mon Oct 06, 2008 5:26 pm
Post subject: Re: export data with Titles for field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Didier_V wrote:

> I would like export data but with TITLES for fields (format *.csv)

> Is it possible and if yes, how ?

a) create a record that contains the field names and make sure it's the
first one

b) export to excel, open with a software that reads excel format and
save to csv from there.

--
http://clk.ch
 >> Stay informed about: export data with Titles for field 
Back to top
Login to vote
Didier_V

External


Since: Oct 06, 2008
Posts: 3



(Msg. 5) Posted: Mon Oct 06, 2008 5:26 pm
Post subject: Re: thank you very much [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you very much for your help. That's exactly what I'd like to have.
It's great !!!!!


>
> You don't say what version of FileMaker, but try exporting as a "Merge"
> format file (use the filename extension .csv).
>
> A Merge file is exactly the same as CSV, but does include the Field
> names as the first row (although any spaces in the Field names are
> converted to _ characters).
>
> Since CSV is Comma Separated Values, you files will look like this when
> opened in a tetx editor or word processor:
>
> "Last_Name","First_Name"
> "AAAA","SSS"
> "BBBB","RTR"
> "CCCC","TTT"
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)
 >> Stay informed about: export data with Titles for field 
Back to top
Login to vote
Guy

External


Since: Jan 11, 2008
Posts: 45



(Msg. 6) Posted: Mon Oct 06, 2008 5:26 pm
Post subject: Re: export data with Titles for field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Later versions allow you to save the current layout and records as Excel and
cplumn titles are included

Guy

"Christoph Kaufmann" <clk.DeleteThis@tele2.ch> wrote in message
news:1ioetvs.1nsyvqyre5n34N%clk@tele2.ch...
> Didier_V wrote:
>
>> I would like export data but with TITLES for fields (format *.csv)
>
>> Is it possible and if yes, how ?
>
> a) create a record that contains the field names and make sure it's the
> first one
>
> b) export to excel, open with a software that reads excel format and
> save to csv from there.
>
> --
> http://clk.ch
 >> Stay informed about: export data with Titles for field 
Back to top
Login to vote
Didier_V

External


Since: Oct 06, 2008
Posts: 3



(Msg. 7) Posted: Wed Oct 08, 2008 4:25 pm
Post subject: Re: save the current layout and records as Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you very much for your idea & your help

but how to do it ???? (save the current layout and records as Excel)

I use FMP Advanced version 9.0

> Later versions allow you to save the current layout and records as Excel
> and cplumn titles are included
>
> Guy
 >> Stay informed about: export data with Titles for field 
Back to top
Login to vote
Guy

External


Since: Jan 11, 2008
Posts: 45



(Msg. 8) Posted: Sat Oct 11, 2008 4:50 pm
Post subject: Re: save the current layout and records as Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

FILE MENU
Save/Send -> PDF/Excel


"Didier_V" <do_not_answer DeleteThis @yahoo.com> wrote in message
news:48ed1481$1_5@news.bluewin.ch...
> Thank you very much for your idea & your help
>
> but how to do it ???? (save the current layout and records as Excel)
>
> I use FMP Advanced version 9.0
>
>> Later versions allow you to save the current layout and records as Excel
>> and cplumn titles are included
>>
>> Guy
>
>
 >> Stay informed about: export data with Titles for field 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> FileMaker All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]