count total records with a loop

[fmp6andfmp7]

I have a database of products which need to be exported in groups of 1000. There can be as many as 40000 or as few as 8000. The steps as I see them are:

l. loop to export the records

2. if record count is greater then 1000 then export 1000 as file name 1.csv

3. else export remaining records and name as 1.csv

I understand the logic of it but I do not know how to script it? My scripting ability is very basic. Any help would be great!

[Reed]

Here is a file that will demonstrate what you are trying to do. In FMP8, it is easy to use variables to dynamically name the exported files, but with prior versions you have to use plugins or Applescript etc. (depending on the platform)

In any case, you should be able to open the script in v7 if you don't have 8 yet, and see the logic behind it. You'll just have to use global fields instead of variables to set the position within the found set prior to omitting records.

export1000.fp7.zip