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

[Jonathan Schwartz]

Thanks ggt...

...but I'm not sure that this will work for me.  The steps you 
suggest appears to create a single record with a single field full of 
recids.....for later processing to explode the recids?

I need the discreet records immediately.

The application is one where users will build a list of records for 
generating an email campaign. They might perform several additions to 
the second table, and then need to prune it until satisfied.

Was your idea for a script to run immediately afterward to explode 
the single record?

J



At 10:31 PM +0100 1/26/08, Gjermund Gusland Thorsen wrote:
>Or even better do the same thing and use "\n", $tmp and use a
>relationship to undig the data after, like this, but then you can not
>do the recids from your current found set, but a key that fits your
>relationship:
>---
>unset( $tmp );
>foreach( $r['data'] as $k => $v ) {
>$tmp[] = $value['commonlyUsedKeyForThisRecordInThisTable'][0];
>}
>$query->AddDBParam( 'recids', implode( "\n", $tmp) );
>---
>This will be the simplest way I assume, I typed this just off the top
>of my head, so it's not tested but the method should really work.
>
>2008/1/26, Gjermund Gusland Thorsen <ggt667 at gmail.com>:
>>  I would do the following, in theory, make a table called SearchResults,
>>
>>  searchResultID, autoincrement by one
>>  recids, text
>>
>>  Then I would do
>>  ---
>>  unset( $tmp );
>>  foreach( $r['data'] as $k ) {
>>  list($recid,$modid) = explode( '.', $k );
>>  $tmp[] = $recid;
>>  }
>>  $query->AddDBParam( 'recids', implode( ',', $tmp) );
>>  ---
>>
>>
>>  2008/1/26, Jonathan Schwartz <jschwartz at exit445.com>:
>>  > 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
>>  >
>>
>_______________________________________________
>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