[FX.php List] Duplicating related records; motives and methods

[Derrick Fogle]

Doing it in Scriptmaker, you should only have one script trigger call  
to the Parent record that can duplicate itself and all the related  
records without any more FX.php calls. That *should* be faster than  
the XML RPC method.

On Jul 17, 2006, at 12:38 PM, Gjermund Gusland Thorsen wrote:

> I have made solutions that do this in FX.php and ScriptMaker
>
> Typical scenario; making a copy of an order with orderlines in order
> to make an invoice.
>
>
>
> The FX.php way is simple,
> there is just to
> ---
> 1) Send the -recid of the order to XML RPC as a FMDup copy the
> relationational value key to a string
>
> 2) send the -recid to the XML RPC with a recid value from each desired
> orderline... FMDup, followed by a FMEdit that injects the relational
> value key from pt 1)
>
>
>
> ScriptMaker
> ---
> I essence I do the same thing, but is it really necessary to loop
> through the selection?
>
> And why is this slower than XML RPC?
>
> On 200 orderlines the difference is about 2 mins :-(
>
>
>
> Perhaps it would be smart of FMI to add duplicated related records?
>
>
>
> ggt667
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list


Derrick Fogle
derrick at fogles.net