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

[Jonathan Schwartz]

Bob,

While I don't love the solution, it works for me right now, because:

- The function won't be a commonly used one.
- The server is not busy.
- The PHP looping method requires a communication between servers for 
each record.  The FMP script method only requires 1. Internal speed 
of FMP script method is fast.
- I might test for the number of records and opt to use the PHP 
looping method anyway for small lists.
- I will probably be looking at MySQL as a next step anyway.

Now..I have another nagging question that I will post next.

Thanks for your help.

Jonathan


At 10:36 AM -0600 1/27/08, Bob Patin wrote:
>Sounds like a plan; so instead of PHP looping and creating records, 
>you do it in a FM script.
>
>Cool...
>
>Bob Patin
>Longterm Solutions
>bob at longtermsolutions.com
>615-333-6858
>http://www.longtermsolutions.com
>Member of FileMaker Business Alliance and FileMaker TechNet
>
>   CONTACT US VIA INSTANT MESSAGING:
>      AIM or iChat: longterm1954
>      Yahoo: longterm_solutions
>      MSN: tech at longtermsolutions.com
>      ICQ: 159333060
>
>--------------------------
>Contact us for FileMaker hosting and programming for all versions of FileMaker
>PHP * CDML * Full email services * Free DNS hosting * Colocation * Consulting
>
>On Jan 26, 2008, at 11:18 PM, Jonathan Schwartz wrote:
>
>>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
>>_______________________________________________
>>FX.php_List mailing list
>>FX.php_List at mail.iviking.org
>>http://www.iviking.org/mailman/listinfo/fx.php_list
>
>_______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list


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