How to script 750 different exports

[jess]

I have voter registration database and would like to know how I can script an export of all field contents into 750 different excel files.

Specifically, I want it to export all voters in Precinct 1100 to a file name 1100_Voters...then do next precinct 1101_Voters..and so on.

Any suggestions?

Thx..Jess

[xochi]

Hi Jess,

With FM8, script parameters and local script variables, this is relatively easy. I set up a similar system to export data files for two dozen locations in 3 different formats each (a PDF file for printing, a short Excel file for printing that matches the PDF file, and a long Excel file including more fields).

Start by reading the online FM help documents about file paths and script variables, you will eventually create something like:

file:/rootfolder/subfolder/exports/$precinct_Voters.xls

where $precinct is equal to the precinct you are exporting.

Then, just make a loop that does this once for each of the 750 precincts.

Edited July 21, 2006 by Guest