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

[Joel Shapiro]

Hey Jonathan

I know you've got a working solution and you've moved on.

FWIW: I wonder if using FMEdit -- with an "Allow creation..." FM  
relationship -- would be faster than FMNew.  My sense is that it  
would be somewhat faster, but I've got nothing to back that up.

Glad you found something that works.

-Joel


On Jan 27, 2008, at 9:01 AM, Jonathan Schwartz wrote:

> 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
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list