Columns and Rows record Export

In article <48a13587$0$80906$dbd4f001@news.wanadoo.nl>, "Ursus"
<ursus.kirk.TakeThisOut@orange.nl> wrote:

> > row for reimportation into Maxbulk. Is there a way to create a table
> > that will show all employees and their emails in discreet rows.
> >
> > Now the Excel document looks like this:
> >
> > Company-CompanyEmail-Staff1-Staff1Email-Staff2-Staff2Email (all
> > sequential columns)
> >
> > What I want is:
> >
> > Company- CompanyEmail
> > Staff1-Staff1Email
> > Staff2-Staff2Email
>
> You want every new line to be a new record.
> I have not tried this, but it might work.
> Create one global export field. gExport
> Script:
> find all records
> goto first
> loop
> set gexport > Company & "TAB" & CompanyEmail & "TAB" & Staff1 & "," &
> Staff1Email & "P" & Staff2 & "TAB" & Staff2Email & "P"
> goto next record
> exit loop after last
> omit 1 record
> find omitted only
> export as TAB, choose only the gexport field
>
> P = the return sign
> TAB = a tab
> Barebones only, no errorchecking etc.
>
> Keep well, Ursus

Except that FileMaker won't export Tabs or Returns within record Text,
even when it's only exporting one Global field. So this approach won't
work unless you want to do some post-processing on the file after
exporting from FileMaker.

The Script would need to transfer the addresses to separate records in
another Table and Export them from there.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
 >> Stay informed about: Columns and Rows record Export 

In article
<5d0aa45a-991e-43d1-b91e-d8186906209c.RemoveThis@t54g2000hsg.googlegroups.com>,
Buckbuck <buck.matthew74.RemoveThis@yahoo.com> wrote:

> FM 8.5
>
> I have a CONTACTS table. Most of the entry headings are companies.
> Within each company there are employees; Staff1, Staff 2 etc., each
> with their own email Staff1Email, Staff2Email etc. My bulk email
> program - Maxbulk Mailer, can import a tab file, and so what I do is
> export records to produce a list of emails. The problem is there is a
> fair amount of effort reorganizing the Staff and Emails onto their own
> row for reimportation into Maxbulk. Is there a way to create a table
> that will show all employees and their emails in discreet rows.
>
> Now the Excel document looks like this:
>
> Company-CompanyEmail-Staff1-Staff1Email-Staff2-Staff2Email (all
> sequential columns)
>
> What I want is:
>
> Company- CompanyEmail
> Staff1-Staff1Email
> Staff2-Staff2Email
>
> etc.
>
> Thanks
> Matthew

Since it doesn't matter what order emails are sent, there's no reason
to keep company and staff email addresses together. Therefore I would
probably write a Script to do multiple exports.
ie.

Export [Company and Company Email]
Export [Staff1 and Staff1 Email]
Export [Staff2 and Staff2 Email]
etc.

You than have to do multiple imports back into Maxbulk.

Of course, depending on you computer set-up and what your trying to
achieve, it may be better to simply email directly from FileMaker
itself (with or without and email plug-in).

Even better, change the structure of your database so that Staff
details are in a separate Table, with one record per staff member and a
Relationship linking the Company record with however many Staff records
are needed. This way you can do just two exports - one from the COmpany
Table and one from the Staff Table.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
 >> Stay informed about: Columns and Rows record Export