It took 33 seconds and I am very, very, very happy.



Thanks again.

Edhy Rijo

you can get that better with some tweaking

Congrats, I remember well going from 15 minutes to 15 seconds and how good it felt.

Keith Chisarik

Bulk copies....can't live without'em!

BTW, is there a way to simply bulk update the records instead of inserting them? Another process is to loop through the inserted records a 2nd or 3th time to re-process them, and after that, the modified ones should be save back to the server.

Edhy Rijo

Trent,



Talking about concurrency, in this same process, when I need to made some modifications to the imported data, I am using an SF BO with UpdateConcurrencyType and DeleteConcurrencyType set to OFF, but when I try to save any modifications I will get the SF Concurrency Manager form but without showing any value to be selected.



In this case I don't want or need any type of concurrency checking, what or where else do I need to check to make sure this SF Concurrency Manager form does not show up and my records are simply just saved?

Edhy Rijo

Yes. There are a number of ways to make sure that there is not any concurrency exception popping up, for example, you can handle the ConcurrencyException event and manage this yourself (which you would just ignore any collisions).



Most likely you are doing this on an SF dialog. If so, you can set the AutoHandleCollisions property to false and it should prevent that dialog from appearing.

Thanks for the info.



I believe the AutoHandleCollisions property will handle All or Nothing action, is there a way to control which BO to exclude from the AutoHandleCollisions action?

Edhy Rijo

That is the only place that the dialog is fired from. So if you want to handle this on a BO by BO basis, then you will have to handle the ConcurrencyException event.

Hi

Any plan to add this feature to BO by SF team?

Hello ,

Which feature are you referring to? The ConcurrencyException options Trent mentioned are already available, and have been for quite a while. The SQLBulkCopy is a function of SQL server, and is very handy.