Sunday, January 14, 2007

How to use application packages effectively

All of us would have done the customer data conversion or company data conversion while clients migrate from legacy systems to PeopleSoft CRM systems.
This piece of code which I developed is really efficient and makes the best use of application packages.
Steps to follow :
1. Create an application engine and store the file details into a temp table or state record depending on the technical design.
2. In the peoplecode section,
a) import the RB_CDM:objectcollection and Individual:contact objects.
b) Create a object collect of RB_CDM.
c) Once done, instantiate the object in add mode and set the properties.
d) Invoke the save method which would create a new record.

Once this is done, just run the app engine and see the magic.
The best part of this code is that the speed at which it runs in the process schedluer and you will be amazed.
I did a test run of inserting 100 rows into the PeopleSoft CRM system and it ran just under 2 minues. Roughly, 1.2 sec for insertng every customer.
Hope this approach helps for the other developers.
If you have any other code/examples , mail me on harshagatt@gmail.com. I will post the same on my blog.
Regards,
Harsha Gatt

PS: I got to know that example code is copyrighted material and not supposed to be posted.
Thanks to Chris Speer for letting me know about the same.

1 comment:

ரமேஷ்/ Ramesh said...

Hi I need your help on App package, i importing million contact from PS Fincancials. I am using Contact app pakcage to imported it. Address, and phone number and emails are misplaced.



How do i created mupliple phone numbers, email in one contact and "default" address place.