How to design / create Parallel Processing AE for Data Import ??
We have to import millions of customer information from legacy system into PeopleSoft CRM. We have developed an AE which uses delivered Application Packages to do that. However, it requires 4.5 days to import 3.2 lac customer info.
1. How to develop an AE, multiple instances of which will import data in Parallel, thus reducing the import time ?
2. What will be impact (or likelyhood of deadlocks) if all the instances insert / update data for same set of records ?
CRM 9.00, PeopleTools 8.49
DB: Oracle 10g Enterprise on AIX 6.1 (4 dual core Xeon / 8 GB RAM) App Server: Windows 2003 Enterprise
Thank you for posting your question. Answer to your second question is –
To release the deadlocks, you can use commitwork() and collectgarbage() after processing each set of data, (say count=10000 rows) in Application Engine peoplecode.
I am using PT_WF_NOTIFICATION to send mail.In mail some part of text should be displayed as BOLD. I have used html tags but these are displayed in the mail.How to print text in bold?
I am using message catalog to display part of message.
Thank you for posting your question
Most Possible reason is email is being sent as Text, that’s the reason HTML tag are not accepted.
In the application package PT_WF_NOTIFICATION, for the notification class there is a property called ContentType which should initialized if HTML tag are going to used.
Please refer peoplebook for sendmail function; code for content type is:
Content_Type = “Content-type: text/html; charset=utf8”