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

[Gjermund Gusland Thorsen]

So you do not know how FileMaker works with linebreaks? You do not
have to do any scripting the way I told you to do it.

2008/1/26, Jonathan Schwartz <jschwartz at exit445.com>:
> 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
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>