[FX.php List] Saving/Exporting records - RESOLVED

Jonathan Schwartz jschwartz at exit445.com
Sat Jan 26 22:18:05 MST 2008


Hi Folks,

I came up with a workable solution for now. It cut down the time from 
over one minute to approx 15 seconds for creation of 1500 records.

For reference, here's what I did:

1) User queries records in primary table, sees resulting records.
2) User clicks "Save" button, which repeats query and writes recid's 
to a comma separated PHP string.
3) The query also includes a '-script' parameter that runs a FMP script:
	a) Creates a Parent record
	b) Saves the recid string in a single field
	c) Loops thru values in the single field, creating child 
records for each recid in string
	d) Populates other child fields with lookup
4) Returns user to either add more records or edit the newly formed list.

This works for me.

Thanks to all that offered help.

Jonathan



-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-381-1852


More information about the FX.php_List mailing list