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

Jonathan Schwartz jschwartz at exit445.com
Sat Jan 26 15:53:44 MST 2008


ggt,

My goal is essentially duplicate found records in a separate table. 
Does your suggestion do that, or, is it a way to simply view records 
in the the primary table?  I understand how to view matching records 
with a multiple key.

Again, I need to create new records in another table.

J


>I am saying that it is not needed and that all the records matching
>the keys on each line will show up in the portal
>
>2008/1/26, Jonathan Schwartz <jschwartz at exit445.com>:
>>  Are you saying that if FMP is supplied with a single record with a
>>  single field that contains line breaks (during a New Record step), it
>>  will spawn a new record for each line break?
>>
>>  I can't wrap my head around that one.
>>
>>  Thx.
>>
>>  Jonathan
>>
>>
>>
>>  At 10:53 PM +0100 1/26/08, Gjermund Gusland Thorsen wrote:
>>  >If you have linebreaks in a key field it will function as a logical or
>>  >between the values.
>>  >
>>  >2008/1/26, Gjermund Gusland Thorsen <ggt667 at gmail.com>:
>>  >>  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
>>  >>  >
>>  >>
>>  >_______________________________________________
>>  >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
>>
>_______________________________________________
>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


More information about the FX.php_List mailing list