Re: FMPRO-L Digest - 13 Oct 2009 to 14 Oct 2009 (#2009-168)

[Chad Chelius]

Stephen,
Actually I want one header at the beginning of the exported file only,  
not before each record. So the resulting file would have the header at  
the top then all of the exported records beneath.

chad

On Oct 14, 2009, at 6:00 PM, FMPRO-L automatic digest system wrote:

> I'm exporting the contents of a FMP field to create a list of names
> and addresses. I need to add a header to the exported file but it only
> appears once at the top of the exported file and not before each
> exported record. How would I go about achieving that?
>
> Chad Chelius
>
> ------------------------------
>
> Date:    Tue, 13 Oct 2009 16:44:47 -0600
> From:    Stephen Wonfor <[hidden email]>
> Subject: Re: Adding Header information to exported data
>
> Chad
>
> Do you mean row 1 is header, row 2 is data, row 3 is header, row 4 =20
> data etc. then you'll need to script the export by writing the data  
> =20
> into another data table.  Or something.
> Or you could give each record a serialID#, have the increment 2, so  
> =20
> they go 2,4,6,8...
> Then create a header row record, set its serial to 1, make a whole =20
> bunch of them, so they get 1,3,5,7
> Sort by serial ID
> Export.
>
> But, why do you want the header "before each exported record"
>
> Stephen

[Craig Gaevert]

Couldn't you get the same result from Save/Send Records as . .  where  
the field name becomes the header name and all the record data  
populates below? Even though it is nominally an excel file you could  
open it in word, or convert it out as a tab file. From your  
description this is what it sounds like you're looking for.

Craig

On Oct 14, 2009, at 15:40, Chad Chelius wrote:

> Stephen,
> Actually I want one header at the beginning of the exported file  
> only, not before each record. So the resulting file would have the  
> header at the top then all of the exported records beneath.
>
> chad
>
> On Oct 14, 2009, at 6:00 PM, FMPRO-L automatic digest system wrote:
>
>> I'm exporting the contents of a FMP field to create a list of names
>> and addresses. I need to add a header to the exported file but it  
>> only
>> appears once at the top of the exported file and not before each
>> exported record. How would I go about achieving that?
>>
>> Chad Chelius
>>
>> ------------------------------
>>
>> Date:    Tue, 13 Oct 2009 16:44:47 -0600
>> From:    Stephen Wonfor <[hidden email]>
>> Subject: Re: Adding Header information to exported data
>>
>> Chad
>>
>> Do you mean row 1 is header, row 2 is data, row 3 is header, row 4  
>> =20
>> data etc. then you'll need to script the export by writing the data  
>> =20
>> into another data table.  Or something.
>> Or you could give each record a serialID#, have the increment 2, so  
>> =20
>> they go 2,4,6,8...
>> Then create a header row record, set its serial to 1, make a whole  
>> =20
>> bunch of them, so they get 1,3,5,7
>> Sort by serial ID
>> Export.
>>
>> But, why do you want the header "before each exported record"
>>
>> Stephen
>

[Marina Tadiello]

My "handmade" solution is to add a record with the contents of
the header to the database, and give it a sort order lower than
any other record - so that if you sort your records before
exporting, the record with the contents of the header appears as
the first.

Alternatively, you could add a row with the header contents
after importing the exported records into your new list (eg a
spreadsheet file, which can then be exported into any word
processing file).

marina


>I'm exporting the contents of a FMP field to create a list of names
>and addresses. I need to add a header to the exported file but
>it only
>appears once at the top of the exported file and not before each
>exported record. How would I go about achieving that?

[Emma Glaisher]

Some javascript/style in this post has been disabled (why?)

What exactly do you mean by a header? A lot of people think you mean a
'heading', i.e. a field name at the top of each column. I suspect you mean
an InDesign header?




On 14/10/09 23:40, "Chad Chelius" <[hidden email]> wrote:

> Stephen,
> Actually I want one header at the beginning of the exported file only,
> not before each record. So the resulting file would have the header at
> the top then all of the exported records beneath.
>
> chad
>
> On Oct 14, 2009, at 6:00 PM, FMPRO-L automatic digest system wrote:
>
>> I'm exporting the contents of a FMP field to create a list of names
>> and addresses. I need to add a header to the exported file but it only
>> appears once at the top of the exported file and not before each
>> exported record. How would I go about achieving that?
>>
>> Chad Chelius
>>
>> ------------------------------
>>
>> Date: Tue, 13 Oct 2009 16:44:47 -0600
>> From: Stephen Wonfor <[hidden email]>
>> Subject: Re: Adding Header information to exported data
>>
>> Chad
>>
>> Do you mean row 1 is header, row 2 is data, row 3 is header, row 4 =20
>> data etc. then you'll need to script the export by writing the data
>> =20
>> into another data table. Or something.
>> Or you could give each record a serialID#, have the increment 2, so
>> =20
>> they go 2,4,6,8...
>> Then create a header row record, set its serial to 1, make a whole =20
>> bunch of them, so they get 1,3,5,7
>> Sort by serial ID
>> Export.
>>
>> But, why do you want the header "before each exported record"
>>
>> Stephen
>
> --------------------------------
> Inbound email scanned by Mimecast.
> --------------------------------
>


Emma Glaisher
Artworker and Database Development
Fourninety Limited

Tel: [phone]
[hidden email]
http://www.fourninety.com/

---

Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered address Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ

Confidentiality Notice: The information in this document and any attachments are confidential. It is intended only for the use of the named recipient. If you are not the intended recipient please notify us immediately and delete this document. The contents on this document must not be disclosed to any other person nor may any copies be taken. The views of the author may not represent the views of the Company.

Security Warning: This e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. All liability for any claims arising as a result of using this medium to transmit information by us or to us is excluded to the extent permitted by law.

---

[Stephen Pocock]

Hi

Export is at MERGE .mer format.   It will include the names of the fields exported as the first row of a CSV.

Hope this helps

Stephen

IMPORTANT - PLEASE READ

Please notify us if this communication has been sent to you by mistake. If it has been, Client Legal Privilege is not waived or lost and you are not entitled to use it in any way.