-
How to insert Account from Inbound email Attachment having Thousands of record?
I am creating Account from CSV file which is received from Inbound Email. It is throwing Regex too complicated error.
How should I resolve this problem? I have wrote following code --
This discussion was modified 8 years, 8 months ago by
Ajay Prakash.
-
This discussion was modified 8 years, 8 months ago by Ajay Prakash.
-
This discussion was modified 7 years, 1 month ago by
Forcetalks.
-
This discussion was modified 8 years, 8 months ago by
-
5 Replies
-
global class createAccountsFromMail implements Messaging.InboundEmailHandler{
global String MyFile{get;set;}
global String[] filelines = new String[]{};
global ListAccountList=new List (); global Messaging.InboundEmailResult handleInboundEmail(Messaging.InboundEmail email, Messaging.InboundEnvelope envelope){
Messaging.InboundEmailResult result = new Messaging.InboundEmailresult();
try{
System.debug('HELLO There');
for(Messaging.Inboundemail.BinaryAttachment at : email.binaryAttachments){
System.debug('Mail contents');
MyFile=at.body.toString().substring(0,5000);
filelines=MyFile.Split('\n');
System.Debug('File Lines----'+filelines.size());
for(Integer i=1;i-
This reply was modified 8 years, 8 months ago by Ajay Prakash.
-
This reply was modified 8 years, 8 months ago by Ajay Prakash.
-
This reply was modified 8 years, 8 months ago by
-
Complete code is not showing here.If someone need then I can mail.
-
This reply was modified 8 years, 8 months ago by Ajay Prakash.
-
This reply was modified 8 years, 8 months ago by
-
Try using batch class to execute the logic. Splitting the string by '\n' also produce this issue so, need to avoid that.
-
Hi,
Also you have to go with some kind of integration tool (informatica, mulesoft) or scheduled data loaders (Command Line Interface of Data Loader) or import wizard.
-
Hi,
You can use apps present in app exchange, there might be a feature regarding it.
Hope this helps.
Log In to reply.
Popular Salesforce Blogs
Integration with Okta (User APIs) in Salesforce
1. User Fetching from Okta - Get User API - API URL - https://{!comapny}.okta.com/api/v1/users/{!username} Method - GET Headers - Accept, application/json Authorization, SSWS token Content-Type,…
Transforming Businesses with Salesforce Digital Process Automation (DPA)
In today’s rapidly evolving business landscape, staying ahead of the competition requires adopting innovative solutions. Drive efficiency, enhance customer experience, and empower data-driven decision-making. Salesforce…
Case Study: Empowering Global Pharma Customer Support
Transformative impact of the Salesforce Service Cloud Call Center Solution on enhancing customer support across multiple countries within the pharmaceutical industry. The pharmaceutical industry operates…
