Looping record exports

[Dagel]

I have a number of found records and I am needing to create a single tab delimited file for each. I've already got the path and the $fileName set.

FileMaker apparently exports all the records in the found set- so I will need to be able to script a find of records which have not been marked as "exported" then somehow loop a script which will step through finding, exporting, and marking each record one at a time.

I'm stumped. Any help or a point in the right direction would be greatly appreciated.

[Vaughan]

So you want to export each record separately?

Why not make a calc field to concatenate the fields, then use the Export Field command.

[comment]

Or:

http://www.fmforums.com/forum/showpost.php?post/279964/

See also:

http://my.advisor.com/doc/18846

http://www.fmforums.com/forum/showpost.php?post/293603/

http://www.fmforums.com/forum/showtopic.php?tid/184454/

---

keyword: isolate record

[Cabinetman]

Why not make a calc field to concatenate the fields, then use the Export Field command.

I agree.

First, I'd add 2 fields:

Exported (text field with say an "X" in records that have been exported already) and

Exported Calc (calculation field as mentioned above)

Next, Decide on a sort field.

(quick version I have to go...)

Then script something like this,

Find records where Exported is empty

Sort

Go to record first

Loop

Export field contents

Insert text "X" into Exported

Go to record next exit after last

End loop

May have left something out but gotta run for now...