Re: Export from Filemaker Pro.

[Ed LaFrance <edlafrance@printexusa.com>]

>
>On Aug 6, 11:55am, pumin wrote:
>> Subject: Export from Filemaker Pro.
>> ******    message to minivend-users from "pumin" <pumin@madmacs.com>
>    ******
>>
>> Hello Filemaker Pro user,
>>
>> How can i export a text file from Filemaker Pro, with field names on the
>> very top line?  I couldn't find any script that does.  If you know how to
>> do, please tell me so i can import to Minivend without manually adding
>> fieldnames.
>>
>

Hello Pumin -

If you are willing to invest a little time, you can do it "automatically".
You will need to create a layout which contains every field you want to
export, and updated it as needed if you add new fields to the database.
You will also need an extra field for internal sorting use, make it numeric
and set it's options to auto-enter by calculation as follows:

Status(CurrentRecordID)

Define your export fields and field order, then have your export script go
something like this:

Freeze Window
Go to Layout ("Export Layout")
Go To Field ("First Field")
Set Field ("First Field", "Status(CurrentFieldName)")
Go To Field ("Next Field")
Set Field ("Next Field", "Status(CurrentFieldName)")
.
.
.
Set Field ("Last Field", "Status(CurrentFieldName)")
Sort ("Restore", "No Dialog")  {sort by your special sort field, descending
order, puts this "header" record at the top}
Export ("Restore", "No Dialog")

The script creates a new record, fills each field with it's name, sorts
that record to the "top" of the file, then exports the data.

Yes, there are a number of limitations.  Only Text and Number field types
will tolerated data outside their defined type - and only if you haven't
set type validation in field Options, so if you want to export the values
in Date, Time, Calculation or Summary Fields, you will have to create
parallel text-type "export" fields in which you can place their data,
converted to text strings.  Also, you can't do alot of tricky sorting and
filtering before exporting .

Other kind souls have posted some viable alternatives, hopefully you will
see something on this mail list which will help you.

Sincerely,

Ed LaFrance

-
PRINTEX Marking Technologies
12113 Kirkham Rd.
Poway, CA  92064  U.S.A.
(858) 513-2418
(800) 982-1928
(858) 513-2419 fax
edlafrance@printexusa.com
http://www.printexusa.com