[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