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

Gjermund Gusland Thorsen ggt667 at gmail.com
Mon Jul 17 11:38:49 MDT 2006


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


More information about the FX.php_List mailing list