[FX.php List] Saving/Exporting records from search results

[Bob Patin]

Jonathan,

I'd probably use a relationship to populate a new record:

loop thru the found set, creating a new record with just the keyID  
from the first record. Do a lookup to populate the rest of the fields...

So new record gets the keyID field value from table 1, table 2 uses  
that keyID value to lookup the values for all the other fields.

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 2:04 PM, Jonathan Schwartz wrote:

> Hi Folks,
>
> This is a scaled-down repeat of a post from earlier this week.  I  
> didn't get any replies to that post, and I'm still seeking a solution.
>
> In short, I need to be able to export the records from a user- 
> generated query into a second table. I have tried 2 methods. One is  
> slow. The other doesn't work.
>
> #1: Run a php script to loop through each record with FMNew. It took  
> over a minute to generate 1200 records and pegs the meter. This is  
> with the fields reduced to just the record ID.
>
> #2: Run a script to have FMP export the records and then import into  
> the second db.  I now realize that this won't work because neither  
> Export or Import are Web Compatible.
>
> So I'm back to #1... or another method I haven't thought of yet.
>
> Any suggestions?
>
> 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